[Forum] MySQL error upgrading from 3.8 tp 4.2.4

[mrmckoy]

Using php 5.5 via http://mymodeltalk.com/jobs/install/upgrade.php. I submitted ticket: 1511952. Not sure why but i'm getting this error as the upgrade processes:


Upgrading to 4.0.8
Step 5 - Altering post Table (1 of 1)
An error has occurred with your database. Please contact vBulletin Support for assistance.

Module: 408, Step 5 Database Error:1091

Can't DROP 'userid'; check that column/key exists

Query:

ALTER TABLE vb_post DROP INDEX userid, ADD INDEX userid (userid, parentid)

[Paul M]

The error is fairly self explanatory, fixing it requires database access.

As you submitted a ticket then you just need to wait for support to work on it.

[mrmckoy]

The error is fairly self explanatory, fixing it requires database access.

As you submitted a ticket then you just need to wait for support to work on it.

One would think so but the column field userid actually does exist in the table and its got a lot of data in it.

[Paul M]

Its not the column its complaining about, if you look carefully, its the index on the column, that's missing.