[Tickets #12016] kronolith set wrong type_id

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12016
------------------------------------------------------------------------------
  Ticket             | 12016
  Created By         | patrick.vangilst at labri.fr
  Summary            | kronolith set wrong type_id
  Queue              | Kronolith
  Version            | 4.0.3
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


patrick.vangilst at labri.fr (2013-02-04 13:35) wrote:

Hi,
I'm setting up a fresh new install of Horde Webmail Edition  5.0.3  
with Kronolith 4.0.3 on RHEL 6.3 with php-5.3.3.
Starting whith an empty database, I create an event in the default  
calendar and it seems that the initial database setup sets wrong  
type_id in rampage_types table.
Here are my sql statements:

mysql> select * from rampage_types;
+---------+-----------+
| type_id | type_name |
+---------+-----------+
|       1 | calendar  |
|       2 | event     |
|       3 | task      |
+---------+-----------+

mysql> select * from rampage_objects;
+-----------+----------------------------------------------------------+---------+
| object_id | object_name                                               
| type_id |
+-----------+----------------------------------------------------------+---------+
|         1 |  
20130204125127.1iaIcsxax7sCZckU1QabJA8 at webmail2.domain.fr |       1 |
|         3 |  
20130204125519.nx1NVCc7PIHcjwaThqvk8A1 at webmail2.domain.fr |       1 |
|         2 | RLfoTY0wyPu5wP7W2Tp5Rg9                                   
|       2 |
+-----------+----------------------------------------------------------+---------+

mysql> select share_id, share_name, attribute_name from  
kronolith_sharesng where share_name='RLfoTY0wyPu5wP7W2Tp5Rg9';
+----------+-------------------------+--------------------+
| share_id | share_name              | attribute_name     |
+----------+-------------------------+--------------------+
|        2 | RLfoTY0wyPu5wP7W2Tp5Rg9 | Agenda de <my_name> |
+----------+-------------------------+--------------------+

Here we can see that this share_name is a calendar (agenda), but in  
rampage_objects table, the type_id is 2 (event).
It's the same for the events (type_id=1, calendar)....

This is annoying when migrating from my old H3 db to this new H5  
install, because I can't see tags for events (sql statement looking  
for type_id=1 for events, thus displaying no tags...)

Is there something wrong with my install, or is it a bug ?