The Arcive of vBulletin Modifications Site. |
|
|
|||||||
|
[vB 4.1.3+] Get rid of one query per page with a simple configuration change
 Andreas
Join Date: Jan 2004
Posts: 6,863
Germany
05-06-2011, 09:00 PM
If you are running vBulletin 4.1.3+ and you do not have set a Server SQL Mode you can get rid of one query on ervery page by adding Code:
$config['Database']['no_force_sql_mode'] = true; To verify that no mode is set run [sql] SELECT @@GLOBAL.sql_mode; SELECT @@SESSION.sql_mode; [/sql] If both queries give empty results no mode is set and you can safely add the configuration setting. 
|
|
#3
05-11-2011, 06:15 PM
|
||||
|
||||
Quote:
 .
|
|
#6
06-26-2011, 06:41 PM
|
||||
|
||||
|
Awesome! Thanks!
--------------- Added [DATE]1309123130[/DATE] at [TIME]1309123130[/TIME] --------------- Would it be possible to make this a plugin versus editing the config.php file?
|
|
#7
06-30-2011, 06:44 PM
|
||||
|
||||
|
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
|
 |
«
Previous Thread
|
Next Thread
»
|
|
All times are GMT. The time now is 12:32 AM.