Register Members List Search Today's Posts Mark Forums Read

Article Options
[vB 4.1.3+] Get rid of one query per page with a simple configuration change
Join Date: Jan 2004
Posts: 6,863

by Andreas Andreas is offline 07 May 2011

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

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to your config.php

To verify that no mode is set run

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

If both queries give empty results no mode is set and you can safely add the configuration setting.
Views: 5690
Reply With Quote
Old 07 May 2011, 15:49
Princeton's Avatar
Princeton Princeton is offline
Join Date: Nov 2001
Real name: Joe Velez
great tip - thanks for sharing!
Former Staff Member

Latest Articles:
Liquid Layout = Less Ad Revenue?
How to Monetize Your Site
Improve Web Page Performance
How To Write For The Web

If it needs instructions, there's room for improvement.
Give users what they actually want, not what they say they want. And whatever you do, don't give them new features just because your competitors have them!
Reply With Quote
Old 11 May 2011, 21:15
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
Join Date: Sep 2008
Real name: Michael Miller Jr
Originally Posted by Princeton View Post
great tip - thanks for sharing!
Ditto .
Daddy Does Dios and Figs!

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!
Reply With Quote
Old 26 Jun 2011, 18:24
8thos's Avatar
8thos 8thos is offline
Join Date: Aug 2010
Real name: DRE
Where in AdminCP does it say set Server SQL Mode?
Reply With Quote
Old 26 Jun 2011, 21:32
Alfa1's Avatar
Alfa1 Alfa1 is offline
Join Date: Dec 2005
Nowhere. You can check by running the above query.
Reply With Quote
Old 26 Jun 2011, 21:41
HMBeaty's Avatar
HMBeaty HMBeaty is offline
Join Date: Sep 2005
Real name: Brooks
Awesome! Thanks!

--------------- Added 26 Jun 2011 at 22:18 ---------------

Would it be possible to make this a plugin versus editing the config.php file?
"Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time!"
"It's important to only think about what you desire, not what you fear to achieve your ultimate goal!!
Reply With Quote
Old 30 Jun 2011, 21:44
ProFifaLeagues's Avatar
ProFifaLeagues ProFifaLeagues is offline
Join Date: Aug 2009
Real name: Rob
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
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Article Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 15:01.

Layout Options | Width: Wide Color: