Kolab-3. DB error

[Daniel Hoffend]

The kolab_cache_contact table belongs to the roundcube database.

Usually you shouldn't need to apply those patches manually. This
is usually done by the upgrade script that gets executed during
an installation or package upgrade.

Btw. Your error messages is about the cache_messages table and
not the kolab_cache_contact table. It looks like the database
structure of your default roundcube installation is out-of-date.

Maybe you would like to execute a command like this:

     /usr/share/roundcubemail/bin/updatedb.sh \
         --dir /usr/share/doc/roundcubemail/SQL/ \
         --package roundcube

But keep in mind: Usually this should have happend during the
yum/apt-get upgrade command unless you've patched or installed
roundcube yourself.

--
Daniel

------ Originalnachricht ------
Von: "Thomas Spuhler" <thomas.spuhler at btspuhler.com>
An: users at lists.kolab.org
Gesendet: 01.02.2015 00:54:55
Betreff: Kolab-3. DB error

>I am getting this error in the logs
>Unknown column 'expires' in 'field list' (SQL Query: INSERT INTO
>cache_messages (user .......
>
>I found this:
>http://lists.kolab.org/pipermail/users/2014-February/016704.html
>
>
>MariaDB [kolab]> ALTER TABLE `kolab_cache_contact` ADD `name`
>VARCHAR(255) NOT NULL,
>     -> ADD `firstname` VARCHAR(255) NOT NULL,
>     -> ADD `surname` VARCHAR(255) NOT NULL,
>     -> ADD `email` VARCHAR(255) NOT NULL;
>
>but doing it I get:
>ERROR 1146 (42S02): Table 'kolab.kolab_cache_contact' doesn't exist
>
>I cannot find any place where we add this table in the update
>instructions. Has it fallen through the cracks?
>
>
>--
>Best regards
>Thomas Spuhler
>
>All of my e-mails have a valid digital signature
>ID 60114E63
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5714 bytes
Desc: not available
URL: <http://lists.kolab.org/pipermail/users/attachments/20150201/76fc61d1/attachment.bin>