ERROR 1064 in 4_CLEANUP_AND_CONVERT_SPELLS.sql

4_CLEANUP_AND_CONVERT_SPELLS.sql

ERROR 1064 (42000) at line 62: 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 ') WHERE cnt>2) x2) ON s.guid = x2.guid AND s.skill = x2.skill' at line 1

I apologize, my MySQL knowledge starts and ends at "google the error" so I don't really have anything constructive to add.
I got this error when running 4_CLEANUP_AND_CONVERT_SPELLS.sql against azerothcore_characters DB, that DB contains a recent dump of my trinitycore characters DB.

I have a separate MySQL server from the AzerothCore and TrinityCore Servers, not sure if that is relevant. Let me know if I can provide anything more to assist in troubleshooting this error.

Start with 4_CLEANUP_AND_CONVERT_SPELLS.sql at line 62 and reproduce the ERROR 1064 against the reported azerothcore_characters database. Inspect the SQL near the subquery ending in `) WHERE cnt>2) x2)` and verify the script runs successfully on the relevant MySQL version.

Written by the indexing model from the issue text.