[vB 4.1.3+] Get rid of one query per page with a simple configuration change

[Andreas]

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


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


to your config.php

To verify that no mode is set run


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



If both queries give empty results no mode is set and you can safely add the configuration setting.

[Princeton]

great tip - thanks for sharing!

[TheLastSuperman]

great tip - thanks for sharing!

Ditto ;).

[8thos]

Where in AdminCP does it say set Server SQL Mode?

[Alfa1]

Nowhere. You can check by running the above query.

[HMBeaty]

Awesome! Thanks!

--------------- Added 1309123130 at 1309123130 ---------------

Would it be possible to make this a plugin versus editing the config.php file?

[rammieone]

Running the check above i get the return
@@GLOBAL.sql_mode; @@SESSION.sql_mode; So am i advised not to use this edit?

Thanks just wanted to be double sure