This is a comment on Upgrade from 6.0.37 to 6.1.26 on php 7.4.33, posted by WikiAdmin at 08/11/2025 06:54

View source for Re: Upgrade from 6.0.37 to 6.1.26 on php 7.4.33

In this particular case, MariaDB 10.4, it was a feedback from a software packager that many hosters and appliances use for adding WackoWiki. When solving the SQL mode incompatibilities between MySQL 8 and MariaDB I set this threshold for removing ##NO_AUTO_CREATE_USER## for MySQL 8.0 or greater. 

Otherwise, **MySQL 8** and higher would throw a **fatal error** when using ##NO_AUTO_CREATE_USER## in **SQL session mode**.
%%
const SQL_MODE_LAX = [
	'mariadb'	=> 'NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER',
	'mysql'		=> 'NO_ENGINE_SUBSTITUTION'
];
%%