For some reason when opening the issue it does not let me select other than the dev version, mine is 7.73

Here's the error:

PDOException: SQLSTATE[42000]: 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 WHERE type = 'module'' at line 1: SELECT name, schema_version FROM {system} WHERE type = :type; Array ( [:type] => module ) in drupal_get_installed_schema_version() (line 155 of /site/includes/install.inc).

Any hint to solve it? thanks!

Some more data:

MySql Server: 8.0.22-0ubuntu0.20.04.2

Comments

Andrés Chandía created an issue. See original summary.

andrés chandía’s picture

andrés chandía commented
Issue summary: View changes
andrés chandía’s picture

andrés chandía commented
Issue summary: View changes
andrés chandía’s picture

andrés chandía commented
Issue summary: View changes
longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Status: Active » Fixed
Related issues: +#2978575: Mysql 8 Support on Drupal 7

Drupal 7 is not yet compatible with MySQL 8. MySQL 8 has added system as a reserved word, but that is also the name of one of our tables.

See #2978575: Mysql 8 Support on Drupal 7 for a patch that might help, please help out by commenting on that issue if you can.

andrés chandía’s picture

andrés chandía commented

Thanks longwave I don't know what I was thinking of, I don't know how I didn't relate this upgrade with that thread where I have also posted, but obviously it was that, patch 2978575-290.patch did it for me.

Sorry and thanks again!!

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.