@Ananthlingam In order to fix your issue regarding
the PR kindly follow the steps given below :
Please ensure to replace "prefix_" with the table prefix you set during the QloApps installation. To find your table prefix, follow these steps:
i) Navigate to the "Advanced Parameters -> Configuration Information" Tab. Refer to the screenshot [https://tinyurl.com/537w7ft5]
ii) Obtain the table prefix from the Configuration Information page. Refer to the screenshot [https://tinyurl.com/ymvte45m]
iii) 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; Once you've completed these steps, please merge the following PR: