Bug database error

[Freekoid]

Getting this error when I upgrade from version 2!

Invalid SQL:

ALTER TABLE dbtech_vbshop_item
ADD giftpm ENUM ('0', '1') NOT NULL DEFAULT '1';

MySQL Error : Duplicate column name 'giftpm'
Error Number : 1060

 

[Fillip H.]

What version were you on previously (the full version number) and what was the output on the screen before you received that error?

 

[Freekoid]

I was on the one before which would be 2.2.3.

It wouldnt get past 1.1

Created Table: dbtech_vbshop_category
Created Table: dbtech_vbshop_purchase
Created Table: dbtech_vbshop_gift
Created Table: dbtech_vbshop_item
Created Table: dbtech_vbshop_purchase
Altered Table: administrator
Altered Table: user
Altered Table: usergroup

Updating Version Number To: 1.0.0

Altered Table: user
Created Table: dbtech_vbshop_ticket

Updating Version Number To: 1.1.0

Altered Table: dbtech_vbshop_category

 

[Fillip H.]

Hmm that's really weird, it shouldn't be running those steps since you're on 2.2.3...

Any chance of an AdminCP account with Can Administer Plugins and an FTP account? If I can't get to the bottom of why it's re-doing everything, I will at least be able to silence the error and avoid any duplicate data or anything of the sort

 

[Freekoid]

Done and done!

 

[Fillip H.]

For anyone else reading this: It was a rather unique scenario, but thankfully vBulletin didn't just randomly decide to run all the upgrade steps

If anyone else is in a similar situation the fixed file is /dbtech/vbshop/install/120.php and has been updated in the release package