Why can't I skip steps if information was imported

[mband2000]

Hello.. I'm having a bit of a problem.

I'm currently importing my system and it stalls on the last page of the POST importing..

The thing is... I think it stalls on the LAST post in the database.. and whenever I try to go to the next mod.. it starts back on that last page of the POST importing.

How can I skip that section or force it to go to the next section?

[Jerry]

You can't skip sections if they are dependant, on the last page of posts, ImpEx updates all the post.parentid's, that can take a while some times.

How many posts are you importing ?

[mband2000]

I'm importing 233,000 post.

The script gets to "Importing 230,000 - 232,000 post"..

And it stalls and gives this error..



ImpEx Database errormysql error: Invalid SQL: SELECT postid, importpostid FROM post WHERE importpostid = K YOUR 423511

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 'YOUR 423511' at line 1

mysql error number: 1064

Date: Thursday 02nd 2006f March 2006 03:19:36 PM
Database: newforum
MySQL error:



^^that's all I'm getting

[Jerry]

Well I can see why the SQL is broken, which board and version are you importing from ?

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

[mband2000]

Opps.. I'm very sorry for not including all the info. Here it is.

Source - IPB - 2.0.1
Target - vBulletin 3.5.4
Module - 007?? - Import Posts

[Jerry]

Can you start a support ticket and ask for me, there is something going on as there should be nothing but integers being passed as an importpostid.

Is the source hacked ?

[mband2000]

No the source has no hacks that I know of... but I will definately open a ticket.. thanks alot.