Announcement

Collapse
No announcement yet.

Repair Optimize Tables Question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Repair Optimize Tables Question

    Hi VB Team,

    I am getting database errors. Should I just run the repair / optimise feature to check and fix tables? If that's how database errors are fixed, that's a pretty powerful and well written feature.

    Also how do I diagnose what tables are missing or faulty in a database error? For example how do I make sense of the info below?

    Database error in vBulletin 3.7.2:

    Invalid SQL:

    SELECT languageid,
    phrasegroup_global AS phrasegroup_global,
    phrasegroup_siradrianblog AS phrasegroup_siradrianblog,
    phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
    phrasegroup_user AS phrasegroup_user,
    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 'phrasegroup_siradrianblog' in 'field list'
    Error Number : 1054
    Request Date : Wednesday, July 2nd 2008 @ 05:58:29 PM
    Error Date : Wednesday, July 2nd 2008 @ 05:58:29 PM
    Script : http://www.mysite.com/forums/blogs/subscriptions.php?do=addentry&entry=38
    Referrer :
    IP Address : XX.6.8.98
    Username :
    Classname : vb_database
    MySQL Version :
    Thanks

    Reggie

  • #2
    Repairing and Optimizing tables will not fix your error which is caused by a missing field. It appears that you have vBlogetin installed and that is what is causing the error. You need to contact its authors for instructions on how to completely uninstall this addon and fix the error.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Help Please - Error Number : 1054

      Oops - thought I had started a new thread for my problem. May delete this.

      Comment

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