6.0.0-alpha12
6/6/25

[#9838] Groups will not update
Summary Groups will not update
Queue Horde Groupware Webmail Edition
Queue Version 1.2.9
Type Bug
State No Feedback
Priority 2. Medium
Owners
Requester mailroom (at) bijurdelimon (dot) com
Created 04/07/2011 (5174 days ago)
Due
Updated 07/13/2011 (5077 days ago)
Assigned 04/08/2011 (5173 days ago)
Resolved 07/13/2011 (5077 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
07/13/2011 02:19:55 PM Jan Schneider State ⇒ No Feedback
 
07/01/2011 08:19:34 PM Jan Schneider Comment #15 Reply to this comment
Similar issues have been reported for Horde 4 when using the MySQLi 
driver. Are you sure are using the MySQL driver?
04/19/2011 05:50:20 PM mailroom (at) bijurdelimon (dot) com Comment #14 Reply to this comment
Well, then the database or the DB library don't return an error even 
though adding the group doesn't succeed. There isn't anything we can 
do about that.
This function was working before as we added two groups and multiple 
users to each group without any issues prior to the upgrade

04/19/2011 05:48:36 PM mailroom (at) bijurdelimon (dot) com Comment #13 Reply to this comment
These queries is the history backend logging the successful adding of
groups to the backend. That code is only reached if there was no
error adding groups. That means that your groups must have been added
somewhere. Since you seem to be able to *list* groups though, I can
only imagine that you use a split write/read database setup, and the
writes are not synchronized to the slave database.
Could this be a stale group cache issue?
Just to be sure, I tried the following:

1.  Went to Horde Config/ Groups and disabled caching.
2.  Copied the new generated config file
3.  Logged Out of Horde
4.  Restarted IIS
5.  Logged into Horde
6.  Went into groups and tried to delete a user by putting a check 
mark and clicking save
7.  Result at top said the group was updated and the users name no 
longer appeared
8.  Clicked on another group
9.  Went back into the 1st group and the user I tried to remove was 
still there
10.  Checked the database table and the user's entry still remains.

04/19/2011 05:47:23 PM Jan Schneider Comment #12 Reply to this comment
Well, then the database or the DB library don't return an error even 
though adding the group doesn't succeed. There isn't anything we can 
do about that.
04/19/2011 05:35:11 PM mailroom (at) bijurdelimon (dot) com Comment #11 Reply to this comment

[Show Quoted Text - 19 lines]
We are using a single dedicated MYSQL installation.  Checking the 
Groups Database Tables, the entries are not added or removed 
respectively when the admin action is performed

04/19/2011 04:09:47 PM Michael Rubinsky Comment #10 Reply to this comment
These queries is the history backend logging the successful adding 
of groups to the backend. That code is only reached if there was no 
error adding groups. That means that your groups must have been 
added somewhere. Since you seem to be able to *list* groups though, 
I can only imagine that you use a split write/read database setup, 
and the writes are not synchronized to the slave database.
Could this be a stale group cache issue?
04/19/2011 03:59:51 PM Jan Schneider Comment #9 Reply to this comment
Unfortunately the SQL group driver doesn't log any queries, but:

[Show Quoted Text - 10 lines]
These queries is the history backend logging the successful adding of 
groups to the backend. That code is only reached if there was no error 
adding groups. That means that your groups must have been added 
somewhere. Since you seem to be able to *list* groups though, I can 
only imagine that you use a split write/read database setup, and the 
writes are not synchronized to the slave database.
04/18/2011 04:13:57 PM mailroom (at) bijurdelimon (dot) com Comment #8 Reply to this comment
Any update on this?
No...and the log you provided doesn't contain any information 
relative to managing groups, unfortunately.
I think that might be a part of the issue.  I turned on Debugging for 
logging then performed the previously described actions (with the 
previously described results) and this is all that was logged.  Is 
there something perhaps I am missing to try or do you have anything 
else I should try?

Thanks again



04/15/2011 08:24:01 PM Michael Rubinsky Comment #7 Reply to this comment
Any update on this?
No...and the log you provided doesn't contain any information relative 
to managing groups, unfortunately.
04/15/2011 07:19:19 PM mailroom (at) bijurdelimon (dot) com Comment #6 Reply to this comment
Any update on this?

Thank You
04/08/2011 05:02:41 PM mailroom (at) bijurdelimon (dot) com Comment #5 Reply to this comment
Are there any errors in the (PHP and Horde) logs?
I turned on DEBUG logged and went to perform the function to add a 
group.  This is what I found in the log

I went to Groups, selected the top level and added a group called 
test.  UI said test added successfully and it showed as new group.   
Clicked on the group and it went back to the main group listing with 
the new group not showing.

(paths were changed for security reasons)

Apr 08 12:43:13 HORDE [debug] [horde] SQL Query by 
SessionHandler_mysql::_read(): query = "SELECT session_data FROM 
horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' 
FOR UPDATE" [pid 12320 on line 139 of 
"M:\x\lib\Horde\SessionHandler\mysql.php"]
Apr 08 12:43:13 HORDE [debug] [horde] SQL query by 
Horde_Alarm_sql::_list(): SELECT alarm_id, alarm_uid, alarm_start, 
alarm_end, alarm_methods, alarm_params, alarm_title, alarm_text, 
alarm_snooze, alarm_internal FROM horde_alarms WHERE alarm_dismissed = 
0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR alarm_snooze <= 
?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid IS NULL OR 
alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, alarm_end [pid 
12320 on line 151 of "M:\x\lib\Horde\Alarm\sql.php"]

Apr 08 12:43:14 HORDE [debug] [horde] SQL Query by 
SessionHandler_mysql::_read(): query = "SELECT session_data FROM 
horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' 
FOR UPDATE" [pid 12320 on line 139 of 
"M:\x\lib\Horde\SessionHandler\mysql.php"]
Apr 08 12:43:14 HORDE [debug] [horde] Session data unchanged (id = 
aq2le5e5eop23p6194cqhbv9v1) [pid 12320 on line 264 of 
"M:\x\lib\Horde\SessionHandler.php"]

Apr 08 12:43:17 HORDE [debug] [horde] SQL Query by 
SessionHandler_mysql::_read(): query = "SELECT session_data FROM 
horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' 
FOR UPDATE" [pid 12320 on line 139 of 
"M:\x\lib\Horde\SessionHandler\mysql.php"]
Apr 08 12:43:17 HORDE [debug] [horde] Session data unchanged (id = 
aq2le5e5eop23p6194cqhbv9v1) [pid 12320 on line 264 of 
"M:\x\lib\Horde\SessionHandler.php"]

Apr 08 12:43:17 HORDE [debug] [horde] SQL Query by 
SessionHandler_mysql::_read(): query = "SELECT session_data FROM 
horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' 
FOR UPDATE" [pid 12320 on line 139 of 
"M:\x\lib\Horde\SessionHandler\mysql.php"]
Apr 08 12:43:17 HORDE [debug] [horde] SQL query by 
Horde_History::getHistory(): SELECT * FROM horde_histories WHERE 
object_uid = ?, values: horde:group:3 [pid 12320 on line 244 of 
"M:\x\lib\Horde\History.php"]
Apr 08 12:43:17 HORDE [debug] [horde] SQL query by 
Horde_History::log(): INSERT INTO horde_histories (history_id, 
object_uid, history_ts, history_who, history_desc, history_action, 
history_extra) VALUES (?, ?, ?, ?, ?, ?, ?), values: 
2189,horde:group:3,1302280997,user@user.com,,add, [pid 12320 on line 
217 of "M:\x\lib\Horde\History.php"]
Apr 08 12:43:17 HORDE [debug] [horde] SQL query by 
Horde_Alarm_sql::_list(): SELECT alarm_id, alarm_uid, alarm_start, 
alarm_end, alarm_methods, alarm_params, alarm_title, alarm_text, 
alarm_snooze, alarm_internal FROM horde_alarms WHERE alarm_dismissed = 
0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR alarm_snooze <= 
?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid IS NULL OR 
alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, alarm_end [pid 
12320 on line 151 of "M:\x\lib\Horde\Alarm\sql.php"]

Apr 08 12:43:18 HORDE [debug] [horde] SQL Query by 
SessionHandler_mysql::_read(): query = "SELECT session_data FROM 
horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' 
FOR UPDATE" [pid 15516 on line 139 of 
"M:\x\lib\Horde\SessionHandler\mysql.php"]
Apr 08 12:43:18 HORDE [debug] [turba] Hook _horde_hook_share_init in 
application horde not called. [pid 15516 on line 1736 of 
"M:\x\lib\Horde.php"]
Apr 08 12:43:18 HORDE [debug] [turba] SQL query by 
Horde_Share_sql::listShares: SELECT DISTINCT s.*  FROM turba_shares s   
LEFT JOIN turba_shares_users u ON u.share_id = s.share_id LEFT JOIN 
turba_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner = 
'user@user.com' OR (s.perm_creator & 4) OR (s.perm_default & 4) OR ( 
u.user_uid = 'user@user.com' AND (u.perm & 4)) OR (g.group_uid IN 
('1') AND (g.perm & 4)) ORDER BY s.share_name ASC [pid 15516 on line 
469 of "M:\x\lib\Horde\Share\sql.php"]
Apr 08 12:43:18 HORDE [debug] [turba] Cache hit: 
perm_sql_exists_turba:sources:localsql (Id 
9bc50e66eeb54ada9a0cc36981d3424a newer than 1302194598) [pid 15516 on 
line 175 of "M:\x\lib\Horde\Cache\sql.php"]
Apr 08 12:43:19 HORDE [debug] [kronolith] Hook _horde_hook_share_init 
in application horde not called. [pid 15516 on line 1736 of 
"M:\x\lib\Horde.php"]
Apr 08 12:43:19 HORDE [debug] [kronolith] SQL query by 
Horde_Share_sql::listShares: SELECT DISTINCT s.*  FROM 
kronolith_shares s  LEFT JOIN kronolith_shares_users u ON u.share_id = 
s.share_id LEFT JOIN kronolith_shares_groups g ON g.share_id = 
s.share_id WHERE s.share_owner = 'user@user.com' OR (s.perm_creator & 
2) OR (s.perm_default & 2) OR ( u.user_uid = 'user@user.com' AND 
(u.perm & 2)) OR (g.group_uid IN ('1') AND (g.perm & 2)) ORDER BY 
s.attribute_name ASC [pid 15516 on line 469 of 
"M:\x\lib\Horde\Share\sql.php"]
Apr 08 12:43:19 HORDE [debug] [kronolith] 
Kronolith_Driver_sql::listEventsConditional(): user = "user@user.com"; 
query = "SELECT event_id, event_uid, event_description, 
event_location, event_private, event_status, event_attendees, 
event_keywords, event_title, event_category, event_recurcount, 
event_recurtype, event_recurenddate, event_recurinterval, 
event_recurdays, event_start, event_end, event_alarm, event_modified, 
event_exceptions, event_creator_id FROM kronolith_events WHERE 
calendar_id = ? AND event_alarm > ? AND ((event_end >= ?) OR 
(event_recurenddate >= ? AND event_recurtype <> ?))"; values = 
"user@user.com,0,2011-04-08 00:00:00,2011-04-08 00:00:00,0" [pid 15516 
on line 318 of "M:\x\kronolith\lib\Driver\sql.php"]
Apr 08 12:43:19 HORDE [debug] [nag] Hook _horde_hook_share_init in 
application horde not called. [pid 15516 on line 1736 of 
"M:\x\lib\Horde.php"]
Apr 08 12:43:19 HORDE [debug] [nag] SQL query by 
Horde_Share_sql::listShares: SELECT DISTINCT s.*  FROM nag_shares s   
LEFT JOIN nag_shares_users u ON u.share_id = s.share_id LEFT JOIN 
nag_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner = 
'user@user.com' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR ( 
u.user_uid = 'user@user.com' AND (u.perm & 2)) OR (g.group_uid IN 
('1') AND (g.perm & 2)) ORDER BY s.attribute_name ASC [pid 15516 on 
line 469 of "M:\x\lib\Horde\Share\sql.php"]
Apr 08 12:43:19 HORDE [debug] [nag] SQL alarms list by user@user.com
table = nag_tasks; query = "SELECT * FROM nag_tasks WHERE task_owner = 
? AND task_alarm > 0 AND (task_due - (task_alarm * 60) <= ?) AND 
task_completed = 0" [pid 15516 on line 514 of 
"M:\x\nag\lib\Driver\sql.php"]
Apr 08 12:43:19 HORDE [debug] [nag] SQL query by 
Horde_Share_sql::listShares: SELECT DISTINCT s.*  FROM nag_shares s   
LEFT JOIN nag_shares_users u ON u.share_id = s.share_id LEFT JOIN 
nag_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner = 
'user@user.com' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR ( 
u.user_uid = 'user@user.com' AND (u.perm & 2)) OR (g.group_uid IN 
('1') AND (g.perm & 2)) ORDER BY s.attribute_name ASC [pid 15516 on 
line 469 of "M:\x\lib\Horde\Share\sql.php"]
Apr 08 12:43:19 HORDE [debug] [mnemo] Hook _horde_hook_share_init in 
application horde not called. [pid 15516 on line 1736 of 
"M:\x\lib\Horde.php"]
Apr 08 12:43:19 HORDE [debug] [mnemo] SQL query by 
Horde_Share_sql::listShares: SELECT DISTINCT s.*  FROM mnemo_shares s   
LEFT JOIN mnemo_shares_users u ON u.share_id = s.share_id LEFT JOIN 
mnemo_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner = 
'user@user.com' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR ( 
u.user_uid = 'user@user.com' AND (u.perm & 2)) OR (g.group_uid IN 
('1') AND (g.perm & 2)) ORDER BY s.attribute_name ASC [pid 15516 on 
line 469 of "M:\x\lib\Horde\Share\sql.php"]
Apr 08 12:43:19 HORDE [debug] [mnemo] SQL query by 
Horde_Share_sql::listShares: SELECT DISTINCT s.*  FROM mnemo_shares s   
LEFT JOIN mnemo_shares_users u ON u.share_id = s.share_id LEFT JOIN 
mnemo_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner = 
'user@user.com' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR ( 
u.user_uid = 'user@user.com' AND (u.perm & 2)) OR (g.group_uid IN 
('1') AND (g.perm & 2)) ORDER BY s.attribute_name ASC [pid 15516 on 
line 469 of "M:\x\lib\Horde\Share\sql.php"]






04/08/2011 02:45:34 PM Jan Schneider Comment #4 Reply to this comment
Are there any errors in the (PHP and Horde) logs?
04/08/2011 01:46:28 PM mailroom (at) bijurdelimon (dot) com Comment #3 Reply to this comment
Why not?
Not quite sure.  The UI indicates that the update and/or deletion is 
successful but upon refresh the deleted item remains or added item is 
not there.  Checked DB table and finding the same - item is either 
still there or not added

04/08/2011 12:46:59 PM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
Why not?
04/07/2011 07:50:52 PM mailroom (at) bijurdelimon (dot) com Comment #1
Priority ⇒ 2. Medium
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Summary ⇒ Groups will not update
Type ⇒ Bug
Queue ⇒ Horde Groupware Webmail Edition
Reply to this comment
After upgrading to 1.2.9, Groups no longer update

1.  Using MYSQL Driver
2.  Cannot add new group
3.  Cannot delete member from existing group
4  Cannot add member to existing group

Saved Queries