db error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bellaa
    New Member
    • Jul 2009
    • 7

    db error

    PHP Code:
    Database error in vBulletin 3.7.4:
    Invalid SQL:
    SELECT d.discussionid FROM discussion AS d
                        INNER JOIN groupmessage 
    AS g ON g.discussionid=d.discussionid
                        WHERE postuserid
    =AND visible>AND deleted=0
                        GROUP BY d
    .discussionid;
    MySQL Error   Unknown column 'g.discussionid' in 'on clause'
    Error Number  1054
    Request Date  
    TuesdaySeptember 8th 2009 06:15:22 PM
    Error Date    
    TuesdaySeptember 8th 2009 06:15:22 PM
    Script        
    http://siteadı.com/forum/admincp/xperience_admin.php?do=savepoints
    Referrer      http://siteadı.com/forum/admincp/xperience_admin.php?do=savepoints
    IP Address    85.99.27.129
    Username      
    Admin
    Classname     
    vB_Database
    MySQL Version 
    5.0.81-community 
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    There is no 'discussionid' field in the vB 3.7.4 groupmessage table. That query and error is either from a bad file or an add-on.

    To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

    Next, disable all plugins.

    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    define('DISABLE_HOOKS', true);
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...