on my forums i posted then went back and posted again with in the time limit (dont know y i got around it) and because of that the forums thought the 2 posts had the same number (post id) and it screwed up my "thread table" in the database
i need to rebuild that table but dont know where to start...i havent backed up the database yet (stupid mistake i make too often)...can any1 send me the table contents so i can rebuild it - i use vBulletin 2.3.0 and vBPortal 3.0b
Code:
Database error in vBulletin 2.3.0:
Invalid SQL:
SELECT thread.threadid
FROM thread,subscribethread
WHERE subscribethread.threadid=thread.threadid
AND subscribethread.userid='1'
AND thread.visible=1
AND lastpost>1058591671
mysql error: Can't open file: 'thread.MYI'. (errno: 145)
mysql error number: 1016
Date: Saturday 19th of July 2003 12:21:33 AM
Script: http://www.dfmafia.net/forums/forums/usercp.php?s=
Referer: http://dfmafia.net/index.php?s=
above is the error message i get and when i went to myphpadmin i found that thread table corupted the rest of the tables r fine...notice the script:
http://dfmafia.net/forums/forums/usercp.php?s= is incorrect as well...
i would like to get this fixed asap
any assistance would be great - email me at
dflw_mafia@yahoo.com