You are here:  » XML import not working for bigger files

Support Forum



XML import not working for bigger files

Submitted by encore on Tue, 2010-04-06 06:56 in

Recently my service provider did a little upgrades on their service and after that I have been able to import only XML files that are very small in size. All little bigger files import failes but without any error codes or anything. We are quite puzzled about this issue - both me and my service provider and so we need your assistance to solve this issue.

PHP version on the server: 5.2.13
MySQL version on the server: 5.1.44

All seems to work fine until following function is called in admin.php:
MagicParser_parse("../feeds/".$admin_importFeed["filename"],"admin__importRecordHandler",$admin_importFeed["format"]);

I'm also running the very same software on my personal computer with identical MySQL database and doesn't have these problems. My PHP version is 5.3.1 and MySQL version 5.1.45. I'm able to import big XML files on this set-up with no problems.

Right now I'm temporarily getting around this problem by making the XML import on my personal computer and then taking MySQL dump which I import manually to the MySQL in the server.

Me and my service provider need your assistance so that we can tackle this bug down, thank you.

Submitted by support on Tue, 2010-04-06 07:10

Hi there,

It sounds almost as if it just a combination of the following settings in the master php.ini

display_errors = Off
max_execution_time = 60

The import script does issue set_time_limit(0), but this can be overruled by max_execution_time in php.ini. One way to check the settings would be to run a phpinfo() script on your site, and look for the local settings of the above to see if that is the problem - just create a script called phpinfo.php containing:

<?php
  phpinfo
();
?>

Fingers crossed that should be all it is...

Cheers,
David.

Submitted by encore on Tue, 2010-04-06 12:57

My service provider had max_execution_time = 30. They now changed to 60 but it didn't help to this problem.
Any other suggestion?

Errors and warning do get written into server's error_log but in this case there doesn't come up any.

Submitted by support on Tue, 2010-04-06 13:50

Hi,

60 seconds is probably not enough really for a large feed - just to confirm if that is the problem, could you perhaps ask your service provider to try max_execution_time = 0 (which allows unlimited time)?

Cheers,
David.

Submitted by encore on Tue, 2010-04-06 13:55

I don't think that's the problem as the execution fails in just a few seconds, not in 30 or 60.
I think it must be something else.

You may see my service provider's phpinfo() here if it helps to troubleshoot: {link saved}

Submitted by support on Tue, 2010-04-06 14:00

Hi,

Do your smaller feeds take longer than a few seconds, but when you now try a large feed it fails within a few seconds - is that what's happening?

Could you perhaps email me know the URL of your installation (and any password required for /admin/) and I'll take a look for you...

Cheers,
David.

Submitted by encore on Tue, 2010-04-06 14:33

Sent you email with details.