Boost your SugarCRM with seamless Google integration. Sync contacts, meetings, and Drive files. Streamline workflows and elevate productivity.
#781 - Sync fails due to SQL syntax error. Happens all the time
Cron job breaks and stops working until i delete the meeting in the logs that has caused a SQL syntanx. I have been emailing this for a while and no one has ever got back to me with a solution. I am having to manually fix this ALL the time.
Here are some examples:
1:
Mon Sep 15 01:20:04 2014 [24801][1][FATAL] Error inserting into table: meetings: Query Failed:INSERT INTO meetings (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,team_id,team_set_id,location,join_url,host_url,creator,external_id,duration_hours,duration_minutes,date_start,date_end,status,type,reminder_time,email_reminder_time,email_reminder_sent,sequence,repeat_interval,gevent_id,allday,is_gevent) VALUES ('5c48f771-7b72-259d-7943-54163eceff12',' Yogesh','2014-09-15 01:20:02','2014-09-15 01:20:02','e1dcd344-935b-9ff1-11aa-534211674c9d','e1dcd344-935b-9ff1-11aa-534211674c9d','Book sent prospectus call to make time 0430529',0,'','bb938470-869c-dd85-aa4b-533a95968b1a','61b58d3d-35d5-9cb6-2549-53588196fcd6','','','','','',,'30','2014-09-16 04:00:00','2014-09-16 04:30:00','Planned','Sugar',600,-1,0,0,1,'https://www.google.com/calendar/feeds/default/private/full/m9sng48r2tp411cb9rt',0,1)::: 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 ''30','2014-09-16 04:00:00','2014-09-16 04:30:00','Planned','Sugar',600,-1,0,0,1,' at line 2
Mon Sep 15 01:20:04 2014 [24801][1][FATAL] Job 4d41c0f3-9ffe-03ef-4004-54163ee71692 (gsync google cal2) failed in CRON run
2: Mon Sep 15 01:10:15 2014 [18987][1][FATAL] Error inserting into table: meetings: Query Failed:INSERT INTO meetings (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,team_id,team_set_id,location,join_url,host_url,creator,external_id,duration_hours,duration_minutes,date_start,date_end,status,type,reminder_time,email_reminder_time,email_reminder_sent,sequence,repeat_interval,gevent_id,allday,is_gevent) VALUES ('9c69670f-f2d6-7fee-db62-54163c897171',' Xu ye -Home','2014-09-15 01:10:02','2014-09-15 01:10:02','1','1','041298 \nThis guy seems a bit hows your father but its for his wife and he reckons she speaks good English,\nCall to set up meeting',0,'3c703926-b023-c59b-a869-536b00366ac3','bb938470-869c-dd85-aa4b-533a95968b1a','22ce87e5-4ad0-4b0c-5b0a-53782bd8fb36','','','','','',,'15','2014-09-15 00:30:00','2014-09-15 00:45:00','Planned','Sugar',60,-1,0,0,1,'https://www.google.com/calendar/feeds/default/private/full/8seielce2ulak8tg',0,1)::: 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 ''15','2014-09-15 00:30:00','2014-09-15 00:45:00','Planned','Sugar',60,-1,0,0,1,'' at line 2
Mon Sep 15 01:10:15 2014 [18987][1][FATAL] Job 2b01278d-d2ac-5764-67de-54163cdd4170 (gsync google cal2) failed in CRON run
It seems as though there are some basic sql errors here ?
sandraarango
10 years ago
Hi,
I just got the log you shared now. I will get back to you after my investigation.
Thanks, Rolustech Support
10 years ago
Hi,
Can you please let us know which version of SugarCRM you are using? Also this query generated by SugarCRM code so we need access in order to investigate the issue. As per the log it looks like Duration field is not properly interpreting the the query. You can share credentials privately on support@rolustech.com
Thanks! Rolustech Support
10 years ago
Just emailed then. Thank you. Hopefully you got it?
10 years ago
Hi,
I haven't received any email yet.
Regards
10 years ago
Ok i resent using my gmail account incase there was an issue with my mail server and junk mail or something. it has subject of: Support case #781
10 years ago
Hi,
We are investigating and will get back to you soon.
Thanks!
10 years ago
Hi Stau Ree,
As per our converstaion on email, your issue is resolved and now meetings are being properly setup, so I am closing this case.
You can contact us in case further help required.
Cheers..! Rolustech Support