vb_user options field

[David Fordham]

I am wanting to force all my users to accept emails from the admin. Is there an easy SQL update that one can run?

Thanks

[Dismounted]

Admin CP > Maintenance > Execute SQL Query > Automatic Query

[David Fordham]

Hmm, this is odd but even as the admin, I get a message saying I am not authorized to run SQL.

Any insight here. I cannot find that permission anywhere.

[Dismounted]

You have to add your userid to the list for 'Users with SQL Query Running Permissions' in config.php.

[David Fordham]

This is now in my config.php file in my includes directory:

// ****** 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['blog_admin']['canrunqueries'] = '1';

yet I am still getting the same error...

David

[ragtek]

blog admin? wtf

the name of the variable is
$config['SpecialUsers']['canrunqueries'] = '1';

is this the config.php of a blog maybe?

in forums/includes/config.php there have to be this: $config['SpecialUsers']['canrunqueries'] = '1';