Hi People! Please help my.
Suitecrm 7.5.1 version
Show this error:
Database failure. Please refer to suitecrm.log for details.
suitecrm.log show this:
Sat Mar 5 09:00:40 2016 [512758][1][FATAL] Query Failed: SELECT reminders.* , 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 reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 where (reminders.popup = 1) AND reminders.deleted=0: MySQL error 1267: Illegal mix of collations (utf8_spanish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
Sat Mar 5 09:00:40 2016 [512758][1][FATAL] Query Failed: SELECT reminders.* , 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 reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 where (reminders.related_event_module = ‘Meetings’ AND reminders.related_event_module_id = ‘’) AND reminders.deleted=0: MySQL error 1267: Illegal mix of collations (utf8_spanish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
Sat Mar 5 09:00:40 2016 [512758][1][FATAL] Query Failed: SELECT reminders.* , 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 reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 where (reminders.related_event_module = ‘Meetings’ AND reminders.related_event_module_id = ‘’) AND reminders.deleted=0: MySQL error 1267: Illegal mix of collations (utf8_spanish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
Sat Mar 5 09:00:40 2016 [512758][1][FATAL] Error running count query for Opportunity List: Query Failed: ( SELECT count() c FROM meetings INNER JOIN opportunities meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0
AND meetings.parent_type = ‘Opportunities’
where ( meetings.parent_id=‘ee95a02b-b7b3-a8af-3a03-56da2e038a20’ AND (meetings.status !=‘Held’ AND meetings.status !=‘Not Held’)) AND meetings.deleted=0 ) UNION ALL ( SELECT count() c FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c INNER JOIN opportunities tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = ‘Opportunities’
where ( tasks.parent_id=‘ee95a02b-b7b3-a8af-3a03-56da2e038a20’ AND (tasks.status != ‘Completed’ AND tasks.status != ‘Deferred’)) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls INNER JOIN opportunities calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0
AND calls.parent_type = ‘Opportunities’
where ( calls.parent_id=‘ee95a02b-b7b3-a8af-3a03-56da2e038a20’ AND (calls.status != ‘Held’ AND calls.status != ‘Not Held’)) AND calls.deleted=0 ): MySQL error 1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_spanish_ci,IMPLICIT) for operation ‘=’