Upgrade 2.8.5.5 -> 2.8.6.1 - SQL ERROR about app HOT 7 OPEN

Hello,

Some news about this one.
After a lot of trial and error, I found out that the fix was to manually add

mysqli_report(MYSQLI_REPORT_OFF);

In the app config.php after the upgrade.

from app.

Unfortunately, after fixing the issue manually, when saving the config from the app, the line goes away.

I see this commit but it looks like it's not available in 2.8.6.1 which is latest release.

c11d11c

from app.

Hello,
is this the only error in the sql.log?

I try to use PHP 8.1 and MySQL 8.0
I get this error too, but the login page loads. When I login then more errors show up, like:

sql.ERROR: [User=  ()] MySql Query: SELECT * FROM `user_email_preferences` WHERE `user_id` = '24'; [] []

I've checked the sql-server log and the commands are been executet:

Connect	[email protected] on booked using TCP/IP
Init DB	booked
Query	SET NAMES utf8
Query	SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
Query	SELECT `name`, `value` FROM `user_preferences` WHERE `user_id` = '24'
Quit

So even if the SQL-server sends a valid query an error appears in the sql.log. Can you confirm this behaviour?

from app.

Hello, I fixed the issue by adding manually

mysqli_report(MYSQLI_REPORT_OFF); at the beginning of config.php

I also needed to patch this file with this change:

c11d11c

Otherwise as soon as you trigger a config change it will remove the previously added line in the config.php

Maybe this can help you too

from app.

OK I did both, but nothing changed. Which version of MySQL do you use?

from app.

Server version: 8.0.33-cll-lve MySQL Community Server - GPL

from app.

OK, thats the same I use.
Thanks for your help!

from app.