Bug 96592 - Thunderbird Addressbook deleted records not reflected in Base
Summary: Thunderbird Addressbook deleted records not reflected in Base
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Thunderbird-Interoperability
  Show dependency treegraph
 
Reported: 2015-12-19 08:58 UTC by patufet99
Modified: 2023-04-11 12:00 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description patufet99 2015-12-19 08:58:07 UTC
I have observed that if I delete records from the Thunderbird AddressBook, these deletes seems not to be updated in Base. I am using LibreOffice 4.2.8.2 with Ubuntu 14.04, but have experienced the same with Windows 7. 

By looking at the content of the abook.map in ./thunderbird, deleted records are still there, but are not shown when retrieving the addresses directly from Thunderbird.

If I export the AddressBook from Thunderbird to a ldif file, delete abook.map and import the ldif file, the records are correct. I guess that there is some issue in how Thunderbird stores the data in abook.map and how LibreOffice reads it.
Comment 1 Robert Großkopf 2015-12-20 15:25:17 UTC
(In reply to patufet99 from comment #0) 
> By looking at the content of the abook.map in ./thunderbird, deleted records
> are still there, but are not shown when retrieving the addresses directly
> from Thunderbird.
> 
So Thunderbird isn't deleting the record but will only set them to something like unvisible in the GUI. Base shows the whole data, which are currently there. Why should this be a bug of LO-Base?
Comment 2 patufet99 2015-12-20 18:18:28 UTC
I cannot judge if this is a bug of LO Base or a problem of Thunderbird as I do not know the insights of how the data is stored in the abook.map file. I just filed the bug in the hope that the info could be useful to somebody!
Comment 3 patufet99 2015-12-20 20:19:35 UTC
I have found some additional information here:

http://mozilla.6506.n7.nabble.com/thunderbird-address-book-mork-deleted-rows-and-distribution-list-question-td182838.html

But it is not clear for me if the problem lies in the way that the mork database handles deleted records or in the LO Base parser.
Comment 4 Alex Thurgood 2015-12-21 07:23:05 UTC
@David : any idea whether this is a mork driver integration problem, or more to do with the way TB handles deleted records ?
Comment 5 DavidO 2015-12-21 07:34:12 UTC
(In reply to Alex Thurgood from comment #4)
> @David : any idea whether this is a mork driver integration problem, or more
> to do with the way TB handles deleted records ?

This is indeed a good question, TBH I don't know (yet).

One information wasn't mentioned in this report: What operation system is used? In case of Windows, our mork dirver wasn't used at all. But ancient seamonkey mozilla driver was used. Note, that this driver was removed on master. Since 5.1 our native mork driver will be used on both 32 and 64 bit Windows platform.
Comment 6 patufet99 2015-12-21 07:45:01 UTC
In windows I used Win7 64 bit, Thunderbird 38.4.0. And LibreOffice 5.0.4.2.
Comment 7 DavidO 2015-12-21 16:28:36 UTC
(In reply to patufet99 from comment #6)
> In windows I used Win7 64 bit, Thunderbird 38.4.0. And LibreOffice 5.0.4.2.

What bitness version of LibreOffice are you using?

* 32 bit: ancient seamonkey mozilla driver is used (was removed on master)
* 64 bit: mork driver is used

But anyway, someone could test it on Linux and report here there result. On Linux we always use mork driver in latest LO releases.
Comment 8 patufet99 2015-12-21 16:33:05 UTC
LO 5.0.4.2, 64 bit.
As mentioned on my original post with Ubuntu 14.04 the behaviour is the same. Ubuntu is 64 bit as well.
Comment 9 Alex Thurgood 2016-01-04 17:01:38 UTC
Confirming on

Version: 5.2.0.0.alpha0+
Build ID: 21f152a52397bf99364e5dc5ba9519e11452f260
CPU Threads: 2; OS Version: -; UI Render: default; 
Locale : fr-FR (fr.UTF-8)

OSX 10.11.2

I created a new entry in a TB addressbook (personal addresses) that had no other entries.

I then created a new ODB file that connected to the TB address book. When I opened the ODB file, I can see the single entry in the personal address table.

I then closed LibreOffice and went back to Thunderbird. Opened the address book manager and deleted the single address in it.

Next, I reopened the ODB file and double clicked on the table "personal'. It opened to show the deleted entry, i.e. it hadn't been changed / removed accordingly.
Comment 10 QA Administrators 2017-03-06 14:09:22 UTC Comment hidden (obsolete)
Comment 11 Alex Thurgood 2018-03-28 07:16:29 UTC
Bug still present in LO 6.0.2.1
Comment 12 QA Administrators 2019-03-29 04:02:34 UTC Comment hidden (obsolete)
Comment 13 B Kirby 2019-12-19 23:59:51 UTC
Not quite sure how to fill one of these comments out (e.g. what status it should have - so left as NEW), but I can confirm that deleted records from the Thunderbird AddressBook still show up in the Base database created when generating labels from a mailing list.
I am using
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: threaded
Comment 14 QA Administrators 2022-12-10 03:22:26 UTC Comment hidden (obsolete)
Comment 15 Robert Großkopf 2022-12-10 07:34:57 UTC
Shouldn't we close this bug? Thunderbird addressbook isn't connectable any more. You have to use a connection through SQlite instead. See Bug 138715
Comment 16 Alex Thurgood 2022-12-10 13:08:03 UTC
(In reply to Robert Großkopf from comment #15)
> Shouldn't we close this bug? Thunderbird addressbook isn't connectable any
> more. You have to use a connection through SQlite instead. See Bug 138715

Probably, but does the problem also exist when using sqlite over ODBC? If it does, then this bug report should probably remain open.