cant install prestashop

[zili10]

Hi, I cant install prestashop, I don't know why, I have been trying for 28 days to install it but no success 

 

the error:

 

the values of auto increment increment and offset must be set to 1

 

 

[bellini13]

what database type and version are you using?  what database collation type is being used?

[Jignesh.aakoliya]

Hi,
 
try this sql query on your server's mysql, to force auto_increment andoffset to 1 :
SET auto_increment_increment=1;
and :

SET auto_increment_offset=1;

Thanks

[pevank]

See also ":

https://www.prestashop.com/forums/topic/577834-http-error-500-by-install-prestashop-17-and-also-by-16/

[SiliconAlchemy]

Hi, I cant install prestashop, I don't know why, I have been trying for 28 days to install it but no success 

 

the error:

 

the values of auto increment increment and offset must be set to 1

 

 

 

https://www.prestashop.com/forums/topic/553541-auto-increment-and-offset-error-on-installing-prestashop/?do=findComment&comment=2474807

 

@pevank this has nothing to do with your problem

[benwiggy]

I'm also seeing this error on installation. Clear guidance is needed from Prestashop on this problem. Otherwise, I can't use it.

[SiliconAlchemy]

@benwiggy See here:

https://www.prestashop.com/forums/topic/553541-auto-increment-and-offset-error-on-installing-prestashop/#comment-2474807

 

I gave up and moved to a proper ecommerce solution - Magento.  If you can't install PrestaShop on a replicated mysql database, it immediately removes itself from consideration by anyone who cares about their customer's data.

[benwiggy]

Thanks. I've been using earlier versions of Prestashop for some time. I really need something that's free to use, as my margins are almost non-existent. I could continue with 1.6 for a while, but it's not secure http and doesn't do GPDR compliance.

[bellini13]

38 minutes ago, benwiggy said:

I could continue with 1.6 for a while, but it's not secure http and doesn't do GPDR compliance.

you can install an SSL certificate on your server and then enable SSL in the Prestashop back office.  Prestashop is not responsible for purchasing and installing an SSL certificate on your server, you are.

PS v1.6 does support GPDR, you need to install a module and there are a few options for that

[benwiggy]

7 hours ago, bellini13 said:

you can install an SSL certificate on your server and then enable SSL in the Prestashop back office. 

I've tried that, but it doesn't work. The rest of my site is fine: only the Prestashop page.

[bellini13]

well what exactly have you tried?  and what exactly doesn't work

[benwiggy]

I've turned it on in the back office, but it doesn't work. It remains http, even when explicitly sent as https. As said, the rest of my site works fine.

This is just one of many issues with Prestashop that render it unsatisfactory, like having to modify tpl files outside the theme to adjust the style, which of course gets overwritten if updated. (But we're already digressing from the main issue of not being able to install 1.7 at all.)

[bellini13]

well you were complaining about a specific issue with Prestashop that I know for a fact works, so figured I would try to assist you.  But since you appear to just want to complain and not actually attempt to fix anything, I'll carry on.

[benwiggy]

Yes, I would like it fixed, but I didn't want to get this thread too far off-topic. I'll start another thread.