Execute SQL Query (In admincp)

[JaNa]

Hullo,

Not quite sure if this is right forum, but it's sorta a SQL problem.

I'm trying to "Execute SQL Query" to install a mod I just downloaded. The only problem is, when I click on it, it says "You are not authorized to execute SQL queries"

How would I change it so I could run it? :tired:

[Boofo]

You need to set that setting in the config.php file. ;)

[JaNa]

Well I already have....*uh oh*

[Zachery]

Are you running vB3 or vB2?

[JaNa]

Oh, sorry. VB3

[JaNa]

ugh come on, what's wrong with it?

This is what i've put...

// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$superadministrators = '1,jana';

[Zachery]

USERID NOT USERNAME

USERID is a NUMBER
USERNAME is a TEXT

You just need to enter your USERID

[JaNa]

My USERID was already there, I just put my USERNAME to test...

[Zachery]

If your userid was there you should have permission to execute the Query

[Zachery]

To run a query


// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = '1';

[Boofo]

To run a query


// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = '1';

I was trying to point out NOT to use commas with only 1 number.

[JaNa]

Bleh. I got it working, thanks for your support.

* JaNa Jumps in joy :D