Need help with a db error
 

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

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.

thank you very much lynne

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

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,2534,2548,247,2526,254 5,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

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

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

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

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

Merged threads, please do not open mutliple threads regarding the same issue.

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

If you can't access the admincp as you've stated, please access your web hosting panel, ie cpanel, directadmin etc, you can use phpmyadmin to repair/optimize the tables in the DB and correct your DB issues.