serious error: t error 28 from storage engine SQL=SELECT ...

This forum is for general questions about extensions for Joomla! version 1.5.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
unleash_it
Joomla! Ace
Joomla! Ace
Posts: 1311
Joined: Wed Nov 05, 2008 11:28 pm

serious error: t error 28 from storage engine SQL=SELECT ...

Post by unleash_it » Sun May 05, 2013 6:14 pm

hello dear joomla-fans

got the following error on my page:

btw - my server admin told me days ago - that he detected a error - that some intrusion may have
taken place..
what do you say!`? see the following page: http://www.literaturen.org

btw. i have to admit: i run the site in version 1-5-7or something like that....

love to hear from you


greetings
unleash

Code: Select all


Got error 28 from storage engine 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.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 ) 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 vjl1p_content AS a LEFT JOIN vjl1p_categories AS c ON c.id = a.catid LEFT JOIN vjl1p_users AS ua ON ua.id = a.created_by LEFT JOIN vjl1p_users AS uam ON uam.id = a.modified_by LEFT JOIN vjl1p_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN vjl1p_categories as parent ON parent.id = c.parent_id LEFT JOIN vjl1p_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM vjl1p_categories AS cat JOIN vjl1p_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 INNER JOIN vjl1p_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-05 18:06:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-05 18:06:47') GROUP BY a.id ORDER BY c.lft, fp.ordering, a.created DESC LIMIT 0, 3 Got error 28 from storage engine 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.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 ) 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 vjl1p_content AS a LEFT JOIN vjl1p_categories AS c ON c.id = a.catid LEFT JOIN vjl1p_users AS ua ON ua.id = a.created_by LEFT JOIN vjl1p_users AS uam ON uam.id = a.modified_by LEFT JOIN vjl1p_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN vjl1p_categories as parent ON parent.id = c.parent_id LEFT JOIN vjl1p_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM vjl1p_categories AS cat JOIN vjl1p_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 INNER JOIN vjl1p_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-05 18:06:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-05 18:06:47') GROUP BY a.id ORDER BY c.lft, fp.ordering, a.created DESC
regards un-leash,
a big fan for ++ 11 years now: With Joomla you can easily create and extend your website: see the site, that offers you ideas & modules - extensions.joomla.org - it lists over 4000 extensions

 
unleash_it
Joomla! Ace
Joomla! Ace
Posts: 1311
Joined: Wed Nov 05, 2008 11:28 pm

Re: serious error: t error 28 from storage engine SQL=SELECT

Post by unleash_it » Sun May 05, 2013 11:03 pm

Hi dear guys

followed the hints and had a quick view on the issues - found out the following:

http://forum.joomla.org/viewtopic.php?p=2241972


Database Error: Unable to connect to the database:Could not connect to MySQL



and this might be interesting:



Error code 28: No space left on device

This is normally caused because your /tmp folder is filled with sessions etc.
You might want/need to contact your ghost to clean that folder for you since you have no access.
They can btw if they want install on host/server level a cronjob to take care of that issue permanently


and - well the following might be interesting too:
I had this same issue, was getting odd SQL errors, and eventually got to
the Joomla error "DB function failed with error number 1030."
When you see the mySQL error "Got error 28 from storage engine SQL..."
Error Code 28 is definitely "No Space Left on Device"
I busted into the server room and we had 5.2 KB left on disk. Heh.
Time to delete useless files! So, lotsa useless logs and other non-essential progs got deleted that day.

Restarted and... problem solved.
well - i try to get in contact with my server-admin and we hope to fix this.


greetings

leash
regards un-leash,
a big fan for ++ 11 years now: With Joomla you can easily create and extend your website: see the site, that offers you ideas & modules - extensions.joomla.org - it lists over 4000 extensions

 

Locked

Return to “Extensions for Joomla! 1.5”