MySql Install problem: The values of auto_increment increment and offset must be set to 1

[Mulflar]

Well, as the topic says I'm getting this error on installing a new prestashop

"The values of auto_increment increment and offset must be set to 1"

It seems a weird error because as I understand this is an error it can be in tables, not in a clean schema

Any help?

[ziostanko]

hi

 

i'm trying to set up prestashop working with a master master mysql replica environment and i get this error during installation too...

 

anybody can help?

 

thanks

zio

[ziostanko]

retried setting up a galera cluster with a load balancer on azure but still getting same error...

 

is there a way to workaround it?

 

thx zio

[GhosToM]

Hi,

 

try this sql query, to force auto_increment and offset to 1 :

SET [spam-filter]auto_increment_increment=1;

and :

SET [spam-filter]auto_increment_offset=1;

Bye

[babem]

Can anybody help us? My install problem same one, but if I install to localhost then no problem.