Error message

By chaerani on 15 Nov 2006 at 02:19 UTC

Hi, i receive this error log:

Type php
Date Wednesday, November 15, 2006 - 06:54
User Anonymous
Location /index.php?q=comment/reply/163/11813&quote=1
Message Got error 28 from table handler query: SELECT DISTINCT(c.nid), c.* FROM comments c INNER JOIN node_access na ON na.nid = c.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','simple_access0')) AND c.status = 0 ORDER BY c.timestamp DESC LIMIT 0, 10 in D:\indrani.net\indrani.net\includes\database.mysql.inc on line 66.
Severity error

Also in every page there is this error message:

user error: Got error 28 from table handler
query: SELECT DISTINCT(c.nid), c.* FROM comments c WHERE c.status = 0 ORDER BY c.timestamp DESC LIMIT 0, 10 in D:\indrani.net\indrani.net\includes\database.mysql.inc on line 66.

user error: Got error 28 from table handler
query: SELECT i.* FROM aggregator_category_item ci LEFT JOIN aggregator_item i ON ci.iid = i.iid WHERE ci.cid = 1 ORDER BY i.timestamp DESC, i.iid DESC LIMIT 0, 5 in D:\indrani.net\indrani.net\includes\database.mysql.inc on line 66.

What do I need to do? Sorry i'm not an IT person.. I'm using Drupal 4.6.5. on IIS server

Comments

Google

styro commented 15 November 2006 at 02:46

seems to think you've run out of disk space:

http://www.google.com/search?q=mysql+error+28

--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ

Now my User access control all messed up

chaerani commented 15 November 2006 at 03:26

Thanks. I have called up my server's customer server and they've rectified the issue with regards of mysql error28. Now my website does not have error message anymore.

HOWEVER, my user login seems to lost all the user access privilege. The side navigation menu does not link to admin or create entry. When i try to access admin page manually at index.php?q=admin I received "access denied" website.

So then i tried to login using the master login (the one that is created the first time). I checked the "access control" and nothing changed there, my user login still have all the privileges. But when i login using my user login, I'm denied all access function. What sort of bug is this?