Things are going a tad strange here, We imported everything to VB from phpbb, but thing that was strange was all the user titles got converted into user groups well I dont mind that I can try and fix it but to top it of all the users in the primary usergroups are no where to be seen when I go to usergroup manager, in registered user group (default one) it says 0 users, in all others there are either 1 or two, we have around 900 users and they all seem to be missing from any usergroup mentioned in the usergroup manager though those user exist when I search for them I can see their profile, their posts and everything.
Now going into phpmyadmin I go to vb3 database and this is what I see is that all users (besides me, the other admin and a few users I edited manually) everyone has "usergroupid" field set as 0
So what should I do I belive I need to run a sql querry which will update the usergroupid of all the users? am I correct? the id of usergroup administrator is 6, registered user is 2. I want all the users with usergroup id set as 0 to update to usergroup id 2, then I will promote the admins and mods manually so can anyone tell me the sql querry or is there another solution to this?
There also seems to be another problem when a new user registers he also goes into that mysterious userid=0 usergroup.
Now going into phpmyadmin I go to vb3 database and this is what I see is that all users (besides me, the other admin and a few users I edited manually) everyone has "usergroupid" field set as 0
So what should I do I belive I need to run a sql querry which will update the usergroupid of all the users? am I correct? the id of usergroup administrator is 6, registered user is 2. I want all the users with usergroup id set as 0 to update to usergroup id 2, then I will promote the admins and mods manually so can anyone tell me the sql querry or is there another solution to this?
There also seems to be another problem when a new user registers he also goes into that mysterious userid=0 usergroup.
Comment