i'm getting this error in two of my joomla/rockettheme powered websites.
DB function failed with error number 1030 Got error -1 from storage engine SQL=SELECT m.*, u.name AS editor, g.name AS groupname, MIN(mm.menuid) AS pages FROM in_modules AS m LEFT JOIN in_users AS u ON u.id = m.checked_out LEFT JOIN in_groups AS g ON g.id = m.access LEFT JOIN in_modules_menu AS mm ON mm.moduleid = m.id WHERE m.client_id = 0 GROUP BY m.id ORDER BY position ASC, ordering ASC LIMIT 50
Does anyone know what is happening?
Has anyone solved something like this?
It only happens inside the administrator, because the websites are running good ... it seems.
And they are running in the same server.
MySQL Error 1030 means, that the Table is corrupt. This happens quite often when the Database was not cleanly shut down on reboot, or the DB-Server crashed and auto-check on MySQL's startup exceeds it's max. execution time (reasons for that could be a big table, too short max.execution-time, slow cpu/low memory).
One can fix it by simply executing a "repair" on that Table - this can be done with every MySQL-GUI like phpMyAdmin or similar or via the Commandline:
# mysql
> repair table <yourtablename>;
> quit;