search

Qloapps / QloApps

QloApps is a Free and Open-source hotel management and reservation system to take a hotel business online. QloApps offers a Property Management System (PMS), a Booking Engine, and an attractive Hotel Website. Elevate hotel operations with QloApps to streamline processes and provide an enhanced experience for both hoteliers and guests.
https://qloapps.com
Open Software License 3.0
4.5k stars 483 forks source link

SQL error on query All part #14

Open ghamdikar opened 7 years ago

ghamdikar commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

This problem occurs in MySQL 5.7 too.

sumitwebkul commented 7 years ago

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 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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