• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
UBports Robot Logo UBports Forum
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

OTA-24 Devel/RC potential contacts data loss

Scheduled Pinned Locked Moved OS
4 Posts 2 Posters 609 Views 2 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • F Offline
      flohack
      last edited by 9 Nov 2022, 20:18

      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!

      My languages: πŸ‡¦πŸ‡Ή πŸ‡©πŸ‡ͺ πŸ‡¬πŸ‡§ πŸ‡ΊπŸ‡Έ

      1 Reply Last reply Reply Quote 2
      • F Offline
        flohack
        last edited by 9 Nov 2022, 20:24

        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)

        My languages: πŸ‡¦πŸ‡Ή πŸ‡©πŸ‡ͺ πŸ‡¬πŸ‡§ πŸ‡ΊπŸ‡Έ

        1 Reply Last reply Reply Quote 1
        • U UBportsNews referenced this topic on 9 Nov 2022, 22:24
        • D Offline
          domubpkm
          last edited by 11 Nov 2022, 06:19

          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

          F 1 Reply Last reply 11 Nov 2022, 20:29 Reply Quote 0
          • F Offline
            flohack @domubpkm
            last edited by 11 Nov 2022, 20:29

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

            My languages: πŸ‡¦πŸ‡Ή πŸ‡©πŸ‡ͺ πŸ‡¬πŸ‡§ πŸ‡ΊπŸ‡Έ

            1 Reply Last reply Reply Quote 1
            2 out of 4
            • First post
              2/4
              Last post