Automatic Upgrade script silently fails causing upgraded stores to crash

Description

Upgrade scripts have several issues that will cause upgrades to fail depending on mysql server configuration/version.

The upgrade sql must be updated for compatibility across multiple versions of mysql. Error checking needs to be added so that the upgrade does not silently fail if there is a problem. Any problems must be output to the screen and the update must be rolled back or prevented from happening when an error state is detected.

Environment

None

Steps to reproduce

None

Status

Assignee

Michael Sasek

Reporter

Michael Sasek

Labels

Severity

Crash

Fix versions

Affects versions

2.5.4

Priority

High
Configure