COMMUNITY FORUM
Search Results (Searched for: Re Error SQL)
- Pellegrino Lippiello
Error Adding new Articles
Category: English K2 Community
i have a problem: when i Try to add a new article , it is not possible to add because there is this error:
TableK2Item::store failed - Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `jos_k2_items` ( `id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`video_caption`,`video_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`metadata`,`metadesc`,`metakey`,`params` ) VALUES ( '','prov','prov','21','1','\r\n prrr
','','','','','','2013-02-17 10:10:28','62','','2013-02-17 10:10:28','0000-00-00 00:00:00','0','7','0','robots=\nauthor=','','','catItemTitle=\ncatItemTitleLinked=\ncatItemFeaturedNotice=\ncatItemAuthor=\ncatItemDateCreated=\ncatItemRating=\ncatItemImage=\ncatItemIntroText=\ncatItemExtraFields=\ncatItemHits=\ncatItemCategory=\ncatItemTags=\ncatItemAttachments=\ncatItemAttachmentsCounter=\ncatItemVideo=\ncatItemVideoWidth=\ncatItemVideoHeight=\ncatItemAudioWidth=\ncatItemAudioHeight=\ncatItemVideoAutoPlay=\ncatItemImageGallery=\ncatItemDateModified=\ncatItemReadMore=\ncatItemCommentsAnchor=\ncatItemK2Plugins=\nitemDateCreated=\nitemTitle=\nitemFeaturedNotice=\nitemAuthor=\nitemFontResizer=\nitemPrintButton=\nitemEmailButton=\nitemSocialButton=\nitemVideoAnchor=\nitemImageGalleryAnchor=\nitemCommentsAnchor=\nitemRating=\nitemImage=\nitemImgSize=\nitemImageMainCaption=\nitemImageMainCredits=\nitemIntroText=\nitemFullText=\nitemExtraFields=\nitemDateModified=\nitemHits=\nitemCategory=\nitemTags=\nitemAttachments=\nitemAttachmentsCounter=\nitemVideo=\nitemVideoWidth=\nitemVideoHeight=\nitemAudioWidth=\nitemAudioHeight=\nitemVideoAutoPlay=\nitemVideoCaption=\nitemVideoCredits=\nitemImageGallery=\nitemNavigation=\nitemComments=\nitemTwitterButton=\nitemFacebookButton=\nitemGooglePlusOneButton=\nitemAuthorBlock=\nitemAuthorImage=\nitemAuthorDescription=\nitemAuthorURL=\nitemAuthorEmail=\nitemAuthorLatest=\nitemAuthorLatestLimit=\nitemRelated=\nitemRelatedLimit=\nitemRelatedTitle=\nitemRelatedCategory=\nitemRelatedImageSize=\nitemRelatedIntrotext=\nitemRelatedFulltext=\nitemRelatedAuthor=\nitemRelatedMedia=\nitemRelatedImageGallery=\nitemK2Plugins=\n\n' )
How can i solve it?
Thanks
- Christian Rerucha
Too many open database connections...
Category: English K2 Community
Anyway, We have a joomla 2.5.7 website. We have just 3 third party extensions:
1. K2
2. Breezing Forms
3. Akeeba Backup (which is currently NOT set up to back up automatically)
Almost every Friday morning at about 2:30 am (PST), our database is flooded with SQL requests, coming from our site. At 200 simultaneous connections, the database is automatically shut down (godaddy), and from that point forward, I have to call godaddy, have them manually close all the connections to the database, and essentially "Restart" the the database.
This ha been happening like clockwork for the last six months. Godaddy has not been helpful, nor forthcoming with information to assist in the "hunt" for the problem... until today. This morning, they were able to give me a clue. The following SQL request seems to be the culprit:
SELECT i.* ,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged ,
c.name as categoryname ,
c.id as categoryid ,
c.alias as categoryalias ,
c.params as categoryparams
FROM jos_k2_items as i LEFT JOIN jos_k2_categories AS c ON c.id = i.catid
WHERE i.published = 1 AND
i.access IN(1 , 1 ) AND
i.trash = 0 AND
c.published = 1 AND
c.access IN(1 , 1 ) AND
c.trash = 0 AND
( i.publish_up = '0000-00-00 00:00:00' OR
i.publish_up <= '2013-02-15 10:22:34' ) AND
( i.publish_down = '0000-00-00 00:00:00' OR
i.publish_down >= '2013-02-15 10:22:34' ) AND
MATCH(i.title ,
i.introtext ,
i.`fulltext` ,
i.image_caption ,
i.image_credits ,
i.video_caption ,
i.video_credits ,
i.extra_fields_search ,
i.metadesc ,
i.metakey) AGAINST ('Search...*' IN BOOLEAN MODE)
ORDER BY i.id DESC
LIMIT 0 , 10
So, let's start here. Is there any help you can give me? Does this code (or COULD this code) have anything to do with the "Too many connections" error that throws our site offline?
P.S. If I need to be posting this question somewhere else, please direct me to do so. As I said, I'm new this this whole forum thing. Apologies...
- Andrew Nashaat
An error has occurred !!
Category: English K2 Community
When I try to create a new category, item or anything it gives me :
500 - An error has occurred.
Table 'sp******_forth.cc0l_finder_types' doesn't exist SQL=SELECT `id` FROM `cc0l_finder_types` WHERE `title` = 'K2 Item' :silly:
Any help !!
- donna moy
[Solved] This is not an image file - ERROR!
Category: Frontpage Slideshow
I read the thread above and tried everything to no avail.
My GD Image is enabled, i rebuilt Apache and rebooted the server. Still doesn't work.
Web server Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP version 5.3.21
MySQL version 5.1.66-cll
GD Image library bundled (2.0.34 compatible)
Upload limit 2MB
Memory limit 64M
- Jani
K2 installation fails, database tables not created
Category: English K2 Community
When installing K2_v2.6.3.zip via Joomla Extension manager, the installation fails with error 500 SQL=SHOW FULL COLUMNS FROM j_k2_categories. The problem is that MySQL tables are not being created with the installation script automatically.
I was able to complete the installation by manually creating tables from administrator/components/com_k2/install.mysql.sql file. I copied and edited the file with the right prefix for tables, ran the SQL commands manually from the command line and tried the installation again, tthis time it worked.
However, I'm not sure if the K2 extension works ok, because some tables might still be missing and/or it could be that some data is missing from the tables.
It seems to be a bug in K2 installation, because other joomla tables and other extensions has been installed fine with the extensions manager. I would like to hear if there is any fix for this, or alternatively a better error message from the K2 installer describing in detail why it's unable to create the tables would be nice. With joomla debug mode on it seems that K2 installer is not even trying to run "create table" statements before trying to access a table with SHOW FULL COLUMNS.
Best,
Jani
- Cecile Bekker
Upload Articles to Items again and got error!
Category: English K2 Community
Am a kamakazi when it comes to technical stuff -
I just trashed articles in Items that I uploaded from Article Manager to Items before
- I worked in Articles making changes to my pages so I thought to reload them into Items so they are updated - so trash the ones in Items and reloaded Articles from Joomla Article Manager ---
- NOW got this error....
Table 'simplype_joom137.jos_finder_types' doesn't exist SQL=SELECT `id` FROM `jos_finder_types` WHERE `title` = 'K2 Item'
site link is simply4pets.co.za/joomla16/administrator/index.php?option=com_k2&view=items
- not publish yet ...
Am very new to K2 but find it amazing! Please advice before I do to much damage to my site! Hosting company dont give 3rd party assistance!
THANK YOU!
- danny leary
RSS Feed not working
Category: English K2 Community
The above method does work for a feed if needed. The only issue i found with the above script is that the date is not getting added correctly or changed to the correct pubDate rss format from the sql table. A big deal for mailchimps rss to email feature.
However after hours of trying to impplement a custom solution, i regressed back to seeing if i could fix the issue i was having with the k2 rss feature. In firefox i would get a subscription option but the page was empty. in chrome, thankfully it atleast parsed the text and i could see that items were indeed getting put into the xml, so what was going on. Mailchimp said that the feed was invalid.
so i went to see if Google feedburner could generate a feed from the blog's url. It of course found the k2 rss feed url path in the header. However, it did pass me an error "The entity name must immediately follow the '&' in the entity reference." on line ten of my xml which the feed validator from feedvalidator.org showed was the description; which in k2 is taken from a metatag field. From an internet search it seems that this error is due to the '&' not being parsed correctly in my metatag description used to generate the rss' description. I found the metatag from whence the description came, changed '&' to 'and' and walla! The error went away, the feed validated, and mailchimp took it and it has the date correctly formatted which should trigger the auto email!
I sure the problems with xml and k2 that some have experienced might be due to various issues. But in my case with the latest k2 and joomla (2.5) the feed itself was good, just a bad character not getting dealt with well by the xml. Once this was fixed in the description, all was well. Which i am glad for. I learned much about rss, php, and xml when toying with all the tutorials, but there are just soooo many different ways of doing it and sadly, most of them just plain don't work :) at least without a lot of customization, trial and error.
Hopefully this helps some :)
- Hairy Dog Digital
32M memory limit in K2 ONLY?
Category: English K2 Community
I am working on a site and having issues with K2 (v 2.5.7) item pages (in Joomla 2.5.6) intermittently presenting as blank empty pages.
When I check the server error log, I get the familiar, "PHP Fatal error: Allowed memory size of 33554432 bytes exhausted..."
The PHP memory on the server is set to 128M. I've confirmed this via a phpinfo() and via the Joomla back-end System Information.
When I look at the K2 system information in the backend it is reporting only 32M system memory.
I put a PHP statement of: echo ini_get('memory_limit') at the bottom of the site's template index.php page and at the bottom of the administrator/index.php page. On all components EXCEPT FOR K2, the statement output shows 128M. Whenever a K2 component is used -- either in the frontend or backend -- the statement output shows 32M.
I've been digging through all of the K2 coding (and the MySQL database) trying to find anything that may be causing this: .htaccess file, php.ini file, ini_set("memory_limit") in a php file. No luck.
Have anyone ever encountered this before? I'm scratching my head on this one.
- kunle
[SOLVED] Re: K2 front-end save and close
Category: English K2 Community
Php 5.3.10
MySQL 5.5.20
Joomla 2.5.8
I'm currently building a site offline using wampserver so after installing K2 I noticed neither 'Save & Close' nor 'Save & New' buttons worked in back-end.
Then in the JS error console (using firefox browser) I noticed these errors:
Get ajax.googleapis.com/ajax/libs/jquery/1.8/jquery.min.js
X ReferenceError: jQuery is not defined
Get ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js
X TypeError: $K2 is not a function
Since the system is not connected to internet I guessed the 'http' header for 'googleapis' might be the cause so here's what I did that fixed it:
Navagated to K2 Parameter i.e.
Parameters > Layouts & Views > CSS & JavaScript Settings > Backend jQuery & jQuery UI handling
By default it was set to 'Load a remote copy of jQuery & UI' so I switched this to 'Load a local copy of jQuery & UI' then saved the settings. Now the 'Save & Close' and 'Save & New' buttons works fine.
Went back to JS error console (using firefox browser) refreshed the screen and
'X ReferenceError: jQuery is not defined' and
'X TypeError: $K2 is not a function' errors are not shown anymore.
As soon as my site is developed & put on a hosting server I shall switch back to 'Load a remoted copy of jQuery UI to see If the error will return.
- MJ
Can't upload image to the item/image
Category: English K2 Community
Here are my Settings, perhaps someone can give a hint on what it could be:
My test images:
image 1 - 800x600x24b JPEG (94,6kb) = 500 (Internal Server Error)
image 2 - 400x640x24b JPEG (80,8kb) = 500 Internal Server Error in 9 of 10
image 3 - 300x240x24b JPEG (67,5kb) = ok in 9 of 10
Versions:
Joomla 2.5.8
K2 v2.6.2
Folders:
all exist and have 777 (for test environment 'media' incl. all subfolders have 777)
/media (777 incl. all subfolders)
/cache (777)
/tmp (777)
My PHP settings:
Apache/2.2.22
PHP Version 5.3.8 (version 4 tested, same effect)
MySQL-Version 5.1.60-log
memory_limit 100M
upload_max_filesize 8M
max_execution_time 90
GD Version bundled (2.0.34 compatible)
register_globals off
safe_mode off
**********************
Reloading (F5) helps sometimes.
Sometimes, 2 images (resolutions) are generated, but the rest do not and it stops
What can i do?
Newer than new is impossible .. :blink:
*********************
Many Thanks for your help, MJ
- Peter Grube
Errors everywhere
Category: English K2 Community
For some reason K2 is not creating the User table in the database, hence the Table 'escapeforlife.vajxp_k2_user_groups' doesn't exist SQL=SELECT id AS value, name AS K2UserGroup FROM vajxp_k2_user_groups - error message.
By the looks of it, it's a file permissions problem, when I checked Joomla File permissions, It say's configuration.php file not writable, try changing that file permission to 666 then try reinstall.
- Antony
Errors everywhere
Category: English K2 Community
TableK2UserGroup: :store failed
Table 'escapeforlife.vajxp_k2_user_groups' doesn't exist SQL=INSERT INTO `vajxp_k2_user_groups` (`id`,`name`,`permissions`) VALUES ('','Public','{\"comment\":\"1\",\"frontEdit\":\"0\",\"add\":\"0\",\"editOwn\":\"0\",\"editAll\":\"0\",\"publish\":\"0\",\"inheritance\":\"0\"}')
do I need to do a reinstall of Joomla?
- Peter Grube
User choose K2 User Group during registration
Category: English K2 Community
The only way I could achieve this functionality was by using Community Builder to handle both the Registration & Profile but although the CB is free you need to purchase either their Conditionals plugin or alternately get the third party Community Builder Profile Pro which is able to create different profile types & Registration forms.
The only drawback is that although you can select different user types during registration, & K2 adds them to your list of users, it doesn't automatically add them to your K2 User Groups. So they cannot add items until you add them manually. Which in my case is ok, because I need to approve the users anyway.
While I am at it I thought I would ask for some feedback from the Admins here, this link mentions the same problem about syncing CB & K2 but it's over 2 yrs old, I am hoping I am missing something.
One last thing in the CB Forum has suggested work around for this but my PHP skills are limited & I am getting the dreaded white screen of death.
It says around line 957 begins the function "function saveRegistration( $option )", at the end of this function, before the "}" sign insert this code (it must be a part of the function) ...
Could someone point out where exactly is the end of this function.
- Jim

15 Dec 2012 00:15 Replied by Jim on topic Issues installing K2 2.6.2 with Joomla 2.5.7 Issues installing K2 2.6.2 with Joomla 2.5.7
Category: English K2 Community
I'm new to K2 but not to Joomla.
I had similar warnings upon installation of K2, and have set warnings to none. When I try to make a K2 category I get this failure error:
TableK2Category: :store failed
Table 'oabjlkyi_1721969.jos_k2_categories' doesn't exist SQL=INSERT INTO `jos_k2_categories` (`id`,`name`,`alias`,`description`,`parent`,`published`,`access`,`ordering`,`params`,`language`) VALUES ('','News and events','news-and-events'... etc.
Any thoughts?
- Samantha
Blank Page
Category: English K2 Community
Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with that of JRegistry::loadSetupFile() in /home/samprins/public_html/libraries/joomla/html/parameter.php on line 512
Strict Standards: Declaration of fancyboxClass::getHeaderLibrary() should be compatible with that of JAPopupHelper::getHeaderLibrary() in /home/samprins/public_html/plugins/system/japopup/fancybox/fancybox.php on line 17
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/plugins/system/k2/k2.php on line 306
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/plugins/system/k2/k2.php on line 27
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/plugins/system/k2/k2.php on line 120
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/plugins/system/jalazyload/jalazyload.php on line 37
And then when I go to the comments area to check what error I get, I see nothing but this:
Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with that of JRegistry::loadSetupFile() in /home/samprins/public_html/libraries/joomla/html/parameter.php on line 512
Strict Standards: Declaration of fancyboxClass::getHeaderLibrary() should be compatible with that of JAPopupHelper::getHeaderLibrary() in /home/samprins/public_html/plugins/system/japopup/fancybox/fancybox.php on line 17
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/plugins/system/k2/k2.php on line 306
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/plugins/system/k2/k2.php on line 27
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/admin.k2.php on line 14
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/admin.k2.php on line 18
Strict Standards: Non-static method K2HelperPermissions::checkPermissions() should not be called statically in /home/samprins/public_html/administrator/components/com_k2/admin.k2.php on line 39
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/components/com_k2/helpers/permissions.j16.php on line 19
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/components/com_k2/helpers/permissions.j16.php on line 20
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/admin.k2.php on line 66
Strict Standards: Declaration of K2ControllerComments::display() should be compatible with that of JController::display() in /home/samprins/public_html/administrator/components/com_k2/controllers/comments.php on line 15
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/views/comments/view.html.php on line 21
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/views/comments/view.html.php on line 22
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/views/comments/view.html.php on line 40
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/views/comments/view.html.php on line 41
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/models/comments.php on line 65
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/models/comments.php on line 68
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/models/comments.php on line 21
Strict Standards: Only variables should be assigned by reference in /home/samprins/public_html/administrator/components/com_k2/models/comments.php on line 24
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 82 bytes) in /home/samprins/public_html/libraries/joomla/database/database/mysql.php on line 706
Any ideas?
- Vivek Moorthy
Issues installing K2 2.6.2 with Joomla 2.5.7
Category: English K2 Community
I've seen a number of threads on google about this, but no definitive answers.
Here is the issue. I have a QuickInstall instance of Joomla 2.5.7 (HostGator). Nothing else is installed in the instance.
I'm getting the following error message on the install of K2.
Thank you for installing K2 by JoomlaWorks, the powerful content extension for Joomla!
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/libraries/joomla/database/database/mysql.php on line 375
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/libraries/joomla/database/database/mysql.php on line 375
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/tmp/install_50b57849205db/script.k2.php on line 212
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/tmp/install_50b57849205db/script.k2.php on line 233
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/libraries/joomla/database/database/mysql.php on line 375
I'm also getting similar errors with categories:
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/administrator/components/com_k2/models/categories.php on line 80
and items:
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/libraries/joomla/database/database/mysql.php on line 383
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/libraries/joomla/database/database/mysql.php on line 383
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/libraries/joomla/database/database/mysql.php on line 383
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/libraries/joomla/database/table.php on line 409
Warning: Invalid argument supplied for foreach() in /home/djtiger/public_html/libraries/joomla/html/html/select.php on line 504
Please advise at your earliest convenience. Thanks.
- Johan Wedel
Fatal Error - please help
Category: English K2 Community
This is what the information screen is showing:
Web Server Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP version 5.3.6
MySQL version 5.0.96-community-log
GD image library bundled (2.0.34 compatible)
Multibyte string support Disabled
Upload limit 8M
Memory limit 32M
Open remote files (allow url fopen) Yes
I host my own server with WHM/cPanel, so not sure how to enable it. I will try the link you provided, but hope I dont screw something up :)
- yoyo
glossary and k2
Category: English K2 Community
Column count does not match value count at row 1 SQL = INSERT INTO `` jnew_finder_tokens "
a solution?
thank you
- Márcio Silva
ERRO mysql.php on line 383 RESOLVED
Category: Frontpage Slideshow
You are correct, are warning but to my customer is ERROR.
I get on installation Joomla 2.5
Hi the problem was resolved
Only reinstalling of the component.
Thanks
- Katia
ERRO mysql.php on line 383 RESOLVED
Category: Frontpage Slideshow