Announcement

Collapse
No announcement yet.

Database Error after upgrading

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • Lynne
    replied
    Please run maintenance > diagnostics > suspect file version and make sure all the files are totally default and you have no leftover files listed.

    Leave a comment:


  • Big Dan
    replied
    Negative removing all plugins while leaving the Blog and CMS addon enabled still generates that error.

    Leave a comment:


  • Big Dan
    replied
    Originally posted by Lynne
    That is from a modification. There is no visible column in the attachment table.
    Thanks but I have no modifications installed other than the CMS and blog

    Edit:

    My apologies I had some 3.8 plugins disabled but is was still causing problems. Disabling plugins via config got it working again.

    Leave a comment:


  • Lynne
    replied
    That is from a modification. There is no visible column in the attachment table.

    Leave a comment:


  • Big Dan
    started a topic [Suite] Database Error after upgrading

    Database Error after upgrading

    Did an upgrade on a pretty much vanilla install of 3.8.7 to 4.1.10 and am getting the following error when trying to view the forum. Tried re-running the upgrade script, no luck.

    Code:
    [FONT=arial]Database error in vBulletin 4.1.10:[/FONT]
    
    [FONT=arial]Invalid SQL:[/FONT]
    [FONT=arial]SELECT COUNT(*) AS count FROM bglw38_attachment WHERE visible = 0;[/FONT]
    
    [FONT=arial]MySQL Error   : Unknown column 'visible' in 'where clause'[/FONT]
    [FONT=arial]Error Number  : 1054[/FONT]
    [FONT=arial]Request Date  : Tuesday, February 21st 2012 @ 12:47:57 PM[/FONT]
    [FONT=arial]Error Date    : Tuesday, February 21st 2012 @ 12:47:58 PM[/FONT]
    [FONT=arial]Script        : [/FONT][URL]http://bigguylilworld.com/forum.php[/URL]
    [FONT=arial]Referrer      :[/FONT]
    [FONT=arial]IP Address    : 24.161.16.84[/FONT]
    [FONT=arial]Username      : Big Dan[/FONT]
    [FONT=arial]Classname     : vB_Database[/FONT]
    [FONT=arial]MySQL Version : 5.1.52-cll[/FONT]


    Thanks,
    Dan
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
😀
🥰
🤢
😎
😡
👍
👎