Just upgraded to the new version FrontpageSlideshow-v3.1.0_j1.5-1.7-2.5 on J1.5 - v.2.* was not an issue.

FPSSCategory::store failed - Unknown column 'params' in 'field list' SQL=UPDATE `star_fpss_categories` SET `name`='Front Page',`published`='1',`params`='imageWidth=450\nimageQuality=55\nthumbWidth=10\nthumbQuality=10\npreviewWidth=450\npreviewQuality=55\ntitle=0\ntext=1\ntagline=0\ncategory=0\nauthor=0\nreadmore=0\ntarget=_self\nliveData=0\n\n' WHERE id='1'

Help please

I am running Joomla 2.5.1 on IIS server with SQL server. I'm running PHP 5.3.9 and everything seems to be working fine including core Joomla functionality.

I install the K2 Component without issues and no errors reported once completed.

However, a set of tables were not created in the database. Because of this, I can't add categories, items, tags, etc... I get errors similar to the following:

TableK2Category: :store failed
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.SQL=INSERT INTO [myprefix_k2_categories] () VALUES ()

I get an error when I hit the paramaters as well:

[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'myprefix_k2_user_groups'.SQL=SELECT id AS value, name AS K2UserGroup FROM myprefix_k2_user_groups

Any thoughts as to where the issue lies during the installation process?

We would hate to have to resort to Joomla core functionality on this site - K2 is MUCH more flexible and powerful.

Hi i've purchased Frontpage Slideshow  v3.1.0 and i am unable to get it working correctly with Windows 2008 IIS 7, php version 5.3.9, MySQL version 5.1.56-community, GD Image library 2.0.34 compatible, PHP upload limit 16M, PHP Memory limit 16M, media/com_fpss writable, cache writable with 2.5.0-Stable-Full_Package...

When trying to upload an image i get a circle that goes round in a circle but does not show image. on checking my server i see the image uploaded and renamed.

if i try to select save while the circle trying to load an image i get an error - Please select an image.

If i browse server for image i get the same issue...

If i use one of the demo listing i can edit the image as there was an image there before, but i still don't get the image change until i click save (which you can only do while editing one of the demo items) once the item as saved if i go back into the slide item i find the image as changed..

How can this be fix??? URGENT MATTER

I got this error "Error building Admin Menus" when I installed k2 2.4.5 on my joomla 1.7.3 site.

Also:

Warning: Invalid argument supplied for foreach() in /home/content/76/8459776/html/EasleySCDentist/libraries/joomla/database/database/mysql.php on line 361

Warning: Invalid argument supplied for foreach() in /home/content/76/8459776/html/EasleySCDentist/libraries/joomla/database/database/mysql.php on line 361

Warning: Invalid argument supplied for foreach() in /home/content/76/8459776/html/EasleySCDentist/tmp/install_4f27e5edbdbb8/script.k2.php on line 68

Warning: Invalid argument supplied for foreach() in /home/content/76/8459776/html/EasleySCDentist/tmp/install_4f27e5edbdbb8/script.k2.php on line 87


Any ideas?
Thanks

Any news ?

Could this problem cause the other trouble about the SLIDE LINK that doesn't work?

forum.joomlaworks.net/frontpage-slideshow-%28for-joomla!%29/slide-links-don%27t-work/

I didn't have any news since I last PM you with my Site SuperAdmin keys.. Any help would be appreciated

I have turned on the error debug from global but in the blank white pages no messages apear, it's total white page ... in order this is System information from k2 dashboard:
Web Server• Apache
•PHP version• 5.2.13
•MySQL version• 5.0.92-community
•GD image library• bundled (2.0.34 compatible)
•Multibyte string support• •Enabled•
•Upload limit• 100M
•Memory limit• 64M
•Open remote files (allow url fopen)• •Yes•

I don't know where to check if mb_encoding is enabled ... please gide me.
regards,

This is not solved for me. I am still unable to upload images or select an image from the server. I keep getting the "File error. Please try again." When I select an image (either via upload or selected on server) a grey image box appears and says "Image Preview" then stops before anything loads. As soon as you try to save the slide the error appears.

I have installed Admin Tools, fixed permissions, uninstalled fpss, then reinstalled it. No luck.

I have now done a fresh Joomla install. The first extension I installed was Admin Tools. Fixed permissions, then installed FPSS. Same issue.

I have switched back and forth from admin templates.

I can upload files through media manager just fine.

All file permissions are correct.

I couldn't get it working with the following settings:

Web server    Apache/2.2.13 (Unix)
PHP version    5.2.11
MySQL version    5.0.92-community
GD Image library    bundled (2.0.34 compatible)
media/com_fpss    Writable  (777)
cache    Writable          (777)
Frontpage Slideshow v3.1.0
Joomla Version 1.7.3

And it does not work with the new install:
Everything the same as above other than Joomla Version 2.5


Anyone? Please help...

FPSS 3.1.0
Joomla 1.7.3
on Joomlahost.it Server

FPSS version and joomla version please?

When creating a new FPSS category for Slides and assigning it a language, it throws this Error:

Errore nel caricamento del componente: com_fpss, 1
        MySQL server has gone away SQL=SELECT a.lang_code AS value, a.title AS text, a.title_native FROM sol_languages AS a WHERE a.published >= 0 ORDER BY a.title

Any help?

Okay, so I am using v2.0.0 of the Frontpage Slideshow plugin on 1.5.18 Joomla. I did not upgrade versions and did not install this version, I am now the sites administrator and my predecessor installed it.

When I set the module parameter for "category" to anything but "1" I get this error when loading the page the module is published to.

"500 - Unknown column 'home' in 'where clause' SQL=SELECT * FROM fpss_slides WHERE state = 1 AND registers <= 25 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-01-23 21:59:26' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-01-23 21:59:26' ) AND catid IN ( home ) ORDER BY ordering"

Is this a conflict with the installed site template?  I can publish it to multiple positions without getting this error, it is only when I change the category. What is this error telling me?

I tried uploading slides into a category that I created called "1" and while I don't get the 500 error, the slides do not publish.

Any ideas?

I was having trouble installing k2 without getting a BUNCH of fatal errors about invalid arguments...


My SOLUTION:

I was (unnecessarily) using something called qcache that created two files in my Joomla database called mysqli_cached and mysql_cache

The global configs were using one of the files as the database.

Solution. Go to your global configuration and make sure your database says "Mysql" (or mysqli if that's what kind of db you have) only.

I also have this problem too from time to time. For me, this error only occurred when caching was turned on in Global Preferences. I had "K2 Categories" set as the menu item type of my homepage, so the RSS feed would syndicate there. However, I didn't want any articles showing up, so I turned off the "Component" area on the homepage using RocketTheme's Gantry Framework.

Would love to know if there is a fix for this.

I too am having this exact issue. Any ideas?


Web server    Apache/2.2.13 (Unix)
PHP version    5.2.11
MySQL version    5.0.92-community
GD Image library    bundled (2.0.34 compatible)

media/com_fpss    Writable  (777)
cache    Writable          (777)

Frontpage Slideshow v3.1.0
Joomla Version 1.7.3

Hi,

I have the following setup:

Web server    Apache 2.2.19
PHP version    5.3.6
MySQL version    5.1.58
GD Image library    bundled (2.0.34 compatible) 

media/com_fpss    Writable  (755)
cache    Writable          (755)

Frontpage Slideshow v3.1.0

I read for hours this forum and tried things like deleting the files in frontpage cache.
I tried all different FPSS_MOD_JQUERY_LIBRARY_HANDLING options.

But what ever I do nothing helps I can not upload images to the slideshow when i try I get the message:
File error. Please try again.

I only managed to put in some pictures through  the src folder.

How can I solve this?

best regards,

Martin

Hi,

I'm getting these errors in front-end and back-end pages only on some page loads but on any page. Only seems to be affecting my sites with K2 and not sites without K2 which is why I'm asking here.

Changing to mysql/mysqli doesn't help

Anyone else seen these?

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /public_html/libraries/joomla/database/database/mysql.php on line 623

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /public_html/libraries/joomla/database/database/mysql.php on line 666

Please help

Cheers,

Dave

How do I reload a previous version of slideshow - 2.9.1?  The PDS only allows me to load the current version - which isn't working for me - I can't get the slides to load. this is driving me crazy.  :Thanks

(error message: FPSSSlide::store failed - Unknown column 'title' in 'field list' SQL=INSERT INTO `jos_fpss_slides` ( `id`,`title`,`catid`,`published`,`publish_up`,`publish_down`,`created`,`created_by`,`access`,`ordering`,`featured`,`featured_ordering`,`text`,`tagline`,`referenceType`,`referenceID`,`custom`,`hits`,`params` ) VALUES ( '0','Title','2','1','2012-01-05 20:17:00','0000-00-00 00:00:00','2012-01-05 20:19:50','64','0','19','0','','','Tagline','custom','','URL','0','useOriginal=\ntitle=0\ntext=0\ntagline=0\ncategory=0\nauthor=0\nreadmore=0\ntarget=\nliveData=0\n\n' )

I basically ran into the same exact issue. How the error state is encountered is if you install version 3 without uninstalling version 2 first. If you try to APPLY a new category joomla reports "error" if you try to SAVE the category it joomla will produce that FPSS SQL error that you're seeing. The solution is to uninstall your current version 3 installation and re-install version 3 again. I hope this helps.

Hi All,

Just starting to try this procedure on one of my sites, having some issues as I have not altered the database like this before learning curve.

Ok so I have imported all the exported sql into the k2 tables and I am stuck on number 6

I am trying to execute a query is that correct? i use the set up and it creates the below query

SELECT `jos_k2_items`.`created_by`
FROM jos_k2_items
WHERE (
`jos_k2_items`.`created_by`
SET created_by =NEWIDNUMBER WHERE created_by =OLDIDNUMBER
)

When I submit i get the following error message:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET created_by = 42 WHERE created_by = 64)' at line 3



When I try to run this query (i have added the prefix and the number created by id of old and new.
I have to use the UPDATE `PREFIX_k2_items` SET created_by = NEW_ID WHERE created_by = OLD_ID

6. Update k2_items created_by ID to new J1.7 Super User ID by running SQL query:
UPDATE `PREFIX_k2_items` SET created_by = NEW_ID WHERE created_by = OLD_ID


Not even got to step 7 yet lol
Paul

getting this error message. think a certain plug-in is causing things to go screwy..

TableK2Category: :store failed
Table 'JB_Newstream.ukbtg_k2_categories' doesn't exist SQL=INSERT INTO `ukbtg_k2_categories` (`id`,`name`,`alias`,`description`,`parent`,`published`,`access`,`ordering`,`params`,`language`) VALUES ('','K2 plug in modules','k2-plug-in-modules','','0','1','1','','{\"inheritFrom\":\"0\",\"theme\":\"\",\"num_leading_items\":\"2\",\"num_leading_columns\":\"1\",\"leadingImgSize\":\"Large\",\"num_primary_items\":\"4\",\"num_primary_columns\":\"2\",\"primaryImgSize\":\"Medium\",\"num_secondary_items\":\"4\",\"num_secondary_columns\":\"1\",\"secondaryImgSize\":\"Small\",\"num_links\":\"4\",\"num_links_columns\":\"1\",\"linksImgSize\":\"XSmall\",\"catCatalogMode\":\"0\",\"catFeaturedItems\":\"1\",\"catOrdering\":\"\",\"catPagination\":\"2\",\"catPaginationResults\":\"1\",\"catTitle\":\"1\",\"catTitleItemCounter\":\"1\",\"catDescription\":\"1\",\"catImage\":\"1\",\"catFeedLink\":\"1\",\"catFeedIcon\":\"1\",\"subCategories\":\"1\",\"subCatColumns\":\"2\",\"subCatOrdering\":\"\",\"subCatTitle\":\"1\",\"subCatTitleItemCounter\":\"1\",\"subCatDescription\":\"1\",\"subCatImage\":\"1\",\"itemImageXS\":\"\",\"itemImageS\":\"\",\"itemImageM\":\"\",\"itemImageL\":\"\",\"itemImageXL\":\"\",\"catItemTitle\":\"1\",\"catItemTitleLinked\":\"1\",\"catItemFeaturedNotice\":\"0\",\"catItemAuthor\":\"1\",\"catItemDateCreated\":\"1\",\"catItemRating\":\"0\",\"catItemImage\":\"1\",\"catItemIntroText\":\"1\",\"catItemIntroTextWordLimit\":\"\",\"catItemExtraFields\":\"0\",\"catItemHits\":\"0\",\"catItemCategory\":\"1\",\"catItemTags\":\"1\",\"catItemAttachments\":\"0\",\"catItemAttachmentsCounter\":\"0\",\"catItemVideo\":\"0\",\"catItemVideoWidth\":\"\",\"catItemVideoHeight\":\"\",\"catItemAudioWidth\":\"\",\"catItemAudioHeight\":\"\",\"catItemVideoAutoPlay\":\"0\",\"catItemImageGallery\":\"0\",\"catItemDateModified\":\"0\",\"catItemReadMore\":\"1\",\"catItemCommentsAnchor\":\"1\",\"catItemK2Plugins\":\"1\",\"itemDateCreated\":\"1\",\"itemTitle\":\"1\",\"itemFeaturedNotice\":\"1\",\"itemAuthor\":\"1\",\"itemFontResizer\":\"1\",\"itemPrintButton\":\"1\",\"itemEmailButton\":\"1\",\"itemSocialButton\":\"1\",\"itemVideoAnchor\":\"1\",\"itemImageGalleryAnchor\":\"1\",\"itemCommentsAnchor\":\"1\",\"itemRating\":\"1\",\"itemImage\":\"1\",\"itemImgSize\":\"Large\",\"itemImageMainCaption\":\"1\",\"itemImageMainCredits\":\"1\",\"itemIntroText\":\"1\",\"itemFullText\":\"1\",\"itemExtraFields\":\"1\",\"itemDateModified\":\"1\",\"itemHits\":\"1\",\"itemCategory\":\"1\",\"itemTags\":\"1\",\"itemAttachments\":\"1\",\"itemAttachmentsCounter\":\"1\",\"itemVideo\":\"1\",\"itemVideoWidth\":\"\",\"itemVideoHeight\":\"\",\"itemAudioWidth\":\"\",\"itemAudioHeight\":\"\",\"itemVideoAutoPlay\":\"0\",\"itemVideoCaption\":\"1\",\"itemVideoCredits\":\"1\",\"itemImageGallery\":\"1\",\"itemNavigation\":\"1\",\"itemComments\":\"1\",\"itemTwitterButton\":\"1\",\"itemFacebookButton\":\"1\",\"itemGooglePlusOneButton\":\"1\",\"itemAuthorBlock\":\"1\",\"itemAuthorImage\":\"1\",\"itemAuthorDescription\":\"1\",\"itemAuthorURL\":\"1\",\"itemAuthorEmail\":\"0\",\"itemAuthorLatest\":\"1\",\"itemAuthorLatestLimit\":\"5\",\"itemRelated\":\"1\",\"itemRelatedLimit\":\"5\",\"itemRelatedTitle\":\"1\",\"itemRelatedCategory\":\"0\",\"itemRelatedImageSize\":\"0\",\"itemRelatedIntrotext\":\"0\",\"itemRelatedFulltext\":\"0\",\"itemRelatedAuthor\":\"0\",\"itemRelatedMedia\":\"0\",\"itemRelatedImageGallery\":\"0\",\"itemK2Plugins\":\"1\",\"catMetaDesc\":\"\",\"catMetaKey\":\"\",\"catMetaRobots\":\"\",\"catMetaAuthor\":\"\"}','*')