this page doesn't load google maps

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.

Any idea?

Thanks all

Hi Gianluca!

Can you post the SuiteCRM log when you perform that request?
Please set up the log in debug mode like this:


$sugar_config['logger']['level'] = 'debug';

cleaned the log, put debug mode and selected 4 account and clicked on maps. here the log

There is some FATAL errors:


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

I would open a issue en SuiteCRM github

Sadly that bug is in all the suitecrm version, and it isnā€™t the cause of the map problem.

Hi,

Can you provide a PHP log?
A console error would be useful tool.