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

#4093 - Install error after Sugar upgrade

Closed Bug? created by synolia Verified Purchase 2 months ago

Hello,

We are having issue withe errors triggered by the SugarChimp module post upgrading Sugar to 8.0.2.

The error is :

PHP Warning: include(custom/metadata/sugarchimpactivity_MetaData.php): failed to open stream: No such file or directory in /data/sugarcrm-qualif/custom/application/Ext/TableDictionary/tabledictionary.ext.php on line 48, referer: [SUGAR_URL]
[Thu Apr 25 10:01:56.664555 2019] [php7:warn] [pid 29315] [client 10.35.100.50:54867] PHP Warning: include(): Failed opening 'custom/metadata/sugarchimpactivity_MetaData.php' for inclusion (include_path='/data/sugarcrm-qualif:/data/sugarcrm-qualif/vendor:.:/usr/share/pear:/usr/share/php') in /data/sugarcrm-qualif/custom/application/Ext/TableDictionary/tabledictionary.ext.php on line 48, referer: [SUGAR_URL]

I have tried updating the SugarChimp module with the latest version compatible with Sugar 8 to correct the problem and have this issue on install:

[FATAL] Error creating table: sugarchimpactivity_accounts Query Failed: CREATE TABLE sugarchimpactivity_accounts (id varchar(36) NOT NULL ,sugarchimpactivity_id varchar(36) NULL ,account_id varchar(36) NULL ,date_created datetime NULL ,date_entered datetime NULL ,date_modified datetime NULL ,deleted bool DEFAULT 0 NULL , PRIMARY KEY (id), KEY sugarchimpactivity_accounts_idxa (sugarchimpactivity_id), KEY sugarchimpactivity_accounts_idxb (account_id), KEY sugarchimpactivity_accounts_idx (sugarchimpactivity_id, account_id)) CHARACTER SET utf8 COLLATE utf8mb4_general_ci: MySQL error 1253: COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'

Insatlling and uninstalling the older 8.2.0a version of the module seems to fix the errors on the Sugar instance.

Is there a known issue with the latest version of the module?
When will a Sugar 9 compatible module be available?

Kind regards,
Synolia Support

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 months ago

    Thanks for reaching out. The most recent version we have, SugarChimp 9, is compatible with Sugar 9. It can be found on the Orders page.

    In regards to these errors, can you tell me the version of MySQL you're using? You can find information on the supported platforms here: https://support.sugarcrm.com/Resources/Supported_Platforms/

    Thanks,
    Heidi

  2. synolia member avatar

    synolia Verified Purchase

    2 months ago

    Hello,

    The version is mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper.

    Kind regards,
    Synolia Support

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 months ago

    Thanks for checking that. The original error showing indicates the metadata file is not there, which we've seen in the past is generally a permissions issue on the server.

    Can you confirm you have the correct permissions in place? I'm linking two articles below:

    https://support.sugarcrm.com/Knowledge_Base/Platform_Management/Required_File_System_Permissions_on_Linux/index.html
    https://support.sugarcrm.com/Knowledge_Base/Platform_Management/Setting_Default_File_Permissions_and_Ownership_Via_config.php/

    If neither of those solve the issue, let's go ahead and schedule a call so we can take a closer look and ensure this gets resolved:

    https://calendly.com/fanaticallabs_support/sugarchimp-support-meeting

    Thanks,
    Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "The team is always proactive in assisting with any questions. Keep up the great work! Great product and great support!"

    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.