Error upgrading to 8.0

[Vincent]

We are upgrading EspoCRM from 7.5.6 to 8.0 using CLI and got below error

ERROR: Failed to rebuild database schema. Details: Incomplete or invalid index definition `primary` on table google_calendar_event at /var/www/html/bcms/vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php:2473

We have removed the only extension, Advanced Pack, before doing upgrade.


Remark:
1. We have another system using EspoCRM and upgraded from 7.3.3 to 8.3.4 using CLI successfully
2. 1.X advanced pack was installed before

Best regards,
Vincent

[victor]

A similar topic and solution to the problem can be found here: https://forum.espocrm.com/forum/inst...dating-to-v8-0.

[Vincent]

In the Entity Manager page, we find

A. 5 SYSTEM entities (cannot be modified) related to Google Calendar

Google Calendar
GoogleCalendarRecurrentEvent
GoogleCalendarUser
GoogleContactsGroup
GoogleContactsPair

B. 2 System Entities have relationship with GoogleContactsPair
Contracts
Leads

It seems that all 7 entities and relationship cannot be removed.


Thanks.

[victor]

These Entities appear and disappear during the installation and removal of Google Integration extension. That is, the following steps should be enough for you: https://forum.espocrm.com/forum/inst...7257#post97257. If they do not help, then the same topic on the forum describes additional options for solving the problem, for example, https://forum.espocrm.com/forum/exte...4703#post94703.

[Vincent]

Thanks.

The only extension, Advanced Pack, shown in the Extensions page was removed before upgrade. But the entities starts with "Google" still exist in the Entities page.

We do not use the Google entities in our system. Should we remove these entities by deleting the related json file?

[victor]

Vincent,

You can try to delete all Google-related folders in the following locations:

• client/custom/modules/google
• client/modules/google
• application/Espo/Modules/Google
• custom/Espo/Modules/Google

After that make Hard Rebuild: https://docs.espocrm.com/administrat.../#hard-rebuild.

Also please do not forget to write on the forum wich the suggested steps you have already taken, so that the community knows what you have already done and doesn't recommend it again.