import getting stuck on posts import

[rwhetsto]

Hi!

When I import the posts after a bunch of imports (somewhere around the 200,000th post) it turns into a white page and the script seems to stop running. I can click on other links in the admincp but if I click on the import link again it just spins and I get the white screen of death again. If I log out, close the browser and go back to the admincp and click on import I get the same white screen.

If I delete (truncate) the data from the posts table in the dB, I am able to access the import page again and it seems to "finish" the posts import and consistently 124 posts get put into the posts table.

Could the script be getting hung on a particular post?

I am importing from phpbb2, fresh install of vBulletin 3.6

I would appreciate any advise on how to avoid this issue and complete the import.

Thanks,
Ryan

[Jason2]

I had a similar problem. Just re-upload all files and try again.

Regards Jason :)

[rwhetsto]

Thanks Jason,

When you say re-upload the files you mean the impex files right, not the whole vBulletin package?

I read that somewhere else and re-uploaded the impex files, tried it again, but got the same results.

[Jerry]

Hi!

When I import the posts after a bunch of imports (somewhere around the 200,000th post) it turns into a white page and the script seems to stop running. I can click on other links in the admincp but if I click on the import link again it just spins and I get the white screen of death again. If I log out, close the browser and go back to the admincp and click on import I get the same white screen.

The ideal thing is to get the PHP error logs to see why the process is dying.



If I delete (truncate) the data from the posts table in the dB, I am able to access the import page again and it seems to "finish" the posts import and consistently 124 posts get put into the posts table.

From the target database I take it ?


Could the script be getting hung on a particular post?

Possible, how many are you doing per page and what is the PHP memory limit ?

[rwhetsto]

The ideal thing is to get the PHP error logs to see why the process is dying.
I am running it again to see what I get in the error log. Should I set impexdebug to true? Would that shed any insight?


From the target database I take it ?
Correct


Possible, how many are you doing per page and what is the PHP memory limit ?
I have tried 500, 1000 and 2000. Same result for each. I don't know how to find my memory limit. I now do not think this is it. At first I was trying to import around 350,000 posts and the import would die at the exact same spot. I have since pruned the source dB (using phpbb) down to around 200,000 posts. Same result for both instances. Dies 124 posts before the end.

[rwhetsto]

The ideal thing is to get the PHP error logs to see why the process is dying.

Nothing showed up in the error log

[Jerry]

I'd say check out what the 125th post from the end is, see if it has lots of complicated content that could break a parser etc ?