Installation gets stuck "Create database tables" 12%

[a.ila]

I'm trying to go through the installation wizard for PS 1.7.5.0 on Apache 2.4.37, PHP 7.1.25, MySQL 5.7.19, Debian 8

I am stuck on the step "Create table" and I unfortunately I don't have any clue on what is causing the installation to fail. The message don't give enough details on the issue itself.
I've looked at both Apache log file and MySQL, frankly I don't see any error.
As anyone any idea on where to find error details during the installation? It's getting quite frustrating.

MySQL

2019-01-15T16:22:43.469714Z        71 Connect   prestashop@localhost on  using Socket
2019-01-15T16:22:43.470033Z        71 Query     SELECT @@auto_increment_increment as aii
2019-01-15T16:22:43.470295Z        71 Query     SELECT @@auto_increment_offset as aio
2019-01-15T16:22:43.470742Z        71 Quit
2019-01-15T16:22:43.471314Z        72 Connect   prestashop@localhost on prestashop using Socket
2019-01-15T16:22:43.472064Z        72 Query     CREATE TABLE `ps_test` (
                        `test` tinyint(1) unsigned NOT NULL
                ) ENGINE=MyISAM
2019-01-15T16:22:43.480873Z        72 Query     DROP TABLE `ps_test`
2019-01-15T16:22:43.481090Z        72 Quit

Apache

 

[Cyburg]

You'll probably not get much help here, especially with this very well known problem that has been around for ages, but no one ever can be bothered to address properly...

I would try using https://thirtybees.com

[JBW]

Set _PS_MODE_DEV_ to true in file config/defines.inc.php to see the details about the 500 error

/* Debug only */
if (!defined('_PS_MODE_DEV_')) {
define('_PS_MODE_DEV_', true);
}

 

[sniperobam]

On 15/01/2019 at 17:56, a.ila said:

J'essaie de passer par l'assistant d'installation de PS 1.7.5.0 sur Apache 2.4.37, PHP 7.1.25, MySQL 5.7.19, Debian 8

Je suis bloqué sur l'étape "Créer une table" et je n'ai malheureusement aucune idée de la cause de l'échec de l'installation. Le message ne donne pas assez de détails sur le problème lui-même.
J'ai consulté le fichier journal Apache et MySQL. Franchement, je ne vois aucune erreur.
Comme n'importe qui une idée sur où trouver des détails d'erreur pendant l'installation? Cela devient assez frustrant.

MySQL

Apache

 

Hi, I would first ask you to try to install the software with the active internet connection.

[Krysalidesign]

Hi all,

I have exactly the same problem with prestashop 1.7.5.1.

I've tried Chrome, Firefox and Edge and still have the problem.

Tables are created in database but are all empty. Apparently, there is no server problem but I'll try to reach my hosting service tomorow morning.

But right now, I don't have any clue to solve this problem, anybody have an idea ?

Thanks in advance,

Best regards

[a.ila]

The installation wizard lacks details when things don't work out of the box. I finally solved all the issues by searching for the youngest/last modified files, which usually are the logs. In fact within Prestashop directory, there are quite few which do have details.

find /apache/prestashop -type f -printf "%T@ %p\n" | sort -n | cut -d' ' -f -2 | tail -fn5;

In my case, they were mostly caused by php configurations (php.ini), dependencies and file permission.

If you face this type of issues,  you've better chances to fix it with direct SSH access and some control on Apache/PHP

Edited February 22, 2019 by a.ila (see edit history)

[Krysalidesign]

Hi,

Yes but here, I don't have access to the server, I mean, it's hosted by OVH and I don't have a lot of customization's option...

And usually it's supposed to work 😕

Edited February 22, 2019 by Krysalidesign (see edit history)

[Jagotic]

Try InnoDB Engine, and let us know what happens.

[Krysalidesign]

Hi all !

Thanks for the answers.

Just to let you know, I cleaned my server, removed everything and retry with Firefox. Then it worked.

I didn't change anything else so I supposed the server was overcharged and took to much time to answer.

[mohamedaitbella]

Hi i had the same problim but when i tried in private browser window everything goes will