DB Error message with FlexiContent (incorrect key file)

More
10 years 10 months ago #43798 by KingBis
Hi,

since a certain time I have this problem with FlexiContent :



or



I don't know why and how to solve it.

Thank you in advance for your help.

"Nous ne dirons pas que les Grecs combattent tels des héros, mais que les héros combattent tels des Grecs" Winston Churchill

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #43801 by gkhn
it would be better if you posted the error message using code tag in this forum.

cropped error messages I think it will not help.

it looks like db is crashed or maybe user does not have db permissions?

did you try to repeair the database?

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #43802 by KingBis
Thank you for the reply.

You are right, I did not notice for images.

Here an exemple of error :
Code:
SELECT i.*, ie.*, ty.name AS typename, 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 categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.state IN ( 1, -5 ) AND c.id IN (211,210,212,117,208,128,209,207,145,155,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,204,203,215,217,220,221) GROUP BY i.id ORDER BY i.created DESC, i.title Incorrect key file for table '/tmp/#sql_2833_0.MYI'; try to repair it SQL=SELECT i.*, ie.*, ty.name AS typename, 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 categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM jom17_content AS i LEFT JOIN jom17_flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN jom17_flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN jom17_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jom17_categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.state IN ( 1, -5 ) AND c.id IN (211,210,212,117,208,128,209,207,145,155,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,204,203,215,217,220,221) GROUP BY i.id ORDER BY i.created DESC, i.title LIMIT 0, 15 SELECT i.*, ie.*, ty.name AS typename, 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 categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.state IN ( 1, -5 ) AND c.id IN (211,210,212,206,96,117,208,128,209,207,145,155,205,161,160,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,204,203,215,217,220,221) GROUP BY i.id ORDER BY i.created DESC, i.title Incorrect key file for table '/tmp/#sql_2833_0.MYI'; try to repair it SQL=SELECT i.*, ie.*, ty.name AS typename, 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 categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM jom17_content AS i LEFT JOIN jom17_flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN jom17_flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN jom17_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jom17_categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.state IN ( 1, -5 ) AND c.id IN (211,210,212,206,96,117,208,128,209,207,145,155,205,161,160,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,204,203,215,217,220,221) GROUP BY i.id ORDER BY i.created DESC, i.title LIMIT 0, 100 SELECT i.*, ie.*, ty.name AS typename, 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 categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.id <> 0 AND i.state IN ( 1, -5 ) AND c.id IN (145,155,161,208,217) GROUP BY i.id ORDER BY i.created DESC, i.title Incorrect key file for table '/tmp/#sql_2833_0.MYI'; try to repair it SQL=SELECT i.*, ie.*, ty.name AS typename, 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 categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM jom17_content AS i LEFT JOIN jom17_flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN jom17_flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN jom17_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jom17_categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.id <> 0 AND i.state IN ( 1, -5 ) AND c.id IN (145,155,161,208,217) GROUP BY i.id ORDER BY i.created DESC, i.title LIMIT 0, 5

did you try to repeair the database?


To be honest, I don't know how to do that. I am a beginner in server and everything that goes with.

"Nous ne dirons pas que les Grecs combattent tels des héros, mais que les héros combattent tels des Grecs" Winston Churchill

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #43805 by gkhn

Kingbis wrote: Thank you for the reply.

You are right, I did not notice for images.

Here an exemple of error :

did you try to repeair the database?


To be honest, I don't know how to do that. I am a beginner in server and everything that goes with.

Have a look at this video explaining how to repair your db


You shpould also check your db username permissions.
docs.cpanel.net/twiki/bin/view/AllDocume...0User's%20Privileges

BUT before you play around with database backup your website!
and test the backup that you have taken! otherwise it is possible that you may crash the site completely especially if you dont know and have not done this before and you will not be able to take it back to where it was working as normal before.

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #43836 by ggppdk
Hello

for some reason you have crashed/corrupt DB Tables, please (if possible) backup you DB and then repair it (e.g. via Cpanel/phpmyadmin)


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 1.873 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline