On 2/13/2019 at 11:56 PM, jlit said:I just tried to install prestashop and got the same error. On my hosts DB, auto increment is set to 2. My hosting company advised this should not be changed. It looks like prestashop has indeed be hard coded to only work with auto increment of 1, which I have never seen in 30 years of database development. If their DB code is this bad, to only work with very basic mysql installs, its not something I would want to use in production. I also frequently use galera cluster in larger installations. Looks like I need to find a different e-commerce provider. I am surprised that the e-commerce platform comparison/review sites don't mention this major show stopping limitation.
I am also surprised that noone from prestashop has jumped in with guidance.
yes I just landed on the same problem. My god.
Solution 1):
1) Goto: src/PrestaShopBundle/Install
2) Open Database.php
3) Escape line 81,81 and 83;
Solution 2): When using MariaDB Galera in Cluster setup. Like MultiMaster of MasterSlave settings.
!!! *** Do this only on 1 of the nodes *** !!!
1) Edit /etc/my.cnf.d/server.cnf
2) Add or edit:
wsrep_auto_increment_control=OFF
auto_increment_increment=1
auto_increment_offset=1
3) Install Prestashop
4) When finished remove the settings