[ImpEx] - Error when associating users

[mOdEtWo]

I'm trying to import from phpBB2 to vB 3.0.1.

I've done everything according to the readme, and I have configured ImpEx properly as far as I can see.

When running the ImpEx script, step 1 goes perfectly fine, it check and updates the database (also means it can find the phpBB database). But when I try to associate my old phpBB user with my new one (Userid - 7 :: mOdEtWo ... and setting ID 1 in the input box, since I am UserID 1 on the new vB3 forum). But when I click the "Associate" button, I get a MySQL error:

Database error in vBulletin:ImpEx Target 3.0.1
Invalid SQL:

UPDATE user
SET importuserid = '7'
WHERE userid = '1'

mysql error: Table 'db.user' doesn't exist
mysql error number: 1146
Date: Thursday 15.th of April 2004 09:22:45 AM
Script: http://localhost/forums/impex/index.php
Referer: http://localhost/forums/impex/index.php
Username: mOdEtWo
IP Address: 127.0.0.1

Now, look at the error message saying "mysql error: Table 'db.user' doesn't exist". I know why, cause it should look for Table db.vb3_user instead, as I've specified in the ImpExConfig.php file: targettablefrefix = vb3_. Also, when looking at the table in phpMyAdmin, it is named db.vb3_user.

Am I doing something wrong, or is it something wrong with the script?

[Jerry]

Typo on line 3023 of ImpExDatabase.

It is :

UPDATE user

It should be :

UPDATE " . $tableprefix . "user

in function associate_user.

[mOdEtWo]

Yay, I spotted a bug.

Thanks for clearing it out Jerry!

[Jerry]

With a system of that size there will be a few hiding in corners

[mOdEtWo]

With a system of that size there will be a few hiding in corners

Of course it will. You've done a great job, seems like the rest is going very well (at importing posts atm).

Ah, this script is so much better than the old vB2 scripts.

[Jerry]

Did you post another bug, I'm tracking them now and can't see anything.

[mOdEtWo]

Well, when I specify to associating my phpBB user (id 7) with my vB user (id 1), it says that the associating is being done, but when I close that screen and go back to the Import/Export index screen, it displays 0 users as associated. So it seems it doesn't do the associating. However, I can't redo the option on the same user, it just gives me an error about "ID does not exist" (or something like that).

When I checked my member list, I could see 2 mOdEtWo accounts - one with user ID 1, and one with user ID 7.

Thoughts?

[Jerry]

I belive its being done and the fault lies with the counter not the actual assocation, on it now.

[mOdEtWo]

I see. Well, the old vB2 import scripts associated and merged the two users (as far as I remember), and I ended up having only one mOdEtWo user - which is correct.