by Rolustech

Become more efficient! Enter everything just once. Automatically sync Emails, Calendars, Contacts, and Documents between Google Apps and Sugar. Get your Gmail, Contacts, Calendar items and Documents automatically synced instantly with this seamless integration.

Free Trial

By clicking you consent to share your profile with the developer

#781 - Sync fails due to SQL syntax error. Happens all the time

Closed Bug? created by elgoots 7 years ago

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 ?


  1. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Hi,

    I just got the log you shared now. I will get back to you after my investigation.

    Thanks, Rolustech Support

  2. rolustech member avatar

    Rolustech Provider Affiliate

    7 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

  3. elgoots member avatar

    elgoots

    7 years ago

    Just emailed then. Thank you. Hopefully you got it?

  4. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Hi,

    I haven't received any email yet.

    Regards

  5. elgoots member avatar

    elgoots

    7 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

  6. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Hi,

    We are investigating and will get back to you soon.

    Thanks!

  7. rolustech member avatar

    Rolustech Provider Affiliate

    7 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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating