[Upgrade error 7.0.8 -> 7.0.9]: Error occurred while EspoCRM rebuild

[Danny]

Hi forks,

I tried to upgrade my staging environment to newer version (It's currently 7.0.8) via CLI command.

However, it encountered error (log_upgrade.log)
Anyone has any ideas how can I check or resolve this?

Also, my Clean-up is not working

I checked the log file on 07 May around 8 o'clock but not quite sure what is the cause

Any help are appreciated. Thanks
·

[Vadym]

Hi Danny,

As described in your error log, cron jobs are disabled. To enable it, go to Administration -> Settings and uncheck the Disable Cron box.
[2023-05-09 08:44:03] WARNING: Cron is not run because it's disabled with 'cronDisabled' param.



Do you have any customizations by coding? Please provide a screenshot of Administration -> Extensions to investigate this issue in more detail.

[item]

Hi Vadim,
look :
[2023-05-09 08:44:08] INFO: SCHEMA, Execute Query: ALTER TABLE lead ADD name VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci` [] []
INFO: SCHEMA, Execute Query: ALTER TABLE lead ADD name VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci` [] []
[2023-05-09 08:44:08] ALERT: Rebuild database fault: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large

I think is a collation/encoding issue of mysql..
Yuri have posted a script for this .. but not find it :s

to run in command line .. must take long time if database is big

[Vadym]

Thanks for the hint!

[Vadym]

Hi Danny,

Perhaps the following threads will be helpful:

https://forum.espocrm.com/forum/installation-and-upgrade-help/60558-id-collation-changed-after-upgrade

https://forum.espocrm.com/forum/installation-and-upgrade-help/62444-long-upgrade-time-with-collation-change-need-efficiency-help#post62459