PDA

View Full Version : i am having a serious problem


MGM
10-13-2003, 01:37 AM
I can't seem to access my forums, everytime i go to my forums it gives me this error:

Warning: mysql_query(): Unable to save result set in /var/www/html/forums/admin/db_mysql.php on line 86

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT forum.forumid AS forumid, thread.threadid AS threadid, thread.title AS title
FROM forum
LEFT JOIN thread ON (thread.forumid = forum.forumid AND thread.lastpost = forum.lastpost)
WHERE displayorder <> 0 AND active = 1 AND thread.title <> ""
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 12th of October 2003 10:49:11 PM
Script: http://www.forevergaming.com/forums/forums/
Referer:

If you want to see it yourself, go to www.forevergaming.com/forums

Also, when I try to access my Admin CP, in the home page it gives me this error:

Warning: mysql_query(): Unable to save result set in /var/www/html/forums/admin/db_mysql.php on line 86

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: SELECT count(*) AS count FROM thread WHERE dateline>=1065931200
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 12th of October 2003 10:49:48 PM
Script: http://www.forevergaming.com/forums/forums/admin/index.php?action=home
Referer: http://www.forevergaming.com/forums/admin/?

could anyone help me please?

MGM out

MGM
10-13-2003, 02:07 AM
I fixed it running the Repair query, sorry for wasting your time, this can be closed :p

MGM out