#4093 - Install error after Sugar upgrade
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