joelrotunda85
05-30-2003, 07:10 PM
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!
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!