[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [Bug #1779] Users appear twice in User Selection
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [Bug #1779] Users appear twice in User Selection dropdown |
Date: |
Mon, 25 Nov 2002 15:20:15 -0500 |
=================== BUG #1779: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1779&group_id=509
Changes by: Dave Hall <address@hidden>
Date: 2002-Nov-26 07:20 (Australia/Melbourne)
------------------ Additional Follow-up Comments ----------------------------
Floriant,
Did you try my suggestion below? Also what authentication system are you using.
Erwann,
I will see what floriant's response is, but i am likely to reassign this one to
our ldap hacker.
Cheers
=================== BUG #1779: FULL BUG SNAPSHOT ===================
Submitted by: floriant Project: phpGroupWare
Submitted on: 2002-Nov-22 20:25
Category: calendar Bug Group: 0.9.14 release
Severity: 5 - Major Priority: Normal
Resolution: None Assigned to: skwashd
Status: Open Component Version: TGZ
Platform Version: Linux - Debian Reproducibility: Intermittent
Summary: Users appear twice in User Selection dropdown
Original Submission: A user came to me and complained that she is listed twice
in the user selection dropdown in the calendar. The assigned events differ.
It often happens on her account but I cannot reproduce it anywhere else
Follow-up Comments
*******************
-------------------------------------------------------
Date: 2002-Nov-26 07:20 By: skwashd
Floriant,
Did you try my suggestion below? Also what authentication system are you using.
Erwann,
I will see what floriant's response is, but i am likely to reassign this one to
our ldap hacker.
Cheers
-------------------------------------------------------
Date: 2002-Nov-25 19:16 By: erwann
This problem apears when you create users thanks to LDAP (for example. I think
the problem is the same if you use a mailing list).
In fact, users are in a group (for example Default) which exists (which is in
phpgw_accounts), and in a group which doesn't exists (this is this account
which is bad).
I think using LDAP create a group by user, and when you say "all users are in
this or this group" it's possible that some "bad" groups exist, and duplicate
users.
You must just delete the duo (group,user) in phpgwp_acl where group isn't in
phpgw_accounts.
Erwann
-------------------------------------------------------
Date: 2002-Nov-23 19:49 By: skwashd
Hi,
I had this issue once before. It relates to problems with the acl table.
First back up all your data.
I would suggest running this SQL on your db ... note it is designed for mysql
but should work on others.
SELECT account_id FROM phpgw_accounts;
Note down all those accounts
Then
SELECT * FROM phpgw_acl WHERE acl_account NOT IN (list from above seperated by
commas);
like so:
SELECT * FROM phpgw_acl WHERE acl_account NOT IN (1,2,3,4);
Then use the appropriate SQL to deleted the stray records.
This should fix it. Please remember to backup all your data.
Good luck and please tell me how you go.
Cheers
CC list is empty
No files currently attached
For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1779&group_id=509