Hello,
First, thank you for the great product.
I have to use Upgrade from UI option (I don't have shell on my hosting) and I stuck with this error:
"Error 500
Error occurred while EspoCRM rebuild. Please see the log for more detail."
Here are some lines from the log file (DEBUG log level enforced):
[2023-04-07 15:04:28] DEBUG: Schema\Converter - End: building schema [] []
[2023-04-07 15:04:28] INFO: Installation process [643030e1a12d69fe7]: End "rebuild" step. [] []
[2023-04-07 15:04:28] INFO: Installation process [643030e1a12d69fe7]: Start "copy" step. [] []
[2023-04-07 15:04:39] INFO: Installation process [643030e1a12d69fe7]: End "copy" step. [] []
[2023-04-07 15:04:39] INFO: Installation process [643030e1a12d69fe7]: Start "rebuild" step. [] []
[2023-04-07 15:04:40] DEBUG: Schema\Converter - Start: building schema [] []
[2023-04-07 15:04:40] ERROR: Failed to rebuild database schema. Details: There is no column with name "entity_type" on table "array_value". at /var/www/vhosts/ -------/vendor/doctrine/dbal/src/Schema/Exception/ColumnDoesNotExist.php:16 [] []
[2023-04-07 15:04:40] ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details.. [] []
[2023-04-07 15:05:05] DEBUG: Schema\Converter - End: building schema [] []
[2023-04-07 15:05:05] ERROR: Database rebuild failure, details: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. [] []
[2023-04-07 15:05:05] DEBUG: API (500) Error occurred while EspoCRM rebuild. Please see the log for more detail.; POST /Admin/action/runUpgrade; Input data: {"id":"643030e1a12d69fe7"}; Route pattern: /{controller}/action/{action}; Route params: Array ( [controller] => Admin [action] => runUpgrade ) [] []
[2023-04-07 15:05:05] ERROR: (500) Error occurred while EspoCRM rebuild. Please see the log for more detail.; POST /Admin/action/runUpgrade; line: 288, file: /var/www/vhosts/ ----------------- /application/Espo/Core/Upgrades/Actions/Base.php [] []
It looks like the process is reverting back to 7.3.4 version after this error. I've checked the DB "entity_type" column in "array_value" table is in place. Though the table is empty.
I've added custom fields to Account and Contact entities (via Entity Manager) and to their layouts respectively. Previous upgrades went well. I've tried all EspoCRM-upgrade-7.3.4-to-7.4.x.zip to no avail.
I guess it's not critical since everything keeps working well on 7.3.4 but I'll be happy to help with debugging this issue.
Best regards,
Alex
First, thank you for the great product.
I have to use Upgrade from UI option (I don't have shell on my hosting) and I stuck with this error:
"Error 500
Error occurred while EspoCRM rebuild. Please see the log for more detail."
Here are some lines from the log file (DEBUG log level enforced):
[2023-04-07 15:04:28] DEBUG: Schema\Converter - End: building schema [] []
[2023-04-07 15:04:28] INFO: Installation process [643030e1a12d69fe7]: End "rebuild" step. [] []
[2023-04-07 15:04:28] INFO: Installation process [643030e1a12d69fe7]: Start "copy" step. [] []
[2023-04-07 15:04:39] INFO: Installation process [643030e1a12d69fe7]: End "copy" step. [] []
[2023-04-07 15:04:39] INFO: Installation process [643030e1a12d69fe7]: Start "rebuild" step. [] []
[2023-04-07 15:04:40] DEBUG: Schema\Converter - Start: building schema [] []
[2023-04-07 15:04:40] ERROR: Failed to rebuild database schema. Details: There is no column with name "entity_type" on table "array_value". at /var/www/vhosts/ -------/vendor/doctrine/dbal/src/Schema/Exception/ColumnDoesNotExist.php:16 [] []
[2023-04-07 15:04:40] ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details.. [] []
[2023-04-07 15:05:05] DEBUG: Schema\Converter - End: building schema [] []
[2023-04-07 15:05:05] ERROR: Database rebuild failure, details: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. [] []
[2023-04-07 15:05:05] DEBUG: API (500) Error occurred while EspoCRM rebuild. Please see the log for more detail.; POST /Admin/action/runUpgrade; Input data: {"id":"643030e1a12d69fe7"}; Route pattern: /{controller}/action/{action}; Route params: Array ( [controller] => Admin [action] => runUpgrade ) [] []
[2023-04-07 15:05:05] ERROR: (500) Error occurred while EspoCRM rebuild. Please see the log for more detail.; POST /Admin/action/runUpgrade; line: 288, file: /var/www/vhosts/ ----------------- /application/Espo/Core/Upgrades/Actions/Base.php [] []
It looks like the process is reverting back to 7.3.4 version after this error. I've checked the DB "entity_type" column in "array_value" table is in place. Though the table is empty.
I've added custom fields to Account and Contact entities (via Entity Manager) and to their layouts respectively. Previous upgrades went well. I've tried all EspoCRM-upgrade-7.3.4-to-7.4.x.zip to no avail.
I guess it's not critical since everything keeps working well on 7.3.4 but I'll be happy to help with debugging this issue.
Best regards,
Alex
Comment