Trevallion1776

After upgrading from WHMCS 6.3.2 to WHMCS 7.10.3, I am getting a SQL error every 5 minutes (from cron running). The cron running every 5 minutes is causing the following error to be logged. The status field is empty: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND lastreply > '2020-12-08 09:40:04' AND lastreply <= '2020-12-08 09:45:05'' at line 1 - Full Query: SELECT * FROM tbltickets WHERE merged_ticket_id = 0 AND did IN (1) AND status IN () AND lastreply > '2020-12-08 09:40:04' AND lastreply <= '2020-12-08 09:45:05' Any idea on how to fix issue?

After upgrading from 6.3.2 to 7.10.3, I am getting a SQL error every 5 minutes from the cron. The status expression AND status IN () is empty. SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND lastreply > '2020-12-08 09:05:05' AND lastreply <= '2020-12-08 09:10:04'' at line 1 - Full Query: SELECT * FROM tbltickets WHERE merged_ticket_id = 0 AND did IN (1) AND status IN () AND lastreply > '2020-12-08 09:05:05' AND lastreply <= '2020-12-08 09:10:04' Any idea how to fix?

I recently switch our application to use AutoAuth in WHMCS, and the application is not working quite right when the user changes their password. When a user changes their password using clientarea.php?action=changepw, it changes their password, but then the user is logged out of WHMCS when the clientarea.php?action=changepw&success=1 is called. Because the user is logged out of WHMCS, they are presented with a login page for WHMCS. Is this by design? Is there something else that needs to be done when the user changes their password so that the WHMCS session is preserved?