In order to run manual SQL queries from within the AdminCP, you need to edit your "includes/config.php" file to add your userid to the list of users permitted to run such queries.
Look for this section in the file:
PHP Code:
/* #### 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. */
$config['SpecialUsers']['canrunqueries'] = '';
Add your userid to the last line. Suppose your userid is 1, then you would want:
PHP Code:
/* #### 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. */
$config['SpecialUsers']['canrunqueries'] = '1';