Hi @Ananth,
You don't have to find the query you just need to run the given SQL in your database to fix the issue. You can do this by your own or you can ask from you host provider to execute this query on your database.
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;
But make sure to replace 'prefix' in the SQL query with your table prefix so that SQL query can run correctly. Whenever the QloApps installed you have to mention the Table prefix at the time of installation.
To find your table prefix, follow these steps:
Navigate to the "Advanced Parameters -> Configuration Information" Tab. Refer to the screenshot
Obtain the table prefix from the Configuration Information page. Refer to the screenshot
Once you've completed the above step, then merge the following PR: https://github.com/Qloapps/QloApps/pull/729