I got this error

TableK2Item::store failed - Incorrect key file for table



I found this on the joomla site.

I reported it to my hosting provider and they told me that it was an error in their global mysql service and
they had to fix it.

Else I had to repair the jos_session table from MyPhPAdmin:
1) Enter your Hosting Cpanel
2) Select PhpMyAdmin
3) Select your data base
4) Check the table jos_session
5) At the bottom search for a drop list and select the option: repair
the table
That worked for me.



My host helped me fix it and said that is was caused by a lot of adding and deleting.

Concerned me because, that is what we do add content. It will probably happen again



He gave me this link when I asked if there was a way I could fix it automatically...



www.mydigitallife.info/2007/09/21/check-and-optimize-mysql-database-automatically-with-crontabcron/



Just incase anyone else runs into similar problems.

Hello,please anyone be so kind to help me... i have a really bad day because of this error message:/Im using joomla 1.5.15 and k2 v2.2after i add any extra field to any category i receive such a message (see attached)..please, any suggestions?p.s. im using rockettheme affinity template (everything else works fine).please please please...DB function failed with error number 1064You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'AND published=1
AND trash=0 AND access<=1' at line 1 SQL=SELECT * FROM
jos_k2_categories WHERE id= AND published=1 AND trash=0 AND access<=1




Warning: Invalid argument supplied for foreach() in /home/a3930998/public_html/components/com_k2/sef_ext/com_k2.php on line 98this one allso don't workhttp://www.joomvision.com/Blog/How-to-solve-the-K2-Database-error-DB-function-failed-with-error-number-1064.htmlim getting a new "warning on line"

Hello,im using k2v2 joomla 1.5.15 and i have some problems with extra fields...when i try to assign any of them to some category i get an error:DB function failed with error number 1064You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'AND published=1
AND trash=0 AND access<=1' at line 1 SQL=SELECT * FROM
jos_k2_categories WHERE id= AND published=1 AND trash=0 AND access<=1
PHP Error Message



Warning: Invalid argument supplied for foreach() in /home/a3930998/public_html/components/com_k2/sef_ext/com_k2.php
on line 98
but anyway extra fields adds sucessfully. Where could be the problem?this one doesn't work:http://www.joomvision.com/Blog/How-to-solve-the-K2-Database-error-DB-function-failed-with-error-number-1064.htmlplz help someone... maybe there are some additional settings i need to change in extra fields?

This refuses to work for me, am i missing out something? I have followed the steps but still i get Invalid argument supplied for foreach() in \components\com_k2\views\latest\view.html.php on line 120. Any help please i am really having a headache on this.

tonino said:Hello my friend, I resolved in this way (I am no expert in php): i have edit / components/com_k2/templates/default/item.php look for the line of code n 354

I attach a file in text format because it is impossible to paste code on this forum

To me it worked!

Sorry for my English

I want the same functionality for registered members to post news. I have created an item menu but i get an item not found error, am i missing out on something? There is also an option to point to an item to display but with it there isn't a link to post news. In my own opinion i thought it was there so that an item can be featured itself. Also my latest news link wont work, am still getting Warning: Invalid argument supplied for foreach() in \components\com_k2\views\latest\view.html.php on line 120 error, i tried replacing with a code from forum member tonico [Attachment bug: SQL error ] file modified.rtf but nothing worked i still get the error. Please help with this. Thank you.

Olivier Nolbert said:Hi Nick,
You have to create an item menu that links to a k2 itemlist view, then just connect to the front-office of your website, click on the item menu and you should have a link 'Add an item...' at the top right of the page.

Are you french ?

Olivier

Yes i know this stuff might happen when using SVN. But what is good is that we do discover some bugs and get rid of them to the next release:-)

Lefteris Kavadas said:Hi. You are right about this bug. Just fixed it. Please note that when using the SVN version you may encounter in such kind of issues. Thank you for reporting this issue to us.

Hi. You are right about this bug. Just fixed it. Please note that when using the SVN version you may encounter in such kind of issues. Thank you for reporting this issue to us.

Thanks for your code - this has solved my headache. - Fixed the problem

tonino said:Hello my friend, I resolved in this way (I am no expert in php): i have edit / components/com_k2/templates/default/item.php

look for the line of code n 354

I attach a file in text format because it is impossible to paste code on this forum

To me it worked!

Sorry for my English

Hi Mickey,

Seems by the error message that this is a problem with your database and not K2.
I would suggest that your restore your database to before the bulk upload.
Recheck your upload file for errors, consider importing in the data in two smaller batches.

I would consult the documentation for mysql, check the mysql forums or speak with your host company.

Regards,

Simon
K2Joom.com

Hi,

 

I have inserted an image in my article. When clicking on the image from the category view, the item (page) opens and the image gets bigger. But on top of the page i get the following message:

 

No valid database connection 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 ') AND itemID!=4' at line 1 SQL=SELECT DISTINCT itemID FROM jos_k2_tags_xref WHERE tagID IN (,) AND itemID!=4

I am running joomla v. 1.5.5, latest k2 with the "beta" version for frontend editing with joomfish installed.

Maybe it has something to do with the beta version, but anyway i need to fix it.

 

Does anyone know how and in which file i can fix this?

Hi, I just figured out the issue. It required some digging. Basically the tables were not created during the install process. My issue was the SQL file used by K2 in the install package had some statements that were throwing errors with MySQL 4.X that was on my server. I updated to 5.X and now K2 is installed and everything works great.

Thanks.

Hi, I'm having the same issue. Downloaded the latest k2 install zip file and this error comes up after a "success" message:

Thank you for installing K2 by JoomlaWorks, the powerful content component for Joomla! 1.5.

Warning: Invalid argument supplied for foreach() in ../joomla/libraries/joomla/database/database/mysql.php on line 678

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in ../joomla/administrator/components/com_k2/install.k2.php on line 73

Warning: Invalid argument supplied for foreach() in ../joomla/administrator/components/com_k2/install.k2.php on line 103

---

This issue doesn't occur when I installed it on my local that uses XAMPP. Any ideas?

Thanks!

Hi,

The problem is when trying to search in the tags, if you turn it off from the Search_K2 plugin parameters, the error won't show anymore, of course you'll lose the tag searching functionality.

As far as I can tell, this is a bug in the K2 Search plugin, since it uses MySQL's MATCH function incorrectly. So the best thing to do is to go back to the old plugin, where the search is done using the LIKE operator.

In the MySQL Site it explains that the MATCH function in NATURAL LANGUAGE MODE performs a search against a text collection, and a text collection can only exist within a table. When the plugin tries to search the tags it adds a foreign column into the MATCH function, which of course breaks the query.

Art.

Hi. The queries you posted are from the K2 component search not the K2 search plugin. The queries are fine. Maybe providing a link to your site will help us see what's wrong.

cmath said:Hi Lefteris, The following sql query is executed, but there are no errors on the page, although the search is not returning any results:
SELECT i.*, 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 <= 2
AND i.trash = 0
AND c.published = 1
AND c.access <= 2
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-02-17 10:51:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-02-17 10:51:06' )
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 ('ramakrishna')
ORDER BY i.id DESC
LIMIT 0, 10
SELECT COUNT(*)
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 2
AND i.trash = 0
AND c.published = 1
AND c.access <= 2
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-02-17 10:51:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-02-17 10:51:06' )
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 ('ramakrishna')

Thanks,

Lefteris Kavadas said:Hi. Are you getting any error? Please enable debug mode and check the query ( or post it here....). cmath said:Lefteris, I have set Enable search in tags to NO, but still have the problem in search. What is the fix for this? Could you provide us the updated search file?

Hi Lefteris,
The following sql query is executed, but there are no errors on the page, although the search is not returning any results:
SELECT i.*, 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 <= 2
AND i.trash = 0
AND c.published = 1
AND c.access <= 2
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-02-17 10:51:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-02-17 10:51:06' )
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 ('ramakrishna')
ORDER BY i.id DESC
LIMIT 0, 10
SELECT COUNT(*)
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 2
AND i.trash = 0
AND c.published = 1
AND c.access <= 2
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-02-17 10:51:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-02-17 10:51:06' )
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 ('ramakrishna')

Thanks,

Lefteris Kavadas said:Hi. Are you getting any error? Please enable debug mode and check the query ( or post it here....). cmath said:Lefteris, I have set Enable search in tags to NO, but still have the problem in search. What is the fix for this? Could you provide us the updated search file?

I just bought the Simple Image Gallery Pro (as i was very happy with the Frontpage Slideshow, which i also bought).
I have a problem though with installation.
I am getting the following error:

I really don't have a clue what is wrong, maybe someone can help me out (using Joomla 1.5)

I'm using:

Joomla 1.5.15
MySQL 5.1.30
PHP 5.2.9
Apache 2.2.11


Fernando P said:I'm having exactly the same problem. Any solutions yet?
No k2 results on normal mode, and this errorwith debug ON

JDatabaseMySQL::query: 1210 - Incorrect arguments to MATCH SQL=SELECT i.title AS title, i.metadesc, i.metakey, c.name as section, i.image_caption, i.image_credits, i.video_caption, i.video_credits, i.extra_fields_search, tags.name as tag, i.created, CONCAT(i.introtext, i.fulltext) AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM jos_k2_items AS i INNER JOIN jos_k2_categories AS c ON c.id=i.catid AND c.access <= 18 LEFT JOIN jos_k2_tags_xref tags_xref ON tags_xref.itemID = i.id LEFT JOIN jos_k2_tags tags ON tags.id = tags_xref.tagID WHERE MATCH(i.title, i.introtext, i.`fulltext`,tags.name,i.extra_fields_search,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.metadesc,i.metakey) AGAINST ('clara') AND i.trash = 0 AND i.published = 1 AND i.access <= 1 AND c.published = 1 AND c.access <= 1 AND c.trash = 0 GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

I'm having exactly the same problem. Any solutions yet?

No k2 results on normal mode, and this errorwith debug ON

JDatabaseMySQL::query: 1210 - Incorrect arguments to MATCH SQL=SELECT i.title AS title, i.metadesc, i.metakey, c.name as section, i.image_caption, i.image_credits, i.video_caption, i.video_credits, i.extra_fields_search, tags.name as tag, i.created, CONCAT(i.introtext, i.fulltext) AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM jos_k2_items AS i INNER JOIN jos_k2_categories AS c ON c.id=i.catid AND c.access <= 18 LEFT JOIN jos_k2_tags_xref tags_xref ON tags_xref.itemID = i.id LEFT JOIN jos_k2_tags tags ON tags.id = tags_xref.tagID WHERE MATCH(i.title, i.introtext, i.`fulltext`,tags.name,i.extra_fields_search,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.metadesc,i.metakey) AGAINST ('clara') AND i.trash = 0 AND i.published = 1 AND i.access <= 1 AND c.published = 1 AND c.access <= 1 AND c.trash = 0 GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

NVM. I figured it out. Didn't know how tied in everything was...

Closed.

Ok I think I know how to fix this, but I could use some help finding something. How do you reset the filter to be 20 users shown instead of all users shown? Seems that there is just too many people showing up for the memory limit to handle the request.