
-
Display NameKwek Jian Wen
-
Member SinceJanuary 17th, 2015
-
Last SeenMay 12th, 2022
Kwek Jian Wen does not have any add-ons for sale.
-
Support October 25th, 2018 @ 7:54 am
Hi Jon,
Problem solved. Thanks for following up!
Jessica
View Comment
-
Support October 25th, 2018 @ 7:52 am
Hi Jon,
Thanks for taking of this issue. It is solved. You may close this topic.
Jessica
View Comment
-
Support September 27th, 2018 @ 8:38 am
Hi Jon,
Sure. I think one of the support (heigine.rosal@izeno.com) has written to you. Thank you!
Jessica
View Comment
-
-
Support September 25th, 2018 @ 1:30 am
Hi Jon,
No problem.
Thank you very much. I have already spoken to my support, however they would like to connect with you. May I know if there is an email ID or contact that I can pass it to them to connect you? Thanks.
Jessica
View Comment
-
Support September 21st, 2018 @ 1:48 am
Hi Jon,
Thank you for fixing the SugarChimp issues for me. As discussed, would you mind to send me a brief of the issues that I am facing from deleting my target lists? Thus it would be easier for my person in charge to rectify and fix the issues.
Thank you.
View Comment
-
Support September 18th, 2018 @ 12:32 am
Hi Jon,
I won't be around starting from 1pm (Singapore time) today. Let's do it on Wednesday 11am (Singapore time, Sep 19). Thank you.
View Comment
-
Support September 17th, 2018 @ 12:39 am
Hi Jon,
Meeting scheduled at 11:00am - Tuesday, September 18, 2018 (China, Singapore, Perth time). Let me know If I need to prepare anything.
View Comment
-
Support September 14th, 2018 @ 2:54 am
Hi Jon,
I've tried so many times. The Field Mapping page just acting weird, only leading me to health status page. Is there a way you can reset it? I am pretty sure the application of the latest version of SugarChimp has screwed up.
View Comment
-
Support September 7th, 2018 @ 12:34 am
Hi Jon,
Thanks for your prompt response. It's fixed!
View Comment
-
Support June 24th, 2016 @ 8:47 am
This is strange. I have ever used Account syncing during the very first time when I started using it besides Contact, Target and Lead. But recently I only realized there isn't account syncing option anymore. Has it been taken out again? Why?
View Comment
-
Support February 12th, 2015 @ 3:56 pm
In a nutshell, can I say the above mentioned is simply more convenient to generate report within Sugar?
If that is the case, we shall downgrade to Basic.
Thanks a lot for your assistance.
View Comment
-
Support February 12th, 2015 @ 1:11 am
Hi SugarChimp,
**I removed the activity hence the cron can continue to run. It does not solve the fundamental problem. Therefore, you need to help me understand the queries below so I can decide whether to continue professional version. **
_The cron run failed seems to only occur to MailChimp Activity to SugarChimp. The export and import of contact list seems to be working fine.
MailChimp Activity to SugarChimp is a feature for professional version right?
Is that belong to one of these two feature Activity Data Pushed to Sugar and Report on Campaign Activity in Professional version?
What about See Campaign Activity? What are the actual functions for these three features (Activity Data Pushed to Sugar, Report on Campaign Activity and See Campaign Activity)
If only these features are causing issues but not arising from synchronizing the contact details, then we shall consider to use Basic if the features were not really essential to us._
Regards, Ian
View Comment
-
Support February 11th, 2015 @ 1:56 am
I just removed the SugarChimp activity that I created to test after reinstallation, the queue issue is no longer appear in SugarChimp scheduler log.
View Comment
-
Support February 11th, 2015 @ 1:49 am
Hi SugarChimp,
The cron run failed seems to only occur to MailChimp Activity to SugarChimp. The export and import of contact list seems to be working fine.
MailChimp Activity to SugarChimp is a feature for professional version right?
Is that belong to one of these two feature Activity Data Pushed to Sugar and Report on Campaign Activity in Professional version?
What about See Campaign Activity? What are the actual functions for these three features (Activity Data Pushed to Sugar, Report on Campaign Activity and See Campaign Activity)
If only these features are causing issues but not arising from synchronizing the contact details, then we shall consider to use Basic if the features were not really essential to us.
Regards, Ian
View Comment
-
Support February 11th, 2015 @ 1:39 am
Hi SugarChimp,
This is appeared in the debug "failed in cron run" for MailChimp activity to SugarChimp.
Wed Feb 11 09:10:11 2015 [30077][1][FATAL] Job 90f8883e-085c-cf8c-4ea3-54d9025b7f29 (MailChimp to SugarCRM Activity Job - Initial Campaign Activity Import ) failed in CRON run Wed Feb 11 09:10:11 2015 [30077][1][INFO] Resolving job 90f8883e-085c-cf8c-4ea3-54d9025b7f29 as failure: Unexpected failure, please check PHP logs and sugarcrm.log Wed Feb 11 09:10:11 2015 [30077][1][INFO] Will retry job 90f8883e-085c-cf8c-4ea3-54d9025b7f29 at 2015-02-11 01:10:36 (25) Wed Feb 11 09:10:11 2015 [30077][1][DEBUG] Hook called: SchedulersJobs::job_failure_retry Wed Feb 11 09:10:11 2015 [30077][1][DEBUG] Hook called: SchedulersJobs::before_save Wed Feb 11 09:10:11 2015 [30077][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated Wed Feb 11 09:10:11 2015 [30077][1][INFO] Query:UPDATE job_queue SET assigned_user_id='1',name='MailChimp to SugarCRM Activity Job - Initial Campaign Activity Import ',date_modified='2015-02-11 01:10:06',scheduler_id='',execute_time='2015-02-11 01:10:36',status='queued',resolution='failure',message='Forced failure on timeout\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\nUnexpected failure, please check PHP logs and sugarcrm.log\n',target='class::MailChimpToSugarCRMActivity',data='YTo0OntzOjIxOiJtYWlsY2hpbXBfY2FtcGFpZ25faWQiO3M6MTA6IjA1MmIzOTgxMDQiO3M6MTc6Im1haWxjaGltcF9saXN0X2lkIjtzOjEwOiJiMzk3NDYyZjFkIjtzOjEzOiJpbmNsdWRlX2VtcHR5IjtiOjA7czo1OiJzaW5jZSI7YjowO30=',requeue=1,retry_count=25,failure_count=75,job_delay=30,client='CRON1c5d072676309395bd010d69d45b82c7:30077',percent_complete=NULL WHERE job_queue.id = '90f8883e-085c-cf8c-4ea3-54d9025b7f29' AND deleted=0 Wed Feb 11 09:10:11 2015 [30077][1][INFO] Query Execution Time:0.0098340511322021
View Comment
-
Support February 10th, 2015 @ 3:13 am
Hi Jason,
I thought it would be helpful for you if I include this debug for you to see what is going on after the re-installation.
Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: Instantiate SugarChimp_Scheduler Driver SugarChimp_Scheduler_MailchimpActivityToSugarCRM Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver::start Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver->start_timer timer started at 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver->start_timer elapsed time is empty Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver::start License is good. Run it! Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Original Start time 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Current time 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Time since last check 0 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Elapsed time 0 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Time used 0 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_MailchimpActivityToSugarCRM->run Running... Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Original Start time 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Current time 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Time since last check 0 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Elapsed time 0 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Time used 0 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT mailchimp_list_id FROM sugarchimp_mc_activity ORDER BY date_entered ASC Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_MailchimpToSugar->get_next_mailchimp_list_id get oldest job: SELECT mailchimp_list_id FROM sugarchimp_mc_activity ORDER BY date_entered ASC LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT mailchimp_list_id FROM sugarchimp_mc_activity ORDER BY date_entered ASC LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.011916160583496 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_MailchimpToSugar->get_next_mailchimp_list_id There are no jobs to be processed for the list. Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Original Start time 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Current time 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Time since last check 0 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Elapsed time 0 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Time used 0 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT COUNT(id) AS pending_count FROM job_queue WHERE target = 'class::MailChimpToSugarCRMActivity' AND status = 'queued' Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.01948618888855 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Activity::is_activity_import_job_queued: there is no job pending Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_MailchimpActivityToSugarCRM->run: queue up the next import activity job Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_MailchimpActivityToSugarCRM->run: sql to get next job to queue: SELECT mailchimp_campaign_id, mailchimp_list_id, initial_sync, last_sync FROM sugarchimp_activity_tracker WHERE DATE_ADD(start_date, INTERVAL 30 DAY) > '2015-02-10 02:45:05' AND (last_sync IS NULL OR DATE_ADD(last_sync, INTERVAL 1 DAY) < '2015-02-10 02:45:05') ORDER BY last_sync ASC, start_date DESC LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT mailchimp_campaign_id, mailchimp_list_id, initial_sync, last_sync FROM sugarchimp_activity_tracker WHERE DATE_ADD(start_date, INTERVAL 30 DAY) > '2015-02-10 02:45:05' AND (last_sync IS NULL OR DATE_ADD(last_sync, INTERVAL 1 DAY) < '2015-02-10 02:45:05') ORDER BY last_sync ASC, start_date DESC LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0030720233917236 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_MailchimpActivityToSugarCRM->run: activity tracker, there are no MailChimp Campaigns on the account yet, nothing needs syncing Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver::end Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver::end The scheduler ran successfully Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Original Start time 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Current time 1423536315 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver Time since last check 0 Tue Feb 10 10:45:15 2015 [7048][1][FATAL] SugarChimp:debug:1423536315: SugarChimp_Scheduler_Driver::end final result: Array ( [status] => success [message] => All activities are processed from Mailchimp to sync to SugarCRM. [elapsed_time] => 0 )
Tue Feb 10 10:45:15 2015 [7048][1][INFO] Resolving job b613244b-cbc9-5aa7-9c15-54d970b07450 as success: Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: SchedulersJobs::before_save Tue Feb 10 10:45:15 2015 [7048][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:UPDATE job_queue SET assigned_user_id='1',name='SugarChimp',date_modified='2015-02-10 02:45:05',scheduler_id='97797b90-befb-54d6-7b37-54d95d89d44f',execute_time='2015-02-10 02:45:00',status='done',resolution='success',message=NULL,target='function::SugarChimp',data=NULL,requeue=0,retry_count=NULL,failure_count=NULL,job_delay=0,client='CRON1c5d072676309395bd010d69d45b82c7:7048',percent_complete=NULL WHERE job_queue.id = 'b613244b-cbc9-5aa7-9c15-54d970b07450' AND deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0048129558563232 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Updating records related to SchedulersJobs b613244b-cbc9-5aa7-9c15-54d970b07450 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Retrieve Team: SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.00071907043457031 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: SchedulersJobs::after_save Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Creating new instance of hook class SugarSearchEngineQueueManager without parameters Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Adding the following bean to the populate queue- module: SchedulersJob , id: b613244b-cbc9-5aa7-9c15-54d970b07450 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:UPDATE schedulers SET last_run='2015-02-10 02:45:05' WHERE id='97797b90-befb-54d6-7b37-54d95d89d44f' Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.007634162902832 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Get One: |SELECT id FROM job_queue WHERE execute_time <= '2015-02-10 02:45:05' AND status = 'queued' ORDER BY date_entered ASC| Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT id FROM job_queue WHERE execute_time <= '2015-02-10 02:45:05' AND status = 'queued' ORDER BY date_entered ASC Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT id FROM job_queue WHERE execute_time <= '2015-02-10 02:45:05' AND status = 'queued' ORDER BY date_entered ASC LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0072269439697266 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: SchedulersJobs::before_retrieve Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Retrieve SchedulersJob : SELECT job_queue.* FROM job_queue WHERE job_queue.id = 'dfb2afc5-c97f-6e84-8e6e-54d970269d03' AND job_queue.deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT job_queue.* FROM job_queue WHERE job_queue.id = 'dfb2afc5-c97f-6e84-8e6e-54d970269d03' AND job_queue.deleted=0 Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT job_queue.* FROM job_queue WHERE job_queue.id = 'dfb2afc5-c97f-6e84-8e6e-54d970269d03' AND job_queue.deleted=0 LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0041060447692871 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: SchedulersJobs::after_retrieve Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:UPDATE job_queue SET status='running', date_modified='2015-02-10 02:45:05', client='CRON1c5d072676309395bd010d69d45b82c7:7048' WHERE id='dfb2afc5-c97f-6e84-8e6e-54d970269d03' AND status='queued' Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0049688816070557 Tue Feb 10 10:45:15 2015 [7048][1][DEPRECATED] Formatting correction: SchedulersJobs->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code Tue Feb 10 10:45:15 2015 [7048][1][DEPRECATED] Formatting correction: SchedulersJobs->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code Tue Feb 10 10:45:15 2015 [7048][1][DEPRECATED] Formatting correction: SchedulersJobs->execute_time had formatting automatically corrected. This will be removed in the future, please upgrade your external code Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: SchedulersJobs::before_save Tue Feb 10 10:45:15 2015 [7048][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:UPDATE job_queue SET assigned_user_id='1',name='Update tracker_sessions Table',date_modified='2015-02-10 02:45:05',scheduler_id='7177389e-52b0-3a5c-54a9-50da608e0b28',execute_time='2015-02-10 02:45:00',status='running',resolution='queued',message=NULL,target='function::updateTrackerSessions',data=NULL,requeue=0,retry_count=NULL,failure_count=NULL,job_delay=0,client='CRON1c5d072676309395bd010d69d45b82c7:7048',percent_complete=NULL WHERE job_queue.id = 'dfb2afc5-c97f-6e84-8e6e-54d970269d03' AND deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0073361396789551 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Updating records related to SchedulersJobs dfb2afc5-c97f-6e84-8e6e-54d970269d03 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Retrieve Team: SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0077838897705078 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: SchedulersJobs::after_save Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Creating new instance of hook class SugarSearchEngineQueueManager without parameters Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Adding the following bean to the populate queue- module: SchedulersJob , id: dfb2afc5-c97f-6e84-8e6e-54d970269d03 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: Users::before_retrieve Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Retrieve User : SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = '1' AND users.deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0023341178894043 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0023469924926758 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT team_id, teams.name, teams.name_2 FROM team_memberships rel RIGHT JOIN teams ON (rel.team_id = teams.id) WHERE rel.user_id = '1' AND rel.team_id = '1' Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0086460113525391 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: Teams::before_retrieve Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Retrieve Team : SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.011477947235107 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: Teams::after_retrieve Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: Teams::before_retrieve Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Retrieve Team : SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.00074410438537598 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: Teams::after_retrieve Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT id ,teams.name as team_name , teams.created_by owner FROM teams WHERE deleted=0 AND id='1' Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.001276969909668 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link). Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id WHERE ear.bean_module = 'Users' AND ear.bean_id = '1' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0045311450958252 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: Users::after_retrieve Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] ----->SchedulersJob calling function: updateTrackerSessions Tue Feb 10 10:45:15 2015 [7048][1][INFO] ----->Scheduler fired job of type updateTrackerSessions() Tue Feb 10 10:45:15 2015 [7048][1][INFO] ----->Scheduler is about to update tracker_sessions table by running the query UPDATE tracker_sessions set active = 0 where date_end < '2015-02-09 20:45:05' Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:UPDATE tracker_sessions set active = 0 where date_end < '2015-02-09 20:45:05' Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.014986038208008 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Resolving job dfb2afc5-c97f-6e84-8e6e-54d970269d03 as success: Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: SchedulersJobs::before_save Tue Feb 10 10:45:15 2015 [7048][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:UPDATE job_queue SET assigned_user_id='1',name='Update tracker_sessions Table',date_modified='2015-02-10 02:45:05',scheduler_id='7177389e-52b0-3a5c-54a9-50da608e0b28',execute_time='2015-02-10 02:45:00',status='done',resolution='success',message=NULL,target='function::updateTrackerSessions',data=NULL,requeue=0,retry_count=NULL,failure_count=NULL,job_delay=0,client='CRON1c5d072676309395bd010d69d45b82c7:7048',percent_complete=NULL WHERE job_queue.id = 'dfb2afc5-c97f-6e84-8e6e-54d970269d03' AND deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0052027702331543 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Updating records related to SchedulersJobs dfb2afc5-c97f-6e84-8e6e-54d970269d03 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Retrieve Team: SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.00059819221496582 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Hook called: SchedulersJobs::after_save Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Creating new instance of hook class SugarSearchEngineQueueManager without parameters Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Adding the following bean to the populate queue- module: SchedulersJob , id: dfb2afc5-c97f-6e84-8e6e-54d970269d03 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:UPDATE schedulers SET last_run='2015-02-10 02:45:05' WHERE id='7177389e-52b0-3a5c-54a9-50da608e0b28' Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0048849582672119 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Get One: |SELECT id FROM job_queue WHERE execute_time <= '2015-02-10 02:45:05' AND status = 'queued' ORDER BY date_entered ASC| Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Limit Query:SELECT id FROM job_queue WHERE execute_time <= '2015-02-10 02:45:05' AND status = 'queued' ORDER BY date_entered ASC Start: 0 count: 1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query:SELECT id FROM job_queue WHERE execute_time <= '2015-02-10 02:45:05' AND status = 'queued' ORDER BY date_entered ASC LIMIT 0,1 Tue Feb 10 10:45:15 2015 [7048][1][INFO] Query Execution Time:0.0014970302581787 Tue Feb 10 10:45:15 2015 [7048][1][DEBUG] Calling MySQLi::disconnect()
View Comment
-
Support February 10th, 2015 @ 2:01 am
Hi Jason,
Thanks for your assistance.
I have just uninstalled and reinstalled SugarChimp. A repair and rebuild is also done. Now I'm testing it.
The importing of list seems to be working fine now.
Regards, Ian
View Comment
-
Support February 10th, 2015 @ 1:20 am
Hi SugarChimp,
What do you mean by replicate that on your side? The error?
I did not run the Repair and & Rebuild after installing SugarChimp. What is the purpose to run Repair & Rebuild after installing it?
It seems like I cannot reintall SugarChimp by myself. I shall get iZeno to do it for me then.
Somehow it is really not so effective. Anyway, hope it really can be solved as soon as possible.
Thanks.
Regards, Ian
View Comment
-
Support February 9th, 2015 @ 7:44 am
Hi SugarChimp,
Any concrete solution based on the php log errors? We are hoping to solve it before the free trial. We did not actually really try out since we sign up. It would be great if you can help us to resolve it as soon as possible. Thanks a lot.
View Comment
Kwek Jian Wen has not rated any add-ons.
Kwek Jian Wen has not verified any add-ons.
Kwek Jian Wen has not created any Wanted Add-ons.