You Are Not Authorized to Execute SQL Queries in vBulletin Maintenance
After login to vBulletin Admin Control Panel, and click on “Execute SQL Query” link under the Maintenance section, the administrator may always been denied and rejected with an error message saying “You are not authorized to execute SQL queries”. This is the case even if you’re super administrator who authorized to do everything on the forums. However, a simple trick will grant the user who needs this Execute SQL Query function with the required permission and right.
To grant an user permission and right to run Execute SQL Query from Control Panel, simply login to your web server which is running vBulletin forum. Then edit the /includes/config.php file.
Find the following line:
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
After a few lines, you should see the following setting:
$canrunqueries = ”;
Add in the user IDs of the forum members, moderators or administrators that you want to enable their ability to be able to run SQL queries in between the quotes (’). Note that it’s user ID and not user name. User ID is the number assigned to the user account automatically and sequentially. For example, if you want to add the right to administrator, who is usually the first person created on the board, and thus has the user ID number 1, change the line to:
$canrunqueries = ‘1′;
To add more users, simply seperate them with comma (,).
Related Articles
- Change or Set MySQL Long Query Time Value for log-slow-queries
- How to Disable and Turn Off vBulletin Plugin and Product System
- Enable Logging of Slow Queries (Slow Query Log) in MySQL Database
- Change or Increase vBulletin Maximum Number of Total Allowed Private Messages (PM)
- Hack to Add Forum Sponsors to vBulletin Categories and Forums
- How to Turn On and Enable vBulletin RSS Feed and XML Syndication Support
- How to Change the Logo of vBulletin Forum to Custom One
- AskEraser to Delete Private Search Queries in Ask.com
- How to Add and Display Ad or Message to Unregistered Guest Only in vBulletin
- How to Escape Characters in Oracle PL/SQL Queries
Entries (RSS)
January 15th, 2009 14:31
Hi forum users
November 3rd, 2008 21:33
Hi forum users and readers I hope you can solve a stupid problem with my computer
Im getting a lot of popups when Im browsing the internet, sometimes even when Im not at the computer, I leave it on for
an hour and when I get back I have 2-3 popups that have appeared from nowhere. How can I remove this? Im really not intrested
in finding adult friends or downloading a new screen saver
Okay I hope you can give me any ideas, Im gonna check back to the forum in couple days to see what you have suggested, Bye!
November 3rd, 2008 09:30
Hello this is Mike from houston, you got a nice forum here with some good topics and I hope you can help me with some tehnical problems
Im getting a lot of popups when Im browsing the internet, sometimes even when Im not at the computer, I leave it on for
an hour and when I get back I have 2-3 popups that have appeared from nowhere. How can I remove this? Im really not intrested
in finding adult friends or downloading a new screen saver
Well thats it, stupid problem and I hope that it has a nice easy solution that you can come up with, Im getting all your replays to my email
so I´ll keep an eye on the topic, take care.
June 15th, 2008 02:58
thanks, got the sql problem solved in vbulleting.
November 5th, 2007 03:57
i’m eric. joining a couple boards and looking
forward to participating. hehe unless i get
too distracted!
eric
October 13th, 2007 02:24
Hello,
Great forum!
I found a lot of interesting information here.
Does this forum helpful for you also?