OTA-24 Devel/RC potential contacts data loss

flohack

While trying to roll out a new backend for contacts and addressbook data we faced some regressions that led us to the decision to revert the entire feature for now and work on it later.
As many of you have already updated their devices to the latest devel or RC image you will now have to deal with the following issue: As the new feature involved changing databases a onetime migration was made, copying all old contacts to a new database. Contacts added/modified/deleted after Sep 28 2022 will now be reset or be missing. The contacts backend will again use the old database.

Please go to your address-book App and export all contacts before you install latest devel or RC. In case you forget to do so there is a potential SQL query that can help with that. We will publish it in this thread later.

Thanks for your patience and understanding!

flohack

So the SQL statement would be:

sqlite3 -header -csv /home/phablet/.local/share/system/privileged/Contacts/qtcontacts-sqlite/contacts.db "SELECT DisplayLabels.displayLabel,Names.firstName, Names.lastName,PhoneNumbers.phoneNumber, EmailAddresses.emailAddress, Contacts.modified FROM Contacts LEFT JOIN DisplayLabels ON DisplayLabels.contactId = Contacts.contactId LEFT JOIN EmailAddresses ON EmailAddresses.contactId = Contacts.contactId  LEFT JOIN Names ON Names.contactId = Contacts.contactId LEFT JOIN Nicknames ON Nicknames.contactId = Contacts.contactId LEFT JOIN PhoneNumbers ON PhoneNumbers.contactId = Contacts.contactId WHERE Contacts.collectionId = 1 ORDER BY Contacts.modified DESC;" > /home/phablet/Documents/contactsfromnewbackend.csv

It outputs to Documents/contactsfromnewbackend.csv (csv with comma separation)

domubpkm

Hello @Flohack
There was a proposed update in RC tonight. Before install it, is it test version of OTA-24 or other RC to come? Thanks

flohack

@domubpkm Hello, this RC is the final candidate for OTA-24