Back to vBulletin Tips & Tricks

[vB 4.1.3+] Get rid of one query per page with a simple configuration change
by Andreas 07 May 2011

If you are running vBulletin 4.1.3+ and you do not have set a 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
Code:
$config['Database']['no_force_sql_mode'] = true;
to your config.php

To verify that no mode is set run
SQL Query: (how to run queries)
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.

vblts.ru supports vBulletin®, 2022-2024