Akonadi fails to start: Unable to add column 'version' to table 'SchemaVersionTable'

[Martin Kho]

On Saturday 22 September 2012 10:20:52 Garry Williams wrote:
> I recently updated from updates-testing to get:
> 
>     akonadi-1.8.0-1.fc17.x86_64
>     kdepimlibs-4.9.1-3.fc17.x86_64
>     kdepimlibs-akonadi-4.9.1-3.fc17.x86_64
>     kdepim-libs-4.9.1-1.fc17.x86_64
>     kdepim-4.9.1-1.fc17.x86_64
>     kdepim-runtime-libs-4.9.1-1.fc17.x86_64
>     kdepim-runtime-4.9.1-1.fc17.x86_64
> 
> and others.
> 
> This didn't go as expected.
> 
> The first problem was that yum wanted to remove mysql for
> dependencies.  I added --setopt=clean_requirements_on_remove=0 to fix
> that.  This was the first hint that I did something wrong.  :-(
> 
> Next, after restarting the desktop, I got this:
> 
>     Test 6:  ERROR
>     --------
> 
>     MySQL server default configuration not found.
>     Details: The default configuration for the MySQL server was not
> found or was not readable. Check your Akonadi installation is complete
> and you have all required access rights.
> 
> Another hint.
> 
> I found a copy of the missing file in
> 
>     /usr/share/kde4/apps/digikam/database/mysql-global.conf
> 
> and copied it to /etc/akonadi .
> 
> Now I'm stuck on this error:
> 
>     "Unable to add column 'version' to table 'SchemaVersionTable'.
>     Query error: 'Table 'akonadi.SchemaVersionTable' doesn't exist
> QMYSQL: Unable to execute query'"
>     Unable to initialize database.
> 
> What am I doing wrong?

Hi,

Have you akonadi-mysql installed?

Martin Kho

> 
> (Incidentally, sqlite is hopeless.  I tried that after the first error
> and akonadi consumes all of the CPU resource without any hint that it
> will subside.)
> 
> --
> Garry Williams
> _______________________________________________
> kde mailing list
> kde at lists.fedoraproject.org
> https://admin.fedoraproject.org/mailman/listinfo/kde
> New to KDE4? - get help from http://userbase.kde.org