I can not install PrestaShop.

[Ilia]

I can not install PrestaShop. The last page of the installation shows error 504 - Gateway timed-out. I attach a screenshot of the error and the logs.

2018/08/04 16:02:23 [error] 530#530: *9 FastCGI sent in stderr: "PHP message: PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/prestashop/classes/shop/Shop.php on line 347" while reading response header from upstream, client: 192.168.0.180, server: _, request: "GET /prestashop/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "192.168.0.175"
2018/08/04 16:03:37 [error] 530#530: *9 FastCGI sent in stderr: "PHP message: PHP Warning:  file_put_contents(/var/www/html/prestashop/var/cache/prod/cacert.pem): failed to open stream: No such file or directory in /var/www/html/prestashop/classes/Tools.php on line 1948" while reading response header from upstream, client: 192.168.0.180, server: _, request: "GET /prestashop/install/index.php?restart=true HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "192.168.0.175"
2018/08/04 16:09:40 [error] 532#532: *79 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 192.168.0.180, server: _, request: "GET /prestashop/install/index.php?installDatabase=true&_=1533388119591 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock", host: "192.168.0.175", referrer: "http://192.168.0.175/prestashop/install/index.php"

 

[selectshop.at]

Your server is bad configured. fpm is not configured properly. time_out settings are set too low value. Please ask for support of your provider n this case. He should also read all other server logs.

Furthermore if you are trying to install PS 1.7.4. you should use at least php version 7.2. See here min. server requirements tested in production for to road Prestashop. https://www.prestashop.com/forums/topic/633857-server-requirements-for-ps-17/

[Ilia]

I am the server administrator. Please tell me which settings I should change?

[selectshop.at]

Read the link I added before ? How to configure fpm you will find several tutorials over the net. Cannot assist you, because I don't know what you have installed. Better you follow instructions for your OS installed. Ubuntu, Centos, etc. ngninx or fpm only or both.

https://stackoverflow.com/questions/18740635/nginx-upstream-timed-out-110-connection-timed-out-while-reading-response-hea

https://serverfault.com/questions/356422/how-do-i-increase-fastcgi-read-timeout-to-prevent-504-error-on-nginx

etc...

[Ilia]

I increased the time out on my Nginx web server. Now there is another error:

1: SQL error on query Tablespace for table '`prestashop`.`customer_message_sync_imap`' exists. Please DISCARD the tablespace before IMPORT.

Previously, I completely cleared this database.

Edited August 4, 2018 by Ilia
Information added. (see edit history)

[selectshop.at]

There is something wrong with your database. Or some broken index, try to repair, or something wrong with the configuration of your database. It's mariaDB ? If yes please revert to their support docu.

[selectshop.at]

If you already imported a database: delete the database, create a new one and re-import your data. Possibly something got wrong during import process. If you are still having same error, than please revert to specific docu. MariaDB or mySQL.

You can also try this: https://www.24x7servermanagement.com/clients/knowledgebase.php?action=displayarticle&id=106

[Ilia]

So, in order to install PrestaShop, you need to change the fastcgi_read_timeout and keepalive_timeout directives in the file /etc/nginx/nginx.conf to a larger value, for example, 3600, as I did.