Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.
#4187 - Sugarchimp Sync Fail
Hello-
The text below is the message we're receiving, notifying us that the sugarchimp sync isn't working. Some of our users are just getting stuck on "loading" screens within our sugar instance.
Mon Jul 22 15:20:55 2019 [10695][1][FATAL] SugarChimp:fatal:1563808855: A SugarChimp error was detected. We tried to email you about the error, but Sugar is unable to send emails to support@highlandsolutions.com. Here is what we tried to send:
Subject: Heads up! SugarChimp Sync Failed
Body: Sometimes your Sugar instance is unable to communicate with MailChimp. If you only receive this email every once in a while, there is nothing to worry about. Sugar will re-establish where it left off and continue syncing with MailChimp.
If you are receiving this email every few minutes, please contact SugarChimp Suport so we can take a look: support@sugarchimp.com
Error: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1
Site: https://meea.sugarondemand.com SugarCRM Version: 9.0.1 SugarCRM Edition: ENT SugarChimp Version: 9.1.2d
Full error: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
SugarChimp License: b9582fd5759185e3852de0e59f189564
Error: SMTP Error: data not accepted.
Please send this message to SugarChimp support if you have any questions: support@sugarchimp.com Mon Jul 22 15:20:57 2019 [10695][1][FATAL] SMTP -> ERROR: QUIT command failed. Reply: , 255.27962:0A000000, 255.27962:0E000000, 255.31418:1F000130, 0.35250:0A00EE84, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:50000000, 1.36674:32000000, 1.61250:00000000, 1.45378:55000000, 1.44866:02000000, 16.55847:BC000000, 17.43559:00000000E0020000000000000100000000000000, 20.52176:140F2E880D0070204800D13D, 20.50032:140F2E887D1710104D000000, 0.35180:0A002F3D, 255.23226:0A00BB80, 255.27962:0A000000, 255.27962:32000000, 255.17082:DC040000, 0.27745:63000000, 4.21921:DC040000, 255.27962:FA000000, 255.1494:68000000, 0.38698:00000000, 0.37692:0E000100, 0.37948:0F010480, 5.33852:00000000534D545000000000, 4.56248:DC040000, 7.40748:010000000000010BE0786534, 7.57132:000000000000000005000780, 1.63016:32000000, 4.39640:DC040000, 8.45434:DD0DD1ED439B354FA78D2B10F13F67363A333963, 5.10786:0000000031352E32302E323039342E3031333A4D5748505231384D42313339323A33396334653566662D303862342D343032392D613231312D65636263353338643832373500502000000000, 255.1750:0A00DF3F, 255.31418:90000000, 0.22753:0A00F136, 255.21817:DC040000, 4.60547:DC040000, 0.21966:0A00F636, 4.30158:DC040000 [Hostname=MWHPR18MB1392.namprd18.prod.outlook.com] 221 2.0.0 Service closing transmission channel Code: 000 Mon Jul 22 15:26:12 2019 [22193][1][FATAL] An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:26:12 2019 [22193][1][FATAL] SugarChimp:fatal:1563809172: SugarChimp_Scheduler_Driver Exception caught: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:26:12 2019 [22193][1][FATAL] SugarChimp:fatal:1563809172: SugarChimp_Scheduler_Driver::end The scheduler failed to finish: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
Mon Jul 22 15:26:15 2019 [22193][1][FATAL] SMTP -> ERROR: DATA END command failed. Reply: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:70130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F35050000, 20.50032:140F2E887D17F01F0200BB30, 0.35180:3A050000, 255.23226:1B02 Code: 554 Extended Code: 5.2.0 Mon Jul 22 15:26:15 2019 [22193][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:70130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F35050000, 20.50032:140F2E887D17F01F0200BB30, 0.35180:3A050000, 255.23226:1B02 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:26:15 2019 [22193][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:70130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F35050000, 20.50032:140F2E887D17F01F0200BB30, 0.35180:3A050000, 255.23226:1B02 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:26:15 2019 [22193][1][FATAL] SugarChimp:fatal:1563809175: A SugarChimp error was detected. We tried to email you about the error, but Sugar is unable to send emails to support@highlandsolutions.com. Here is what we tried to send:
Subject: Heads up! SugarChimp Sync Failed
Body: Sometimes your Sugar instance is unable to communicate with MailChimp. If you only receive this email every once in a while, there is nothing to worry about. Sugar will re-establish where it left off and continue syncing with MailChimp.
If you are receiving this email every few minutes, please contact SugarChimp Suport so we can take a look: support@sugarchimp.com
Error: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1
Site: https://meea.sugarondemand.com SugarCRM Version: 9.0.1 SugarCRM Edition: ENT SugarChimp Version: 9.1.2d
Full error: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
SugarChimp License: b9582fd5759185e3852de0e59f189564
Error: SMTP Error: data not accepted.
Please send this message to SugarChimp support if you have any questions: support@sugarchimp.com Mon Jul 22 15:26:16 2019 [22193][1][FATAL] SMTP -> ERROR: QUIT command failed. Reply: , 255.27962:0A000000, 255.27962:0E000000, 255.31418:1E020000, 0.35250:1F001432, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:50000000, 1.36674:32000000, 1.61250:00000000, 1.45378:55000000, 1.44866:02000000, 16.55847:BC000000, 17.43559:00000000E0020000000000000100000000000000, 20.52176:140F2E880D0010107E020000, 20.50032:140F2E887D1700005D050000, 0.35180:F9030000, 255.23226:0A001030, 255.27962:0A000000, 255.27962:32000000, 255.17082:DC040000, 0.27745:67050000, 4.21921:DC040000, 255.27962:FA000000, 255.1494:6C050000, 0.38698:00000000, 0.37692:0E000100, 0.37948:0E000100, 5.33852:00000000534D545000000100, 4.56248:DC040000, 7.40748:010000000000010BE0786534, 7.57132:000000000000000000000000, 1.63016:32000000, 4.39640:DC040000, 8.45434:DD0DD1ED439B354FA78D2B10F13F67363A333963, 5.10786:0000000031352E32302E323039342E3031333A4D5748505231384D42313339323A33396334653566662D303862342D343032392D613231312D65636263353338643832373500503000000000, 255.1750:03001736, 255.31418:99050000, 0.22753:0A00A883, 255.21817:DC040000, 4.60547:DC040000, 0.21966:0A00AC83, 4.30158:DC040000 [Hostname=MWHPR18MB1392.namprd18.prod.outlook.com] 221 2.0.0 Service closing transmission channel Code: 000 Mon Jul 22 15:31:19 2019 [1264][1][FATAL] An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:31:19 2019 [1264][1][FATAL] SugarChimp:fatal:1563809479: SugarChimp_Scheduler_Driver Exception caught: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:31:19 2019 [1264][1][FATAL] SugarChimp:fatal:1563809479: SugarChimp_Scheduler_Driver::end The scheduler failed to finish: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
Mon Jul 22 15:31:20 2019 [1264][1][FATAL] SMTP -> ERROR: DATA END command failed. Reply: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:7E130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F43050000, 20.50032:140F2E887D17F01F0A004981, 0.35180:48050000, 255.23226:0A00 Code: 554 Extended Code: 5.2.0 Mon Jul 22 15:31:20 2019 [1264][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:7E130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F43050000, 20.50032:140F2E887D17F01F0A004981, 0.35180:48050000, 255.23226:0A00 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:31:20 2019 [1264][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:7E130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F43050000, 20.50032:140F2E887D17F01F0A004981, 0.35180:48050000, 255.23226:0A00 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:31:20 2019 [1264][1][FATAL] SugarChimp:fatal:1563809480: A SugarChimp error was detected. We tried to email you about the error, but Sugar is unable to send emails to support@highlandsolutions.com. Here is what we tried to send:
Subject: Heads up! SugarChimp Sync Failed
Body: Sometimes your Sugar instance is unable to communicate with MailChimp. If you only receive this email every once in a while, there is nothing to worry about. Sugar will re-establish where it left off and continue syncing with MailChimp.
If you are receiving this email every few minutes, please contact SugarChimp Suport so we can take a look: support@sugarchimp.com
Error: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1
Site: https://meea.sugarondemand.com SugarCRM Version: 9.0.1 SugarCRM Edition: ENT SugarChimp Version: 9.1.2d
Full error: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
SugarChimp License: b9582fd5759185e3852de0e59f189564
Error: SMTP Error: data not accepted.
Please send this message to SugarChimp support if you have any questions: support@sugarchimp.com Mon Jul 22 15:31:21 2019 [1264][1][FATAL] SMTP -> ERROR: QUIT command failed. Reply: , 255.27962:0A000000, 255.27962:0E000000, 255.31418:0A00A880, 0.35250:1F001336, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:50000000, 1.36674:32000000, 1.61250:00000000, 1.45378:55000000, 1.44866:02000000, 16.55847:BC000000, 17.43559:00000000E0020000000000000300000000000000, 20.52176:140F2E880D0070200A00AD80, 20.50032:140F2E887D1710106B050000, 0.35180:0A00AE80, 255.23226:4800D13D, 255.27962:0A000000, 255.27962:32000000, 255.17082:DC040000, 0.27745:75050000, 4.21921:DC040000, 255.27962:FA000000, 255.1494:7A050000, 0.38698:0F010480, 0.37692:0E000100, 0.37948:0F010480, 5.33852:00000000534D545000000100, 4.56248:DC040000, 7.40748:010000000000010BE0786534, 7.57132:00000000000000000E000100, 1.63016:32000000, 4.39640:DC040000, 8.45434:DD0DD1ED439B354FA78D2B10F13F67363A333963, 5.10786:0000000031352E32302E323039342E3031333A4D5748505231384D42313339323A33396334653566662D303862342D343032392D613231312D65636263353338643832373500503000000000, 255.1750:03001736, 255.31418:A7050000, 0.22753:0A00A883, 255.21817:DC040000, 4.60547:DC040000, 0.21966:0A00AC83, 4.30158:DC040000 [Hostname=MWHPR18MB1392.namprd18.prod.outlook.com] 221 2.0.0 Service closing transmission channel Code: 000 Mon Jul 22 15:38:48 2019 [18983][819e2245-08ed-34ba-3fa5-54f48c591ecc][FATAL] An exception occurred while executing 'SELECT case when jt4_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite, sugarchimpactivity.name, sugarchimpactivity.activity, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id, sugarchimpactivity.date_modified, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by FROM sugarchimpactivity LEFT JOIN sugarfavorites sf_sugarchimpactivity ON (sf_sugarchimpactivity.module = ?) AND (sf_sugarchimpactivity.record_id = sugarchimpactivity.id) AND (sf_sugarchimpactivity.assigned_user_id = ?) AND (sf_sugarchimpactivity.deleted = ?) LEFT JOIN sugarchimp_mc_campaign jt1_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimpmclist_id = INNER JOIN sugarchimpactivity_accounts sugarchimpactivity_accounts ON (sugarchimpactivity.id = sugarchimpactivity_accounts.sugarchimpactivity_id) AND (sugarchimpactivity_accounts.deleted = ?) INNER JOIN accounts jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_accounts.account_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN accounts_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = jt3_sugarchimpactivity.id LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON (sugarchimpactivity.id = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON (jt4_favorite_link.id = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC LIMIT 11' with params ["SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0, 0, "a15dd232-aaa4-d344-873b-54ee0d3b4b38", "0", "SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0]:
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 'JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimp' at line 1 Mon Jul 22 15:39:05 2019 [19450][819e2245-08ed-34ba-3fa5-54f48c591ecc][FATAL] An exception occurred while executing 'SELECT case when jt4_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite, sugarchimpactivity.name, sugarchimpactivity.activity, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id, sugarchimpactivity.date_modified, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by FROM sugarchimpactivity LEFT JOIN sugarfavorites sf_sugarchimpactivity ON (sf_sugarchimpactivity.module = ?) AND (sf_sugarchimpactivity.record_id = sugarchimpactivity.id) AND (sf_sugarchimpactivity.assigned_user_id = ?) AND (sf_sugarchimpactivity.deleted = ?) LEFT JOIN sugarchimp_mc_campaign jt1_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimpmclist_id = INNER JOIN sugarchimpactivity_contacts sugarchimpactivity_contacts ON (sugarchimpactivity.id = sugarchimpactivity_contacts.sugarchimpactivity_id) AND (sugarchimpactivity_contacts.deleted = ?) INNER JOIN contacts jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_contacts.contact_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN contacts_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = jt3_sugarchimpactivity.id LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON (sugarchimpactivity.id = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON (jt4_favorite_link.id = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC LIMIT 11' with params ["SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0, 0, "58374935-6547-9e89-b829-54f0ee63c30d", "0", "SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0]:
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 'JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimp' at line 1 Mon Jul 22 15:43:00 2019 [11642][819e2245-08ed-34ba-3fa5-54f48c591ecc][FATAL] An exception occurred while executing 'SELECT case when jt4_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite, sugarchimpactivity.name, sugarchimpactivity.activity, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id, sugarchimpactivity.date_modified, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by FROM sugarchimpactivity LEFT JOIN sugarfavorites sf_sugarchimpactivity ON (sf_sugarchimpactivity.module = ?) AND (sf_sugarchimpactivity.record_id = sugarchimpactivity.id) AND (sf_sugarchimpactivity.assigned_user_id = ?) AND (sf_sugarchimpactivity.deleted = ?) LEFT JOIN sugarchimp_mc_campaign jt1_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimpmclist_id = INNER JOIN sugarchimpactivity_accounts sugarchimpactivity_accounts ON (sugarchimpactivity.id = sugarchimpactivity_accounts.sugarchimpactivity_id) AND (sugarchimpactivity_accounts.deleted = ?) INNER JOIN accounts jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_accounts.account_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN accounts_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = jt3_sugarchimpactivity.id LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON (sugarchimpactivity.id = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON (jt4_favorite_link.id = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC LIMIT 11' with params ["SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0, 0, "5e8555b6-ed11-e667-d256-54ee0d84e78d", "0", "SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0]:
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 'JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimp' at line 1 Mon Jul 22 15:43:52 2019 [29213][819e2245-08ed-34ba-3fa5-54f48c591ecc][FATAL] An exception occurred while executing 'SELECT case when jt4_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite, sugarchimpactivity.name, sugarchimpactivity.activity, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id, sugarchimpactivity.date_modified, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by FROM sugarchimpactivity LEFT JOIN sugarfavorites sf_sugarchimpactivity ON (sf_sugarchimpactivity.module = ?) AND (sf_sugarchimpactivity.record_id = sugarchimpactivity.id) AND (sf_sugarchimpactivity.assigned_user_id = ?) AND (sf_sugarchimpactivity.deleted = ?) LEFT JOIN sugarchimp_mc_campaign jt1_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimpmclist_id = INNER JOIN sugarchimpactivity_contacts sugarchimpactivity_contacts ON (sugarchimpactivity.id = sugarchimpactivity_contacts.sugarchimpactivity_id) AND (sugarchimpactivity_contacts.deleted = ?) INNER JOIN contacts jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_contacts.contact_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN contacts_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = jt3_sugarchimpactivity.id LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON (sugarchimpactivity.id = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON (jt4_favorite_link.id = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC LIMIT 11' with params ["SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0, 0, "45583c16-2e11-11e8-87b9-06c156d48849", "0", "SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0]:
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 'JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimp' at line 1 Mon Jul 22 15:45:22 2019 [31237][1][FATAL] An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:45:22 2019 [31237][1][FATAL] SugarChimp:fatal:1563810322: SugarChimp_Scheduler_Driver Exception caught: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:45:22 2019 [31237][1][FATAL] SugarChimp:fatal:1563810322: SugarChimp_Scheduler_Driver::end The scheduler failed to finish: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
Mon Jul 22 15:45:24 2019 [31237][1][FATAL] SMTP -> ERROR: DATA END command failed. Reply: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:80030400, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:B02A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:B52A0000, 1.44866:80010000, 16.55847:8B130000, 17.43559:0000000004020000000000000200000000000000, 20.52176:140F2E880D00F01F33050000, 20.50032:140F2E887D17F01F0A00FF88, 0.35180:38050000, 255.23226:AE01 Code: 554 Extended Code: 5.2.0 Mon Jul 22 15:45:24 2019 [31237][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:80030400, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:B02A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:B52A0000, 1.44866:80010000, 16.55847:8B130000, 17.43559:0000000004020000000000000200000000000000, 20.52176:140F2E880D00F01F33050000, 20.50032:140F2E887D17F01F0A00FF88, 0.35180:38050000, 255.23226:AE01 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:45:24 2019 [31237][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:80030400, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:B02A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:B52A0000, 1.44866:80010000, 16.55847:8B130000, 17.43559:0000000004020000000000000200000000000000, 20.52176:140F2E880D00F01F33050000, 20.50032:140F2E887D17F01F0A00FF88, 0.35180:38050000, 255.23226:AE01 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:45:24 2019 [31237][1][FATAL] SugarChimp:fatal:1563810324: A SugarChimp error was detected. We tried to email you about the error, but Sugar is unable to send emails to support@highlandsolutions.com. Here is what we tried to send:
Subject: Heads up! SugarChimp Sync Failed
Body: Sometimes your Sugar instance is unable to communicate with MailChimp. If you only receive this email every once in a while, there is nothing to worry about. Sugar will re-establish where it left off and continue syncing with MailChimp.
If you are receiving this email every few minutes, please contact SugarChimp Suport so we can take a look: support@sugarchimp.com
Error: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1
Site: https://meea.sugarondemand.com SugarCRM Version: 9.0.1 SugarCRM Edition: ENT SugarChimp Version: 9.1.2d
Full error: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
SugarChimp License: b9582fd5759185e3852de0e59f189564
Error: SMTP Error: data not accepted.
Please send this message to SugarChimp support if you have any questions: support@sugarchimp.com Mon Jul 22 15:45:27 2019 [31237][1][FATAL] SMTP -> ERROR: QUIT command failed. Reply: , 255.27962:0A000000, 255.27962:0E000000, 255.31418:B3010000, 0.35250:0A000189, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:50000000, 1.36674:32000000, 1.61250:00000000, 1.45378:55000000, 1.44866:02000000, 16.55847:BC000000, 17.43559:00000000E0020000000000000200000000000000, 20.52176:140F2E880D001010CC010000, 20.50032:140F2E887D1700000A00C388, 0.35180:D1010000, 255.23226:0A000589, 255.27962:0A000000, 255.27962:32000000, 255.17082:DC040000, 0.27745:0A00C588, 4.21921:DC040000, 255.27962:FA000000, 255.1494:0A00C688, 0.38698:00000000, 0.37692:0F010480, 0.37948:0F010480, 5.33852:00000000534D545000000100, 4.56248:DC040000, 7.40748:010000000000010BE0786534, 7.57132:00000000000000003A333963, 1.63016:32000000, 4.39640:DC040000, 8.45434:DD0DD1ED439B354FA78D2B10F13F67363A333963, 5.10786:0000000031352E32302E323039342E3031333A4D5748505231384D42313339323A33396334653566662D303862342D343032392D613231312D65636263353338643832373500602005000780, 255.1750:0A000E83, 255.31418:0A00CE88, 0.22753:0D020000, 255.21817:DC040000, 4.60547:DC040000, 0.21966:12020000, 4.30158:DC040000 [Hostname=MWHPR18MB1392.namprd18.prod.outlook.com] 221 2.0.0 Service closing transmission channel Code: 000 Mon Jul 22 15:47:07 2019 [20151][819e2245-08ed-34ba-3fa5-54f48c591ecc][FATAL] An exception occurred while executing 'SELECT case when jt4_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite, sugarchimpactivity.name, sugarchimpactivity.activity, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id, sugarchimpactivity.date_modified, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by FROM sugarchimpactivity LEFT JOIN sugarfavorites sf_sugarchimpactivity ON (sf_sugarchimpactivity.module = ?) AND (sf_sugarchimpactivity.record_id = sugarchimpactivity.id) AND (sf_sugarchimpactivity.assigned_user_id = ?) AND (sf_sugarchimpactivity.deleted = ?) LEFT JOIN sugarchimp_mc_campaign jt1_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimpmclist_id = INNER JOIN sugarchimpactivity_accounts sugarchimpactivity_accounts ON (sugarchimpactivity.id = sugarchimpactivity_accounts.sugarchimpactivity_id) AND (sugarchimpactivity_accounts.deleted = ?) INNER JOIN accounts jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_accounts.account_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN accounts_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = jt3_sugarchimpactivity.id LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON (sugarchimpactivity.id = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON (jt4_favorite_link.id = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC LIMIT 11' with params ["SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0, 0, "5e8555b6-ed11-e667-d256-54ee0d84e78d", "0", "SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0]:
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 'JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimp' at line 1 Mon Jul 22 15:48:45 2019 [24503][819e2245-08ed-34ba-3fa5-54f48c591ecc][FATAL] An exception occurred while executing 'SELECT case when jt4_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite, sugarchimpactivity.name, sugarchimpactivity.activity, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id, sugarchimpactivity.date_modified, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by FROM sugarchimpactivity LEFT JOIN sugarfavorites sf_sugarchimpactivity ON (sf_sugarchimpactivity.module = ?) AND (sf_sugarchimpactivity.record_id = sugarchimpactivity.id) AND (sf_sugarchimpactivity.assigned_user_id = ?) AND (sf_sugarchimpactivity.deleted = ?) LEFT JOIN sugarchimp_mc_campaign jt1_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimpmclist_id = INNER JOIN sugarchimpactivity_accounts sugarchimpactivity_accounts ON (sugarchimpactivity.id = sugarchimpactivity_accounts.sugarchimpactivity_id) AND (sugarchimpactivity_accounts.deleted = ?) INNER JOIN accounts jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_accounts.account_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN accounts_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = jt3_sugarchimpactivity.id LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON (sugarchimpactivity.id = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON (jt4_favorite_link.id = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC LIMIT 11' with params ["SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0, 0, "5e8555b6-ed11-e667-d256-54ee0d84e78d", "0", "SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0]:
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 'JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimp' at line 1 Mon Jul 22 15:48:53 2019 [24714][819e2245-08ed-34ba-3fa5-54f48c591ecc][FATAL] An exception occurred while executing 'SELECT case when jt4_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite, sugarchimpactivity.name, sugarchimpactivity.activity, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id, sugarchimpactivity.date_modified, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by FROM sugarchimpactivity LEFT JOIN sugarfavorites sf_sugarchimpactivity ON (sf_sugarchimpactivity.module = ?) AND (sf_sugarchimpactivity.record_id = sugarchimpactivity.id) AND (sf_sugarchimpactivity.assigned_user_id = ?) AND (sf_sugarchimpactivity.deleted = ?) LEFT JOIN sugarchimp_mc_campaign jt1_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimpmclist_id = INNER JOIN sugarchimpactivity_contacts sugarchimpactivity_contacts ON (sugarchimpactivity.id = sugarchimpactivity_contacts.sugarchimpactivity_id) AND (sugarchimpactivity_contacts.deleted = ?) INNER JOIN contacts jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_contacts.contact_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN contacts_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = jt3_sugarchimpactivity.id LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON (sugarchimpactivity.id = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON (jt4_favorite_link.id = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC LIMIT 11' with params ["SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0, 0, "f9b1e596-9110-11e9-8f39-06bef78d6e58", "0", "SugarChimpActivity", "819e2245-08ed-34ba-3fa5-54f48c591ecc", 0, 0]:
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 'JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON sugarchimpactivity.sugarchimp' at line 1 Mon Jul 22 15:50:56 2019 [10533][1][FATAL] An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:50:56 2019 [10533][1][FATAL] SugarChimp:fatal:1563810656: SugarChimp_Scheduler_Driver Exception caught: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:50:56 2019 [10533][1][FATAL] SugarChimp:fatal:1563810656: SugarChimp_Scheduler_Driver::end The scheduler failed to finish: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
Mon Jul 22 15:50:57 2019 [10533][1][FATAL] SMTP -> ERROR: DATA END command failed. Reply: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:B02A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:B52A0000, 1.44866:80010000, 16.55847:65130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F43050000, 20.50032:140F2E887D17F01F0A004981, 0.35180:48050000, 255.23226:0A00 Code: 554 Extended Code: 5.2.0 Mon Jul 22 15:50:57 2019 [10533][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:B02A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:B52A0000, 1.44866:80010000, 16.55847:65130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F43050000, 20.50032:140F2E887D17F01F0A004981, 0.35180:48050000, 255.23226:0A00 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:50:57 2019 [10533][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00A280, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:B02A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:B52A0000, 1.44866:80010000, 16.55847:65130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D00F01F43050000, 20.50032:140F2E887D17F01F0A004981, 0.35180:48050000, 255.23226:0A00 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:50:57 2019 [10533][1][FATAL] SugarChimp:fatal:1563810657: A SugarChimp error was detected. We tried to email you about the error, but Sugar is unable to send emails to support@highlandsolutions.com. Here is what we tried to send:
Subject: Heads up! SugarChimp Sync Failed
Body: Sometimes your Sugar instance is unable to communicate with MailChimp. If you only receive this email every once in a while, there is nothing to worry about. Sugar will re-establish where it left off and continue syncing with MailChimp.
If you are receiving this email every few minutes, please contact SugarChimp Suport so we can take a look: support@sugarchimp.com
Error: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1
Site: https://meea.sugarondemand.com SugarCRM Version: 9.0.1 SugarCRM Edition: ENT SugarChimp Version: 9.1.2d
Full error: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
SugarChimp License: b9582fd5759185e3852de0e59f189564
Error: SMTP Error: data not accepted.
Please send this message to SugarChimp support if you have any questions: support@sugarchimp.com Mon Jul 22 15:50:59 2019 [10533][1][FATAL] SMTP -> ERROR: QUIT command failed. Reply: , 255.27962:0A000000, 255.27962:0E000000, 255.31418:0A00A880, 0.35250:0A001D30, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:50000000, 1.36674:32000000, 1.61250:00000000, 1.45378:55000000, 1.44866:02000000, 16.55847:BC000000, 17.43559:00000000E0020000000000000100000000000000, 20.52176:140F2E880D0070200A00AD80, 20.50032:140F2E887D1710106B050000, 0.35180:0A00AE80, 255.23226:4800D13D, 255.27962:0A000000, 255.27962:32000000, 255.17082:DC040000, 0.27745:75050000, 4.21921:DC040000, 255.27962:FA000000, 255.1494:7A050000, 0.38698:0F010480, 0.37692:0E000100, 0.37948:0F010480, 5.33852:00000000534D545000000100, 4.56248:DC040000, 7.40748:010000000000010BE0786534, 7.57132:0000000000000000FFE5C439, 1.63016:32000000, 4.39640:DC040000, 8.45434:DD0DD1ED439B354FA78D2B10F13F67363A333963, 5.10786:0000000031352E32302E323039342E3031333A4D5748505231384D42313339323A33396334653566662D303862342D343032392D613231312D6563626335333864383237350010100E000100, 255.1750:03001736, 255.31418:A7050000, 0.22753:0A00A883, 255.21817:DC040000, 4.60547:DC040000, 0.21966:0A00AC83, 4.30158:DC040000 [Hostname=MWHPR18MB1392.namprd18.prod.outlook.com] 221 2.0.0 Service closing transmission channel Code: 000 Mon Jul 22 15:56:24 2019 [22202][1][FATAL] An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:56:24 2019 [22202][1][FATAL] SugarChimp:fatal:1563810984: SugarChimp_Scheduler_Driver Exception caught: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 Mon Jul 22 15:56:24 2019 [22202][1][FATAL] SugarChimp:fatal:1563810984: SugarChimp_Scheduler_Driver::end The scheduler failed to finish: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
Mon Jul 22 15:56:25 2019 [22202][1][FATAL] SMTP -> ERROR: DATA END command failed. Reply: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A005B0E, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:51130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D001010F0140000, 20.50032:140F2E887D1700000A002383, 0.35180:F5140000, 255.23226:0A00 Code: 554 Extended Code: 5.2.0 Mon Jul 22 15:56:25 2019 [22202][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A005B0E, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:51130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D001010F0140000, 20.50032:140F2E887D1700000A002383, 0.35180:F5140000, 255.23226:0A00 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:56:25 2019 [22202][1][FATAL] PHPMailerProxy encountered an error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A005B0E, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:A42A0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:A92A0000, 1.44866:80010000, 16.55847:51130000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F2E880D001010F0140000, 20.50032:140F2E887D1700000A002383, 0.35180:F5140000, 255.23226:0A00 SMTP code: 554 Additional SMTP info: 5.2.0 Mon Jul 22 15:56:25 2019 [22202][1][FATAL] SugarChimp:fatal:1563810985: A SugarChimp error was detected. We tried to email you about the error, but Sugar is unable to send emails to support@highlandsolutions.com. Here is what we tried to send:
Subject: Heads up! SugarChimp Sync Failed
Body: Sometimes your Sugar instance is unable to communicate with MailChimp. If you only receive this email every once in a while, there is nothing to worry about. Sugar will re-establish where it left off and continue syncing with MailChimp.
If you are receiving this email every few minutes, please contact SugarChimp Suport so we can take a look: support@sugarchimp.com
Error: An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1
Site: https://meea.sugarondemand.com SugarCRM Version: 9.0.1 SugarCRM Edition: ENT SugarChimp Version: 9.1.2d
Full error: Array ( [status] => error [message] => An exception occurred while executing 'SELECT FROM sugarchimp_mc_list WHERE () LIMIT 1':
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 'FROM sugarchimp_mc_list WHERE () LIMIT 1' at line 1 )
SugarChimp License: b9582fd5759185e3852de0e59f189564
Error: SMTP Error: data not accepted.
Please send this message to SugarChimp support if you have any questions: support@sugarchimp.com Mon Jul 22 15:56:26 2019 [22202][1][FATAL] SMTP -> ERROR: QUIT command failed. Reply: , 255.27962:0A000000, 255.27962:0E000000, 255.31418:0A003080, 0.35250:02017100, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:50000000, 1.36674:32000000, 1.61250:00000000, 1.45378:55000000, 1.44866:02000000, 16.55847:BC000000, 17.43559:00000000E0020000000000000100000000000000, 20.52176:140F2E880D0070200A003883, 20.50032:140F2E887D17101018150000, 0.35180:0A003983, 255.23226:0A003910, 255.27962:0A000000, 255.27962:32000000, 255.17082:DC040000, 0.27745:22150000, 4.21921:DC040000, 255.27962:FA000000, 255.1494:27150000, 0.38698:00000000, 0.37692:0F010480, 0.37948:0F010480, 5.33852:00000000534D545000323339, 4.56248:DC040000, 7.40748:010000000000010BE0786534, 7.57132:000000000000000000000000, 1.63016:32000000, 4.39640:DC040000, 8.45434:DD0DD1ED439B354FA78D2B10F13F67363A333963, 5.10786:0000000031352E32302E323039342E3031333A4D5748505231384D42313339323A33396334653566662D303862342D343032392D613231312D65636263353338643832373500502000000000, 255.1750:0A00F63F, 255.31418:54150000, 0.22753:0A003B83, 255.21817:DC040000, 4.60547:DC040000, 0.21966:0A003C83, 4.30158:DC040000 [Hostname=MWHPR18MB1392.namprd18.prod.outlook.com] 221 2.0.0 Service closing transmission channel Code: 358
-
"Amazing product and amazing people. Thanks a lot for all the help at any question! :D"
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
5 years ago
Hi Jen,
Thanks for reaching out and sharing this error! I'd like to have our developer, Jon, take a closer look. Can you find some time that works for you so we can troubleshoot further?
https://calendly.com/fanaticallabs_support/sugarchimp-support-meeting
Thanks! Heidi
5 years ago
Hi Jen,
Thanks for scheduling a call! We look forward to chatting. Before the call tomorrow, can you complete the following steps? We're eager to see if there are any clues prior to the call.
Once that's done, you can put SugarChimp back into normal mode by doing the following:
Thanks again for your help in troubleshooting!
Heidi
5 years ago
Just wanted to follow up here and close this ticket out. We were able to resolve this issue by reaching out to Sugar support who made changes to your instance. We're working with Sugar support further to identify the underlying issue and make changes going forward for others who might encounter the same error.
Let us know if you encounter any further trouble!
Best, Heidi