-
-
Notifications
You must be signed in to change notification settings - Fork 212
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Fatal Error: DatabaseException - SELECT SQL_CACHE- The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. #2909
Comments
Yeah I already left a comment in the code regarding that ;) |
MySQL version | 8.0.19 |
@wdebusschere Did run ran composer install and uploaded all file ? Because the |
Can't test anymore, getting now Symphony Notice: Undefined index errors.
|
@wdebusschere 763305c should take care of this |
Since the feature is deprecated, the first step is to at least disable it for real, by not usign the SQL_NO_CACHE directive at all. This is the first step towards removing this API. Re #2909
@wdebusschere Also check the other 2 commits ^^^ which should take care of mysql 8 if mysql's doc is right. |
Affected Symphony version(s) : 2.7.10 - 3.0.0
PHP version(s) : 7.1 - 7.3
MySQL version(s): 8.0
OS(es) :
To be able for symphonycms to work with MySql 8.0 i need to disable 'query_caching'.
installer/config_default.php 'query_caching' => 'off', did not work, i need to disable it in the symphony code:
$query = preg_replace('/^SELECT\s+/i', 'SELECT SQL_CACHE ', $query);
Error:
In the config.php 'query_caching' => 'off', works.
The text was updated successfully, but these errors were encountered: