Issue with default settings for registered users

[SeanThomps]

Hello,

The imported users all are having to turn on private-messaging, and notification, and some other options. Is there anyway I can set all of their default options for them?

[Jerry]

Which system did you import from and have you moved the users from the imported usergroup into the default registered one ?

You can mass alter user settings via :

AdminCP -> Import & Maintenance -> Execute SQL Query

[SeanThomps]

I moved from invisionboard 1.3 Jerry, and when I tried to do what you said it told me that I am not authorized to do SQL Queries!!!.. :( How can I enable such a permission? I am the only Administrator.

[Steve Machol]

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** 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.
$canrunqueries = 'x';

...with x being your userid number.

[SeanThomps]

Thanks!