CSV Import always giving 500 Server Error

[Ulisses Ramos]

Well, i posted this problem more then 5 times for different 1.5 version on Forge and got no response.

 

This one has was created 21/09/2012 and is still unresolved.

http://forge.prestashop.com/browse/PSCFV-4286

 

 

My store has 11 shops on it. They are all on the same group, but they don´t share costumers or orders.

 

Everything works just fine, but when i try to import a csv i always get a 500 server error.

I even tried this with a csv with ONE product and still get the eror.

 

I´ve been doing some tests and the only way i got it to work with a 50 product CSV file, was to change the processing times on php.ini and fastcgi to 3600.

As my store has more then 5500 products, getting all updated every 3 weeks would take days.

I checked on phpmyadmin and all tables seem to be processed in about 60 seconds.

I saw this by making a copy of my database, emptying all product tables and running that 50 product csv. All tables are filled after those 60 seconds.

However the script on the store keeps running for minutes and minutes and gives the 500 error.

It seems that the script isn´t getting info from the database that all data was handled.

 

Please help

 

I´m running a Microsoft IIS 8 server with this configuration

 

Informação do servidor
Informação do servidor: Windows NT build 9200 (Unknown Windows version Datacenter Edition) i586
Server software version: Microsoft-IIS/8.0
PHP version: 5.4.8
Memory limit: 512M
Max execution time: 300
Database information
MySQL version: 5.5.28
MySQL engine: InnoDB
Tables prefix: ps_
Informação da loja
Prestashop version: 1.5.2.0
Current theme in use: default
Mail configuration
Método do Correio electrónico: You are using your own SMTP parameters.
Servidor SMTP: smtp.gmail.com
Utilizador SMTP: Definido
Palavra Chave do SMTP: Definido
Encriptação: ssl
Porta: 465
A sua informação
Your web browser: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0

 

My php.ini is this

 

[php]
;;;;;;;;;;;;;;;;;;;
; About php.ini   ;
;;;;;;;;;;;;;;;;;;;
engine = On
short_open_tag = Off
asp_tags = Off
precision = 14
output_buffering = 4096
zlib.output_compression = Off
implicit_flush = Off
unserialize_callback_func =
serialize_precision = 17
disable_functions =
disable_classes =
zend.enable_gc = On
;;;;;;;;;;;;;;;;;
; Miscellaneous ;
;;;;;;;;;;;;;;;;;
expose_php = On
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_input_time = 250
memory_limit = 512M
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
error_reporting = E_ALL
display_errors = On
display_startup_errors = On
log_errors = On
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off
html_errors = Off
;;;;;;;;;;;;;;;;;
; Data Handling ;
;;;;;;;;;;;;;;;;;
variables_order = "GPCS"
request_order = "GP"
register_argc_argv = Off
auto_globals_jit = On
post_max_size = 512M
auto_prepend_file =
auto_append_file =
default_mimetype = "text/html"
;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
doc_root =
user_dir =
enable_dl = Off
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;
file_uploads = On
upload_max_filesize = 512M
max_file_uploads = 20
;;;;;;;;;;;;;;;;;;
; Fopen wrappers ;
;;;;;;;;;;;;;;;;;;
allow_url_fopen = On
allow_url_include = Off
default_socket_timeout = 60
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;
[CLI Server]
cli_server.color = On
[Date]
[filter]
[iconv]
[intl]
[sqlite]
[sqlite3]
[Pcre]
[Pdo]
[Pdo_mysql]
pdo_mysql.cache_size = 2000
pdo_mysql.default_socket=
[Phar]
[mail function]
SMTP = localhost
smtp_port = 25
mail.add_x_header = On
[sql]
sql.safe_mode = Off
[ODBC]
odbc.allow_persistent = On
odbc.check_persistent = On
odbc.max_persistent = -1
odbc.max_links = -1
odbc.defaultlrl = 4096
odbc.defaultbinmode = 1
[interbase]
ibase.allow_persistent = 1
ibase.max_persistent = -1
ibase.max_links = -1
ibase.timestampformat = "%Y-%m-%d %H:%M:%S"
ibase.dateformat = "%Y-%m-%d"
ibase.timeformat = "%H:%M:%S"
[MySQL]
mysql.allow_local_infile = On
mysql.allow_persistent = On
mysql.cache_size = 2000
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
[MySQLi]
mysqli.max_persistent = -1
mysqli.allow_persistent = On
mysqli.max_links = -1
mysqli.cache_size = 2000
mysqli.default_port = 3306
mysqli.default_socket =
mysqli.default_host =
mysqli.default_user =
mysqli.default_pw =
mysqli.reconnect = Off
[mysqlnd]
mysqlnd.collect_statistics = On
mysqlnd.collect_memory_statistics = Off
;mysqlnd.net_cmd_buffer_size = 2048
[OCI8]
[PostgreSQL]
pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0
[sybase-CT]
sybct.allow_persistent = On
sybct.max_persistent = -1
sybct.max_links = -1
sybct.min_server_severity = 10
sybct.min_client_severity = 10
[bcmath]
bcmath.scale = 0
[browscap]
[session]
session.save_handler = files
session.use_cookies = 1
session.use_only_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.cookie_httponly =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor = 1000
session.gc_maxlifetime = 1440
session.bug_compat_42 = Off
session.bug_compat_warn = Off
session.referer_check =
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
session.hash_function = 0
session.hash_bits_per_character = 5
[MSSQL]
mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
mssql.secure_connection = Off
[Assertion]
[COM]
[mbstring]
[gd]
[exif]
[Tidy]
tidy.clean_output = Off
[soap]
soap.wsdl_cache_enabled=1
soap.wsdl_cache_dir="/tmp"
soap.wsdl_cache_ttl=86400
soap.wsdl_cache_limit = 5
[sysvshm]
[ldap]
ldap.max_links = -1
[mcrypt]
[dba]
[WebPIChanges]
error_log = "C:\Windows\temp\php54_errors.log"
upload_tmp_dir = C:\Windows\temp
session.save_path = C:\Windows\temp
cgi.force_redirect = 0
cgi.fix_pathinfo = 1
fastcgi.impersonate = 1
fastcgi.logging = 0
max_execution_time = 300
date.timezone = Europe/Lisbon
extension_dir = "C:\Program Files (x86)\PHP\v5.4.8\ext\"
[ExtensionList]
extension=php_mysql.dll
extension=php_gd2.dll
extension=php_curl.dll
extension=php_pdo_mysql.dll
[php_MYSQLI]
extension=php_mysqli.dll
[php_MBSTRING]
extension=php_mbstring.dll

 

MySQL my.ini

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
[client]
port=3306
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=800
query_cache_size=83M
table_cache=1520
tmp_table_size=30M
thread_cache_size=38
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=30M
key_buffer_size=13M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=10M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=5M
innodb_buffer_pool_size=471M
innodb_log_file_size=169M
innodb_thread_concurrency=8

 

My FASTCGI is

<fastCgi>
  <application fullPath="C:\PHP\php-cgi.exe"
	 maxInstances="4"
	 idleTimeout="300"
	 activityTimeout="350"
	 requestTimeout="250"
	 instanceMaxRequests="10000"
  <environmentVariables>
	 <environmentVariable
		name="PHP_FCGI_MAX_REQUESTS"
		value="10000" />
  </environmentVariables>
  </application>
</fastCgi>

Edited October 28, 2012 by Ulisses Ramos (see edit history)

[Ulisses Ramos]

Bump

[Ulisses Ramos]

Bump

[Ulisses Ramos]

Bump