When clicking on Execute SQL Queries under Import and Maintainance in ACP, I get a message saying I'm not authorized to do so. If not me, then who? How might I go about changing this? All admin permissions are set to "Yes".
Not authorized to execute SQL queries
Collapse
X
-
Tags: None
-
Originally posted by ContramontanumWhen clicking on Execute SQL Queries under Import and Maintainance in ACP, I get a message saying I'm not authorized to do so. If not me, then who? How might I go about changing this? All admin permissions are set to "Yes". -
-
-
Mine too. Thanks for the help.Comment
-
-
To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:
$config['SpecialUsers']['canrunqueries'] = 'x';
...with x being your userid number.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Not working for me...
This was an easy fix, yet even though I inserted my user name at the 'x':
$config['SpecialUsers']['canrunqueries'] = 'x';
Saved and over wrote the file on the server, it still replies with:
You are not authorized to execute SQL queries
Closed browser, relogged in, same thing. Check the file, overwrite again. Try over, same thing. I cannot get it to work? I am using version: 3.8.4
My user name is two upper case letters followed by my last name like this: "X X Xxx" Is the system picky about a two spaces in the user name? Don't know what else to try.Comment
-
Okay, I changed my User ID to XXXxx with no spaces, restarted the browser, and tried in IE and Firefox and it still reports:
You are not authorized to execute SQL queries
Anyone have an answer without wasting time pitching horseshoes?Comment
-
You need to use your user ID number (NOT YOUR USERNAME), which is the number at the end of the URL when you hover over your username in a post. On this forum, your userid is 233235. On your forum it will be different.
My userid on my forum is 12, therefore my line in the config file reads:
$config['SpecialUsers']['canrunqueries'] = '12';
Not throwing horseshoes. I'm correct, you're just doing it wrong, or not following instruction.Comment
-
Thanks, finally a detailed response.
I suppose if a person worked with their vBulletin at an installation level on occasion, such information would be a given, but some people have other prerogatives. It was the final explanation that revealed the missing details.
I know other people will scour for this obscure information in the future, therefore I will mention that “hovering” over the name does not produce any results. However, if you access Admin Control Panel, and search for your own user name under the USERS panel on the left, the User ID is displayed by your User Name as (id: x) top left.
Notice, no vague acronyms or “mind-readers try to guess” feedback, just clear defined directionsComment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment