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

#3146 - Error received regularly

Closed Bug? created by EnableItMike 2 years ago

-------- Forwarded Message --------
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 sugarchimpactivity_contacts.0 id, sugarchimpactivity_contacts.1 sugarchimpactivity_id, sugarchimpactivity_contacts.2 contact_id, sugarchimpactivity_contacts.3 date_created, sugarchimpactivity_contacts.4 date_modified, sugarchimpactivity_contacts.5 deleted FROM sugarchimpactivity INNER JOIN sugarchimpactivity_contacts sugarchimpactivity_contacts ON sugarchimpactivity_contacts.sugarchimpactivity_id = sugarchimpactivity.id WHERE (sugarchimpactivity_contacts.contact_id = ?) AND (sugarchimpactivity_contacts.deleted = ?)' with params ["69941791530750000477100927160156", 0]:

Unknown column 'sugarchimpactivity_contacts.0' in 'field list'

Site: https://xxxxxx.xxxxxxx.xxxxxx
SugarCRM Version: 7.9.0.0
SugarCRM Edition: ENT
SugarChimp Version: 7.8.3h

Full error: Array
(
    [status] => error
    [message] => An exception occurred while executing 'SELECT sugarchimpactivity_contacts.0 id, sugarchimpactivity_contacts.1 sugarchimpactivity_id, sugarchimpactivity_contacts.2 contact_id, sugarchimpactivity_contacts.3 date_created, sugarchimpactivity_contacts.4 date_modified, sugarchimpactivity_contacts.5 deleted FROM sugarchimpactivity INNER JOIN sugarchimpactivity_contacts sugarchimpactivity_contacts ON sugarchimpactivity_contacts.sugarchimpactivity_id = sugarchimpactivity.id WHERE (sugarchimpactivity_contacts.contact_id = ?) AND (sugarchimpactivity_contacts.deleted = ?)' with params ["69941791530750000477100927160156", 0]:

Unknown column 'sugarchimpactivity_contacts.0' in 'field list'
)

  1. chad member avatar

    hutchins.chad gmail.com Verified Purchase

    2 years ago

    Hi Mike, that query is an auto-generated query from Sugar. It's hard to know exactly where that's happening in our Scheduler run.

    In Sugar 7.9, Sugar added a new prepared sql statements development tool. They rewrote how a lot of the internal queries are generated. I'm guessing this is related to that. We haven't had any issues reported in 7.9 yet.

    Unfortunately I don't have a solution at this time. I will need to investigate this more and will get back to you next week.

    Is this for a client? If so, which one?

    Thanks!

  2. chad member avatar

    hutchins.chad gmail.com Verified Purchase

    2 years ago

    Hi Mike, following up on this. I cannot seem to replicate this issue in Sugar 7.9. Are you still receiving the error emails?

    Have you tried running a quick repair and rebuild recently? I wonder if something got off in the vardefs somehow.

    If you're still having issues with this, let's setup a quick call to see if we can track down exactly where it's happening in the sync process. Please pick a day and time here: https://calendly.com/fanaticallabs/sugarchimp-support/

    Let us know. Thanks!

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hello Mike,

    We were able to replicate a similar bug in SugarCRM 7.9 and have resolved that issue. I believe that your issue will also be resolved with these code changes. Can you update your SugarChimp to the latest 7.9.0 package that has just be released. You can download the latest package from your Purchases page, and install it over the top of your previous installation. There is no need to uninstall or disable the old SugarChimp package. Once the new one is installed in Sugar, monitor the situation and let me know if the issue is resolved.

    Thanks,
    Jon

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hello Mike,

    Can you confirm that everything is working as intended now after installing the new package? Is there anything else we can help you with?

    Thanks,
    Jon

  5. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hello again, Mike. I'm going to close this case out now, as we know that new package has fixed the issues in Sugar 7.9.

    Cheers!
    Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating

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.