by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Free 30 day trial
Try it Now

#4187 - Sugarchimp Sync Fail

Closed Bug? created by jrhodes Verified Purchase 2 years ago

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

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 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

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 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.

    1. Navigate to the Health Status page
    2. Right click anywhere on the page and select "Inspect"
    3. Switch to the "Console" and paste the following string (this puts SugarChimp into debug mode and gives us greater insight into what's happening):
      SUGAR.App.api.call('CREATE',SUGAR.App.api.buildURL('SugarChimp/setting/logger/debug')
    4. Wait 10 minutes and then navigate to "Diagnostic Tool" within the Admin page
    5. Ensure all the boxes are checked and click "Execute Diagnostic"
    6. Download the diagnostic file and send it to mailchimp@fanaticallabs.com so we can take a closer look

    Once that's done, you can put SugarChimp back into normal mode by doing the following:

    1. Navigate to the Health Status page
    2. Right click anywhere on the page and select "Inspect"
    3. Switch to the "Console" and paste the following string:
      SUGAR.App.api.call('CREATE',SUGAR.App.api.buildURL('SugarChimp/setting/logger/normal')

    Thanks again for your help in troubleshooting!

    Heidi

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "SugarChimp is working great. We're able to sync all of our lists and subscriber fields between MailChimp and SugarCRM. SugarChimp Support also did a great job supporting us as we were setting everything up."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.