vBulletin Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • WhiteRook
    New Member
    • Feb 2006
    • 13

    vBulletin Database Error

    I'm not sure what happened.... I was in the adminCP and accidentally dragged something from the middle of the CP and dropped it who knows where... all I know is every thing went blank. I'm now getting email from vBulletin every 5 minutes with this message



    Database error in vBulletin 3.8.1:

    Invalid SQL:

    SELECT languageid,
    phrasegroup_global AS phrasegroup_global,
    phrasegroup_forum AS phrasegroup_forum,
    phrasegroupinfo AS lang_phrasegroupinfo,
    options AS lang_options,
    languagecode AS lang_code,
    charset AS lang_charset,
    locale AS lang_locale,
    imagesoverride AS lang_imagesoverride,
    dateoverride AS lang_dateoverride,
    timeoverride AS lang_timeoverride,
    registereddateoverride AS lang_registereddateoverride,
    calformat1override AS lang_calformat1override,
    calformat2override AS lang_calformat2override,
    logdateoverride AS lang_logdateoverride,
    decimalsep AS lang_decimalsep,
    thousandsep AS lang_thousandsep
    FROM language
    WHERE languageid = 1;

    MySQL Error : Unknown column 'phrasegroupinfo' in 'field list'
    Error Number : 1054
    Request Date : Friday, December 28th 2012 @ 12:17:35 PM
    Error Date : Friday, December 28th 2012 @ 12:17:35 PM
    Script : http://www.eaglewarez.com/forums/arc...hp/t-1372.html
    Referrer :
    IP Address : 180.76.5.89
    Username :
    Classname : vB_Database
    MySQL Version :


    Does anyone have a clue..... or even how to stop the email flooding my inbox

    Thank you.
  • Amaury
    Senior Member
    • Mar 2012
    • 1807
    • 4.2.X

    #2
    Are there any errors in your server access logs? (If you don't know how to access them, contact your hosting provider.)
    Former vBulletin user

    Comment

    • WhiteRook
      New Member
      • Feb 2006
      • 13

      #3
      yes it's full of errors ,what kind of error am I looking for?

      It's full of "file does not exist" almost like someone cleaned me out

      Comment

      • Amaury
        Senior Member
        • Mar 2012
        • 1807
        • 4.2.X

        #4
        It sounds like maybe you were compromised.

        If you can access your Admin CP, run Suspect File Versions. Do you get any results with File does not contain expected contents?
        Former vBulletin user

        Comment

        • Trevor Hannant
          vBulletin Support
          • Aug 2002
          • 24325
          • 5.7.X

          #5
          There is no 'phrasegroupinfo' column in a default 3.8.1 installation. To troubleshoot this, first download a fresh copy of the vBulletin ZIP file from the Members Area then 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);

          Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

          Do you have the same problem?
          Vote for:

          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

          Comment

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