[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: |
Sat, 23 Nov 2002 03:49:53 -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-23 19:49 (Australia/Melbourne)
What | Removed | Added
---------------------------------------------------------------------------
Assigned to | None | skwashd
------------------ Additional Follow-up Comments ----------------------------
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
=================== 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-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