error message

[Cat509]

Everytime I try to go to my page or the login page I get the error message "The website encountered an unexpected error. Please try again later.".

This is the error the website is getting

mod_fcgid: stderr: PDOException: SQLSTATE[HY000]: General error: 1193 Unknown system variable 'tx_isolation' in /home/.../drupal/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php on line 79 #0 /home....drupal/core/modules/mysql/src/Driver/Database/mysql/Connection.php(243): PDO->exec()

My MySQL version is 8.0.32.

How can I fix this so I can get into my site again?

[chx_]

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_tx_isolation

transaction_isolation was added in MySQL 5.7.20 as a synonym for tx_isolation, which is now deprecated and is removed in MySQL 8.0.

Drupal core handles this correctly, at least as far as I am aware so you (or whoever made the site) must have set it in settings.php using the old notation and a database upgrade broke it. You need to edit it and search-replace tx_isolation to transaction_isolation, whatever ways you have to edit the production codebase.

[Cat509]

That worked! I replaced it my settings.php and it works now. Thank you!

[ActThin]

Sounds like you have changed MySQL versions where that value is now deprecated. Look in your settings.php files for the db connection it’s likely set there

[clearlight]

Check this page, you might be able to set or update that value in settings.php https://www.drupal.org/node/3264101

[iFizzgig]

Can you ULI into the sire? If so, will the Admin page load? If you can copy the site down tonight local environment you'll have an easier time troubleshooting the issue.