farce308

I've installed Mambo 4.5.1. To that I've added the phpbb integration. Everything worked like a charm, I set up some forums, added some users, beautiful stuff.

Then I screwed up. When adding a new user from the admin/adduser panel, the problem began. Admin signed out when I hit submit. The user seems to have been added. I could sign into and out of the forum, but not the rest of the site using the new user name and password. Also, in the admin panel user menu, the label said there were four users, but only three showed up. Well, I puzzled this out for a while, doing some searching in the support boards. A couple of other people have had the same problem with the standard insallation- low and behold there was a patch posted called "repairuseracl.php" that looked like it should do the trick. I installed it, it said "repaired" but it did not fix the problem.

I began digging in the sql - dumb move I know and here's where I think I may have blown it.

By this time, I had added several users. None were showing up in the admin panel and errors were starting to appear upon submission. I found two sql tables that looked like they contained the user info, mos_users and mos_userbackup. The mos_user table had lots of extra fields related to phpbb. It all seemed to make sense so I started deleting all of the non-functional user lines. I think I deleted one too many. There was one with an id of "0" that included a label somewhere in it saying anonymous but not much else. From the way things are behaving now, I'm guessing id=0 was running the new user stuff, but it's gone. AARGHH.

Now, when I try to add a new user, I get the error:

"mosuser::store failed Duplicate entry '0' for key 1 SQL=INSERT into mos_users(lists user fields) VALUES (lists field names)

Can anyone give me fieldvalues for that anonymous user in id=0 or do I need to scrap the whole installation and start over - (please no).

Thanks for any help you can offer.

Bob Stevenson

farce308

I've solved the problem and thought it proper form to let people know how.

It turns out that with phpbb installed, new users have to be added through phpbb. They cannot be added through the admin panel because, well, I think because it doesn't have all the same fields that would be needed. Once the person's been added in phpbb, they can be seen and edited through the admin panel. For example, I needed to change someone from a registered user to an author. This is fine to do in the admin panel AFTER adding them through phpbb.

As far as the id=0 thing. I installed a second copy of mambo with phpbb then copied the fields. It was anonymous I had deleted but his id number is -1. I think this is only an issue in the php combine though.

Thanks for this space to help me think things through. I may be a newbie but I'm a damned determined one. (three hours later)

-Bob Stevenson