[FATAL] Query Failed

💬 General Discussion
1

My suiteCRM keeps crashing out. I’ve checked the sugarcrm.log file and it appears to repeatedly have this error:

[8677][1][FATAL] Query Failed: SELECT alert.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod FROM alert LEFT JOIN users jt0 ON alert.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON alert.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON alert.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (alerts.assigned_user_id = ‘1’ AND is_read != ‘1’) AND alert.deleted=0: MySQL error 1054: Unknown column ‘alerts.assigned_user_id’ in ‘where clause’

Can someone help me?

2

Hello,
Firs make a quick repair rebuild and see on the bottom if you dont need to run a SQL query to synchronise database with vardefs

strange, your module name is ‘alert’ and error occur with ‘alertS’.

Try to find where in (all) file you can find ‘alerts’.

Regards

3

Alerts folder and files found in Modules folder, but i can’t find why… Now I’m getting error on main pages:

Catchable fatal error: Argument 1 passed to Reminder::isDecline() must be an instance of SugarBean, boolean given, called in /home/itisnika/domains/itisnikas.lt/public_html/modules/Reminders/Reminder.php on line 299 and defined in /home/itisnika/domains/itisnikas.lt/public_html/modules/Reminders/Reminder.php on line 374

But my knowledge not so big to solve it :frowning:

4

and log shows:

Wed Jan 6 23:47:53 2016 [2816][1][FATAL] Query Failed:
SELECT * FROM calls_users
WHERE
= ‘3dc6b43a-7b8e-c6b6-bbfe-566fcebccc6a’ AND
user_id = ‘1’ AND
deleted = 0
: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘= ‘3dc6b43a-7b8e-c6b6-bbfe-566fcebccc6a’ AND
user_id = ‘1’ AND
deleted =’ at line 3
Wed Jan 6 23:47:53 2016 [2816][1][FATAL] Query Failed:
SELECT * FROM calls_users
WHERE
= ‘244c4c73-b7d5-2b0d-6f4d-560a982f51f7’ AND
user_id = ‘1’ AND
deleted = 0
: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘= ‘244c4c73-b7d5-2b0d-6f4d-560a982f51f7’ AND
user_id = ‘1’ AND
deleted =’ at line 3