Just looked at the bridge manager and lost all groups and members

[bumbo]

I have IPB 1.3 running and CPG 1.48 so a bridge is not possible . But,Tonite I was being stupid and looking at admin features . I started up the bridge manager just to see what it did , got to the point where I needed to enter the relative path  to my BBS config file and stopped. Closed down CPG .  Now when I log in as admin and look at users I see only Administrators group , all my other groups and members have gone. Any idea what went wrong and if I can fix it ?  I tried to add back a member that was missing and got duplicate message so CPG is still using the database for logins just seems that the admin screen cant list them any longer. Any help is appreciated.  Also if I go back and look at bridge manager is shows as disabled.

Coppermine install : http//glband.org/membersarea/CPGfoto   
Forum Install: http://glband.org/forum
Coppermine version : cpq1.4.8
Forum Version: IPB v1.3
Test account : test/test

Bridge : Never set

[Joachim Müller]

Your coppermine gallery (which is actually at http://glband.org/membersarea/CPGfoto ) is protected with .htaccess-authorization, so I can't take a look. If the bridge is disabled, go to your groups page and try a re-sync.

[bumbo]

You are now authorized with same id/pw .  Not sure I understand resync at groups page sorry .

[Stramm]

Your coppermine gallery (which is actually at http://glband.org/membersarea/CPGfoto ) is protected with .htaccess-authorization, so I can't take a look. If the bridge is disabled, go to your groups page and try a re-sync.

pwd doesn't work, neither for the forum nor th .htaccess on the CPG folder. PLease retry and make sure the testuser account can access the site(s).

Resync... if the bridge shows disabled, try to enable it again and set the group permissions as necessary

[Joachim Müller]

@Stramm: worked for me, try again please.

@bumbo: Erm, OK - I should have clarified: whenever you (as admin) go to the groups page, you trigger a re-sync of groups. You probably have already done so, but as you haven't said that your issue is solved, I guess your issue still persists. So, let's dig deeper: when you ran the bridge manager, this is what happened: in each step, the database table cpgXXX_bridge is being populated with the settings you make. However, during those steps, nothing is suppossed to happen, as the stuff in this table is not being taken into account unless you finally enable bridging (which is done with a switch in coppermine's config table). I'm not sure how anything bad could have happened from running the bridge manager, as you say you never enabled it. However, let's try to find the culprit - use a tool like phpMyAdmin, browse coppermine's bridge table and finally clean it (i.e. delete all records from that table, but don't delete the entire table). Then go back to coppermine, groups manager again and try if it works then.

[Stramm]

yep, works now and things look pretty good. I'm logged in as 'Registered' user. So your groups are still there. Eventually they just don't show up. Maybe due to some wrong entries in the bridge table as GauGau already mentioned.

Manually cleaning it or enabling/ disabling the bridge should help (last possibility will leave additional groups behind and different group permissions)

[bumbo]

deleted records (I could see where it had updated the URL to my forum ) left table intact. Went back to CPG logged as an admin user , opened groups still see same. I see the 3 administrators and the test ID created for this session as registered user.

[bumbo]

Using phpMYAdmin I can see all users in the database and the corresponding group codes. The last record added was the test ID also. So the data is there for some reason groupmgr.php just isnt reporting it any longer. In the groups screen Administrators , Registered, Guests and Banned are the groups listed.

[Joachim Müller]

OK, try this: using phpMyAdmin, go to coppermine's users table and check a record of a user who is suppossed to show up but doesn't. Check the group id recod of that user. Then check the groups table: is there a record that corresponds to the group id the missing user is in? If not, then we have found the main culprit.

[bumbo]

Ok here is an example. 

cpg148_users has a person with user_group of 7 .  This person used to be a member of "Middle School" group.

cpg148_usergroups only contains 4 group_id  1 thru 4 .

I will try to add back the groups I had before and see if they will pick up their members . Just guessing this is next step , if not I can delete them

When I try to add a group it adds 2 instead of 1 and the group name is blank for both in the list . I looked at the database and its adding hem as group_id 16 and 17 also instead of 5 , 6 which would be the next logical group ids.

Ok ... I manually edited the groups in myPHP and made group ids and group names as they needed to be and it is picking up my members . Will advise if able to do all of them and solve this problem.

[bumbo]

Solved. Thanks for leading me to a solution. It is odd that the first new group began at group_id 16 when all I had was through 8. To summarize, I added group records on the groups page , then manually edited the values using myPhpAdmin to the group_ids and group_names I needed. Now all my users and groups appear once again.  Thanks again. I am not going to mess with bridge manager again