QloApps Forums
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Installation problem

    Bug Report
    installation problem
    2
    2
    632
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S
      Sheik last edited by Sheik

      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.2

      Found the solution here:
      https://www.prestasoo.com/blog/fixing-the-sql-error-on-prestashop-installation.html

      Yes, Version 1.3.2 is outdated and needs this fix.

      1 Reply Last reply Reply Quote 0
      • Faiz
        Faiz last edited by

        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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post