Importing db v5.0.85-community-nt to db v5.6.24-log

[NumNum]

I have been trying to import my old db on a windows 2000 server to a windows 2012r2 and am getting the following error using impexe.

PHP Code:

ImpEx Database error

mysql error: Invalid SQL: 
            ALTER TABLE `user`
            ADD INDEX `importuser_index` ( `importuserid` )
            

mysql error: Key column 'importuserid' doesn't exist in table

mysql error number: 1072

Date: Friday 24th 2015f April 2015 05:34:05 PM
Database: vbulletin
MySQL error: 


Looking for any help on this.

[ForceHSS]

You need to add the missing column to the user table as it needs to add the missing index importuser_index

[NumNum]

I can do this manually?

[ForceHSS]

Yes if you can find the sql query you have part of it above but just need the one for putting the column in place first

[NumNum]

There has got to be an easier way than doing this manually.

[ForceHSS]

If you can't do a few queries you could hire someone. If I had vb5 I would give you the queries or a copy of vb5 I would put up a test server and get you the queries

[NumNum]

I'm using 3.8.8, eventual 5.1.6

moving 3.8.8 to a whole new server so i can eventually run 5.

[ForceHSS]

If you are using vb3 why post in vb5? Before you make the mistake and install vb5 don't far to many problems with it give them time to fix them if you really want to upgrade install vb4.2.3 beta. So the column above is that from a custom mod?

[NumNum]

It should be in 3 and not in 5, I can't move it.

I have no custom mods.

[ForceHSS]

So the old db you where trying was it 3.8.8 PL1 and your site is the same?