fnewpost' is marked as crashed

[goshalim]

Thank you both , i did that but unfortunately its not working !!!!

As you can see http://www.canarybreeder.net/up/foru...html=1&check=1

its not working !!!!!


Its comes the admin panel but when i write my codes it shows me this message below


[QUOTE][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, 1247639932, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1247639932, forumread.readtime)
AND post.dateline > 1247639932
AND thread.lastpost > IF(threadread.readtime IS NULL, 1247639932, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1247639932, forumread.readtime)
AND thread.lastpost > 1247639932;

MySQL Error : Table './gorgino_canary/fnewpost' is marked as crashed and should be repaired
Error Number : 145
Request Date : Wednesday, July 15th 2009 @ 03:38:27 AM
Error Date : Wednesday, July 15th 2009 @ 03:38:28 AM
Script : http://www.canarybreeder.net/up/foru...n.php?do=login
Referrer : http://www.canarybreeder.net/up/foru...html=1&check=1
IP Address : 212.31.98.58
Username : admin
Classname : vB_Database
MySQL Version : 5.1.30/QUOTE]