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 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#520 - google calendar sync strange

Closed General Question created by stuart 8 years ago

I am having some strange issues.

Some users can sync perfectly, where others can only sync from google to sugar ( not all ). But not from sugar to google. All settings are correct etc so not sure what is going on. I have checked the logs, and under a user that is not working, it shows syncing with google but doesnt have a successful message afterwards like the others.

We have a huge amount of users we need to buy licenses from as your product is great when it works, but we really need help with this to make sure this will work properly. Any ideas?

  1. stuart member avatar

    stuart

    8 years ago

    we are in australia. So i have set dates in Australian dd/mm/y they are also setup exactly the same on the sugarcrm end as Australian.

    However i noticed on the account where it is not working with sync, i have the following in the sugarcrm log: ( im wondering if the SQL error is actually due to something in their calander meeting title that has a ' or " in it that the server rejects ( security to stop injections? )

    Mon Apr 14 08:56:04 2014 [26024][1][FATAL] STARTED: Calendar sync: lloyd(lloyd@googleappsdomainhere-i-have-hidden-this-domain-from-log.com.au) Mon Apr 14 08:56:04 2014 [26024][1][FATAL] GOOGLE-TO-SUGAR Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-17 02:00:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Jim - Test/Social/Computing with id 8e71f6be-ab10-7429-0d1a-534b6976fb74 saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-15 00:00:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Ben - House/Computer - CONFIRMED with id f3f04d01-7df3-819b-d70c-534b4afb3603 saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-24 01:00:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Deb - Pest/Book with id bae20a72-dd79-835c-e436-534b48b58e3f saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-15 05:00:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Rajkumar - Book - CONFIRMED with id 9fdd2654-10de-9977-7977-534b3f36f0f3 saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-15 07:00:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Luigi - Various/RMF/SMF - CONFIRMED with id 1998b500-07d6-0113-4cab-534b3b0fbfc1 saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-17 08:30:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Ninos - Pest with id eb8bb4c8-4a8b-5d32-0cbc-534b385826ac saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-16 20:30:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Flight to Melb with id 94a03e74-be62-d1ed-1ddf-534b211999e9 saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-11 08:30:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Con - Car - NO SHOW - spoke with him, couldn't mak with id af5929fe-2138-efda-38e6-534b2179498f saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-12 01:30:00 for format d/m/Y h:ia Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting: Raz - Various NO SHOW - no answer with id 12e87d04-8167-e21c-d9f7-534b21d3515b saved in SugarCRM. Mon Apr 14 08:56:06 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-21 22:45:00 for format d/m/Y h:ia Mon Apr 14 08:56:07 2014 [26024][1][FATAL] Meeting: Do not book - must renew my license with id 9963303a-cdf6-8575-afa7-534b211f155b saved in SugarCRM. Mon Apr 14 08:56:07 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-11 06:30:00 for format d/m/Y h:ia Mon Apr 14 08:56:07 2014 [26024][1][FATAL] Meeting: Jerry - House - Calling me back to reschedule with id 77f5dab3-c69a-6fce-a757-534b210c9343 saved in SugarCRM. Mon Apr 14 08:56:07 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-17 00:00:00 for format d/m/Y h:ia Mon Apr 14 08:56:07 2014 [26024][1][FATAL] Meeting: Kulwinder - Test/Property with id b72ad586-4fa8-3e14-d259-534b2135e255 saved in SugarCRM. Mon Apr 14 08:56:07 2014 [26024][1][FATAL] Meeting::save: Bad date 2014-04-14 01:30:00 for format d/m/Y h:ia Mon Apr 14 08:56:07 2014 [26024][1][FATAL] Meeting: Scott - Lawn with id ce8c075f-043e-fba2-6079-534b211e755c saved in SugarCRM. Mon Apr 14 08:56:07 2014 [26024][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,allday,is_gevent,gevent_id) VALUES ('7c679fb3-0a22-578b-67f0-534b6a8be8b4','Ibis syd booked','2014-04-14 04:56:02','2014-04-14 04:56:02','4c1c0448-f5c3-264b-e4f1-5342153a691e','4c1c0448-f5c3-264b-e4f1-5342153a691e','',0,'','1','211012ac-c9df-f16c-9cde-53475cc09899','','','','','',,'30','2014-04-14 22:00:00','2014-04-14 22:30:00','Planned','Sugar',600,-1,0,0,1,0,1,'http://www.google.com/calendar/feeds/default/private/full/ik8dnrls3f9rrlmmpu47jdberk')::: 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-04-14 22:00:00','2014-04-14 22:30:00','Planned','Sugar',600,-1,0,0,1,' at line 2 Mon Apr 14 08:56:07 2014 [26024][1][FATAL] Job 907eb29d-ea2f-979c-3a33-534b6ab3297f (Gsync) failed in CRON ru

  2. stuart member avatar

    stuart

    8 years ago

    also i have run the "quick repair" in sugar admin area.

    Seems to be a possible bug in the sync script?

  3. stuart member avatar

    stuart

    8 years ago

    i think i fixed it, i went through and changed EVERYONES calendar events that existed before we hooked up sugarcrm. Took out any @ symbols, aphostraphys etc. Then wallah, all users started syncing.

  4. rolustech member avatar

    Rolustech Provider Affiliate

    8 years ago

    Hi,

    Thanks for reporting issue related special characters in meetings subject. Although we have catered special characters issues in most cases and we will also look for meetings module.

    Thanks, Support

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Been trying to get this to work for two weeks. Very little support. I hope it works but to this day, it does not." - meyerwells

    Read More Reviews