sql theory authorisation?

  • Time
  • Show
Clear All
new posts
  • dgaf555
    New Member
    • Sep 2006
    • 7

    sql theory authorisation?

    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.

  • Marco van Herwaarden
    Senior Member
    • Nov 2004
    • 6999
    • 3.8.x

    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:

    // 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.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org


    • dgaf555
      New Member
      • Sep 2006
      • 7

      Thankyou all sorted!


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.