No announcement yet.

How To ENABLE 'Execute SQL Query'?

  • Time
  • Show
Clear All
new posts
  • mark99
    Senior Member
    • Oct 2002
    • 118

    How To ENABLE 'Execute SQL Query'?

    Two things:

    1) Despite being the main admin, I still get 'You are not authorized to execute SQL queries', when trying to use the Execute SQL system.

    2) What QUERY should I run (exactly) to default everybodies profile to using the 'StandardControls' instead of the basic option?
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    The answer to your second question lies in resolving access to the first question

    Goto config.php and set yourself up as superadmin and to the variable canrunqueries. Hopefully this will then give you the permissions, otherwise goto the admin permissions section and set yourself up to have every permission.

    Good luck
    Last edited by Floris; Wed 4 Feb '04, 4:32am.


    • Daveh
      Senior Member
      • Apr 2002
      • 152
      • 3.6.x

      In config.php there is something along the lines of $canrunqueries. Add you user number to that.


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