Forum Database Error

محروم.كوم · #1 06-04-2010, 10:20 PM

I've had vBulletin on my site since January, haven't had any problems, but lately I keep getting these emails w/ subject "vBulletin Database Error". It says I need to repair something. I have no idea what I'm supposed to do, and I'm wondering if I'm in over my head. I haven't been able to keep people interested in the forum (interest comes in spurts), & I'm wondering if I should abandon it entirely.

Here are four of the messages:

Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO searchcore_text (searchcoreid, title, keywordtext)
VALUES ( 296, 'Georgia Pre-K Teachers', '' )
ON DUPLICATE KEY UPDATE searchcoreid = VALUES(searchcoreid), title = VALUES(title), keywordtext = VALUES(keywordtext);

MySQL Error : Table './prekinde_forum/searchcore_text' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, June 4th 2010 @ 12:44:32 PM
Error Date : Friday, June 4th 2010 @ 12:44:32 PM
Script : http://prekinders.com/forum/newreply...postreply&t=28
Referrer : http://prekinders.com/forum/showthre...ave-here/page2
IP Address : 72.152.67.114
Username : MrsTracey
Classname : vB_Database

MySQL Version :

*****

Database error in vBulletin 4.0.1:

Invalid SQL:

DELETE searchcore, searchcore_text
FROM searchcore AS searchcore JOIN
searchcore_text AS searchcore_text ON
searchcore.searchcoreid = searchcore_text.searchcoreid
WHERE searchcore.groupcontenttypeid = 2 AND
searchcore.groupid = 76;

MySQL Error : Incorrect key file for table './prekinde_forum/searchcore_text.MYI'; try to repair it
Error Number : 126
Request Date : Thursday, June 3rd 2010 @ 06:15:42 PM
Error Date : Thursday, June 3rd 2010 @ 06:15:42 PM
Script : http://prekinders.com/forum/editpost.php
Referrer : http://prekinders.com/forum/showthre...-Forum-Changes
IP Address : 72.150.95.63
Username : Karen
Classname : vB_Database
MySQL Version : 5.1.30

********

Database error in vBulletin :

mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/prekinde/public_html/forum/includes/class_core.php on line 312

MySQL Error :
Error Number :
Request Date : Monday, May 31st 2010 @ 02:22:32 PM
Error Date : Monday, May 31st 2010 @ 02:22:32 PM
Script : http://prekinders.com/forum/forum.php
Referrer :
IP Address : 208.115.111.244
Username :
Classname : vB_Database
MySQL Version :

********

Database error in vBulletin :

mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/prekinde/public_html/forum/includes/class_core.php on line 312

MySQL Error :
Error Number :
Request Date : Monday, May 31st 2010 @ 02:22:26 PM
Error Date : Monday, May 31st 2010 @ 02:22:26 PM
Script : http://prekinders.com/forum/faq.php
Referrer :
IP Address : 208.115.111.244
Username :
Classname : vB_Database
MySQL Version : __DEFINE_LIKE_SHARE__