Importer Problem

[adwhitworth]

Hi,

Trying to import from IPB 1.3 Final. I can run the first part of the importer fine. When I run the second part, Out of the 103 members, I am the only one installed on the new version of vB 3.0.1 so I put a "1" in the box by my username and leave everyone elses blank and then press Associate...Then for some reason I get a MySQL error saying:

Database error in vBulletin:ImpEx Target 3.0.1:

Invalid SQL: 
                        UPDATE user
                        SET importuserid = '1'
                        WHERE userid = '1'
                    
mysql error: Table 'w206459_vb.user' doesn't exist

mysql error number: 1146

Date: Thursday 15th of April 2004 01:23:57 PM
Script: [url]http://www.slackworth.co.uk/vB/impex/index.php[/url]
Referer: [url]http://www.slackworth.co.uk/vB/impex/index.php[/url]
Username: adwhitworth
IP Address: 62.254.0.30 

I can re-run this part again though. However, if I leave every single user blank and don't associate anyone or just leave this error and and try and run Part 3, I just get this error...

Database error in vBulletin:ImpEx Source 3.0.1:

Invalid SQL: 
            SELECT * FROM ibf_members
            LIMIT ,
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

mysql error number: 1064

Date: Thursday 15th of April 2004 01:25:18 PM
Script: [url]http://www.slackworth.co.uk/vB/impex/index.php[/url]
Referer: [url]http://www.slackworth.co.uk/vB/impex/index.php[/url]
Username: adwhitworth
IP Address: 62.254.0.30 

If anyone could help, I would be really greatful

[mOdEtWo]

This bug has already been reported, and fixed. See this thread:

http://www.vbulletin.com/forum/showthread.php?t=101653

[adwhitworth]

This bug has already been reported, and fixed. See this thread:
http://www.vbulletin.com/forum/showthread.php?t=101653

Thanks. I saw your thread and updated it and stage 2 works but Stage 3 is still dodgy.

[mOdEtWo]

Thanks. I saw your thread and updated it and stage 2 works but Stage 3 is still dodgy.

Aha. Well, it solved the problems you had with step 2.

Anyway, what are the problems with step 3?

[adwhitworth]

I get another SQL error. See the second box of code in the first post

EDIT: Just noticed something. On the Second stage, there is user 1 which is me and when I put in the box "1" to import to vB

"1 NOT done. It is most lightly that vBulletin user 1 dose not exsist.

Continuing with the association."

[mOdEtWo]

I'll leave that up to Jerry or someone else to answear, cause I have no clue what it means.