Help required regarding 500 internal error when importing csv file

[Paulw01]

Hi there,

I receive the error below with presta when importing CSV file with 1703 products with small amount of info per product. The file size is 966kb.

Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_perl/2.0.4 Perl/v5.8.8 Server at www.disclocation.co.uk Port 80

I contacted my host Uk2.net to check permissions etc to see if configuration was a problem. Info from uk2 below.

Upload max file size= 20m (Default is 8 m max 20)
Post max size 20m (average 20 - max 32)
register globals = off (off by default)
allow url fopen = on (off by default)
memory limt=24m (default 8m max 32M)

Could anyone tell me if there are obvious problems preventing me from loading my csv file please ?

Really appreciate any help, as uploading csv file in parts will take hours as eventually I will have about 15000 products. Obviously would like to upload in one go !!!!

Thanks

Paul

[alduxvm]

Hi there,<br/><br/>I receive the error below with presta when importing CSV file with 1703 products with small amount of info per product. The file size is 966kb.<br/><br/>Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_perl/2.0.4 Perl/v5.8.8 Server at www.disclocation.co.uk Port 80<br/><br/>I contacted my host Uk2.net to check permissions etc to see if configuration was a problem. Info from uk2 below.<br/><br/>Upload max file size= 20m (Default is 8 m max 20)<br/>Post max size 20m (average 20 - max 32)<br/>register globals = off (off by default)<br/>allow url fopen = on (off by default)<br/>memory limt=24m (default 8m max 32M)<br/><br/>Could anyone tell me if there are obvious problems preventing me from loading my csv file please ?<br/><br/>Really appreciate any help, as uploading csv file in parts will take hours as eventually I will have about 15000 products. Obviously would like to upload in one go !!!!<br/><br/>Thanks<br/><br/>Paul

 

 

hi!

 

well, first of all, 1703 with images? or without?? with images is something that its never going to work, because PS resizes the images and makes the importing very slow...

 

i need to import 11000 products, a little less than you, what i did was to cut the CSV into files of 400 products... i know, its to much, several times importing... but there is no other way...

 

start cutting you csv and make the test... 400 products per file should work fine.

 

good luck!!

[tomerg3]

It would help if you could look at your server log and find the actual error (error 500 can be caused by many things).

 

24MB memory is very low, you really should have at least 64MB.

 

That could be one reason, another is the timeout limit on your server.

 

Do you get the error right away, or does it run for a while and then gives the error?

 

Can you try to do it with a small file (10 products) and see if the import works.

[philee]

I am coming across this error while importing 2020 products as well.

 

The CSV product file is approximately 8MB. What settings should I set my PHP.INI for my VPN to be able to handle this CSV file size?

 

At the moment, the import would run for about a minute and it would give me a 500 Internal Server Error.

 

Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 mod_fcgid/2.3.6 Server at ---.com Port 80

[tomerg3]

max_execution_time = 3000;

max_input_time = -1;

[philee]

max_execution_time = 3000;

max_input_time = -1;

 

Thanks for your help. This extended the time during import. However, I came into another 500 Internal Server Error, so I checked the error_log. This error came up.

 

[05-Sep-2011 03:57:59] PHP Fatal error:  Out of memory (allocated 26738688) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 03:58:03] PHP Fatal error:  Out of memory (allocated 27525120) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 03:58:08] PHP Fatal error:  Out of memory (allocated 30670848) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 03:58:49] PHP Warning:  include(/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 03:58:49] PHP Warning:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:01:14] PHP Fatal error:  Out of memory (allocated 26738688) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 04:02:51] PHP Warning:  include(/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:02:51] PHP Warning:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:04:15] PHP Warning:  include(/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:04:15] PHP Warning:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:07:12] PHP Warning:  include(/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:07:12] PHP Warning:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:08:03] PHP Fatal error:  Out of memory (allocated 29097984) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 04:08:07] PHP Fatal error:  Out of memory (allocated 27262976) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 04:08:07] PHP Fatal error:  Out of memory (allocated 29360128) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 04:10:48] PHP Warning:  include(/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:10:48] PHP Warning:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 04:25:54] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Cart.php on line 365
[05-Sep-2011 04:25:54] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Cart.php on line 260
[05-Sep-2011 04:25:54] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Cart.php on line 285
[05-Sep-2011 04:47:26] PHP Fatal error:  Out of memory (allocated 23855104) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 04:47:38] PHP Fatal error:  Out of memory (allocated 24641536) (tried to allocate 122880 bytes) in /home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php on line 44
[05-Sep-2011 06:45:40] PHP Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/site/public_html/store/classes/MySQL.php on line 172
[05-Sep-2011 06:45:40] PHP Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/site/public_html/store/classes/MySQL.php on line 172
[05-Sep-2011 06:45:40] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Tools.php on line 1119
[05-Sep-2011 06:45:40] PHP Warning:  uasort() expects parameter 1 to be array, boolean given in /home/site/public_html/store/classes/Tools.php on line 1124
[05-Sep-2011 06:45:40] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Tools.php on line 1125
[05-Sep-2011 08:03:07] PHP Warning:  include(/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 08:03:07] PHP Warning:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 08:04:13] PHP Warning:  include(/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 08:04:13] PHP Warning:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/site/public_html/store/tools/smarty/compile/efc0bf1128474cdfa0a76b17fc8663764d239630.file.category-tree-branch.tpl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/site/public_html/store/tools/smarty/sysplugins/smarty_internal_template.php on line 433
[05-Sep-2011 11:17:35] PHP Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/site/public_html/store/classes/MySQL.php on line 172
[05-Sep-2011 11:17:35] PHP Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/site/public_html/store/classes/MySQL.php on line 172
[05-Sep-2011 11:17:35] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Tools.php on line 1119
[05-Sep-2011 11:17:35] PHP Warning:  uasort() expects parameter 1 to be array, boolean given in /home/site/public_html/store/classes/Tools.php on line 1124
[05-Sep-2011 11:17:35] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Tools.php on line 1125
[05-Sep-2011 11:18:28] PHP Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/site/public_html/store/classes/MySQL.php on line 172
[05-Sep-2011 11:18:28] PHP Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/site/public_html/store/classes/MySQL.php on line 172
[05-Sep-2011 11:18:28] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Tools.php on line 1119
[05-Sep-2011 11:18:28] PHP Warning:  uasort() expects parameter 1 to be array, boolean given in /home/site/public_html/store/classes/Tools.php on line 1124
[05-Sep-2011 11:18:28] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Tools.php on line 1125
[05-Sep-2011 11:58:14] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/Category.php on line 442
[05-Sep-2011 11:58:14] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/CMSCategory.php on line 193
[05-Sep-2011 11:58:14] PHP Warning:  Invalid argument supplied for foreach() in /home/site/public_html/store/classes/CMSCategory.php on line 206

 

Any ideas? Again, it's a 8MB CSV file containing 2,020 products.

[spirits999]

Guys,

I'm having the exact same problem. I even updated the php.ini file but the 500 error comes exactly in about 60-70 seconds uploading only about 50 products. Do I have to restart the server for the php.ini to reflect? Should I delete the htaccess file and try again? Any suggestions guys... Please help...

I have been following the forums quite regularly.. Rocky and Mike Kranzler can really help! Paging for Rescue!

[spirits999]

Has anyone found a solution to this yet?