PrestaShop 1.7.2.4 installation – SQL syntax problem at 13% with `gender`

[Tschüssy Klamotten]

Dear community,

thank you very much for your help in advance. There is not a single PrestaShop installation that goes without fixing at least 5 problems within the installation files – rewriting code, permissions, etc. 

PrestaShop version: 1.7.2.4

Installation process stops at: 13%

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF NOT EXISTS `kh_gender` ( `id_gender` int(11) NOT NULL AUTO_INCREMENT, `ty' at line 1

 

What am I exactly supposed to do: what change in what file? 

Your help is very much appreciated,

Victoria

Edited November 3, 2017 by Tschüssy Klamotten (see edit history)

[tuk66]

It looks like your MariaDB server doesn't like 'IF NOT EXISTS'. Try to edit the /install/data/db_structure.sql file and remove all 'IF NOT EXISTS' occurrences.