Since upgrade to 7.4 getting following querry failed

📦 Install & Upgrade Help
1

Fri Oct 30 23:25:59 2015 [410217][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘assuredf_scrm.favorites’ doesn’t exist
Fri Oct 30 23:26:23 2015 [412587][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘assuredf_scrm.favorites’ doesn’t exist
Fri Oct 30 23:26:37 2015 [413596][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘assuredf_scrm.favorites’ doesn’t exist
Fri Oct 30 23:28:58 2015 [431506][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Fri Oct 30 23:35:48 2015 [472670][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Fri Oct 30 23:51:07 2015 [490282][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 00:36:33 2015 [576932][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 00:47:34 2015 [593157][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 01:03:56 2015 [632982][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 01:14:00 2015 [647372][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 01:15:58 2015 [661024][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 13:46:12 2015 [1009784][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 14:21:01 2015 [108561][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 14:21:07 2015 [109671][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 14:21:12 2015 [110095][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 14:21:15 2015 [110297][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1
Sat Oct 31 14:32:37 2015 [143284][1][FATAL] Query Failed: SELECT count(DISTINCT .id) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((calls.status IN (‘Planned’)
)) AND calls.deleted=0 AND (calls.assigned_user_id = ‘1’ OR (c_u.user_id = ‘1’ AND c_u.deleted = 0 )) : MySQL error 1064: 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 ‘) c FROM calls LEFT JOIN calls_users c_u on c_u.call_id = calls.id where ((c’ at line 1

2

try going to admin -> repair and doing a quick repair and rebuild and execute any changes required to the db

3

Yes, I did that but still showing. I will keep monitoring to see if any new errors are reported on the log.

4

are you running a report or do you have any workflows running?

5

No reports or workflows. Scheduler looks like it is running fine.

6

The query failing for Calls appear to be a bug in 7.4, I have logged the issue here where you can follow progress

Thanks for highlighting this issue