vb3 to vb3

[dcarr]

hanging at step 006


Database error in vBulletin:ImpEx Source 3.0.3:
Invalid SQL: SELECT * FROM customprofilepic ORDER BY userid LIMIT 0,
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 1

anyway I can fix this?

[Jerry]

Firstly, download the latest impex there is some error checking that went in recently to stop this SQL error getting passed to the database.

Secondly, run this SQL :

DELETE FROM datastore WHERE title='ImpExSession';

To clear the broken session and start the whole import again.

[dcarr]

Thanks Jerry, I had the latest..3.03 but was still getting the errors...while waiting I manually added the query's and everything worked fine. Thanks.

[Jerry]

Good to hear, though for public note. 3.03 is the vB version, impex versioning seprate and is in the status thread.

[dcarr]

Sorry I meant the latest impex version