Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT COUNT(post.postid) as unread
FROM fnewpost as post FORCE INDEX (dateline)
INNER JOIN fnewthread as thread USING (threadid)
INNER JOIN fnewforum AS forum USING (forumid)
LEFT JOIN fnewthreadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
LEFT JOIN fnewforumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(03,6,27,50,5,28,21,83,69,70,36,22,4,71,91,92,93 ,94,19,14,15,13,52,57,63,53,59,54,60,55,61,56,62,5 8,38,10,11,25,74,41,76,73,40,75,42,49,12,39,78,43, 51,16,17,29,84,79,85,86,87,23,88,89,90,32,30,81,82 ) AND thread.forumid NOT IN(0) AND thread.visible IN (0,1,2)
AND post.dateline > IF(threadread.readtime IS NULL, 1247583694, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1247583694, forumread.readtime)
AND post.dateline > 1247583694
AND thread.lastpost > IF(threadread.readtime IS NULL, 1247583694, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1247583694, forumread.readtime)
AND thread.lastpost > 1247583694;
MySQL Error : Table './gorgino_canary/fnewpost' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, July 14th 2009 @ 11:08:53 AM
Error Date : Tuesday, July 14th 2009 @ 11:08:55 AM
Script : http://canarybreeder.net/up/forum/
Referrer : http://www.canarybreeder.net/up/
IP Address : 62.152.16.169
Username : admin
Classname : vB_Database
MySQL Version : 5.1.30
|