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.

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?

[NumNum]

exactly, just moving it over to a new server. the only differece is php, and mysql version are newer.

[ForceHSS]

Putting up a test server give me a few mins

--------------- Added 1430258891 at 1430258891 ---------------

I put up a vb3 test server and the column is not part of the user table so it must be from something custom that was in your old db

[NumNum]

Hmmm...

Thanks for your extra work. Guess no short cuts around this.

[ForceHSS]

Happy to help

[NumNum]

Hmmm...

Must be the edited font?

Happy to help

I guess i would need a method of procedure on how to add the index/column. Not familiar with that.

[ForceHSS]

You would need to fix the problem from your old backup the missing column might be in there so best to post in the paid section to see who can help. But why are you trying to install an old backup for and do you not have other backups you can use that might work

[NumNum]

Actually I do a daily backup, and that is the newest. I certainly can try others as well.

--------------- Added 1430321292 at 1430321292 ---------------

Resolved. What i wanted to do impex was of no use. Used SSH and I am back online.