A Few Board Problems

Hey,

My forums have been up for nearly a year now and I have never had a problem with he SQL database or anything. Two nights ago I began getting the VBulletin Database Error Messages and reports from my users that they could not use the "View New Posts" feature without getting an error message.

I don't know where it cold have come from since I have not modififed any files for nearly 2-3 months, so if you have any suggestions or advice please help me!!!!

Here is the messagea I am receiving:

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO search (searchid,query,dateline,querystring,showposts,use rid,ipaddress) VALUES (NULL,'1=1 AND NOT (thread.forumid=\'239\' OR thread.forumid=\'115\' OR thread.forumid=\'314\' OR thread.forumid=\'149\' OR thread.forumid=\'114\' OR thread.forumid=\'309\' OR thread.forumid=\'160\' OR thread.forumid=\'222\' OR thread.forumid=\'69\' OR thread.forumid=\'95\' OR thread.forumid=\'230\' OR thread.forumid=\'206\' OR thread.forumid=\'207\' OR thread.forumid=\'208\') AND thread.lastpost>=1054321748 AND thread.open<>10',1054324988,'',0,1,'24.25.79.58')
mysql error: Can't open file: 'search.MYD'. (errno: 145)

mysql error number: 1016

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO search (searchid,query,dateline,querystring,showposts,use rid,ipaddress) VALUES (NULL,'1=1 AND NOT (thread.forumid=\'202\' OR thread.forumid=\'305\' OR thread.forumid=\'252\' OR thread.forumid=\'239\' OR thread.forumid=\'224\' OR thread.forumid=\'115\' OR thread.forumid=\'314\' OR thread.forumid=\'149\' OR thread.forumid=\'114\' OR thread.forumid=\'309\' OR thread.forumid=\'159\' OR thread.forumid=\'160\' OR thread.forumid=\'222\' OR thread.forumid=\'69\' OR thread.forumid=\'95\' OR thread.forumid=\'230\' OR thread.forumid=\'206\' OR thread.forumid=\'207\' OR thread.forumid=\'208\') AND thread.lastpost>=1054309934 AND thread.open<>10',1054321149,'',0,193,'205.188.209. 6')
mysql error: Duplicate entry '74654' for key 1

mysql error number: 1062

There has also been a few reports that when te search for threads, they are having problems although this is not as widespread as the others.

Thanks for your help!

[amykhar]

looks like a corrupt table. Run repair.php

Amy

[joelrotunda85]

Worked like a charm Amy! Thanks for your help!

[amykhar]

No prob