"You are not authorized to execute SQL queries"

[Dave234]

When I click AdminCP > Maintenance > Execute SQL Query, I can't get in, and I receive the following pop-up message:

You are not authorized to execute SQL queries

I am the Administrator on my website. Why can't I get in? I can get in on my other website.

[kh99]

In your config.php file is this line:

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

you need to add your userid there.

[Dave234]

Where can I find the config.php file?

[kh99]

sorry - that's in the includes subdirectory.

[Dave234]

Not sure exactly where the includes subdirectory is.....

Can you please help me by letting me know exactly where I can find it? For example, AdminCP > _______ > __________

I really appreciate it.

[kh99]

No problem. But it's not a setting in the adminCP, you need to edit the includes/config.php file. Download your current config.php file via ftp, edit it to make the change (use a programming editor or notepad), then upload it, overwriting the current file. This is the same file that has your database connection information that was set up when the forum was installed.

If you're unsure about doing this, you might want to edit a copy of the file (or save it to a different place after editing). That way if something goes wrong you can upload the original file again and you should be back where you were.

[Dave234]

I honestly have no idea how to do this. I have ftp, but how would I download the current config.php file?

[John Lester]

Start your FTP program. Then (assuming your forums are in a "forums" folder) open the forums folder, then open the includes folder, then download the file config.php

--------------- Added [DATE]1346653882[/DATE] at [TIME]1346653882[/TIME] ---------------

If you do not know what your userid is, go to your ACP and then click on users then click on search for users, enter your name and at the very top you will see your userid (above the drop down box above your name).

[borbole]

Originally Posted by Dave234

I honestly have no idea how to do this. I have ftp, but how would I download the current config.php file?

Navigate to the folder mentioned above and then download the file in question to your pc and after entering your user id at the place mentioned above, save the changes and then re-upload the file back overwriting the old one and you should be all done.

Alternatively you can do that through the file manager section in your cpanel, provided it has it.

[Dave234]

I'm very nervous about messing with the config.php file from the ftp. I right-clicked and chose "View/Edit", and it opened it automatically in WordPad. I found the part of the code you were talking about, and I see that my userid is not there.

Regarding what my userid is, I did what you said, John Lester, in AdminCP, and above my name it says: "User: El Luchador Rubio (id: 1)". Does this mean I would enter "1" in the config.php?

I am very nervous about messing with the config.php file through ftp. Borbole, you say that I could access it through the file manager section in my cpanel? Can you please tell me where I can find that? For example, AdminCP > _______ > __________ ? I looked all through it and I can't see anything that says "File Manager".....