Greetings!
I'm trying to upgrade our instance of AtoM from 2.4.1 to 2.6.4 and am running into a problem at the upgrade-sql step. I started off with a blank 2.6.4 install and that worked fine. The error only arose after replacing the database with our 2.4.1 database and running "php symfony tools:upgrade-sql".
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDEX function_FI_2 TO function_object_FI_2' at line 1
We're running MariaDB 10.4.17 rather than specifically the requirement of MySQL 8.0. However, before the upgrade process, the blank 2.6.4 site installed and seemed to be working fine, so I'm not certain if database version is the issue here. If it is for certain, then I'll have a much easier time requesting a non-distro database.
I should also mention that I tried upgrading to 2.5.4, then 2.6.4 to see if it was a byproduct of jumping up too many versions. I was able to upgrade to 2.5.4 without any problems, but the subsequent 2.6.4 update had the same error.
Any hints, fixes or clarification on database requirements would be greatly appreciated!
Mike Schouten
MacEwan University