@Ananthlingam In order to fix your issue regarding
the PR kindly follow the steps given below :
1) Run the provided sql query on your database.
Please ensure to replace "prefix_" with the table prefix you set during the QloApps installation.
To find your table prefix, follow these steps:
Navigate to the "Advanced Parameters -> Configuration Information" Tab. Refer to the screenshot [https://tinyurl.com/537w7ft5]
Obtain the table prefix from the Configuration Information page. Refer to the screenshot [https://tinyurl.com/ymvte45m]
Replace "prefix_" with your actual table prefix in the query provided below.
SQL query :
INSERT INTO `prefix_htl_access` (`id_profile`, `id_hotel`, `access`)
SELECT p.`id_profile`, h.`id` AS `id_hotel`, CASE WHEN p.`id_profile` = 1 THEN 1 ELSE 0 END AS `access`
FROM `prefix_profile` p
CROSS JOIN `prefix_htl_branch_info` h
LEFT JOIN `prefix_htl_access` ha ON (p.`id_profile` = ha.`id_profile` AND h.`id` = ha.`id_hotel`)
WHERE ha.`id_profile` IS NULL;
2) Once you've completed the above step, then merge the following PR:
PR link : https://github.com/Qloapps/QloApps/pull/729