6.0.0-beta13
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
4/11/26
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#12016] kronolith set wrong type_id
*
Your Email Address
*
Spam protection
Enter the letters below:
.___.__ .__..__.. . [__ | \| || ||__| [___|__/|__\|__\| |
Comment
> Here is mysqld.log when I create a new event with a tag: > > 130205 10:23:48 3510 Connect horde@localhost on horde > 3510 Query SET NAMES 'utf8' > 3510 Query SELECT 1 > 3510 Query SHOW CHARACTER SET > 3510 Query SELECT 1 > 3510 Query SET NAMES 'utf8' > 3511 Connect horde@localhost on horde > 3511 Query SET NAMES 'utf8' > 3511 Query SELECT 1 > 3511 Query SHOW CHARACTER SET > 3511 Query SELECT 1 > 3511 Query SET NAMES 'utf8' > 3511 Query SELECT 1 > 3511 Query SELECT g.group_uid AS group_uid, g.group_name AS > group_name FROM horde_groups g, horde_groups_members m WHERE > m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY > g.group_name > 3510 Query SELECT 1 > 3510 Query SELECT DISTINCT s.* FROM kronolith_shares s LEFT JOIN > kronolith_shares_users u ON u.share_id = s.share_id WHERE > s.share_owner = 'vangilst' OR (s.perm_creator & 2) OR (s.perm_default > & 2) OR ( u.user_uid = 'vangilst' AND (u.perm & 2)) ORDER BY > s.attribute_name ASC > 3511 Query SELECT 1 > 3511 Query SELECT g.group_uid AS group_uid, g.group_name AS > group_name FROM horde_groups g, horde_groups_members m WHERE > m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY > g.group_name > 3510 Query SELECT 1 > 3510 Query SELECT DISTINCT s.* FROM nag_shares s LEFT JOIN > nag_shares_users u ON u.share_id = s.share_id WHERE (s.share_owner = > 'vangilst' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR ( > u.user_uid = 'vangilst' AND (u.perm & 2))) ORDER BY s.attribute_name > ASC > 3510 Query SELECT 1 > 3510 Query SELECT * FROM nag_shares WHERE share_name = > 'Z2-15KN6MPKsOJYbOJTVuA1' > 3511 Query SELECT 1 > 3511 Query SELECT g.group_uid AS group_uid, g.group_name AS > group_name FROM horde_groups g, horde_groups_members m WHERE > m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY > g.group_name > 3510 Query SELECT 1 > 3510 Query SELECT DISTINCT s.* FROM nag_shares s LEFT JOIN > nag_shares_users u ON u.share_id = s.share_id WHERE (s.share_owner = > 'vangilst' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR ( > u.user_uid = 'vangilst' AND (u.perm & 2))) AND share_owner = > 'vangilst' ORDER BY s.attribute_name ASC > 3511 Query SELECT 1 > 3511 Query SELECT g.group_uid AS group_uid, g.group_name AS > group_name FROM horde_groups g, horde_groups_members m WHERE > m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY > g.group_name > 3510 Query SELECT 1 > 3510 Query SELECT DISTINCT s.* FROM nag_shares s LEFT JOIN > nag_shares_users u ON u.share_id = s.share_id WHERE (s.share_owner = > 'vangilst' OR (s.perm_creator & 6) OR (s.perm_default & 6) OR ( > u.user_uid = 'vangilst' AND (u.perm & 6))) ORDER BY s.attribute_name > ASC > 3511 Query SELECT 1 > 3511 Query SELECT g.group_uid AS group_uid, g.group_name AS > group_name FROM horde_groups g, horde_groups_members m WHERE > m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY > g.group_name > 3510 Query SELECT 1 > 3510 Query SELECT DISTINCT s.* FROM kronolith_shares s LEFT JOIN > kronolith_shares_users u ON u.share_id = s.share_id WHERE > (s.share_owner = 'vangilst' OR (s.perm_creator & 2) OR > (s.perm_default & 2) OR ( u.user_uid = 'vangilst' AND (u.perm & 2))) > AND s.share_owner = 'vangilst' ORDER BY s.attribute_name ASC > 3510 Query SELECT 1 > 3510 Query SELECT * FROM kronolith_shares WHERE share_name = > 'f0UhDsGiuZFPokNxbgrtcw1' > 3512 Connect horde@localhost on horde > 3512 Query SET NAMES 'utf8' > 3512 Query SELECT 1 > 3512 Query SHOW CHARACTER SET > 3512 Query SELECT 1 > 3512 Query SET NAMES 'utf8' > 3510 Query SELECT 1 > 3510 Query SELECT object_id, object_name FROM `rampage_objects` > WHERE object_name IN ('') AND type_id = 1 > 3512 Query SELECT 1 > 3512 Query INSERT INTO kronolith_events (event_id, event_uid, > event_creator_id, event_title, event_description, event_location, > event_timezone, event_url, event_private, event_status, > event_attendees, event_resources, event_modified, event_start, > event_end, event_allday, event_alarm, event_alarm_methods, > event_recurtype, calendar_id) VALUES ('A88Rpf0sRcGK8kwsEpfSBQ1', > '20130205092348.2SnZwK5ThzMY-vjbxxxVsg1@webmail2.domainfr', > 'vangilst', 'test', '', 'nowhere', '', '', 0, '2', 'a:0:{}', > 'a:0:{}', 1360056228, '2013-02-20 00:00:00', '2013-02-20 01:00:00', > 0, 0, 'a:0:{}', 0, 'f0UhDsGiuZFPokNxbgrtcw1') > 3513 Connect horde@localhost on horde > 3513 Query SET NAMES 'utf8' > 3513 Query SELECT 1 > 3513 Query SHOW CHARACTER SET > 3513 Query SELECT 1 > 3513 Query SET NAMES 'utf8' > 3513 Query SELECT 1 > 3513 Query SELECT * FROM horde_histories WHERE object_uid = > 'kronolith:f0UhDsGiuZFPokNxbgrtcw1:20130205092348.2SnZwK5ThzMY-vjbxxxVsg1@webmail2.domain.fr' > 3513 Query SELECT 1 > 3513 Query INSERT INTO horde_histories (object_uid, history_ts, > history_who, history_desc, history_action, history_extra) VALUES > ('kronolith:f0UhDsGiuZFPokNxbgrtcw1:20130205092348.2SnZwK5ThzMY-vjbxxxVsg1@webmail2.domain.fr', 1360056228, 'vangilst', NULL, 'add', > NULL) > 3510 Query SELECT 1 > 3510 Query SELECT object_id, object_name FROM `rampage_objects` > WHERE object_name IN > ('20130205092348.2SnZwK5ThzMY-vjbxxxVsg1@webmail2.domain.fr') AND > type_id = 1 > 3510 Query SELECT 1 > 3510 Query INSERT INTO `rampage_objects` (object_name, type_id) > VALUES ('20130205092348.2SnZwK5ThzMY-vjbxxxVsg1@webmail2.domain.fr', > 1) > 3510 Query SELECT 1 > 3510 Query SELECT user_id, user_name FROM `rampage_users` WHERE > user_name IN ('vangilst') > 3510 Query SELECT 1 > 3510 Query SELECT tag_id FROM `rampage_tags` WHERE LOWER(tag_name) > = LOWER('test_tag') > 3510 Query SELECT 1 > 3510 Query INSERT INTO `rampage_tags` (tag_name) VALUES ('test_tag') > 3510 Query SELECT 1 > 3510 Query SELECT 1 from `rampage_tagged` WHERE user_id = 1 AND > object_id = 1 AND tag_id = 1 > 3510 Query SELECT 1 > 3510 Query INSERT INTO `rampage_tagged` (user_id, object_id, > tag_id, created) VALUES (1, 1, 1, '2013-02-05T09:23:48') > 3510 Query SELECT 1 > 3510 Query UPDATE `rampage_tag_stats` SET count = count + 1 WHERE > tag_id = 1 > 3510 Query SELECT 1 > 3510 Query INSERT INTO `rampage_tag_stats` (tag_id, count) VALUES (1, 1) > 3510 Query SELECT 1 > 3510 Query UPDATE `rampage_user_tag_stats` SET count = count + 1 > WHERE user_id = 1 AND tag_id = 1 > 3510 Query SELECT 1 > 3510 Query INSERT INTO `rampage_user_tag_stats` (user_id, tag_id, > count) VALUES (1, 1, 1) > 3510 Query SELECT 1 > 3510 Query SELECT pref_scope, pref_name, pref_value FROM > horde_prefs WHERE pref_uid = 'vangilst' AND pref_scope = 'horde' > 3510 Query SELECT 1 > 3510 Query SHOW FIELDS FROM `horde_prefs` > 3510 Query SELECT 1 > 3510 Query SELECT pref_scope, pref_name, pref_value FROM > horde_prefs WHERE pref_uid = 'vangilst' AND pref_scope = 'kronolith' > 3510 Query SELECT 1 > > Any idea ? >
Attachment
Watch this ticket
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers