-
Display NameOLGA MARTOS LOZANO
-
Website
-
Member SinceJune 9th, 2016
-
Last SeenMay 12th, 2022
OLGA MARTOS LOZANO does not have any add-ons for sale.
-
Support March 10th, 2022 @ 3:32 pm
Hi team,
We've already fixed the bug by ourselves. Here you can see the PHP log with the error: _Unable to find source-code formatter for language: php. Available languages are: actionscript, html, java, javascript, none, sql, xhtml, xml PHP Fatal error: Uncaught Error: Class '\DocuSign\eSign\Model\array' not found in /mnt/sugar/shadowed/bovemontero-pre.sugarondemand.com/modules/UT_DocuSign/library/esign-client/src/ObjectSerializer.php:318 Stack trace:
0 /mnt/sugar/shadowed/bovemontero-pre.sugarondemand.com/modules/UT_DocuSign/library/esign-client/src/ObjectSerializer.php(258): DocuSign\eSign\ObjectSerializer::deserialize(Object(stdClass), '\DocuSign\eSign...', NULL)
1 /mnt/sugar/shadowed/bovemontero-pre.sugarondemand.com/modules/UT_DocuSign/library/esign-client/src/ObjectSerializer.php(1342): DocuSign\eSign\ObjectSerializer::deserialize(Array, '\DocuSign\eSign...')
2 /mnt/sugar/shadowed/bovemontero-pre.sugarondemand.com/modules/UT_DocuSign/library/esign-client/src/ObjectSerializer.php(1342): DocuSign\eSign\ObjectSerializer::deserialize(Object(stdClass), '\DocuSign\eSign...')
3 /mnt/sugar/shadowed/bovemontero-pre.sugarondemand.com/modules/UT_DocuSign/library/esign-client/src/ObjectSerializer.php(258): DocuSign\eSign\ObjectSerializer::deserialize(Obj in /mnt/sugar/shadowed/bovemontero-pre.sugarondemand.com/modules/UT_DocuSign/library/esign-client/src/ObjectSerializer.php on line 318_
Our bugfix: Changing this path '\DocuSign\eSign\Model\array' to '\DocuSign\eSign\Model\ModelList[]' Perhaps you could fix it for uncoming release too.
Thanks Beatriz Reviejo Project Lead at redk Spain
View Comment
-
Support March 10th, 2022 @ 11:37 am
Hi,
I'm Beatriz (Affiliated user) and I'm working togeteher Collum helping to find any solution for this issue.
Sugar Console: Thu Mar 10 07:55:41 2022 [20376][1][FATAL] could not load LHS in User Thu Mar 10 07:58:32 2022 [19768][1][FATAL] DocuSign : ObjectSerializer File written bytes Thu Mar 10 07:58:32 2022 [19768][1][FATAL] Written 218721 byte to /tmp/1646899112. Please move the file to a proper folder or delete the temp file after processing. Thu Mar 10 07:59:46 2022 [9848][1][FATAL] could not load LHS in User Thu Mar 10 09:02:54 2022 [29376][1][FATAL] DocuSign : ObjectSerializer File written bytes Thu Mar 10 09:02:54 2022 [29376][1][FATAL] Written 267783 byte to /tmp/1646902974. Please move the file to a proper folder or delete the temp file after processing. Thu Mar 10 09:02:55 2022 [29376][1][FATAL] DocuSign : ObjectSerializer File written bytes Thu Mar 10 09:02:55 2022 [29376][1][FATAL] Written 124995 byte to /tmp/1646902975. Please move the file to a proper folder or delete the temp file after processing. Thu Mar 10 09:03:32 2022 [21108][1][FATAL] could not load LHS Thu Mar 10 09:03:32 2022 [21108][1][FATAL] could not load LHS Thu Mar 10 09:03:33 2022 [21108][1][FATAL] DocuSign : ObjectSerializer File written bytes Thu Mar 10 09:03:33 2022 [21108][1][FATAL] Written 253974 byte to /tmp/1646903013. Please move the file to a proper folder or delete the temp file after processing. Thu Mar 10 09:03:34 2022 [21108][1][FATAL] DocuSign : ObjectSerializer File written bytes Thu Mar 10 09:03:34 2022 [21108][1][FATAL] Written 298848 byte to /tmp/1646903014. Please move the file to a proper folder or delete the temp file after processing.
Chrome Browser: attached screenshots https://bovemontero-pre.sugarondemand.com/rest/v11_15/UT_DocuSign/manageDocuSignFieldMapping
Error Oops, An error has occured Error: Internal Server Error Status : 500 Response Text :
https://bovemontero-pre.sugarondemand.com/rest/v11_15/UT_DocuSign/GetDocuSignTemplateDetails Error Oops, An error has occured Error: Internal Server Error Status : 500 Response Text :
Thanks Beatriz Reviejo Project Lead at redk Spain
View Comment
-
Support March 10th, 2022 @ 9:24 am
Hi,
Ok, this error is already solved following ypur instructions. But we have problems yet:
https://bovemontero-pre.sugarondemand.com/rest/v11_15/UT_DocuSign/manageDocuSignFieldMapping
Error Oops, An error has occured Error: Internal Server Error Status : 500 Response Text :
https://bovemontero-pre.sugarondemand.com/rest/v11_15/UT_DocuSign/GetDocuSignTemplateDetails Error Oops, An error has occured Error: Internal Server Error Status : 500 Response Text :
We're able to send external templates but we get errors using internal templates. Any idea? Thank you very much
Regards Beatriz Reviejo Project lead at redk Spain
View Comment
-
Support March 10th, 2022 @ 8:14 am
Hi,
I work together Collum, analizing this issue.
I think the problem could be this CRM is hosted on SugarCloud. Please check this error: Refused to frame 'https://appdemo.docusign.com/' because it violates the following Content Security Policy directive: "default-src 'self' .sugarcrm.com *.salesfusion.com *.salesfusion360.com *.sugarapps.com *.sugarapps.eu sugarcrm-release-archive.s3.amazonaws.com https://.pendo.io pendo-io-static.storage.googleapis.com pendo-static-5197307572387840.storage.googleapis.com pendo-eu-static.storage.googleapis.com pendo-eu-static-5197307572387840.storage.googleapis.com". Note that 'frame-src' was not explicitly set, so 'default-src' is used as a fallback.
It violates the following Content Security Policy!!!!! why??? If this addOn is compatible with SugarSell, this issue shouldn't get using your Docusign connector. Because SugarSell is always onCloud. When SugarCRM is hosted onCloud, there isn't access to files or DB. Here the doumentation: https://support.sugarcrm.com/Resources/Sugar_Cloud_Policy_Guide/
Do you know what I mean? Could it be the source of this issue?
Thanks Beatriz Reviejo Project Lead at redk Spain
View Comment
-
Support March 1st, 2022 @ 6:27 pm
Hi I've already installed the new packet and It has worked. Thanks
Beatriz Reviejo Porject Lead at redk Spain
View Comment
-
Support October 13th, 2020 @ 11:30 am
Hello, Is it possible, currently? We have a very critical SugarCRM use case and we'd need to reach fields of a custom module from MailChimp. We'd need to design the specific emails from MailChimp using those fields. That custom module (Bookings) is related to Accounts but that relationship is 0-N (any account could have 0 or many Bookings). So we can't create custom fields on Accounts to loading that fields.
Please could you tell me please, if there is any solution using SugarChimp? or any workaround? Thank you very much
Beatriz Reviejo Project Lead at redk Spain
View Comment
-
Support September 25th, 2018 @ 8:20 am
Good morning,
I have any email and I should send feedback our customer. Please, may you write me an email (breviejo@redk.net) and tell me how long would you need for compatible package implementing? An estimated timing is enough, just I'd need to know the estimation to inform our customer.
Thank you very much Regards
Beatriz Reviejo Business Analyst and Product Owner in redk
View Comment
-
-
Support September 20th, 2018 @ 10:52 am
Hi, Any new?
Thanks Beatriz Reviejo Business Analyst and Product Owner in redk
View Comment
-
Support September 19th, 2018 @ 3:34 pm
Hi, Our customer is interested because they were using another kind of integration between Mautic and SugarCRM and currently it doesn't work. They were looking for a new solutions and they've asked for your solution directly. If you'd change the priority to high priority....How long should they wait before getting a compatible package for SugarCRM onCloud instances?
Thank you and regards Beatriz Reviejo
Business Analyst and Product Owner in redk
View Comment
-
Support September 5th, 2018 @ 8:47 am
Hi Jon,
We've checked it and the MailChimp activities are already syncing from MailChimp to SugarCRM module. There're new records related to the actions/activities of the subscribers (clicks, opens or sends). It works :)
The problem is the sync of invalid emails. This action isn't syncing to SugarCRM. Note: we shouldn't to activate the subscribers sync because we must to avoid the data updating in SugarCRM (Name, Surname, Address...) So we think the execution of the following command is right: SUGAR.App.api.call('CREATE',SUGAR.App.api.buildURL('SugarChimp/setting/subscriber_sync_enabled/0'),{},{}); Isn't it?
We'd need keep activated the sync: 1- From MailChimp to SugarCRM, over the field of email in SugarCRM (invalid, refused emails mangement) 2- MailChimp activities into SugarCRM module Also we'd need to keep disabled the subscribers data sync (Name, Surname, Address...) from MailChimp to SugarCRM
Is it possible? If we don't solve this problem the customer won't use SugarChimp no more. Any idea or solution?
I hope you can help us Thank you very much and regards
Beatriz
View Comment
-
Support August 23rd, 2018 @ 1:24 pm
Hi Jon,
It explains how the records sync to MailChimp and how the number of records is so low. Now I understand everything :)
You can close this case because I haven't any other question of this behaviour of the plugin. I would like thank you for your time and help.
Thank you very much, Jon Kind regards Bea
View Comment
-
Support August 22nd, 2018 @ 11:20 am
Hello Jon,
When the SQL was setup the number of records (leads whose should be sent to MailChimp) was 99 but after the first sync only a few subscribers were sent to MailChimp.
After the first sync, every hour and everyday the number of subscribers in MailChimp increases. Currently there are 65 subscribers.
I have one more example with another Target List. In this case the number of records (result of my SQL) was 35 and the first sync only sent a few of subscribers. Currently this number increases because SugarChimp is sending small batches every hour yet.
In both cases if I check the SQL result (I have created reports in SugarCRM using those SQLs), I can see just a kind of update over those Leads (subscribers) => Modified Date of email field. But checking those email addresses, they haven't been changed just their modified dates have beed changed. Those dates are always 1 minute after the sync to MailChimp so I think is SugarChimp who changes those dates.
It looks like SugarChimp always sends small batches of subscribers or Is there other criteria to get the batch of data? Perhaps, the scheduler is executed every hour but its during is a few minutes, isn't it?
Thanks!!! Kind regards Bea
View Comment
-
Support August 21st, 2018 @ 6:44 am
Good morning Jon,
It looks like everything works fine :) From last week, we have two list on SugarCRM and they're synced data to MailChimp via SQL.
I've noticed than the sync happens every hour because the scheduler "SugarChimp - Smartlist" is executed on this frequency. Also I've noticed the sync sends a stack of data every hour and those records are added to MailChimp list automatically.
I've created two reports on SugarCRM to support my following of added records on MailChimp list and there I can see the block of data every hour:
- Why does it send a stack of data and not the all data?
- Which is the criteria to get the data stack? Because my SQL creates the main data stack but then the data are synced by blocks. Why?
- Could you explain me this behaviour, please? It would be great :)
Thank you very much for your help
Regards Bea
View Comment
-
Support August 17th, 2018 @ 12:34 pm
Hi Jon,
Thank you very much for your instructions. I'll try follow every step and I'll write you again with the result.
Have a nice weekend Regards Bea
View Comment
-
Support August 16th, 2018 @ 12:14 pm
Hi Jon,
Finally I got to reach the "smart List" via UI, please look at this:
I've executed by url: http://62.97.109.190:88/#SugarChimp/layout/adminsmartlist And there are 20 records. The last 11 records of this table are testings that we've done those two weeks.
I have inspect the interface and I've seen the button for clearing this table is empty:
SugarChimp Queued Records _<!--<button class="sc-empty-table" id="sugarchimp">Empty Table-->_
And I've checked the code and I've seen the clearing of this queue is disabled on the code. Could you explain me the reason? It is right?
Which would be my next step? Attached the sugarcrm.log trying to send data from SugarCRM to MailChimp by "SQL from SugarChimp":
_Thu Aug 16 14:10:07 2018 [29728][1][INFO] Query:SELECT category, name, value, platform FROM config WHERE category = 'sugarchimp' Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] SugarChimp:debug:1534421410: SugarChimp_Queue::queue_mailchimp_subscribers table_name: sugarchimp_mc Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Contacts Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Prospects Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Accounts Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Contacts Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Prospects Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Accounts Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] SugarChimp:debug:1534421410: SugarChimp_Queue::queue_mailchimp_subscribers: batch insert sql: INSERT INTO sugarchimp_mc (id,mailchimp_list_id,data,date_entered,date_modified,deleted) VALUES (UUID(),'e1e28f048d','YTozOntzOjc6Imxpc3RfaWQiO3M6MTA6ImUxZTI4ZjA0OGQiO3M6NToiZW1haWwiO3M6MTk6ImFzaHlyb3YuaEBnbWFpbC5jb20iO3M6NzoibWFwcGluZyI7YTo0OntzOjg6IkNvbnRhY3RzIjthOjQ6e3M6OToiTkVXLUVNQUlMIjtzOjE5OiJhc2h5cm92LmhAZ21haWwuY29tIjtzOjU6IkZOQU1FIjtzOjg6IkhhbmdlbGRpIjtzOjU6IkxOQU1FIjtzOjc6IkFzaHlyb3YiO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo5OiJQcm9zcGVjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MTk6ImFzaHlyb3YuaEBnbWFpbC5jb20iO3M6NToiRk5BTUUiO3M6ODoiSGFuZ2VsZGkiO3M6NToiTE5BTUUiO3M6NzoiQXNoeXJvdiI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO31zOjU6IkxlYWRzIjthOjQ6e3M6OToiTkVXLUVNQUlMIjtzOjE5OiJhc2h5cm92LmhAZ21haWwuY29tIjtzOjU6IkZOQU1FIjtzOjg6IkhhbmdlbGRpIjtzOjU6IkxOQU1FIjtzOjc6IkFzaHlyb3YiO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo4OiJBY2NvdW50cyI7YToyOntzOjk6Ik5FVy1FTUFJTCI7czoxOToiYXNoeXJvdi5oQGdtYWlsLmNvbSI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO319fQ==','2018-08-16 12:10:05','2018-08-16 12:10:05',0),(UUID(),'e1e28f048d','YTozOntzOjc6Imxpc3RfaWQiO3M6MTA6ImUxZTI4ZjA0OGQiO3M6NToiZW1haWwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo3OiJtYXBwaW5nIjthOjQ6e3M6ODoiQ29udGFjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo1OiJGTkFNRSI7czowOiIiO3M6NToiTE5BTUUiO3M6MTY6IkNyaXN0aW5hIFNlcnJhbm8iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo5OiJQcm9zcGVjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo1OiJGTkFNRSI7czowOiIiO3M6NToiTE5BTUUiO3M6MTY6IkNyaXN0aW5hIFNlcnJhbm8iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo1OiJMZWFkcyI7YTo0OntzOjk6Ik5FVy1FTUFJTCI7czoyNDoibWlndWVsLmpvcmRhb0BneXBmb3IuY29tIjtzOjU6IkZOQU1FIjtzOjA6IiI7czo1OiJMTkFNRSI7czoxNjoiQ3Jpc3RpbmEgU2VycmFubyI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO31zOjg6IkFjY291bnRzIjthOjI6e3M6OToiTkVXLUVNQUlMIjtzOjI0OiJtaWd1ZWwuam9yZGFvQGd5cGZvci5jb20iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9fX0=','2018-08-16 12:10:05','2018-08-16 12:10:05',0) Thu Aug 16 14:10:10 2018 [29728][1][INFO] Query:INSERT INTO sugarchimp_mc (id,mailchimp_list_id,data,date_entered,date_modified,deleted) VALUES (UUID(),'e1e28f048d','YTozOntzOjc6Imxpc3RfaWQiO3M6MTA6ImUxZTI4ZjA0OGQiO3M6NToiZW1haWwiO3M6MTk6ImFzaHlyb3YuaEBnbWFpbC5jb20iO3M6NzoibWFwcGluZyI7YTo0OntzOjg6IkNvbnRhY3RzIjthOjQ6e3M6OToiTkVXLUVNQUlMIjtzOjE5OiJhc2h5cm92LmhAZ21haWwuY29tIjtzOjU6IkZOQU1FIjtzOjg6IkhhbmdlbGRpIjtzOjU6IkxOQU1FIjtzOjc6IkFzaHlyb3YiO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo5OiJQcm9zcGVjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MTk6ImFzaHlyb3YuaEBnbWFpbC5jb20iO3M6NToiRk5BTUUiO3M6ODoiSGFuZ2VsZGkiO3M6NToiTE5BTUUiO3M6NzoiQXNoeXJvdiI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO31zOjU6IkxlYWRzIjthOjQ6e3M6OToiTkVXLUVNQUlMIjtzOjE5OiJhc2h5cm92LmhAZ21haWwuY29tIjtzOjU6IkZOQU1FIjtzOjg6IkhhbmdlbGRpIjtzOjU6IkxOQU1FIjtzOjc6IkFzaHlyb3YiO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo4OiJBY2NvdW50cyI7YToyOntzOjk6Ik5FVy1FTUFJTCI7czoxOToiYXNoeXJvdi5oQGdtYWlsLmNvbSI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO319fQ==','2018-08-16 12:10:05','2018-08-16 12:10:05',0),(UUID(),'e1e28f048d','YTozOntzOjc6Imxpc3RfaWQiO3M6MTA6ImUxZTI4ZjA0OGQiO3M6NToiZW1haWwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo3OiJtYXBwaW5nIjthOjQ6e3M6ODoiQ29udGFjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo1OiJGTkFNRSI7czowOiIiO3M6NToiTE5BTUUiO3M6MTY6IkNyaXN0aW5hIFNlcnJhbm8iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo5OiJQcm9zcGVjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo1OiJGTkFNRSI7czowOiIiO3M6NToiTE5BTUUiO3M6MTY6IkNyaXN0aW5hIFNlcnJhbm8iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo1OiJMZWFkcyI7YTo0OntzOjk6Ik5FVy1FTUFJTCI7czoyNDoibWlndWVsLmpvcmRhb0BneXBmb3IuY29tIjtzOjU6IkZOQU1FIjtzOjA6IiI7czo1OiJMTkFNRSI7czoxNjoiQ3Jpc3RpbmEgU2VycmFubyI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO31zOjg6IkFjY291bnRzIjthOjI6e3M6OToiTkVXLUVNQUlMIjtzOjI0OiJtaWd1ZWwuam9yZGFvQGd5cGZvci5jb20iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9fX0=','2018-08-16 12:10:05','2018-08-16 12:10:05',0) Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '05874397d2' AND deleted=0 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '05874397d2' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '05874397d2' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '765b489df2' AND deleted=0 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '765b489df2' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '765b489df2' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '8812706746' AND deleted=0 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '8812706746' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '8812706746' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'be278cb7a5' AND deleted=0 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'be278cb7a5' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'be278cb7a5' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'cdb3f31752' AND deleted=0 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'cdb3f31752' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'cdb3f31752' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd063c54264' AND deleted=0 Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd063c54264' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd063c54264' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd19f0bcbf2' AND deleted=0 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd19f0bcbf2' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd19f0bcbf2' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'e1e28f048d' AND deleted=0 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'e1e28f048d' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'e1e28f048d' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'ece48cdd43' AND deleted=0 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'ece48cdd43' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'ece48cdd43' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'f5277d7167' AND deleted=0 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'f5277d7167' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'f5277d7167' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'fadea88974' AND deleted=0 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'fadea88974' AND deleted=0 Start: 0 count: 1 Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'fadea88974' AND deleted=0 LIMIT 0,1 Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] SugarChimp:debug:1534421412: SugarChimp_List::mark_other_lists_as_deleted: sql: UPDATE sugarchimp_mc_list SET deleted_from_mailchimp=1 WHERE mailchimp_list_id NOT IN ('05874397d2','765b489df2','8812706746','be278cb7a5','cdb3f31752','d063c54264','d19f0bcbf2','e1e28f048d','ece48cdd43','f5277d7167','fadea88974') Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:UPDATE sugarchimp_mc_list SET deleted_from_mailchimp=1 WHERE mailchimp_list_id NOT IN ('05874397d2','765b489df2','8812706746','be278cb7a5','cdb3f31752','d063c54264','d19f0bcbf2','e1e28f048d','ece48cdd43','f5277d7167','fadea88974') Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT mailchimp_campaign_id, name FROM sugarchimp_mc_campaign Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] SugarChimp:debug:1534421412: SugarChimp_Scheduler_MailchimpListToSugarCRM->run: checking sugarchimp_mc_cleaned_email queue for cleaned emails to process in queue Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT DISTINCT mailchimp_list_id AS mailchimp_list_id, name AS name FROM sugarchimp_backup_queue Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Contacts Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Prospects Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Leads Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Accounts Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Contacts Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Prospects Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Accounts Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Contacts Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Prospects Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Leads Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Accounts Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Contacts Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Prospects Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Accounts Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp_mc WHERE id='52c4ae26-a14d-11e8-ad47-9ed167c316be' Thu Aug 16 14:10:13 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads Thu Aug 16 14:10:13 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp_mc WHERE id='52c8d61b-a14d-11e8-ad47-9ed167c316be' Thu Aug 16 14:10:13 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_site_url Thu Aug 16 14:10:18 2018 [29728][1][INFO] Query:SELECT category, name, value, platform FROM config WHERE category = 'sugarchimp' Thu Aug 16 14:10:20 2018 [29728][1][DEBUG] SugarChimp:debug:1534421420: SugarChimp_Scheduler_SugarToMailchimp->delete_jobs delete the jobs that we just ran: DELETE FROM sugarchimp WHERE mailchimp_list_id = 'ece48cdd43' AND name = 'AddWebhook'
ORDER BY date_entered ASC LIMIT 200Thu Aug 16 14:10:20 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp WHERE mailchimp_list_id = 'ece48cdd43' AND name = 'AddWebhook'
ORDER BY date_entered ASC LIMIT 200Thu Aug 16 14:10:20 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_site_url Thu Aug 16 14:10:22 2018 [29728][1][INFO] Query:SELECT category, name, value, platform FROM config WHERE category = 'sugarchimp' Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarToMailchimp->delete_jobs delete the jobs that we just ran: DELETE FROM sugarchimp WHERE mailchimp_list_id = 'e1e28f048d' AND name = 'AddWebhook'
ORDER BY date_entered ASC LIMIT 200Thu Aug 16 14:10:22 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp WHERE mailchimp_list_id = 'e1e28f048d' AND name = 'AddWebhook'
ORDER BY date_entered ASC LIMIT 200Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarChimpCleanup sql: DELETE FROM sugarchimp_batches WHERE DATE_ADD(date_entered, INTERVAL 7 DAY) < '2018-08-16 12:10:05' Thu Aug 16 14:10:22 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp_batches WHERE DATE_ADD(date_entered, INTERVAL 7 DAY) < '2018-08-16 12:10:05' Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarChimpCleanup->removed batches from the sugarchimp_batches table. Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarChimpCleanup sql: DELETE FROM sugarchimp_lock WHERE DATE_ADD(date_entered, INTERVAL + CONCAT(0, ':', 5) HOUR_MINUTE) < '2018-08-16 12:10:05' Thu Aug 16 14:10:22 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp_lock WHERE DATE_ADD(date_entered, INTERVAL + CONCAT(0, ':', 5) HOUR_MINUTE) < '2018-08-16 12:10:05' Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarChimpCleanup->removed records from the sugarchimp_lock table removed._
I think everything should be rightly configured so I attach the content of config table:
I hope you can find the issue.
Thanks a lot Bea
View Comment
-
Support August 16th, 2018 @ 7:19 am
Hi Jon,
Following your instructions, I found some problems........
I get an error 500 if I try to execute "/layout/adminsmartlistqueue":
Here you can see the detail: General: Request URL: http://62.97.109.190:88/rest/v10/SugarChimp/adminsmartlistqueue Request Method: GET Status Code: 500 Internal Server Error Remote Address: 62.97.109.190:88 Referrer Policy: no-referrer-when-downgrade
Response Headers: Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0 Connection: close Content-Encoding: gzip Content-Length: 20 Content-Type: text/html Date: Thu, 16 Aug 2018 07:15:27 GMT Expires: Thu, 19 Nov 1981 08:52:00 GMT Pragma: no-cache Server: Apache/2.2.22 (Ubuntu) Vary: Accept-Encoding X-Powered-By: PHP/5.4.45-4+deprecated+dontuse+deb.sury.org~precise+1
Request Headers: Accept: application/json, text/javascript, /; q=0.01 Accept-Encoding: gzip, deflate Accept-Language: es-ES,es;q=0.9,en;q=0.8,de;q=0.7,ca;q=0.6 Connection: keep-alive Content-Type: application/json Cookie: download_token_base=9edc971a-dc9a-23da-e0d7-5b75179a95df; PHPSESSID=9e9fd83c-4e48-a964-9826-5b751750b562 Host: 62.97.109.190:88 OAuth-Token: 9e9fd83c-4e48-a964-9826-5b751750b562 Referer: http://62.97.109.190:88/ User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36 X-Metadata-Hash: a2fdc1597c026d75f20518c26719e5e3 X-Requested-With: XMLHttpRequest X-Userpref-Hash: 0a6586f2a3806d0592927c908239aeac
Also if I execute the command: SUGAR.App.api.call('get',SUGAR.App.api.buildURL('Smartlist/setting/logger/debug'),{},{}); I get anr error too:
/rest/v10/Smartlist/setting/logger/debug 404 (Not Found)
error: "no_method", error_message: "Could not find a route with 4 elements"} error: "no_method" error_message:"Could not find a route with 4 elements"
I'm sorry but I'm not able to check anything If I get those errors. What could I do?
Thanks Bea
View Comment
-
OLGA MARTOS LOZANO has not rated any add-ons.
OLGA MARTOS LOZANO has not verified any add-ons.
OLGA MARTOS LOZANO has not created any Wanted Add-ons.