Joomla Templates Club 406,261 posts

[janbielik Friend janbielikJoin date: August 2010Posts: 51Downloads:0Uploads:12 Thanks: 6]

#188336

Hi. My CMS runs on JOOMLA 2.5 – latest version. I was adding articles as usual. Sometimes I get this message:

500 – Incorrect key file for table ‘/tmpfs/#sql_34af_13.MYI’; try to repair it SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ‘ ‘ THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM dlx_content AS a LEFT JOIN dlx_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN dlx_categories AS c ON c.id = a.catid LEFT JOIN dlx_users AS ua ON ua.id = a.created_by LEFT JOIN dlx_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM dlx_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN dlx_categories as parent ON parent.id = c.parent_id LEFT JOIN dlx_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM dlx_categories AS cat JOIN dlx_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = ‘com_content’ AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid = 91 AND (a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2013-06-19 15:02:58’) AND (a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2013-06-19 15:02:58’) GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 0, 100

Screenshot from https://deluxtrade.com/monitoring/zahranicne-media

MySQL is in 5.1 version. This was never shown before! Please help.

[janbielik Friend janbielikJoin date: August 2010Posts: 51Downloads:0Uploads:12 Thanks: 6]

#496370

This error is shown only sometimes. It is unacceptable to run site with this. I have wrote to several forums, but nobody is able to help me and reply. I have possibility to migrate from 5.1 to 5.5 MySQL, but have no experience how to do that. Will this help or it is needed something else to solve it. I do not want to hurry somebody, but it is very urgent. This site belongs to top sites in this business.I have posted all access data needed. There are 6041 articles database is quite large.

This was also shown in admin area:

Error writing file ‘/tmpfs/MYYe1GmY’ (Errcode: 28) SQL=SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name FROM dlx_content AS a LEFT JOIN `dlx_languages` AS l ON l.lang_code = a.language LEFT JOIN dlx_users AS uc ON uc.id=a.checked_out LEFT JOIN dlx_viewlevels AS ag ON ag.id = a.access LEFT JOIN dlx_categories AS c ON c.id = a.catid LEFT JOIN dlx_users AS ua ON ua.id = a.created_by ORDER BY a.hits DESC LIMIT 0, 5

I am using Joomla 2.5 from the beginnig WITHOUT ANY PROBLEMS, but I am not able to fix this alone. MANY ththanks for SUPPORT. I am waiting for help.

[phong nam Friend phong namJoin date: May 2015Posts: 3779Downloads:1Uploads:587 Thanks: 499 Thanked: 974 times in 888 posts]

#496441

Hi janbielik,

It is an error of your SQL when maybe you migrated your SQL 4 to 5.x for Joomla 2.5 template (JA Tiris 2.5 version) before.
Pls login cpanel (phpmyadmin), then export & backup all database of your website. Then try to follow below tips to solve your issue:

http://forums.cpanel.net/f354/help-failed-upgrade-mysql-4-1-5-1-corrupt-tables-144293.html
http://www.uk-cheapest.co.uk/blog/2011/10/how-to-fix-joomla-error-incorrect-key-file-for-table-jos_session-try-to-repair-it/

[Author]

Posts