i can open my forum's index page but the forums, sections & acp's index is db error!

xiumana09 · Apr 9, 2010

i can now open my forum's index page which is http://phgaming.elementfx.com/forums/index.php
but when i tried to visit some sections, acp's index its DATABASE error
here's the error i get in admincp's index

Code:

Database error in vBulletin 3.8.4:

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
            
        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,831,826,707,728,15,703,568,327,325,869) 
        ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Table './jecs_jecs/post' is marked as crashed and last (automatic?) repair failed
Error Number  : 144
Request Date  : Friday, April 9th 2010 @ 01:16:07 AM
Error Date    : Friday, April 9th 2010 @ 01:16:07 AM
Script        : http://phgaming.elementfx.com/forums/forumdisplay.php?f=4
Referrer      : http://phgaming.elementfx.com/forums/index.php
IP Address    : 112.203.236.116
Username      : *JeCs*
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.87-50

and this database error i get when i try to visit any section

Code:

Database error in vBulletin 3.8.4:

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
            
        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,872,623,834,783,829,824,805,798,784,778,773,753,264,732,733,377) 
        ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Table './jecs_jecs/post' is marked as crashed and last (automatic?) repair failed
Error Number  : 144
Request Date  : Friday, April 9th 2010 @ 01:25:26 AM
Error Date    : Friday, April 9th 2010 @ 01:25:27 AM
Script        : http://phgaming.elementfx.com/forums/forumdisplay.php?f=78
Referrer      : http://phgaming.elementfx.com/forums/index.php
IP Address    : 112.203.236.116
Username      : *JeCs*
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.87-50

please help me how can i fix it

i dont want to loose all post we already did..
huhuhu.. please help me

Gouri · Apr 9, 2010

Re: i can open my forum's index page but the forums, sections & acp's index is db err

xiumana09 said:

i can now open my forum's index page which is http://phgaming.elementfx.com/forums/index.php
but when i tried to visit some sections, acp's index its DATABASE error
here's the error i get in admincp's index

Code:

Database error in vBulletin 3.8.4:

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
            
        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,831,826,707,728,15,703,568,327,325,869) 
        ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Table './jecs_jecs/post' is marked as crashed and last (automatic?) repair failed
Error Number  : 144
Request Date  : Friday, April 9th 2010 @ 01:16:07 AM
Error Date    : Friday, April 9th 2010 @ 01:16:07 AM
Script        : http://phgaming.elementfx.com/forums/forumdisplay.php?f=4
Referrer      : http://phgaming.elementfx.com/forums/index.php
IP Address    : 112.203.236.116
Username      : *JeCs*
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.87-50

and this database error i get when i try to visit any section

Code:

Database error in vBulletin 3.8.4:

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
            
        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,872,623,834,783,829,824,805,798,784,778,773,753,264,732,733,377) 
        ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Table './jecs_jecs/post' is marked as crashed and last (automatic?) repair failed
Error Number  : 144
Request Date  : Friday, April 9th 2010 @ 01:25:26 AM
Error Date    : Friday, April 9th 2010 @ 01:25:27 AM
Script        : http://phgaming.elementfx.com/forums/forumdisplay.php?f=78
Referrer      : http://phgaming.elementfx.com/forums/index.php
IP Address    : 112.203.236.116
Username      : *JeCs*
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.87-50

please help me how can i fix it

i dont want to loose all post we already did..
huhuhu.. please help me

In the last there is mySQL Error stating that post is crashed and repaid failed.

Can you try to repair the database manually.

Take the database backup first.

goto cpanel --> mysql databases and select the database and click repair DB

Then try again.

xiumana09 · Apr 9, 2010

Re: i can open my forum's index page but the forums, sections & acp's index is db err

gsonline said:
In the last there is mySQL Error stating that post is crashed and repaid failed.

Can you try to repair the database manually.

Take the database backup first.

goto cpanel --> mysql databases and select the database and click repair DB

Then try again.

thanks a lot sir for helping me.
thanks for giving some of your time for just replying & helping me THANKS A LOT SIR....
more power to x10hosting - the best webhost i'd ever used!

i can open my forum's index page but the forums, sections & acp's index is db error!

xiumana09

New Member

Gouri

Community Paragon

xiumana09

New Member

Free Web Hosting

Our Community

Legal