Bug 387804 - Create folder in KAddressBook fails
Summary: Create folder in KAddressBook fails
Status: CONFIRMED
Alias: None
Product: kaddressbook
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-12-11 19:45 UTC by Ricardo Garos
Modified: 2022-08-17 05:30 UTC (History)
6 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
Screenshot of KAddressBook create folder error message. (55.99 KB, image/png)
2017-12-11 19:45 UTC, Ricardo Garos
Details
Saved log from akonadiconsole (5.06 KB, text/plain)
2020-02-09 19:21 UTC, Matthias Weiss
Details
AkonadiConsole Query Debugger tab with failed and successful queries (227.98 KB, image/png)
2020-07-14 21:36 UTC, Stephen Peterson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ricardo Garos 2017-12-11 19:45:03 UTC
Created attachment 109323 [details]
Screenshot of KAddressBook create folder error message.

I've tried to create a subfolder in the Address book (called "Personal Contacts"), however this gives an error message everytime:

'Could not create address book folder: Unable to append mimetype for collection new resourceId: 4'

It is possible to Add another 'Address Book', and rename the new entry, however if you delete something from one of them it also deletes the data in the other books?

So I want to create a folder instead, however this does not work either.
Comment 1 piedro 2019-03-08 01:06:28 UTC
Hello! 

I have the same problem "creating collcetion fails" when creating any subfolder in any address bbok. 

The Workaround is to create a lot of *.vcf-card folder addressbooks (also in theses I cannot create a  subfolder!) and in consequence clutter the adressbook. 

If this is the intended way of workflow here then please remove the option to add subfolders - it's not working. 

Does anyone use this functionality successfully or is it just that nobody cares about it anyway? I am confused - creating subfolders ina an addressbook seems like a core functionality of any address and contacts organizer... 

WHat's up?
Comment 2 piedro 2019-03-08 01:08:29 UTC
eh yes, since I cannot edit my comments in this bug tracker... 

Here you go: CONFIRMED
Comment 3 bbugs 2019-09-07 23:16:16 UTC
Hello!

I can confirm the bug, although with a slightly different error message:

"Could not create address book folder: Could not create collection [XYZ], resourceId: 11"

I would appreciate that the bug were fixed shortly, since an addressbook without subfolders is not very useful.

There is a kind of workaround that works for me, although it is very ponderous. See: https://forum.kde.org/viewtopic.php?f=215&t=143208
Comment 4 Matthias Weiss 2020-02-09 19:20:36 UTC
I am using kaddressbook 5.12.3 with "akonadictl --version" also reports 5.12.3
Both are the latest versions from "Debian Testing".

I have a similar error message when clicking "Add Address Book Folder..." I get 

"Could not create address book folder: Could not create collection [XYZ], resourceId: 38"

I used akonadiconsole and found error messages in the logging tab. I will try to attach the log.
Comment 5 Matthias Weiss 2020-02-09 19:21:31 UTC
Created attachment 125801 [details]
Saved log from akonadiconsole
Comment 6 Stephen Peterson 2020-07-14 21:36:50 UTC
Created attachment 130130 [details]
AkonadiConsole Query Debugger tab with failed and successful queries

I'm getting a similar error with the SQLite Akonadi backend ("UNIQUE constraint failed"), but interestingly I was able to create a folder using AkonadiConsole. The possible reason is that AkonadiConsole does INSERT-INSERT-SELECT-INSERT into the CollectionMimeTypeRelation table, whereas KAddressBook tries to do INSERT-INSERT-INSERT and fails.
Comment 7 Stephen Peterson 2020-07-14 21:40:44 UTC
(In reply to Stephen Peterson from comment #6)
> Created attachment 130130 [details]
> AkonadiConsole Query Debugger tab with failed and successful queries
> 
> I'm getting a similar error with the SQLite Akonadi backend ("UNIQUE
> constraint failed"), but interestingly I was able to create a folder using
> AkonadiConsole. The possible reason is that AkonadiConsole does
> INSERT-INSERT-SELECT-INSERT into the CollectionMimeTypeRelation table,
> whereas KAddressBook tries to do INSERT-INSERT-INSERT and fails.

I forgot to add that I'm using KAddressBook version 5.13.3 from Kubuntu 20.04.