vBulletin db error

[d3monic]

All of a sudden when I'm in admincp, I get a database error if I try to go to vBulletin Options tab. Everything else works fine.

http://isodose.org/admincp/options.php?null=0 Is the URL it says is the vBulletin Options, which doesn't make sense. Help please?

d3monic Reviewed by d3monic on 12th Nov 2008. vBulletin db error All of a sudden when I'm in admincp, I get a database error if I try to go to vBulletin Options tab. Everything else works fine. http://isodose.org/admincp/options.php?null=0 Is the URL it says is the vBulletin Options, which doesn't make sense. Help please? Rating: 5

[CyberJ37]

That link makes sense,
and try repairing your db, fix errors.

[clarksta]

post back with the correct error number

[d3monic]

For some reason, it fixed itself... o_O. If I get it again, I'll post more info.

[d3monic]

Database error in vBulletin 3.7.3:

Invalid SQL:

        SELECT pm.*, pmtext.*, userlist_ignore.userid AS ignored
            ,icon.iconpath, icon.title AS icontitle
        FROM vb_pm AS pm
        INNER JOIN vb_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
        LEFT JOIN vb_userlist AS userlist_ignore ON
            (userlist_ignore.userid = 1 AND userlist_ignore.relationid = pmtext.fromuserid AND userlist_ignore.type = 'ignore')
        LEFT JOIN vb_icon AS icon ON(icon.iconid = pmtext.iconid)
        WHERE pm.userid = 1
            AND pm.messageread = 0
        ORDER BY pmtext.dateline DESC
        LIMIT 5;

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Friday, November 14th 2008 @ 06:31:16 AM
Error Date    : Friday, November 14th 2008 @ 06:31:16 AM
Script        : http://isodose.org/usercp.php
Referrer      : http://isodose.org/index.php
IP Address    : x.x.x.x
Username      : demonic
Classname     : vB_Database
MySQL Version : 5.0.67-community

Database error in vBulletin 3.7.3:

Invalid SQL:

        SELECT setting.*, settinggroup.grouptitle
        FROM vb_settinggroup AS settinggroup
        LEFT JOIN vb_setting AS setting USING(grouptitle)
        WHERE settinggroup.displayorder <> 0
        ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Friday, November 14th 2008 @ 06:31:42 AM
Error Date    : Friday, November 14th 2008 @ 06:31:43 AM
Script        : http://isodose.org/admincp/options.php?null=0
Referrer      : http://isodose.org/admincp/index.php?do=nav
IP Address    : x.x.x.x
Username      : demonic
Classname     : vB_Database
MySQL Version : 5.0.67-community

I'm thinking of just bagging the forum and either going with another forum software or just coming up with a new idea with the site because vBulletin with these random database errors is starting to annoy me.

[Benign]

That is actually your problem, the script doesnt just randomly break. You alter it; ie mods...

[clarksta]

your problem is server side
try going to .phpmyadmin and repairing the the tables

if the problem persists then contact the host and ask them to check the .sql

[mulah001]

this helped me too thanks!

[mulah001]

*sorry double post.