PDA

View Full Version : MySQL Error : Duplicate column name 'sigpicrevision'


djjeffa
Wed 16th Aug '06, 9:34pm
Im upgrading from 3.5.4 to 3.6.0 and I got to step 7 and got this:
Step 7) Signature Permissions

Creating vb_sigpic table
Altering usergroup Table (1 of 9)
Altering usergroup Table (2 of 9)
Altering usergroup Table (3 of 9)
Altering usergroup Table (4 of 9)
Altering usergroup Table (5 of 9)
Altering usergroup Table (6 of 9)
Altering usergroup Table (7 of 9)
Altering usergroup Table (8 of 9)
Altering usergroup Table (9 of 9)
Altering user Table (1 of 1) http://www.djjeffa.com/vb/image.php?type=dberrorDatabase errorThe djjeffa.com database has encountered a problem.Please try the following:
Load the page again by clicking the Refresh (http://www.djjeffa.com/vb/install/upgrade_360b1.php?step=7#) button in your web browser.
Open the www.djjeffa.com (http://www.djjeffa.com/) home page, then try to open another page.
Click the Back (javascript:history.back(1)) button to try another link.The www.djjeffa.com forum technical staff have been notified of the error, though you may contact them (djjeffacom@msn.com) if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.5.5:
Invalid SQL:
ALTER TABLE vb_user
ADD sigpicrevision INT UNSIGNED NOT NULL;
MySQL Error : Duplicate column name 'sigpicrevision'
Error Number : -1
Date : Wednesday, August 16th 2006 @ 05:26:26 PM
Script : http://www.djjeffa.com/vb/install/upgrade_360b1.php?step=7
Referrer : http://www.djjeffa.com/vb/install/upgrade_360b1.php?step=6
IP Address : 71.242.13.44
Username :
Classname : vb_database