SugarChimp

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