UPgrading 4.0.6 to 4.0.7 database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kersti
    Senior Member
    • Dec 2005
    • 110
    • 4.2.X

    [Forum] UPgrading 4.0.6 to 4.0.7 database error

    My 4.0.6 upgrade wet quite well so I didn't expect any problems going from 4.0.6 to 4.0.7 yet I've just got the following error:

    Step 1) Misc Table Alterations

    Creating index active on vb_product
    Altering user Table (1 of 1)

    in vBulletin 4.0.6:

    Invalid SQL:

    ALTER TABLE vb_user
    DROP fbprofilepicurl;

    MySQL Error : Can't DROP 'fbprofilepicurl'; check that column/key exists
    Error Number : -1
    Request Date : Tuesday, October 5th 2010 @ 10:22:08 PM
    Error Date : Tuesday, October 5th 2010 @ 10:22:09 PM
    Script : http://www.mysite.com/install/upgrade_407.php?step=1
    Referrer : http://www.mysite.com/install/upgrad...and=1286313688
    IP Address : 89.101.182.xxx
    Username :
    Classname : vB_Database
    MySQL Version :
    Anyone got any ideas????
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24318
    • 5.7.X

    #2
    Hmmmm, that column should exist in 4.0.6 and therefore be able to be dropped in this upgrade. Either it's been run already (maybe refreshed the page?) or something went very wrong with your previous upgrade.

    If you look in the upgradelog table, what's the last entry there?
    Vote for:

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

    Comment

    Related Topics

    Collapse

    Working...