SQLSTATE[42000] Error on PHP 8.3

[Juergen]

Hello @all

I am struggeling with the following error message, which appears after the first install of a module on a brand new PW installation by viewing log files:

Short description:

After a fresh install of PW-dev 3.0.240 (latest dev version) on a server running PHP 8.3 and MySql 8.0 everything works fine if I go to the log files. I can view the log files for errors, exceptions, modules,... without problems.

After I install my first module (in my case I have installed the ProcessDatabaseBackups module from Ryan) this error message will be thrown if I want to view a log file.

To be clear again: This error message will be thrown if I want to view a log file in the backend AFTER I have installed a module. Before the first install of a module everything works fine.

On my localhost running on PHP 8.2 there is no problem. Could this be a PHP 8.3 problem? Does anyone struggle with the same problem? I have found some older posts of a similar problem in the forum, but none of them helps me to solve this problem.

Maybe someone can point me into the right direction, what the problem could be, because the error message does not help me to find the cause for this error.

Edit: Ok, it seems that this is a MySQL safety rule on shared hosts, but is there a possibility to change this like inside  a php.ini for PHP?

Thanks in advance

[BitPoet]

You should be able to append the required settings to $config->dbInitCommand.

[Juergen]

Thanks @BitPoet

I have never heard about this config settings property, but I will give it a try.?

It happens only on a testing site, so I have changed the site from multilanguage to single language and then the error was gone. So the problem is only on a multilanguage installation in my case.