The Joomla! Forum ™

Website is http://www.ndsapps.com. I am using a different template for the home page as opposed to the other content pages. Error starts off with "Got error 28 from storage engine SQL=SELECT", etc. I get this as well when I try to access the module manager. See full error below (Error 1)

When I go into Joomla and try to access the Template Manager, any article, menu option, etc., I get a 500 error. In the extension manager, it says that my database is not up to date with the errors below (Error 2). I have Akeeba Backup but my IT guy is the one who registered it to do the Amazon backups and Akeeba requires a backup now as well. Will the Akeeba backup fix my issue? I have backed up the site previously using Akeeba but I cannot see any backup records now either.

I also cannot even take the site offline. I get the following error. "Could not save data. Error: The Global Configuration extension could not be found. Text filter settings have not been saved"

Another weird thing is that the error was there, then after awhile, it went away. Then it came back. My IT guy also was pushing the help documentation for one of our software programs up to joomla which I think may have caused an issue. If any direction as to where to go first to troubleshoot, I'd greatly appreciate it. I'm not too tech/code savy and have learned everything I know on the fly. Thanks in advance.

Error 1:
Got error 28 from storage engine SQL=SELECT a.id, a.title, a.note, a.position, a.module, a.language,a.checked_out, a.checked_out_time, a.published+2*(e.enabled-1) as published, a.access, a.ordering, a.publish_up, a.publish_down,l.title AS language_title,uc.name AS editor,ag.title AS access_level,MIN(mm.menuid) AS pages,e.name AS name FROM `nds_modules` AS a LEFT JOIN `nds_languages` AS l ON l.lang_code = a.language LEFT JOIN nds_users AS uc ON uc.id=a.checked_out LEFT JOIN nds_viewlevels AS ag ON ag.id = a.access LEFT JOIN nds_modules_menu AS mm ON mm.moduleid = a.id LEFT JOIN nds_extensions AS e ON e.element = a.module WHERE (a.published IN (0, 1)) AND a.client_id = 0 AND e.client_id =0 GROUP BY a.id, a.title, a.note, a.position, a.module, a.language,a.checked_out,a.checked_out_time, a.published, a.access, a.ordering,l.title, uc.name, ag.title, e.name,l.lang_code, uc.id, ag.id, mm.moduleid, e.element, a.publish_up, a.publish_down,e.enabled Got error 28 from storage engine SQL=SELECT a.id, a.title, a.note, a.position, a.module, a.language,a.checked_out, a.checked_out_time, a.published+2*(e.enabled-1) as published, a.access, a.ordering, a.publish_up, a.publish_down,l.title AS language_title,uc.name AS editor,ag.title AS access_level,MIN(mm.menuid) AS pages,e.name AS name FROM `nds_modules` AS a LEFT JOIN `nds_languages` AS l ON l.lang_code = a.language LEFT JOIN nds_users AS uc ON uc.id=a.checked_out LEFT JOIN nds_viewlevels AS ag ON ag.id = a.access LEFT JOIN nds_modules_menu AS mm ON mm.moduleid = a.id LEFT JOIN nds_extensions AS e ON e.element = a.module WHERE (a.published IN (0, 1)) AND a.client_id = 0 AND e.client_id =0 GROUP BY a.id, a.title, a.note, a.position, a.module, a.language,a.checked_out,a.checked_out_time, a.published, a.access, a.ordering,l.title, uc.name, ag.title, e.name,l.lang_code, uc.id, ag.id, mm.moduleid, e.element, a.publish_up, a.publish_down,e.enabled ORDER BY `position` asc,a.ordering ASC LIMIT 0, 20 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.note, a.position, a.module, a.language,a.checked_out, a.checked_out_time, a.published+2*(e.enabled-1) as published, a.access, a.ordering, a.publish_up, a.publish_down,l.title AS language_title,uc.name AS editor,ag.title AS access_level,MIN(mm.menuid) AS pages,e.name AS name FROM `nds_modules` AS a LEFT JOIN `nds_languages` AS l ON l.lang_code = a.language LEFT JOIN nds_users AS uc ON uc.id=a.checked_out LEFT JOIN nds_viewlevels AS ag ON ag.id = a.access LEFT JOIN nds_modules_menu AS mm ON mm.moduleid = a.id LEFT JOIN nds_extensions AS e ON e.element = a.module WHERE (a.published IN (0, 1)) AND a.client_id = 0 AND e.client_id =0 GROUP BY a.id, a.title, a.note, a.position, a.module, a.language,a.checked_out,a.checked_out_time, a.published, a.access, a.ordering,l.title, uc.name, ag.title, e.name,l.lang_code, uc.id, ag.id, mm.moduleid, e.element, a.publish_up, a.publish_down,e.enabled ORDER BY `position` asc,a.ordering ASC

Error 2:

No default text filters found.
Database update version (None) does not match CMS version (2.5.4).
Table 'nds_languages' does not have column 'ordering'. (From file 1.7.0-2011-06-06-2.sql.)
Table 'nds_categories' does not have column 'description' with type 'MEDIUMTEXT'. (From file 1.7.1-2011-09-15.sql.)
Table 'nds_session' does not have column 'data' with type 'MEDIUMTEXT'. (From file 1.7.1-2011-09-15.sql.)
Table 'nds_session' does not have column 'session_id' with type 'varchar(200)'. (From file 1.7.1-2011-09-15.sql.)
Table 'nds_modules' does not have column 'position' with type 'VARCHAR(50)'. (From file 1.7.1-2011-09-17.sql.)
Table 'nds_redirect_links' does not have column 'old_url' with type 'varchar(255)'. (From file 1.7.1-2011-09-20.sql.)
Table 'nds_redirect_links' does not have column 'new_url' with type 'varchar(255)'. (From file 1.7.1-2011-09-20.sql.)
Table 'nds_categories' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'nds_contact_details' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'nds_extensions' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'nds_menu' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'nds_modules' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'nds_newsfeeds' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'nds_banners' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'nds_categories' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'nds_contact_details' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'nds_content' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'nds_content' does not have column 'title_alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'nds_menu' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'nds_newsfeeds' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'nds_weblinks' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'nds_languages' does not have column 'sitename'. (From file 1.7.3-2011-10-19.sql.)
Table 'nds_content' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-11-10.sql.)
Table 'nds_newsfeeds' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.4-2011-11-23.sql.)
Table 'nds_content' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.4-2011-11-23.sql.)
Table 'nds_content' does not have column 'title_alias' with type 'VARCHAR(255)'. (From file 1.7.4-2011-11-23.sql.)
Table 'nds_update_sites' does not have column 'last_check_timestamp'. (From file 2.5.0-2011-12-06.sql.)
Table 'nds_updates' does not have column 'infourl'. (From file 2.5.0-2012-01-10.sql.)
Table 'nds_languages' does not have column 'sitename' with type 'VARCHAR(1024)'. (From file 2.5.0-2012-01-14.sql.)
Table 'nds_languages' does not have column 'access'. (From file 2.5.4-2012-03-19.sql.)

After you upgraded to 2.5.4 (from which version?), did you Fix the database (in the Extension Manager, tab Database) ?

The error 28 from storage engine indicates that there is no disk/partition space available for MySQL to work.

_________________
- Ilagnayeru (MIG) Manickam
http://www.eegan.org - helping the poor and underprivileged
educate. empower. enrich.
Support the poor and underprivileged

It was from 2.5.0 I believe that I upgraded from. I don't think that this is the cause of the issue though due to the fact that it was fine and I was able to access everything after the upgrade which was around noon on 4/26/12. I was not notified of the database errors at that time and during previous upgrades, the database was never something that I had to fix. I tried clicking "Fix" in Joomla for the database but considering that I cannot change anything in Joomla right now due to other errors, this is a major concern.

Again, it is only the homepage that has the error, all the other pages are fine though. The homepage does use a different template from the others which is again, another concern. The error on the website was first noticed this morning (4/27/12 8 am EST). I think it is due to pushing a large amount of help files for one of our software programs up to Joomla. I'm not sure why exactly our IT guy decided that they needed to go there and I was not informed of that decision until after the errors occurred and he had conveniently left for vacation. Thanks. I am going to look into the space and see if we can take off the help files.

Looks like he ignored your post ? So perhaps repeating it may sink in ?

_________________
http://weblinksonline.co.uk/joomla-faq.html

No, I did not ignore the post due to if you read the fact that I was going to look into the need for us having the unnecessary files removed. My reply was to the first post. Thanks though for repeating just to make sure I was aware. And by the way, "he" does not apply here. Thank you both for reiterating the statement. Hoping my IT guy will be able to fix this and show me what I can do in case this ever happens again.

Everything is back up and running. Thanks everyone again.

How did you fix it ?

_________________
http://weblinksonline.co.uk/joomla-faq.html

Interestingly, I did nothing nor did anyone else from my company. I believe it was an Amazon issue. It was still in error all this weekend. I'm not sure if they have schedules rake tasks that run through that clean up, etc. Other posts that I have seen on other forums have said that it was a hosting issue. I'm still a little concerned with the fact that that was causing my inability to even take down the website. I'm not sure why the storage space issue made Joomla report 32 database errors as well as any time I tried to go into any menu item, I received a 500 error. Any ideas?