Arch Linux

ES

Member

Registered: 2009-03-13

Posts: 21

[SOLVED] Akonadi: [Unknown Error.(Could not create collection)]

Hi,

Since 2 days ago, akonadi always give me this error (Could not create collection)
I believe it is somehow related to the mysql upgrade, but no clue of how.
The connection to the database seems working, and the settings are pointing to the new socket.
I tried to delete the .config/akonadi/ and .local/share/akonadi/ as suggested on another thread, but it didnt helped.
I also deleted all my akonadi resources, and making a new calendar with the wizard in the settings, but the same error keep poping up.
I have mysql and mysql-clients at 5.1.41-2, and akonadi at 1.2.1-2
Any help will be very appreciated   not being able to see my calendar and todos is pretty unconvenient.

Starting Akonadi Server...                                                                                                                                                  
   done.                                                                                                                                                                    
[eric@arch]# [akonadiserver] Database "akonadi" opened using driver "QMYSQL"                                                                                             [~]
[akonadiserver] DbInitializer::run()                                                                                                                                        
[akonadiserver] checking table  "SchemaVersionTable"                                                                                                                        
[akonadiserver] checking table  "ResourceTable"                                                                                                                             
[akonadiserver] checking table  "CollectionTable"                                                                                                                           
[akonadiserver] checking table  "MimeTypeTable"                                                                                                                             
[akonadiserver] checking table  "PimItemTable"                                                                                                                              
[akonadiserver] checking table  "FlagTable"                                                                                                                                 
[akonadiserver] checking table  "PartTable"                                                                                                                                 
[akonadiserver] checking table  "CollectionAttributeTable"
[akonadiserver] checking relation  "PimItemFlagRelation"
[akonadiserver] checking relation  "CollectionMimeTypeRelation"
[akonadiserver] checking relation  "CollectionPimItemRelation"
[akonadiserver] DbInitializer::run() done
[akonadiserver] skipping update 2
[akonadiserver] skipping update 3
[akonadiserver] skipping update 4
[akonadiserver] skipping update 8
[akonadiserver] skipping update 10
[akonadiserver] skipping update 12
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
PLUGINS:  "/usr/share/akonadi/agents"
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
PLUGINS inserting:  "akonadi_birthdays_resource" 1 ("Resource")
PLUGINS inserting:  "akonadi_distlist_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_ical_resource" 4 ("Resource")
PLUGINS inserting:  "akonadi_imap_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kabc_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kcal_resource" 2 ("Resource")
PLUGINS inserting:  "akonadi_knut_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kolabproxy_resource" 0 ("Resource", "Unique", "NoConfig")
PLUGINS inserting:  "akonadi_localbookmarks_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_maildir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_microblog_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nepomuk_contact_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuk_email_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_notes_resource" 0 ("Resource")
QFileSystemWatcher: failed to add paths: /usr/bin/akonadi_ical_resource
PLUGINS inserting:  "akonadi_strigi_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_vcard_resource" 0 ("Resource")
PLUGINS:  "/usr/share/akonadi/agents"
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Error during insertion into table "CollectionTable" "Incorrect arguments to mysqld_stmt_execute QMYSQL3: Unable to execute statement"

Last edited by ES (2009-11-20 12:11:36)

ES

Member

Registered: 2009-03-13

Posts: 21

Re: [SOLVED] Akonadi: [Unknown Error.(Could not create collection)]

Solved with mysql-5.1.41-3