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: http://www.slackworth.co.uk/vB/impex/index.php
Referer: http://www.slackworth.co.uk/vB/impex/index.php
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: http://www.slackworth.co.uk/vB/impex/index.php
Referer: http://www.slackworth.co.uk/vB/impex/index.php
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 (http://www.vbulletin.com/forum/showpost.php?p=653410&postcount=2). See this thread:
http://www.vbulletin.com/forum/showthread.php?t=101653

[adwhitworth]

This bug has already been reported, and fixed (http://www.vbulletin.com/forum/showpost.php?p=653410&postcount=2). 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.