Tweet
I am trying to upgrade from 7.3.4 to 7.4.6, however I am prevented from doing so due to a database rebuild failure.
The Espo log shows the following errors:
Database rebuild failure, details: Error while rebuilding database. See log file for details..
ERROR: Database rebuild failure, details: No 'foreign' parameter defined in the relation 'teams'..
I have run a full debug log and the following lines are seen near the error:
DEBUG: Schema\Builder: ManyMany for MassEmail.excludingTargetLists
DEBUG: Schema\Builder: ManyMany for MassEmail.targetLists
DEBUG: Schema\Builder: ManyMany for TargetList.syncWithReports
DEBUG: Schema\Builder - End
INFO: Schema, query: ALTER TABLE attachment CHANGE size size BIGINT DEFAULT NULL
INFO: Schema, query: CREATE INDEX IDX_USER ON kanban_order (user_id)
INFO: Schema, query: CREATE INDEX IDX_AUTHENTICATION_PROVIDER_ID ON portal (authentication_provider_id)
INFO: Schema, query: ALTER TABLE subscription CHANGE id id BIGINT AUTO_INCREMENT NOT NULL
INFO: Schema, query: ALTER TABLE template CHANGE bottom_margin bottom_margin DOUBLE PRECISION DEFAULT '20', CHANGE footer_position footer_position DOUBLE PRECISION DEFAULT '10', CHANGE header_position
INFO: Schema, query: ALTER TABLE account CHANGE chance_of_renewal chance_of_renewal INT DEFAULT NULL, CHANGE gross_profit gross_profit INT DEFAULT NULL
ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'gross_profit' at row 18
ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details..
INFO: Installer: Restore previous files.
ERROR: Database rebuild failure, details: No 'foreign' parameter defined in the relation 'teams'..
ERROR: Upgrade Error: Error: Error occurred while EspoCRM rebuild. Please see the log for more detail. [] []
DEBUG: BPM: processPendingFlows [] []
DEBUG: BPM: processTriggeredSignals [] []
Any help would be appreciated.
The Espo log shows the following errors:
Database rebuild failure, details: Error while rebuilding database. See log file for details..
ERROR: Database rebuild failure, details: No 'foreign' parameter defined in the relation 'teams'..
I have run a full debug log and the following lines are seen near the error:
DEBUG: Schema\Builder: ManyMany for MassEmail.excludingTargetLists
DEBUG: Schema\Builder: ManyMany for MassEmail.targetLists
DEBUG: Schema\Builder: ManyMany for TargetList.syncWithReports
DEBUG: Schema\Builder - End
INFO: Schema, query: ALTER TABLE attachment CHANGE size size BIGINT DEFAULT NULL
INFO: Schema, query: CREATE INDEX IDX_USER ON kanban_order (user_id)
INFO: Schema, query: CREATE INDEX IDX_AUTHENTICATION_PROVIDER_ID ON portal (authentication_provider_id)
INFO: Schema, query: ALTER TABLE subscription CHANGE id id BIGINT AUTO_INCREMENT NOT NULL
INFO: Schema, query: ALTER TABLE template CHANGE bottom_margin bottom_margin DOUBLE PRECISION DEFAULT '20', CHANGE footer_position footer_position DOUBLE PRECISION DEFAULT '10', CHANGE header_position
INFO: Schema, query: ALTER TABLE account CHANGE chance_of_renewal chance_of_renewal INT DEFAULT NULL, CHANGE gross_profit gross_profit INT DEFAULT NULL
ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'gross_profit' at row 18
ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details..
INFO: Installer: Restore previous files.
ERROR: Database rebuild failure, details: No 'foreign' parameter defined in the relation 'teams'..
ERROR: Upgrade Error: Error: Error occurred while EspoCRM rebuild. Please see the log for more detail. [] []
DEBUG: BPM: processPendingFlows [] []
DEBUG: BPM: processTriggeredSignals [] []
Any help would be appreciated.
Comment