Geek Answers Handbook

500 Internal server error while entering CSV with large photos

I am having problems importing products with a CSV file.

I am trying to upload a CSV file with about 1400 products., Most of which have three photos or so .... but the pictures are quite large at 3-4 megabytes. So far, during testing, I only tried to import from a CSV file with 5 elements.

I initially got an error in prestashop, showing that the pictures for my products could not be copied. Products were imported, but they did not have photos. I researched this and found that the PHP.INI file needs updating. I did this with the following options:

<?php
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

memory_limit = 256M
max_execution_time = 120
max_input_vars = 3000;
suhosin.post.max_vars = 3000;
suhosin.request.max_vars = 3000;


?>

My PHP info file is here: www.gbamedical.com/info.php

500 . :

[ 22 23:21:19 2014] [5435820] [fcgid: warn] [ 97.115.27.65:60638] mod_fcgid: 120 , http://www.gbamedical.com/shoppe/05ad01min05/index.php?controller=AdminImport&token=62fefdea84f98bf2f436dafc040b6c1f

[ 22 23:21:19 2014] [5435820] [core: error] [ 97.115.27.65:60638] script : index.php, referer http://www.gbamedical.com/shoppe/05ad01min05/index.php?controller=AdminImport&token=62fefdea84f98bf2f436dafc040b6c1f

? , , , 1400 , MONSTER, .

, .

+4
4

URL- CSV,

http://localhost/importimages/image_name.jpg

- .

0

, set_time_limit (0) , ( ), , prestashop, ( , fopen() ).

-, . ( ) fcgid.conf:

FcgidIOTimeout 180

IPCCommTimeout. ( ). , .

0

:

https://serverfault.com/questions/80929/disable-the-timeouts-on-apache-httpd-and-fastcgi

, fastcgi, : -idle-timeout 360

(: 360)

/etc/apache2/mods-enabled/fastcgi.conf. FastCgiExternalServer.

:

<IfModule mod_fastcgi.c>
   AddType application/x-httpd-fastphp5 .php
   Action application/x-httpd-fastphp5 /php5-fcgi
   Alias /php5-fcgi /usr/lib/cgi-bin/php5-fcgi
   FastCgiExternalServer /usr/lib/cgi-bin/php5-fcgi -socket /var/run/php5-fpm.sock -pass-header Authorization -idle-timeout 360
   <Directory /usr/lib/cgi-bin>
      Require all granted
   </Directory>
</IfModule>

apache , fastcgi . ,

0

I had the same problem. I am using Centos 6 and fcgi. I installed in /etc/httpd/conf.d/fcgid.conf

MaxRequestLen 1073741824
FcgidBusyTimeout 6000

And when I import csv, my import process works as a background process

0
source

More articles:


All Articles