Add all members to the registered members group

[Kuja]

After an import pass, all users were imported properly, but not into any groups.

What's a query that would add all users to the registered members group?

Thanks

[Andy Huang]

Simply delete the group they are currently in will move everyone into the registered users group.

[Kuja]

They're not in *any* group - that's the problem!

[Kuja]

*bump*

[Andy Huang]

Back up your user table, then try this query:
UPDATE user SET usergroupid = '2' AND membergroupids = '' AND displaygroupid = '0';

And then:
UPDATE user SET usergroupid = '6' WHERE username = 'YOURUSERNAMEHERE';


The first one should set everyone, including yourself, to registered user group. The second one should promote you to administrator. If the second query does not work, upload the tool.php found in the donotupload directory to your admincp folder and run it from your web browser to promote yourself to admin.