By commdevelopr on

When I went to bed last night, everything was working fine. When I woke up this morning the following error message was appearing on every public page:

user warning: Got error 28 from table handler query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 1 ORDER BY v.weight, t.weight, t.name in /home/wardstl/public_html/includes/database.mysql.inc on line 120.

The site is located at http://15thWardSTL.org

This error doesn't appear on the administrator pages for some reason. I tried disabling recently installed modules, but it didn't appear to solve the problem.

Obviously, it looks really bad to have big red "ERROR" boxes at the top of every page.... I am out of my league dealing with MySQL and the "behind the scenes" stuff - I hope there is an easy fix that I just can't find. Any help would be GREATLY appreciated.

Thanks,
Steve

Comments

commdevelopr’s picture

commdevelopr commented

It looks like when I log out as administrator, (i.e. the general public) nothing appears. I hope this can be diagnosed from the information available! Here is the error that appears to the public:

user warning: Got error 28 from table handler query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1) in /home/wardstl/public_html/includes/database.mysql.inc on line 120.

Cromicon’s picture

Cromicon commented

error 28 is associated with the mysql database server needing it's temp files clearing out. I've had this before and it's fairly common on shared hosting systems (twice a year common for me!)

http://drupal.org/node/44160

ericG’s picture

ericG commented

see the following page "What is error 28 and how can I avoid it?" for more info:
http://www.mysql.com/news-and-events/newsletter/2003-10/a0000000249.html

backup your db, clean up the drive and then run a check and repair on the db

most often it is the tmp partition that fills up, follow some of the links at
http://www.google.com/search?q=%22Got+error+28+from+table+handler%22

for more advice on dealing with the problem

commdevelopr’s picture

commdevelopr commented

Thanks for the quick replies.

My web host (dh2.net) has been unresponsive so far. Is there any of this that I can do without access to the MySQL server? I backed up the MySQL database, but I don't see a way to clean up the drive - it doesn't appear I have access to anything at that level.

Am I stuck until they decide to reply to my ticket? It looks from your links like I may have to have some sort of argument with them as to whose fault this is.... any suggestions on what exactly I need to tell them to do?

Thanks again!