Primary / Additional users moving issue

[stefaandk]

Managed to import all my phpBB stuff into VB and now I have 2 administrators groups and a imported_users group.

I moved all imported_users to registered users, and that all seems fine.

However I have got my 5 admins sitting in the phpbb administrators group but as additional users rather then primary ones.
These imported admins also did not list in imported_users btw

Not really sure about this additional vs primary users concept but the way I understand it is that users can belong to more then one group and get the permissions for both?

Anyways, I can't seem to migrate these phpbb admins to the VB admins using the User Moving/Pruning System
I can't even get these users to list in the find system.

Maybe I'm missing something here in my thinking? :cool:

[Jerry]

If you want to physically move them opposed to set up their usergroup permissions you can run this SQL :



UPDATE user SET usergroupid=6 WHERE usergroupid=X;



Where X is the id of the group they are in and 6 is your standard admin usergroup.

[stefaandk]

Must be an error in that syntax somewhere:

Did the following:

UPDATE user WHERE SET usergroupid=6 WHERE usergroupid=11;
And got"

#1064 - 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 'WHERE SET usergroupid=6 WHERE usergroupid=11' at line 1

I can run queries in phpmyadmin but don't ask me about the syntax I'm afraid :/

[Jerry]

Try it without the first WHERE, so :



UPDATE user SET usergroupid=6 WHERE usergroupid=X;


You might need a table prefix on user depending on your config.