Changes are not saved

[ygoe]

Steps to reproduce

1. Open a contact
2. Focus the organisation field and enter a name
3. Open another contact
4. Open the first contact again

Expected behaviour

Organisation should be there

Actual behaviour

Organisation is empty again

Server configuration

Operating system: Ubuntu Linux

Web server: Apache 2.4

Database: PostgreSQL 10

PHP version: 7

Nextcloud version: current

Contacts version: current

Updated from an older Nextcloud or fresh install: Fresh install

[skjnldsv]

Hey!
Have you updated to the latest? In includes a fix for this exact issue :)

[syntron]

It seems to be that I have the same issue; I also found it reported as #402 and #405. However, here I'm using the latest version of nextcloud (13.0.1.1 with Contact 2.1.3). It seems to be that only (if at all) the first change to a contact is saved. All later change get the respons 'Contact could not be saved'. In the server logs, I find http error code 400 for the first request and 412 for the later ones. The same error seems to occur if the update is done using davdroid; at least I find the same error codes in the log without any change to the data.

I will try to provide additional information as needed.

Some data:

• nextcloud version 13.0.1.1 (updated; first install was an owncloud version)
• contact version 2.1.3
• web server apache 2.4.23 with php 7.0.7
• database: mariadb 10.0.34 (on another VM)
• OS opensuse 42.3
• latest working version: as far as I remember some nextcloud 12.x version (~ end of 2017)

[syntron]

I also found #462, #501 and #507; any hints how to debug? or how to solve the problem? As far as I understood the comments this seems to be linked to a server issue?

[skjnldsv]

Hello @syntron :)
Can you screenshot the network tab of your browser's dev tools after the error?

1. load the page
2. open devtools
3. do one edit
4. do a second edit (error 412?)
5. screenshot the network tab like this:
   

[syntron]

@skjnldsv - here is the screenshot:

I noticed that it is specific to some contacts. My data has this problem. As mentioned elsewhere, it could be related to the wedding day I added at a time. However, currently it is not even displayed anymore ...

[skjnldsv]

Okay, that's what I thought. The first save failed as well. Can you click on it and copy the response tab here please? :)

[syntron]

Here is the error message: <?xml version="1.0" encoding="utf-8"?> <d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns"> <s:exception>Sabre\DAV\Exception\BadRequest</s:exception> <s:message>Calendar object with uid already exists in this calendar collection.</s:message> </d:error> It seems to be the same error as mentioned in the other issues. I also tested it with other contacts which do not use two dates (birthday, etc.). These work. Any way I can test it using MyPHPAdmin or other tools?

[syntron]

Here another finding: - the first change gets an error response but it is saved; i.e. if I click on another contact and then back to the first one, the first change is stored - any change after the first one is not stored - up to now I only found this one contact (my own) with the bug; all other seems to work (in nextcloud) - I found the data in the mysql table; below the used tags are shown (table oc_cards; content of carddata): BEGIN:VCARD VERSION:3.0 PRODID:-//Sabre//Sabre VObject 4.1.2//EN X-KADDRESSBOOK-X-ANNIVERSARY:<YYYY-MM-DD> X-KADDRESSBOOK-X-SPOUSESNAME:<NAME> UID:dcbe6380-37fc-4895-84a9-55d48e1dad0f FN:<NAME with spaces> N:<NAME with ;> TEL;TYPE=cell:+49 <NUMBER> TEL;TYPE=home:+49 <NUMBER> TEL;TYPE=WORK,CELL:+49 <NUMBER> EMAIL;TYPE=home:<EMAIL> ADR;TYPE=home;LABEL=<PLACE; separated by \n>:;;<PLACE; separated by ';'> NOTE:<NOTES; separated by \n> BDAY:<YYYYMMDD> REV:20180426T180849Z CATEGORIES:<CATEGORIES> END:VCARD The entry was edited by nextcloud and kontact (kde). The Kontact related entries (X-KADDRESSBOOK-X... and the \n separated part of ADR) are not found in table oc_cards_properties. However, all other entries match (and also the ; separated part of ADR). I noticed however, that the 3 TEL entries are separated by TYPE= in the vcard (oc_cards) but are only marked as TEL in the table oc_cards_properties. Could this be a reason that sometimes the telephone number is listed twice or more times? Since yesterday (?), this contact is no longer shown in Kontact. I also just noticed that approx. half the contacts are not visible in Kontact. Furthermore, davdroid sync seems to have problems; new contacts are not created in nextcloud. I will report separate issues after I could test these cases more thoroughly. I hope this helps ...

[skjnldsv]

Hey, thanks a lot :)
This helps very much indeed. There is an uid issue. For some reson there is already a calendar entry with the same uid. Could you look at your calendarobjects table and search for this uid :/

[syntron]

No - both tables have only one entry with the uid.
oc_cards_properties as value for name UID; oc_cards in field uri as .vcf

[syntron]

Sorry - I check the wrong tables ...

In calendarobjects the uid exists 3 times for 2 different calender IDs. Can I delete / recreate all contacts related entries somehow?

[skjnldsv]

@georgehrke do you know what are these table used for?
It seems we have a collision here (which is very unlikely, so it's strange)
@syntron can you dump the data here? from the calendarobject table?

[syntron]

@skjnldsv which data do you need exactly? I'm hesitating to post all the contact data stored in the table ...

[georgehrke]

There was an issue related to UIDs not being unique, but it was fixed with Nextcloud 13.0.1:
nextcloud/server#8678

[syntron]

It could be what the fields were add to the nextcloud instance at versions < 13.0.1.

Is were a simple way to (re)generate the data? My best idea is to export all contacts => delete them => import.

[syntron]

I did a save/export => delete on server => restore/import cycle and now it seems to work

[ygoe]

Bug seems gone, with Nextcloud 13.0.2, without having investigated any of the details mentioned here.

[syntron]

note: before this I did update to the latest version (13.0.2)

[brettferrell]

I get this exact behavior in 30.0.2/2.1.3

[StreamThreader]

13.0.2 same error

[skjnldsv]

Okay everyone :)
Thanks for reporting. Since I can't be sure you're all reporting the same issue (same consequences but maybe not same cause). Please create you rown issues and complete the proper format. That includes your browser console log. Thanks a lot! :)

Since this issue is fixed, I'm closing. Please open new ones so we can handle them individually! 🙏