Getting Datbase Error

[p@ndu]

while opening my forum i am getting this error


Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT *
FROM thread AS thread
LEFT JOIN force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '2')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1287029278') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-6-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;

MySQL Error : Table './*******_downloadsmasti/thread' is marked as crashed and should be repaired
Error Number : 145
Request Date : Wednesday, October 13th 2010 @ 11:07:58 PM
Error Date : Wednesday, October 13th 2010 @ 11:07:58 PM

Referrer :
IP Address : ********
Username : *****
Classname : vB_Database
MySQL Version : 5.1.50



can some one please give em a solution for this

[ry215]

Did you installed this mod:
https://vborg.vbsupport.ru/misc.php?do=producthelp&pid=abe1_forceusersreadthread

Try to reinstall it, or remove it.

have good time.

[Lynne]

Your thread table is crashed. Go to maintenance > repair & optimize tables > select the thread table > continue. You may have to do that a couple of times before it says OK.

[p@ndu]

i cant login in to my admin cp also

[ry215]

upload tools.php in folder do_not_upload to admincp, then run it. Ex: domain.com/forum/admincp/tools.php

Repair table.

[p@ndu]

even after uploading tht the problem isnt solved...

plz help....

[Lynne]

Repair the table via phpmyadmin. Or see this - 3 ways to repair a database (http://www.vbulletin.com/forum/showthread.php?44909-3-ways-to-repair-a-database)

[p@ndu]

problem solved thx for help guyz....