No announcement yet.

DB Error when Upgrading

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Suite] DB Error when Upgrading

    I'm getting a db error when upgrading from 4.0.1 to 4.0.2p1.

    Database error in vBulletin 4.0.1:
    Invalid SQL:
            SELECT adlocation, COUNT( * ) AS count
            FROM ad
                adlocation IN ('thread_first_post_content', 'thread_last_post_content')
                active = 1
            GROUP BY
    MySQL Error   : Unknown column 'adlocation' in 'field list'
    Error Number  : 1054
    Request Date  : Friday, March 12th 2010 @ 12:07:26 PM
    Error Date    : Friday, March 12th 2010 @ 12:07:26 PM
    Script        : -------
    Referrer      : ------
    IP Address    : -----
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.1.44-log
    The Error occurs when clicking on the "step 1" button. Hopefully someone has encountered this. I have yet to receive a response from the support ticket system.

  • #2
    I just replied to your ticket regarding this. It looks like you are missing the adlocation field in your ad table. Here is the information from mysql-schema.php to add it back in via phpMyAdmin:

    adlocation VARCHAR(250) NOT NULL DEFAULT ''

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help


    • #3
      Nevermind. disregard this post. I will continue conversations through the ticket.
      Attached Files
      Last edited by crisis04; Fri 12th Mar '10, 2:22pm.


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