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 |
driver. Are you sure are using the MySQL driver?
though adding the group doesn't succeed. There isn't anything we can
do about that.
users to each group without any issues prior to the upgrade
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.
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.
though adding the group doesn't succeed. There isn't anything we can
do about that.
Groups Database Tables, the entries are not added or removed
respectively when the admin action is performed
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.
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.
relative to managing groups, unfortunately.
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
to managing groups, unfortunately.
Thank You
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"]
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
State ⇒ Feedback
Priority ⇒ 2. Medium
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Summary ⇒ Groups will not update
Type ⇒ Bug
Queue ⇒ Horde Groupware Webmail Edition
1. Using MYSQL Driver
2. Cannot add new group
3. Cannot delete member from existing group
4 Cannot add member to existing group