Trevallion1776 Posted December 8, 2020 Share Posted December 8, 2020 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? 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.