:wave:- I am upgrading hydra from 1.11.7 to <2.0.3...
# talk-hydra
r
👋- I am upgrading hydra from 1.11.7 to 2.0.3, and facing issues in migration script execution. logs
Copy code
Could not apply migrations:
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('[]'),
    `login_verifier` varchar(40) NOT NULL,
    `login_csrf` varchar(40) ' at line 6
error executing migrations/20211019000001000000_merge_authentication_request_tables.mysql.up.sql, sql: -- Migration generated by the command below; DO NOT EDIT.
I have checked official documentation, it says ORY/hydra is compatible with MySQL 5.7+ . My system's mySql version : 5.7.34, for Linux (x86_64) using EditLine wrapper Seems migration command is failing as SQL script are not working on 5.7.34. Can anyone please help here , we are on tight timelines and we can't update mySQL to v8 as of now to make it work. Any help would be very helpful. PFA detailed logs
f