In mysql 8.0.3 "system" has become a reserved keyword.
When you load a Drupal 7 database into mysql 8, the migrate module cannot access it. It tries to execute:
select s.* from system;
which fails with: Syntax error or access violation: 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 \'system s\' at line 3: SELECT s.*\nFROM\n{system} s;
I suggest we properly quote every table name send to mysql with backticks so this is solved once and for all.
Closed: outdated
11.0 🔥
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Is this still a problem? We been testing core with MySQL for a while now.
Ah, I found #3155563: select query should quote aliases which are reserved words in MySQL → , committed to 8.9.x, and that looks like it solves the problem of reserved words.
Therefore, I am closing this as outdated, re-open if there is still work to do here.