-
Display Namestuart
-
Member SinceApril 04, 2014
-
Last SeenFebruary 04, 2016
stuart does not have any add-ons for sale.
-
Support April 14, 2014 @ 05:56 am
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.
View Comment
-
Support April 14, 2014 @ 05:28 am
also i have run the "quick repair" in sugar admin area.
Seems to be a possible bug in the sync script?
View Comment
-
Support April 14, 2014 @ 05:06 am
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
View Comment
stuart has not rated any add-ons.
stuart has not verified any add-ons.
stuart has not created any Wanted Add-ons.