[nanaimobar]

Originally Posted by mikewastaken

in your include/config.php file, find the following

	//	****** 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'] = '';

Usually the first person is admin, which is you. So put in '1'.

Hi mikewastaken,

Changed config - which worked like a charm - but when I ran query I got this error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$result = mysql_query("SELECT forumid, title FROM forums order by forumid desc")' at line 1

The mysql version running the site is 4.1.22
and core tables haven't been changed. Site is running vbulletin 3.7.4.