I have been rebuilding my search index over the past several days. Everything has been going well, or so it seems until today. I have near 500,000 posts on my forum and I was around 430,000 on the rebuild when it stopped. Now I and my members are receiving a database error. I get the same error when I try to continue the index rebuild as well.
Any ideas anyone?
__________________________________________________________________________________
Database error in vBulletin 4.0.2:
Invalid SQL:
INSERT INTO searchcore (username, contenttypeid, primaryid, groupcontenttypeid, groupid, ipaddress, userid, dateline, searchgroupid)
VALUES ( 'Mark', 1, 1, 2, 44, 417835123, 1, 1130372610, 1 )
ON DUPLICATE KEY UPDATE username = VALUES(username), contenttypeid = VALUES(contenttypeid), primaryid = VALUES(primaryid), groupcontenttypeid = VALUES(groupcontenttypeid), groupid = VALUES(groupid), ipaddress = VALUES(ipaddress), userid = VALUES(userid), dateline = VALUES(dateline), searchgroupid = VALUES(searchgroupid);
MySQL Error : Table 'searchcore' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Thursday, March 18th 2010 @ 08:51:37 PM
Error Date : Thursday, March 18th 2010 @ 08:51:38 PM
Script : http://www.myforum.org/admincp/misc.php?do=doindextypes
Referrer : http://www.myforum.org/admincp/misc.php?do=chooser
IP Address : 00.00.00.000
Username : Me
Classname : vB_Database
MySQL Version : 4.1.22-standard
Any ideas anyone?
__________________________________________________________________________________
Database error in vBulletin 4.0.2:
Invalid SQL:
INSERT INTO searchcore (username, contenttypeid, primaryid, groupcontenttypeid, groupid, ipaddress, userid, dateline, searchgroupid)
VALUES ( 'Mark', 1, 1, 2, 44, 417835123, 1, 1130372610, 1 )
ON DUPLICATE KEY UPDATE username = VALUES(username), contenttypeid = VALUES(contenttypeid), primaryid = VALUES(primaryid), groupcontenttypeid = VALUES(groupcontenttypeid), groupid = VALUES(groupid), ipaddress = VALUES(ipaddress), userid = VALUES(userid), dateline = VALUES(dateline), searchgroupid = VALUES(searchgroupid);
MySQL Error : Table 'searchcore' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Thursday, March 18th 2010 @ 08:51:37 PM
Error Date : Thursday, March 18th 2010 @ 08:51:38 PM
Script : http://www.myforum.org/admincp/misc.php?do=doindextypes
Referrer : http://www.myforum.org/admincp/misc.php?do=chooser
IP Address : 00.00.00.000
Username : Me
Classname : vB_Database
MySQL Version : 4.1.22-standard
Comment