Hector Saunier Posted August 4, 2010 Share Posted August 4, 2010 I have this error message in my joomla admin site : DB function failed with error number 1030 Got error 28 from storage engine SQL=SELECT c.*, g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c LEFT JOIN jos_categories AS cc ON cc.id = c.catid LEFT JOIN jos_sections AS s ON s.id = c.sectionid LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state != -2 ORDER BY section_name , section_name, cc.title, c.ordering LIMIT 0, 20 and this on the front : No valid database connection Got error 28 from storage engine SQL=SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM jos_categories AS a LEFT JOIN jos_content AS b ON b.catid = a.id AND b.state = 1 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2010-08-04 16:23' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2010-08-04 16:23' ) AND b.access <= 0 WHERE a.section = 4 AND a.published = 1 AND a.access <= 0 GROUP BY a.id HAVING numitems > 0 ORDER BY a.ordering on this page : http://hectorsaunier.clan.heliohost.org/in...d=7&lang=fr and i can't acces to cPanel. Thanks for quick response. Quote Link to comment Share on other sites More sharing options...
Wizard Posted August 4, 2010 Share Posted August 4, 2010 Did you install joomla from fantastico or from source? Quote Link to comment Share on other sites More sharing options...
Hector Saunier Posted August 5, 2010 Author Share Posted August 5, 2010 From Fantastico and i was updated my instalation to 1.5.18 via AFUJ Update. But view the number of poste in your forum talking about the same problem I do not think my instal is concerned. Everything going fine until yesterday, just a few downtime acces. Thanks for your response. Quote Link to comment Share on other sites More sharing options...
Wizard Posted August 5, 2010 Share Posted August 5, 2010 http://www.helionet.org/index/index.php?sh...ic=7007&hl= Issue has been identified and is being worked on. Quote Link to comment Share on other sites More sharing options...
Hector Saunier Posted August 6, 2010 Author Share Posted August 6, 2010 After a total blackout (account suspended) yesterday, everythings work fine now. Thanks a lot. Quote Link to comment Share on other sites More sharing options...
Giuseppe Posted December 1, 2010 Share Posted December 1, 2010 Hello, dear Support! My problem is much alike to the one described here. Some of the webpages stopped working correctly with the message: DB function failed with error number 1030 Got error 28 from storage engine SQL=SELECT c.*, g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c LEFT JOIN jos_categories AS cc ON cc.id = c.catid LEFT JOIN jos_sections AS s ON s.id = c.sectionid LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state != -2 ORDER BY section_name , section_name, cc.title, c.ordering LIMIT 0, 20 I hope the issue will be resolved soon! Thanks on beforehand. P.S. my username and homefolder is glepp on the stevie server. P.P.S. Case closed - everything works again. Problem solved by djbob in another thread about vanishing mysql databases. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.