Impex and Firefox Problem

[sdotson]

I have been trying to import a PHPBB board and I keep getting stuck at importing the posts. There are about 42k of them.

Impex gets about 1/2 to 3/4 the way through and then Firefox throws up a "download" dialogue asking me what I'd like to do with index.php. If I cancel this away, IMPEX sits there with DONE in the status bar and refuses to continue.

I've tried doing anywhere from 500 to 10,000 posts at a time all with the same result.

Any ideas?

BTW, IE just times out when I try to use it.

I'm on a hosted server. Would it be better to do it offline on my local machine? If so what would be required to pull this off (I'd prefer to do it online).

[Steve Machol]

This is most likely a server time and/or memory limit. To temporarily up your limits edit your includes/config.php file and add these lines right under the <?php line:

ini_set('memory_limit', 32 * 1024 * 1024);
ini_set("max_execution_time", "240");

[Jerry]

Do you know your PHP memory limit and script time out settings ?

[sdotson]

No dice Steve. Added it and it still timed out when trying 8000 at a time.

No I do not Jerry. As I said this is a hosted server so I do not have control. I peeked at some of the PHP variables and could not find a memory or timeout variable.

Any idea where I might find this info?

[Steve Machol]

Use a lower number or increase those values.

[sdotson]

OK I've lowered the # of imports to 500 and changed to this:

ini_set('memory_limit', 64 * 1024 * 1024);
ini_set("max_execution_time", "500");

but I still get the same error.


It seems like it works fine for the first few 10 thousand entries. Is there a way to only do a limited number then to rerun the script. I wouldn't mind running it several times to get a result.

or what would be the process to run this offline?

[Jerry]

Does it fail at a consistent point ? there might be a post that is causing it to fail when its parsed, because it has huge or some content that breaks the parser.

[sdotson]

Interesting. I can take a look and see.

Is there a way to break it into two (or more) passes?

I am excited about switching to VB (the support is wonderful) but unless I can get this DB converted I can't use it.. :(

As a last resort is it possible to pay someone to convert it for me?

[Jerry]

Interesting. I can take a look and see.

Is there a way to break it into two (or more) passes?

I am excited about switching to VB (the support is wonderful) but unless I can get this DB converted I can't use it.. :(

As a last resort is it possible to pay someone to convert it for me?

If you open a support ticket and ask for me I'll add some debug to your ImpEx to find out which post is killing it.

[sdotson]

I'll do that tonight. Thanks for the assistance.