Error occurred while EspoCRM rebuild:

[MATO]

Hi All

Running an upgrade test from 6.1.10 to 7.0.10 using SSH

/usr/bin/php7.4-cli command.php upgrade -y
Current version is 6.1.10.
Downloading...
Upgrading... This may take a while..........
Error: Error occurred while EspoCRM rebuild. Please see the log for more detail.


See attached log for errors

[item]

Hello,

try maybe this solution by Yuri

https://forum.espocrm.com/forum/installation-and-upgrade-help/68685-if-espocrm-runs-slow-after-upgrading-to-6-1#post68685

[MATO]

We ran the solution above and are still getting the following errors


ALERT: Rebuild database fault: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax

See log attached

[lazovic]

Hi MATO,

Please tell me which version of MySQL/MariaDB are you using?

The error log points to a bunch of Calls and Contacts. Have any changes been made to these entities and their relationships? If so, which ones?

[MATO]

Hi Lazovic

We are using MySQL 5.7

We haven't changed anything in the last year to point to an issue with Calls or Contacts

We have run another upgrade using

(uiserver):u.....................:~/ESPOCRMTest$ /usr/bin/php7.4-cli command.php upgrade
Current version is 6.1.10.
EspoCRM will be upgraded to version 7.0.10 now. Enter [Y] to continue.
y
Downloading...
Upgrading... This may take a while..........
Error: Error occurred while EspoCRM rebuild. Please see the log for more detail.

We can't see the Calls and Contacts errors you have highlighted

See attached log file from today

[MATO]

Any help on this would be much appreciated as we cannot move forward at the moment

[Vadym]

Hi MATO,

Try to upgrade your MySQL version before EspoCRM upgrading.

[MATO]

Hi Vadym

Unfortunately, our Host will only support 5.7 at present

[lazovic]

MATO,

Tell me, please, if I understand correctly, do you use shared hosting?

Your version of MySQL is suitable for using the latest version of EspoCRM.
The problem may be in some settings of MySQL.

[MATO]

Hi Lazovic

Our Host is IONOS and looking into the DB we can see call-_contact but have no idea how it was created.

We have never had an issue with the upgrade process regarding the DB

What settings would need to be checked on MySQL?

Thank you for your help with this.

MATO

[lazovic]

MATO,

Does table call-_contact store any data now? Look please.

[MATO]

There is no data stored

[item]

strange,
not only call-_contact, call1, call_contact1..

[lazovic]

In any case, even if there are duplicate tables, it is possible to import data into the original tables call, contact and call_contact, remove duplicate tables and try to rebuild (without updating). Before that, a database backup is required.

[MATO]

we are using Call and Contacts for an ordering system that created Call1 and Call_Contact1 and that has been in operation for 3 years with no upgrade issues.

If we Rename or Drop Call-_Contact the Rebuild fails

We are running this on the test ESPOCRM so we can try whatever is needed

[item]

Look on
custom/Espo/Custom/
custom/Espo/Custom/Resources/metadata/entityDefs/

if you have any files with Call-
or search in files "Call-"

clearCache

Maybe there are a corrupted file

[MATO]

Have checked both areas and no Call-