[Tickets #13417] Re: no entry in rampage_tagged when tag added

[noreply at bugs.horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/13417
------------------------------------------------------------------------------
  Ticket           | 13417
  Aktualisiert Von | michael at bigmichi1.de
  Zusammenfassung  | no entry in rampage_tagged when tag added
  Warteschlange    | Mnemo
  Version          | 4.2.1
  Typ              | Bug
  Status           | Feedback
  Priorität        | 1. Low
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


michael at bigmichi1.de (2014-08-06 06:24) hat geschrieben:

ok i must say that i was wrong there is an entry added but with a  
user_id of display_notepad variable that appears in links for that  
notapad. you can see this in the following sql-statement:

select *
from
rampage_tags tags
inner join rampage_tagged tagged on (tags.tag_id = tagged.tag_id)
inner join rampage_users users on (tagged.user_id = users.user_id)
inner join rampage_objects objects on (objects.object_id = tagged.object_id)
inner join rampage_types types on (objects.type_id = types.type_id)
where
tags.tag_id = 13

this results in:
tag_id	tag_name	user_id	object_id	tag_id	created	user_id	user_name	object_id	object_name	type_id	type_id	type_name
13	Steam	2	1340	13	2013-09-13  
16:54:47	2	michael at bigmichi1.de	1340	14	2	2	bookmark
13	Steam	2	1341	13	2013-09-13  
17:10:05	2	michael at bigmichi1.de	1341	15	2	2	bookmark
13	Steam	2	1342	13	2013-09-13  
17:20:09	2	michael at bigmichi1.de	1342	16	2	2	bookmark
13	Steam	2	1343	13	2013-09-13  
17:23:53	2	michael at bigmichi1.de	1343	17	2	2	bookmark
13	Steam	2	1388	13	2013-09-29  
09:04:16	2	michael at bigmichi1.de	1388	18	2	2	bookmark
13	Steam	2	1401	13	2013-10-15  
09:11:34	2	michael at bigmichi1.de	1401	19	2	2	bookmark
13	Steam	2	1777	13	2014-06-12  
12:43:02	2	michael at bigmichi1.de	1777	20140612124302.AS-CLNF4ZYH4A_kgwQKtAA9 at horde.bigmichi1.de	4	4	event
13	Steam	18	1857	13	2014-08-05  
08:24:20	18	kl3tY3acZCTtCXTp_SyXkA2	1857	5371bb2b-2ac8-4c87-9072-6c38bc286502	7	7	note
13	Steam	18	1858	13	2014-07-11  
20:25:34	18	kl3tY3acZCTtCXTp_SyXkA2	1858	53ba94ef-9654-47c2-a431-7680bc286502	7	7	note
13	Steam	18	1859	13	2014-07-11  
20:25:49	18	kl3tY3acZCTtCXTp_SyXkA2	1859	5371bae4-139c-4214-9049-6c38bc286502	7	7	note


for events and bookmarks the username is used in this table and for  
notes not, but all are created by the same user and the notepad is the  
personal one not a shared one