[Tickets #4732] Re: New, faster datatree history migration script

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=4732
-----------------------------------------------------------------------
 Ticket             | 4732
 Updated By         | josh at endries.org
 Summary            | New, faster datatree history migration script
 Queue              | Horde Base
 Version            | 3.1.3
 Type               | Enhancement
 State              | New
 Priority           | 1. Low
 Owners             | 
-----------------------------------------------------------------------


josh at endries.org (2006-12-05 06:46) wrote:

One thing I've noticed with some more testing is that I have some datatree
elements that don't have any attributes. These rows don't get deleted from
the old history database, and I'm not sure if they are supposed to or not.
Here is a snip of these rows:

mysql> SELECT c.datatree_id, c.datatree_name, c.datatree_parents,
c.datatree_order FROM horde_datatree c WHERE c.group_uid = 'horde.history'
order by datatree_id;
+-------------+---------------------------------------------------------+------------------+----------------+
| datatree_id | datatree_name                                           |
datatree_parents | datatree_order |
+-------------+---------------------------------------------------------+------------------+----------------+
|           4 | nag                                                     | 
                |           NULL |
|          13 | imp                                                     | 
                |           NULL |
|          17 | turba                                                   | 
                |           NULL |
|          18 | localsql                                                |
:17              |           NULL |
|         342 | horde                                                   | 
                |           NULL |
|         343 | group                                                   |
:342             |           NULL |
|        1285 | kronolith                                               | 
                |           NULL |
|        3401 | user at foo.com                            | :17             
|           NULL |