Announcement

Collapse
No announcement yet.

Execute SQL Query - Executed the Query, now site is down

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Execute SQL Query - Executed the Query, now site is down

    Hello, and thank you for trying to assist me.

    While trying to execute an SQL querie using:

    Maintenance
    Execute SQL Query

    I get the following error:

    You are not authorized to execute SQL queries

    After contacting support I was told I needed to edit the config.php file. So, I added the following line at the bottom of the file (as support was not very helpful at all, I didn't know where else to put it):

    $config['SpecialUsers']['canrunqueries'] = '1;

    I saved the file, and went into my site's Admin CP. I went to:

    Maintenance
    Execute SQL Query

    After clicking on Execute SQL Query, the Admin CP went blank. All attempts to access the site or Admin CP result in errors or blank screens. Can anyone assist me?

    The website is xdebate.com and the forums are in xdebate.com/forums

    Any help is greatly appreciated. Thank you.
    Regards,
    Lou


    xDebate.com - Present Your Case!

  • #2
    I fixed it by uploading a backup copy of the config.php file.
    Regards,
    Lou


    xDebate.com - Present Your Case!

    Comment


    • #3
      You had missed a single quote, on the end of the line.

      Comment

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