PDA

View Full Version : database error help


CSS59
12-29-2007, 09:55 PM
What does this error mean? I am getting a lot. Thank you

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT COUNT(*) AS posts
FROM vb3_post AS post
WHERE threadid = 57996 AND visible = 1
AND dateline <= 1190729317;

MySQL Error : Got error 134 from storage engine
Error Number : 1030
Date : Saturday, December 29th 2007 @ 06:22:26 PM
Script : http://www.xxxxxxxxxxxxxxxxx/forums/showthread.php?p=1xxxxx
Referrer :
IP Address : xx.xx.xxx.xxx
Username : Unregistered
Classname : vb_database










and also
Database error in vBulletin :

mysql_connect() [<a
href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
/home/xxxxxxxxxx/public_html/forums/includes/class_core.php on line 274

MySQL Error :
Error Number :
Date : Saturday, December 29th 2007 @ 04:58:54 PM
Script :





and alos
Invalid SQL:

SELECT post.postid
FROM vb3_post AS post

WHERE post.threadid = 84793
AND post.visible = 1


ORDER BY post.dateline
LIMIT 200, 20;

MySQL Error : Got error 127 from storage engine
Error Number : 1030
Date : Saturday, December 29th 2007 @ 05:41:49 PM

snakes1100
12-29-2007, 11:22 PM
I would suggest a DB check & repair, then upgrade mysql to the latest version.

Marco van Herwaarden
12-30-2007, 01:32 PM
MySQL error code 134: Record was already deleted (or record file crashed)
MySQL error code 127: Record-file is crashed

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.