SQL error on query All part

[ghamdikar]

hello there,
I got this error every time

SQL error on query All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

[sumitwebkul]

Hello,
It seems this issue is related to MySQL version you are using on your server. We recommend you to install version like MySQL 5.5 on your server and try to install the QloApps again. If you will still face issues then please raise a ticket at https://webkul.uvdesk.com/. We will resolve your issue there.
Thanks

[abispo]

This problem occurs in MySQL 5.7 too.

[sumitwebkul]

Hello,
Yes it the issue in MySQL 5.7 . So we recommend you to install MySql version like MySQL 5.5 or 5.6 on your server and try to install the QloApps again.
If you will still face issues then please raise a ticket at https://webkul.uvdesk.com/. We will resolve your issue there.
Thanks

[happiguru]

Sir, downgrade is not possible since i am using a shared server.
My service provider said they cannot downgrade from MYSQL 5.7 to 5.5 or 5.6 because i am on a shared server.
Is there any other solution we can make on the sql file?

[happiguru]

Thanks for your assistance, it was helpful though it did not solve my problem.

My problem here is that, my host service provider refused to downgrade from MYSQL 5.7 to 5.5 reason being that, i am using using a shared hosting server.

Is there any means or any change we can make on the software or database file so that it can be compartible with MYSQL 5.7?

Thanks in advance.

[sumitwebkul]

We request you to please extract the attached zip and replace the file (db_structure.sql) with the file at below path -
hotelcommerce/install/data/db_structure.sql
After replacing the file try to install QloApps Again.
qlo_db_sql.zip