Andreas
05-06-2011, 10:00 PM
If you are running vBulletin 4.1.3+ and you do not have set a Server SQL Mode (http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html) you can get rid of one query on ervery page by adding
$config['Database']['no_force_sql_mode'] = true;
to your config.php
To verify that no mode is set run
SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;
If both queries give empty results no mode is set and you can safely add the configuration setting.
$config['Database']['no_force_sql_mode'] = true;
to your config.php
To verify that no mode is set run
SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;
If both queries give empty results no mode is set and you can safely add the configuration setting.