I'm trying to update from 5.0.4 to 6.5.2 using the web updater but it failed:
The error message given was: SQLSTATE[HY000]: General error: 1005 Can't create table 'demo.#sql-49c_234' (errno: 150)
A database change failed to apply: ALTER TABLE x2_role_exceptions ADD CONSTRAINT x2_role_exceptions_ibfk_1 FOREIGN KEY x2_role_exceptions_ibfk_1 (roleId) REFERENCES x2_roles (id) ON DELETE CASCADE ON UPDATE CASCADE;.
Hello
I'm trying to update from 5.0.4 to 6.5.2 using the web updater but it failed:
The error message given was: SQLSTATE[HY000]: General error: 1005 Can't create table 'demo.#sql-49c_234' (errno: 150) A database change failed to apply: ALTER TABLE
x2_role_exceptions
ADD CONSTRAINTx2_role_exceptions_ibfk_1
FOREIGN KEYx2_role_exceptions_ibfk_1
(roleId
) REFERENCESx2_roles
(id
) ON DELETE CASCADE ON UPDATE CASCADE;.Any tips to solve this issue?