Kolab-3. DB error

[Thomas Spuhler]

On Sunday, February 01, 2015 09:22:25 PM you wrote:
> 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

Thanks for the reply. I noted when updating roundcube, I had an error, something along the table 
didn't exist. Let me check the details.

BTW, I am the packager of roundcube for Mageia.

-- 
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: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.kolab.org/pipermail/users/attachments/20150201/4c623ff5/attachment-0001.sig>