[Tickets #12016] Re: 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
  Updated By         | patrick.vangilst at labri.fr
  Summary            | kronolith set wrong type_id
  Queue              | Kronolith
  Version            | 4.0.3
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


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

I i try:
horde-db-migrate -d kronolith 17 | tee /root/krono_down.log

I can see this DB statement in my log file:
== 18 KronolithUpgradeCategoriesToTags: Migrating event tags to  
categories. ===
-- select('SELECT event_uid, event_category, event_creator_id,  
calendar_id FROM kronolith_events')
2013-02-04T15:48:29+00:00 DEBUG: SQL  (0.0004s)
         SELECT event_uid, event_category, event_creator_id, calendar_id FROM
           kronolith_events
    -> 0.0010s
2013-02-04T15:48:29+00:00 DEBUG: SQL  (0.0003s)
         SELECT object_id, object_name FROM `rampage_objects` WHERE object_name
           IN ('20130204154545.bOl19mYTouD2XSgXk7t5aQ2 at webmail2.domain.fr') AND
           type_id = 2

But nothing happens since type_id=1....

Then if I run:
  horde-db-migrate -d kronolith 18 | tee /root/krono_up.log

I can see:

== 18 KronolithUpgradeCategoriesToTags: Migrating event categories to  
tags. ===
-- select('SELECT event_uid, event_category, event_creator_id,  
calendar_id FROM kronolith_events')
2013-02-04T15:53:43+00:00 DEBUG: SQL  (0.0001s)
         SELECT event_uid, event_category, event_creator_id, calendar_id FROM
           kronolith_events
    -> 0.0005s
2013-02-04T15:53:43+00:00 DEBUG: SQL  (0.0002s)
         SELECT object_id, object_name FROM `rampage_objects` WHERE object_name
           IN ('20130204154545.bOl19mYTouD2XSgXk7t5aQ2 at webmail2.domain.fr') AND
           type_id = 2
2013-02-04T15:53:43+00:00 DEBUG: SQL  (0.0062s)
         INSERT INTO `rampage_objects` (object_name, type_id) VALUES
           ('20130204154545.bOl19mYTouD2XSgXk7t5aQ2 at webmail2.domain.fr', 2)

Now I have the correct type_id in database.....