phpgroupware-tracker
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]