6.0.0-beta1
9/20/25

[#5967] syncml and duplicate address book in turba
Summary syncml and duplicate address book in turba
Queue Turba
Queue Version 2.2-RC1
Type Bug
State No Feedback
Priority 2. Medium
Owners
Requester lalot (at) univ-aix (dot) fr
Created 12/06/2007 (6498 days ago)
Due
Updated 01/07/2008 (6466 days ago)
Assigned 12/06/2007 (6498 days ago)
Resolved 01/07/2008 (6466 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
01/07/2008 01:06:29 PM Jan Schneider State ⇒ No Feedback
 
12/18/2007 06:52:42 PM Jan Schneider Comment #10 Reply to this comment
Have you been able to test this?
12/07/2007 04:06:14 PM lalot (at) univ-aix (dot) fr Comment #9 Reply to this comment
To eliminate any side-effects from the upgrading, did you try that
with a fresh, clean, unmodified installation?
No. I'm not able to do that before monday now. I suppose it will work. 
I can also ask somebody else to do another try with its data



Thanks



Dom
12/07/2007 12:06:13 PM Jan Schneider Comment #8 Reply to this comment
To eliminate any side-effects from the upgrading, did you try that 
with a fresh, clean, unmodified installation?
12/07/2007 11:42:28 AM lalot (at) univ-aix (dot) fr Comment #7 Reply to this comment
So, to summarize a long story: You upgraded successfully and
everything worked fine. Then you synchronized once and had your Turba
contacts successfully synced to your Palm.
Jan, it's a little bit longer story, at first I tried with a very 
little effort whithout the turba upgrade script. I synced notes and 
tasks successfully.

Contacts and agenda failed to finish. I tested in 1.0.3



So I decided the long jump to 1.1 rc1 and spent time to read scripts 
and run turba upgrade.

Then I was successfull with all. But I noticed a little bit after that 
in contacts, I got my most of my contacts duplicated (two entries)



I erased database, run all the scripts and sql updates. Synced at the 
first try.. smile!

But I've got the problem with contacts that I explained before.



I changed as little as possible config and prefs from the tar.gz. Just 
database settings and ldap global readonly reference from our 
university in turba. Haven't played with shares in that version.







On the next
synchronization these contacts were added to a new address book of
the same name. This new address book has the same permissions like
the first one, but you can't access it through the browse or search
views. Everything correct so far?
see above
Do you use shared address books, i.e. "'use_shares' => true" in
turba/config/sources.php and $conf['shares']['source'] set to your
address book in turba/config/conf.php?
<?php

/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */

// $Horde: turba/config/conf.xml,v 1.21 2007/10/16 16:14:48 mrubinsk Exp $

$conf['menu']['import_export'] = true;

$conf['menu']['apps'] = array();

$conf['client']['addressbook'] = 'localsql';

$conf['shares']['source'] = 'localsql';

$conf['comments']['allow'] = true;

$conf['documents']['type'] = 'horde';

/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */



and in sources.php localsql

     'use_shares' => true,
12/07/2007 11:04:43 AM Jan Schneider Comment #6 Reply to this comment
So, to summarize a long story: You upgraded successfully and 
everything worked fine. Then you synchronized once and had your Turba 
contacts successfully synced to your Palm. On the next synchronization 
these contacts were added to a new address book of the same name. This 
new address book has the same permissions like the first one, but you 
can't access it through the browse or search views. Everything correct 
so far?

Do you use shared address books, i.e. "'use_shares' => true" in 
turba/config/sources.php and $conf['shares']['source'] set to your 
address book in turba/config/conf.php?
12/07/2007 10:59:56 AM Jan Schneider Queue ⇒ Turba
Version ⇒ 2.2-RC1
 
12/07/2007 10:49:49 AM lalot (at) univ-aix (dot) fr Comment #5 Reply to this comment

[Show Quoted Text - 17 lines]
Agenda (kronolith)  H3 (2.1.5)                      L'application est prête

Carnet d'adresses (turba) H3 (2.1.4)                 L'application est prête

Courrier (imp) H3 (4.1.4)                 L'application est prête

Filtres (ingo) H3 (1.1)                 L'application est prête

Horde (horde) 3.1.4                 L'application est prête

Notes (mnemo) H3 (2.1)                 L'application est prête

Paramétrage du compte (myaccount)                 L'application est prête

Tâches (nag) H3 (2.1)                 L'application est prête





./turba/scripts/upgrades/2.1_to_2.2_sql_schema.php



and for other tables adapted from dump and scripts sql or ugrade



CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes 
(attribute_value(255));

CREATE TABLE horde_syncml_map (

     syncml_syncpartner VARCHAR(64) NOT NULL,

     syncml_db          VARCHAR(64) NOT NULL,

     syncml_uid         VARCHAR(64) NOT NULL,

     syncml_cuid        VARCHAR(64),

     syncml_suid        VARCHAR(64),

     syncml_timestamp   INT

);

CREATE INDEX syncml_cuid_idx ON horde_syncml_map (syncml_syncpartner, 
syncml_db, syncml_uid, syncml_cuid);

CREATE INDEX syncml_suid_idx ON horde_syncml_map (syncml_syncpartner, 
syncml_db, syncml_uid, syncml_suid);

CREATE TABLE horde_alarms (

     alarm_id        VARCHAR(250) NOT NULL,

     alarm_uid       VARCHAR(250) NOT NULL,

     alarm_start     DATETIME NOT NULL,

     alarm_end       DATETIME,

     alarm_methods   VARCHAR(255),

     alarm_params    TEXT,

     alarm_title     VARCHAR(255) NOT NULL,

     alarm_text      TEXT,

     alarm_snooze    DATETIME,

     alarm_dismissed TINYINT(1) DEFAULT 0 NOT NULL,

     alarm_internal  TEXT

);

CREATE INDEX alarm_id_idx ON horde_alarms (alarm_id);

CREATE INDEX alarm_user_idx ON horde_alarms (alarm_uid);

CREATE INDEX alarm_start_idx ON horde_alarms (alarm_start);

CREATE INDEX alarm_end_idx ON horde_alarms (alarm_end);

CREATE INDEX alarm_snooze_idx ON horde_alarms (alarm_snooze);

CREATE INDEX alarm_dismissed_idx ON horde_alarms (alarm_dismissed);

CREATE TABLE horde_cache (

     cache_id          VARCHAR(32) NOT NULL,

     cache_timestamp   BIGINT NOT NULL,

     cache_data        LONGBLOB,



     PRIMARY KEY  (cache_id)

);

ALTER TABLE kronolith_events ADD event_private INT DEFAULT 0 NOT NULL;

ALTER TABLE kronolith_events ADD event_recurcount INT;
In options: I only see one Dominique LALOT address book. So I am not
able to list/work with the other one
Do you see it in the "edit" drop down list too? If yes, what are the
permissions for both books?
same permissions: for me everything checked



Thanks



Dom
12/07/2007 10:23:03 AM Jan Schneider Comment #4 Reply to this comment
Did you change anything in Turba's default configuration or preferences?
If not, what happens if you explicitly save the "Address Books" group
of Turba's preferences?
Finally, what do you mean that the new address book only appears for
deleting?
No, in Edit address book too
To which question refers this answer? And what about the other questions?
I made a test using my prod database and followed instructions for
upgrading and turba has a script for that. I have no special setting
in options.
There is no documented upgraded path from older Turba versions to 
Horde Groupware 1.1RC1. So what exactly did you do, and where did you 
come from?
In options: I only see one Dominique LALOT address book. So I am not
able to list/work with the other one
Do you see it in the "edit" drop down list too? If yes, what are the 
permissions for both books?
12/07/2007 08:58:22 AM lalot (at) univ-aix (dot) fr Comment #3 Reply to this comment
Did you change anything in Turba's default configuration or preferences?
If not, what happens if you explicitly save the "Address Books" group
of Turba's preferences?
Finally, what do you mean that the new address book only appears for
deleting?
No, in Edit address book too



I made a test using my prod database and followed instructions for 
upgrading and turba has a script for that. I have no special setting 
in options.



In options: I only see one Dominique LALOT address book. So I am not 
able to list/work with the other one



Thanks



Dom
12/06/2007 09:25:41 PM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
Did you change anything in Turba's default configuration or preferences?

If not, what happens if you explicitly save the "Address Books" group 
of Turba's preferences?

Finally, what do you mean that the new address book only appears for deleting?
12/06/2007 08:54:55 AM lalot (at) univ-aix (dot) fr Comment #1
Priority ⇒ 2. Medium
State ⇒ Unconfirmed
New Attachment: hordesyncpb.png Download
Queue ⇒ Horde Groupware Webmail Edition
Summary ⇒ syncml and duplicate address book in turba
Type ⇒ Bug
Reply to this comment
syncml and turba



Well, syncml is working now using synthesis! Good news and well done!

My problem is that my address book is getting duplicated.



At first I had only my address book which is called with my name with 
just two entries. But syncing with my palm created another address 
book with my name and 300 entries.

The address book only appears for deleting. I can't search it. The 
sync says everything is OK.

There should be a test: two options (merging or creating another book 
with a unique name)



The data appears in the database dump so syncing is OK.. I joined an image



I have managed student and teachers emails with horde for years and 
I'm looking forward to get syncml working (and SSO CAS integrated too..)



Dominique



I followed instructions/scripts for migrating database

Saved Queries