sql theory authorisation?

[dgaf555]

Hi, i've tried searching to no avail.

I am tying to execute a sql theory but it keeps telling me i need authorisation, how do i achieve this? i am admin on my site but it says i don't have authorisation. Is there something i need to do first?

thanks for the help.

Scott

[Marco van Herwaarden]

To run queries from the Admin CP:

Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

Then enter your query in the Manual Query box and click on 'Continue'.

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:

// ****** 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 = 'x';

...with x being your userid number.

[dgaf555]

Thankyou all sorted!