PDA

View Full Version : Need help database error


MaluNYMets
05-04-2010, 02:17 PM
Here is the message. I'm a noob at this so I have no clue.

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT COUNT(post.postid) as unread
FROM post as post FORCE INDEX (dateline)
INNER JOIN thread as thread USING (threadid)
INNER JOIN forum AS forum USING (forumid)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(0171,147,148,237,14,134,89,163,6,383,143,320,32 1,322,284,173,197,363,220,368,381,238,227,324,183, 7,15,371,370,377,48,213,47,40,62,215,16,235,262,28 0,242,19,376,25,74,20,75,21,339,73,22,319,212,341, 106,159,261,243,244,245,247,246,214,88,256,257,259 ,260,216,1,2,4,288,346,56,69,79,230,218,226,140,14 1,364,142,174,175,176,177,193,199,200,285,300,301, 302,303,379,29,239,130,131,132,234,314,315,145,36, 8,169,99,307,112,229,292,41,296,295,291,309,160,16 7,382,359,287,369,209,337,362,360,317,316,378,81,3 05,105,282,164,205,102,91,166,137,103,161,192,264, 265,266,267,268,271,272,273,270,290,367,37,361,372 ,373,374,366,194,275,206,278,375,269,289,313,380,1 81,336,182,323,326,327,356,328,329,330,332,333,334 ,335,358,325,340,338,9,146,100,233,129,12,26,365,1 0,170,263,11,157,117,64,31,32,63,298) AND thread.visible IN (0,1,2)
AND post.dateline > IF(threadread.readtime IS NULL, 1272978711, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1272978711, forumread.readtime)
AND post.dateline > 1272978711
AND thread.lastpost > IF(threadread.readtime IS NULL, 1272978711, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1272978711, forumread.readtime)
AND thread.lastpost > 1272978711;

MySQL Error : Table './divink5_vb/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, May 4th 2010 @ 10:14:10 AM
Error Date : Tuesday, May 4th 2010 @ 10:14:10 AM
Script : http://divineknightsclan.com/forum/
Referrer :
IP Address : 166.137.138.252
Username : DK_BlackFalcon
Classname : vB_Database
MySQL Version : 5.1.30

Lynne
05-04-2010, 05:21 PM
Your post table is crashed. Go to Maintenance > Repair/Optimize > select post table > run. You may have to do this a couple of times until it says it is OK.