[nany37]

trying to solve a problem with our hosting we have encountered the following error on the data base and we can only access the main page on the forum how can we fix this?. We would be grateful if you could help us solve it.



Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT MIN(postid) AS postid
FROM post
WHERE threadid = 2549
AND visible = 1
AND dateline > 1225335006

LIMIT 1;

MySQL Error : Table './atormen1_vbtest/post' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Date : Wednesday, October 29th 2008 @ 10:02:53 PM
Script : http://atormentadas.net/showthread.p...newpost&t=2549
Referrer : http://atormentadas.net/index.php?styleid=1
IP Address : 190.189.159.47
Username : nany
Classname : vB_Database
Edit/Delete Message

lynne tell us to do this to solve the problem

You need to repair/optimize your post table. You can do this through your admin cp > maintenance > repair/optimize tables or through something like phpMyAdmin or even through shell access.


We are trying to do that through our admin cp since 5 hours ago and now appears this error. Could you help us? What are we doing wrong?

Database error in vBulletin 3.6.8:

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, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
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

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)

WHERE thread.threadid IN (0,2549,2563,2556,2559,2561,2557,2555,2560,2558,25 47,2552,2550,2546,2553,2544,25 34,2548,247,2526,2545,207,1207,2536)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Table './atormen1_vbtest/post' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Date : Thursday, October 30th 2008 @ 04:47:33 AM
Script : http://atormentadas.net/forumdisplay.php?f=19
Referrer : http://atormentadas.net/index.php?styleid=1
IP Address : 190.189.159.47
Username : admin
Classname : vB_Database