SQL error after repairing table! help please!

[daydie]

hey guys, i got this error when i tryed to repair all the tables from admincp....

Database error in vBulletin 3.8.0:

Invalid SQL:

		SELECT 
			IF(votenum >= 1, votenum, 0) AS votenum,
			IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
		 post.pagetext AS preview,
			thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
			thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
			thread.prefixid, thread.taglist, hiddencount, deletedcount
			, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
			, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
			
			, threadredirect.expires
			, post_user.displaygroupid AS post_user_displaygid, post_user.usergroupid AS post_user_usergid, last_post_user.displaygroupid AS last_post_user_displaygid, last_post_user.usergroupid AS last_post_user_usergid
		FROM thread AS thread
			LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
			 LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
			
			LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
			
			LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			LEFT JOIN user AS last_post_user ON (thread.lastposter = last_post_user.username)
LEFT JOIN user AS post_user ON (thread.postuserid = post_user.userid)
		WHERE thread.threadid IN (0,529338,529336,529333,529332,529331,529325,529324,529314,529313,529311,529309,529304,529301,529294,529286,529278,529274,529271,529267,529265,8888) 
		ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Table './daydiee/post' is marked as crashed and last (automatic?) repair failed
Error Number  : 144
Request Date  : Tuesday, May 25th 2010 @ 03:51:48 AM
Error Date    : Tuesday, May 25th 2010 @ 03:51:49 AM
Script        : http://daydie.co.uk/download-games-f365/
Referrer      : http://daydie.co.uk/
IP Address    : xxx-xxx-xxx-xxx
Username      : daydie
Classname     : vB_Database
MySQL Version : 5.0.91-log

in the post table it has 0 data in. is there any way i can get this working again. when i try view a thread or forum i get this SQL error.


please help

--------------- Added [DATE]1274781587[/DATE] at [TIME]1274781587[/TIME] ---------------

------------------------

i have just tryed re-creating the post databse via install but had no luck, this is what i got back:

Step 3) Creating Tables
Resetting database...

    * Removing post table

    * Creating access table
      

	
	

			
				Database Error 	Database error
      The database has encountered a problem.
      Please try the following:
          o Load the page again by clicking the Refresh button in your web browser.
          o Open the daydie.co.uk home page, then try to open another page.
          o Click the Back button to try another link.
      The daydie.co.uk forum technical staff have been notified of the error, though you may contact them if the problem persists.
       
      We apologise for any inconvenience.
      Database error in vBulletin : Invalid SQL: CREATE TABLE access ( userid INT UNSIGNED NOT NULL DEFAULT '0', forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0', accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY userid (userid, forumid) ); MySQL Error : Table 'access' already exists Error Number : 1050 Request Date : Tuesday, May 25th 2010 @ 03:58:35 AM Error Date : Tuesday, May 25th 2010 @ 03:58:36 AM Script : http://daydie.co.uk/install/install.php?do= Referrer : http://daydie.co.uk/install/install.php?step=3&emptydb=true IP Address : 81.105.142.155 Username : Classname : vB_Database MySQL Version : 5.0.91-log
			
		

i think it was trying to make access table, even tho i only ticked post table to be deleted and re-created.

--------------- Added [DATE]1274782237[/DATE] at [TIME]1274782237[/TIME] ---------------

i deleted the database, can anybody please help me re-build the basic of the post table. as the install cant do it as it tryed to creat all databases and cant becuase the old ones are still there.

[Marco van Herwaarden]

Hmm not really sure what you have been doing.

You had a database, and there was data in it? (ie. users, forums, posts, etc...)

You tried to repair the database but it failed at the first attempt? If it fails, you should try to run it a few more times. If needed first close the forum.

Then you tried to run install again? And choose to delete exisiting tables? If so, your entire database is removed.

[daydie]

it was running fine. i tryed to repair, was unsucsessful since the post was 0. i deleted this a month ago due to host complaining about size of DB. but everything still worked fine.

[Marco van Herwaarden]

You deleted all your posts a month ago? How?

And how could you still have had any thread/post on your forums during that month?

[daydie]

i dont know >.< anyways i cudnt remake the database so i have had to re-install the db

thank you for your help either way bud. aprichate you posting.