Kolab-3. DB error

[Thomas Spuhler]

On Sunday, February 01, 2015 06:25:48 PM you wrote:
> 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.

This is actually what I have in my %post script:

/usr/share/roundcubemail/bin/updatedb.sh \
    --dir /usr/share/doc/roundcubemail-%{version}/SQL/ \
    --package roundcube || : \
    >/dev/null 2>&1

and it should be;

/usr/share/roundcubemail/bin/updatedb.sh \
    --dir /usr/share/doc/roundcubemail/SQL/ \
    --package roundcube || : \
    >/dev/null 2>&1

                                                         ^^^^
-- 
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/ec8e60e4/attachment.sig>