I had a little bit of a disaster upgrade to 4.5 and wrote about that here:

viewtopic.php?f=66&t=89565

I got the desktop back, in fact, I am writing this from my Kubuntu laptop now.

But there seems to be a lot missing. And one thing was the whole PIM.

So I ran this command

Code: Select all

sudo apt-get install kdepim

and that actually installed the package. But I still can not start it, so I tried starting it from CLI to see if I got any more info:

Code: Select all

kontact: error while loading shared libraries: libkontactinterface.so.4: cannot open shared object file: No such file or directory

I have also seen a couple of other messages about missing shared files. So I don't know if there is a package of shared files that can be added, or if there is a way to just reinstall KDE?

For those not wanting to check the other thread, I am on Kubuntu 10.04.

Got a tip via Identi.ca by claydoh about installing libakonadi-contact4 and libkontactinterface4.

This gave me back my e-mail. Now I need to figure out how to get my addressbook up and running.

Hi,

in order to get your addressbook working, I'd try this (It works flawlessly on my Kubuntu 10.04):
you have to create a bash-script named akonadi-start.sh containing this:

Code: Select all

#!/bin/bash
/usr/bin/akonadictl start

copy the script to
/home/USERNAME/.kde/autostart

then make it executable:

Code: Select all

chmod +x ~/.kde/Autostart/akonadi-start.sh

Here is what I did.

It seems like I lost the settings for Kontact in the upgrade - maybe a good thing - and things had to be set up again.

I started the standalone addressbook. Got it up with no addressbook. So I added "Personal addressbook" and all my 1500+ addresses came up again. While it did, I got A LOT of errors about Birthdays & Anniversaries. I guess one for each contact that had a birthday marked...

After a couple of restarts and a startup today, the addresses comes up inside Kontact as well.

I already had Akonadi running, and all the resources where ok. But today I have one resource in Akonadi displaying this:

Code: Select all

akonadi_kabc_resouce_0
No KDE addressbook plugin configured yet

This could be a result of me choosing the wrong option at first when trying to choose the right addressbook, and then going back when I realised it was wrong.

There are some errors in the Akonadi log that I need to check.

Code: Select all

DBUpdater: query error: "Table 'akonadi.pimitemflagrelation' doesn't exist QMYSQL: Unable to execute query" " "
Query was:  "UPDATE pimitemflagrelation SET Flag_id=(SELECT id FROM flagtable WHERE name='\\SEEN') WHERE Flag_id=(SELECT id FROM flagtable WHERE name='\\Seen');"
Target version was:  19
Mandatory:  false
DBUpdater: query error: "Table 'akonadi.flagtable' doesn't exist QMYSQL: Unable to execute query" " "
Query was:  "DELETE FROM flagtable WHERE name='\\Seen';"
Target version was:  19
Mandatory:  false
Failed to commit transaction for database update

So while some things still need to be solved, it is not all bad

Thank you for the tip. I will keep it in mind for later if needed.

Looks like Akonadi failed to upgrade it's MySQL database. Unfortunately I do not know why. Can you verify that Akonadi can start + connect to it's own MySQL instance?

Sorry it took so long to get back to you. I always ending up fixing my own problems last... Been busy running around helping others with their computer problems

Anyway - did a

Code: Select all

sudo apt-get install kde-full

yesterday, but I still have errors in the Akonadi log. And some other strange behaviour. I have thought about re-installing my laptop several times, but that involves A LOT of work as I still need dual booting. So at least one, maybe two or three days of work to get all back in proper order. And in the mean time, I am not able to do any work.

So I would love to try to fix this if possible.

I am not sure how I would go about testing the sql connection of Akonadi. Right now, if I check the configuration with Akonadi-Tray it is set up to use the internal sql server. I do have a MySQL server running as well that I could use if necessary.

In the configuration, there are two buttons, stop and restart. If I use those, Akonadi stops, and it starts again without complaining about the database itself. But as I had Kontakt running when I did the stop/start, I got this message:

Code: Select all

Could not access the outbox folder (Unknown error. (Unknown resource)).

Is there any way to force the upgrade of the database?

Ooops! Sorry!

It was set to use the MySQL database. Setting it to use internal database now to test.

Switching to internal MySQL server give me this error on restarting of Akonadi:

Code: Select all

Could not access the outbox folder (Unknown error. (Could not fetch root collection of resource akonadi_maildir_resource_0.)).

I have used PhpMyAdmin to check the MySQL database. I have reset the password for the akonadi user so I am sure it can be accessed. Switching back to external MySQL and restarting give a different error message:

Code: Select all

Could not access the outbox folder (Unknown error. (Unknown resource)).

Checking the tables and checking the error messages, I realised that it complained about the table akonadi.flagtable and akonadi.pimitemflagrelation does not exist. This is absolutely correct. What exists is FlagTable and PimItemFlagRelation.

But on the last switch to external MySQL and restart, I suddenly got a clean restart (only with the last error message above), but no errors in the Akonadi log or any other log mentioned in the configuration test of Akonadi. So it looks good right now. I will get back after a couple of days to see if anything changed.