Mysql problem

[Hector Saunier]

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.

[Wizard]

Did you install joomla from fantastico or from source?

[Hector Saunier]

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.

 

[Wizard]

http://www.helionet.org/index/index.php?sh...ic=7007&hl=

Issue has been identified and is being worked on.

[Hector Saunier]

After a total blackout (account suspended) yesterday, everythings work fine now. Thanks a lot.

[Giuseppe]

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.