Database Critical Error

[ITDarasgah]

My Forum is down since last 2 days, with this database error niter plug-in or upgrading, every thing is normal since last 1 month I disable All modification in Config.php with efine('DISABLE_HOOKS', true); But Same kindly advice further

PHP Code:

Database error in vBulletin 3.8.5:

Invalid SQL:

        SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
        FROM post AS post
        LEFT JOIN user AS user ON (user.userid = post.userid)
        WHERE threadid = 8868
            AND visible = 1
            
        ORDER BY dateline ASC
        LIMIT 0,250;

MySQL Error   : Unknown column 'user.username' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, April 20th 2010 @ 11:28:58 PM
Error Date    : Tuesday, April 20th 2010 @ 11:28:58 PM
Script        : http://www.itdarasgah.com/archive/index.php/t-8868.html
Referrer      : 
IP Address    : 66.249.65.66
Username      : 
Classname     : vB_Database
MySQL Version : 


and this

PHP Code:

Database error in vBulletin 3.8.5:

Invalid SQL:

        SELECT
            post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
            user.*, userfield.*, usertextfield.*,
            icon.title as icontitle, icon.iconpath,
            avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
            
            
            editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
            editlog.reason AS edit_reason, editlog.hashistory,
            postparsed.pagetext_html, postparsed.hasimages,
            sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
            sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
            , '' AS field5
            
        FROM post AS post
        LEFT JOIN user AS user ON(user.userid = post.userid)
        LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
        LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
        LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
        LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
        
            
        LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
        LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
        LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 1)
        LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
            
        WHERE post.postid IN (0,388835,389101,389219,396352)
        ORDER BY post.dateline;

MySQL Error   : Unknown column 'displaygroupid' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, April 20th 2010 @ 11:28:51 PM
Error Date    : Tuesday, April 20th 2010 @ 11:28:51 PM
Script        : http://www.itdarasgah.com/showthread.php?t=33029
Referrer      : 
IP Address    : 204.236.235.245
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 


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

any info about this ?

[James T Brock]

Are you able to log-in to your admincp fine by typing the URL in directly?

[ITDarasgah]

Originally Posted by James T Brock

Are you able to log-in to your admincp fine by typing the URL in directly?

No not it all.........

[Lynne]

Disabling this via the config.php file isn't working? The error looks like it is from a modification since I can't find it in default vb. Have you modified your files at all? You may want to reupload all default files, as well as keep your mods off via the config.php file, and see if that fixes it.

[ITDarasgah]

Originally Posted by Lynne

Disabling this via the config.php file isn't working? The error looks like it is from a modification since I can't find it in default vb. Have you modified your files at all? You may want to reupload all default files, as well as keep your mods off via the config.php file, and see if that fixes it.

I already temporarily disable the plugin system, edit config.php
with this under the?php

PHP Code:

define('DISABLE_HOOKS', true); 


but the problem is same and I can't update any file or not install any hack since last one month
what is the default files name that need to re upload

[Lynne]

I don't know which file it would be. Redownload the package from vb.com and then reupload all the default files to your site. (You may want to first save a copy of all your files.)

[ITDarasgah]

Originally Posted by Lynne

I don't know which file it would be. Redownload the package from vb.com and then reupload all the default files to your site. (You may want to first save a copy of all your files.)

Thanks for your help I want to try that,
I will get back to you shortly

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

Originally Posted by Lynne

I don't know which file it would be. Redownload the package from vb.com and then reupload all the default files to your site. (You may want to first save a copy of all your files.)

after re uploaded all default files the problem is same......

[Lynne]

You should put in a support ticket and give support the information to take a look at your site and files.

[legacy123]

I would recommend restoring database after deleting all files and uploading a new installation of vb and running the update script and then this should turn ur vb back to normal if u do not have a db backup delete all of the non-vb standard tables. Also make sure u delete all of your files as they may be edited and stay there or an extra file etc.

[ITDarasgah]

Thanks all of you I get this issue fixed by my self.
In cPanal under the Remote My SQL some one add the IP address for Database Access Host delete that and now the Board is working fine