[Tickets #2822] NEW: New Contact Addition errors

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=2822
-----------------------------------------------------------------------
 Ticket             | 2822
 Created By         | aread-horde at localnet.com
 Summary            | New Contact Addition errors
 Queue              | Turba
 Version            | 2.0.4
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


aread-horde at localnet.com (2005-10-20 12:57) wrote:

Horde 3.0.5, mysql prefs backend, php 4.3.10
When adding a new contact to an addressbook, after hitting submit, the page
reloads a few times, then sits there(no confirmation of addition).  Browsing
the addressbook shows that 2-3 copies of the entry have been added.  From
mysql logs the following query is bring run, which returns >30k rows.  I
have included some data on that table as it is configured on my server. 
This error has just started to creep up(I assume as the number of
entries/time required for the select grew).  Upgrading from the previous
version of Turba and Horde had no effect.  This is beginning to become a big
problem.

                   1228 Query       SELECT datatree_id, datatree_name,
datatree_
parents, datatree_order FROM horde_datatree WHERE (datatree_parents LIKE
':2%' O
R datatree_id = 2) AND group_uid = 'horde.history'

mysql> explain horde_datatree;
+---------------------+---------------+------+-----+---------+-------+
| Field               | Type          | Null | Key | Default | Extra |
+---------------------+---------------+------+-----+---------+-------+
| datatree_id         | int(11)       |      | PRI | 0       |       |
| group_uid           | varchar(255)  |      | MUL |         |       |
| user_uid            | varchar(255)  |      | MUL |         |       |
| datatree_name       | varchar(255)  |      | MUL |         |       |
| datatree_parents    | varchar(255)  |      |     |         |       |
| datatree_order      | int(11)       | YES  |     | NULL    |       |
| datatree_data       | text          | YES  |     | NULL    |       |
| datatree_serialized | smallint(6)   |      | MUL | 0       |       |
| datatree_updated    | timestamp(14) | YES  |     | NULL    |       |
+---------------------+---------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

mysql> explain SELECT datatree_id, datatree_name, datatree_parents,
datatree_order FROM horde_datatree WHERE (datatree_parents LIKE ':2%' OR
datatree_id = 2) AND group_uid = 'horde.history';
+----------------+------+----------------------------+------+---------+-----
-+-------+------------+
| table          | type | possible_keys              | key  | key_len | ref 
| rows  | Extra      |
+----------------+------+----------------------------+------+---------+-----
-+-------+------------+
| horde_datatree | ALL  | PRIMARY,datatree_group_idx | NULL |    NULL | NULL
| 30421 | where used |
+----------------+------+----------------------------+------+---------+-----
-+-------+------------+
1 row in set (0.00 sec)