Hi, iām using
āsugar_versionā => ā6.5.25ā,
āsuitecrm_versionā => ā7.10.7ā,
and i have a problrm with the map module. Iāve inserted a working api key, indeed if i test the request, it works fine, but when i try to put some account on the map, it shows me āthis page doesnāt load google mapsā and nothing works.
Tue Aug 27 16:31:29 2019 [7648][1][FATAL] Query Failed: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , N'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , N'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , N'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.date_willexecute = -1 OR reminders.date_willexecute BETWEEN CONVERT(datetime,N'2019-08-27 16:31:29',120) AND CONVERT(datetime,N'2019-08-28 17:31:29',120))) AND reminders.deleted=0::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Arithmetic overflow error converting expression to data type datetime.
I am not a SQLServer expert, but the problem seems to be quite similar to this one