Make editable/delete-able all phones in addressbook/ contacts

asked 2016-07-15 00:27:35 +0300

nas
491 ●13 ●26 ●32

Ahoy sailors! Since I synced my contacts from my old nokia phone to my Jolla using Bluetooth, I couldn't edit/ delete the telephone numbers that came from my previous phone. The new ones - entered on Jolla, worked fine. I just found a way that made them editable! Here it is what did I do:

As root I wrote in shell(command line):

sqlite3 /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/contacts.db

There I run the following query:

UPDATE "main"."Details" SET "accessConstraints" = '0'

and it worked like a charm ;)

Some WARNINGs:
-- MAKE BACKUPS BEFORE YOU DO ANYTHING!
-- of course do it at your own risk, just because it worked fine for me, doesn't mean it will have the same (happy) results on you
-- who knows? maybe it could brick your contacts db / phone

and some explanations:
-- I opened the contacts.db and I searched to find the difference between old and new phone numbers. The field "accessConstraints" in Details table, when the phone number was from my old phone was set to "3", new numbers were "0". I run the query and did the trick.

I sincerely hope someone else before me find out that, posted it here and I was the last Jolla user who more than 2 years now couldn't edit/ delete phone numbers imported from old phone, but I didn't find any other solution until now...