PDA

View Full Version : Help! Weirdest error...

Chris M
02-18-2003, 09:01 AM
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT quote,name FROM quotes ORDER BY rand() LIMIT 1
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Tuesday 18th of February 2003 12:56:23 AM
Script: http://www.darkblazes.com/forums/forums/index.php?
Referer: http://www.darkblazes.com/forums/admin/index.php?action=head

I get that when trying to access my forums:confused:

Can you help?

Satan
Boofo
02-18-2003, 09:11 AM
Looks like your quotes table is messed up. Have you tried to repair it?
Chris M
02-18-2003, 09:26 AM
No I havent;)

Good idea...

Just one problem - I can't access PhpMyAdmin, or my email, so that suggests to me that it isn't a problem with the quotes table itself, but the server...The quotes table just happens to be the first thing it tries to call...

Maybe i'm wrong:confused:

Satan
Boofo
02-18-2003, 09:31 AM
Originally posted by hellsatan
No I haven't;)

Good idea...

Just one problem - I can't access PhpMyAdmin, or my email, so that suggests to me that it isn't a problem with the quotes table itself, but the server...The quotes table just happens to be the first thing it tries to call...

Maybe i'm wrong:confused:

Satan

Can you access FTP though? You can always disable the quotes in index.php and see if that helps at all. ;)
Chris M
02-18-2003, 09:32 AM
As I suspected - All the Tables are reported to be "OK" by the repair.php file...

Satan
Boofo
02-18-2003, 09:36 AM
Originally posted by hellsatan
As I suspected - All the Tables are reported to be "OK" by the repair.php file...

Satan

Sounds like you hit the nail on the head. Must be server problems then. :)

By the way, use rand(NOW()) instead of rand() when you get back online. It seeds the randomization better with sql .54 and better.
Chris M
02-18-2003, 09:38 AM
@Boofo - I tried removing the quote stuff from global.php...

I ended up removing the $DB_site error, but I still get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/forums/admin/db_mysql.php on line 149

When I goto the Admin CP...

I think there must be a server error:(

Satan