Installation problem
-
SQL-Error in Query All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
As far as I know is this error,only if mysql is 5.7 or higher
Do I have to replace all PRIMARY KEY text into UNIQUE in all files?
or change defining o not null?I wonder if this script is outdated?
I use hotelcommerce 1.3.2Found the solution here:
https://www.prestasoo.com/blog/fixing-the-sql-error-on-prestashop-installation.htmlYes, Version 1.3.2 is outdated and needs this fix.
-
Hello @Sheik
I have already mentioned this error and its solution in one of the topic.
Please follow this link to get the solution: https://forums.qloapps.com/topic/8/error-during-installation-all-parts-of-a-primary-key-must-be-not-null-if-you-need-null-in-a-key-use-unique-instead-error-sql-has-happened