Open Bug 1676987 Opened 5 years ago Updated 5 years ago

Thunderbird v78+ does not convert all ADDRESS BOOKS to SQLITE

Categories

(Thunderbird :: Address Book, defect)

defect

Tracking

(Not tracked)

UNCONFIRMED

People

(Reporter: marcolopespt, Unassigned)

References

()

Details

(Keywords: dataloss)

Attachments

(2 files)

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.111 Safari/537.36

Steps to reproduce:

Upgraded from v68

Actual results:

Few address books were NOT converted

Expected results:

Address books should be converted

Tried all that i can think of
Export and imported address books... converted to 78... same problem!
Don't know what else to do :
Can't revert to v68

I gave up!

I EXPORTED all the address books on v68 (CSV)
UPGRADED to v78
DELETED all the address books from the UI
RESTARTED
DELETED few new empty address books from the UI (there was something really wrong after de update!)
IMPORTED all the address books (CSV)
All address books were created in order (SQL version)

NOTE: had to review ALL the mail RULES, because they were messed up (when the books were deleted)

A guess that's the best approach. I will keep the latest version.

Please retain/copy your original .mab files for testcases - without them we won't be able to determine what caused the migration issue.

In your directory list, I see an .sqlite file for every .mab file. Did version 78 list every address book, but some were partial or empty?

Component: Migration → Address Book
Flags: needinfo?(marcolopespt)

Few of them were empty (the ones that did not create the BAK file)
Also, there was an address book with "no name" in the UI after de update
Even deleting all the "converted" address books (and the empty one!) after restart, there were 2 new EMPTY address books!
This is not related to the MAB files only, i assume there is some configuration on other file that i don't know of.

Flags: needinfo?(marcolopespt)

Empty address book after update

If you're willing, send me the bak files and I can try to reproduce. The prefs.js file could also be useful.
Without testcases, I don't think there's much we could do.

marco, did you connect with Magnus?

Flags: needinfo?(marcolopespt)
Keywords: dataloss

Also, here are instructions from bug 1678939

Your address books went through an upgrade process the first time you opened Thunderbird 78. Obviously this has gone wrong somewhere. There should be backup files in your profile folder, so you can try to do the upgrade again. I'd suggest doing just one initially so you can see if it's working or not.

Here's the steps to do:

  • In Thunderbird's config editor find the entries for a particular book, they'll be named ldap_2.servers.something.…. Change the one named dirType from 101 to 2. Change the one named filename from something.sqlite to something.mab.
  • Close Thunderbird.
  • In your profile folder delete something.sqlite and rename something.mab.bak to something.mab.
  • Open Thunderbird and see if it worked. If not, open the Error Console (under Tools, Developer Tools on the menu) and see what's written there. Copy and paste it here as it may help us figure out what's happened.

(In reply to Wayne Mery (:wsmwk) from comment #7)

marco, did you connect with Magnus?

Not yet. I will send a few address books that were not converted.

Flags: needinfo?(marcolopespt)

(In reply to Wayne Mery (:wsmwk) from comment #8)

Also, here are instructions from bug 1678939

Your address books went through an upgrade process the first time you opened Thunderbird 78. Obviously this has gone wrong somewhere. There should be backup files in your profile folder, so you can try to do the upgrade again. I'd suggest doing just one initially so you can see if it's working or not.

Here's the steps to do:

  • In Thunderbird's config editor find the entries for a particular book, they'll be named ldap_2.servers.something.…. Change the one named dirType from 101 to 2. Change the one named filename from something.sqlite to something.mab.
  • Close Thunderbird.
  • In your profile folder delete something.sqlite and rename something.mab.bak to something.mab.
  • Open Thunderbird and see if it worked. If not, open the Error Console (under Tools, Developer Tools on the menu) and see what's written there. Copy and paste it here as it may help us figure out what's happened.

Reconverting did nothing (same result). Tried it few times with backups. Until i gave up, EXPORTED all the address books to CSV on v68 and IMPORTED them all on v78. Had to rebuild the mail rules, and moved on...

(In reply to marcolopespt from comment #9)

(In reply to Wayne Mery (:wsmwk) from comment #7)

marco, did you connect with Magnus?

Not yet. I will send a few address books that were not converted.

SENT to Mangus email.

(In reply to marcolopespt from comment #11)

(In reply to marcolopespt from comment #9)

(In reply to Wayne Mery (:wsmwk) from comment #7)

marco, did you connect with Magnus?

Not yet. I will send a few address books that were not converted.

SENT to Mangus email.

Sorry, Magnus! :D

See Also: → 1678939, 1653558, 1680936, 1681685
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: