Kolab-3. DB error

[Thomas Spuhler]

On Sunday, February 01, 2015 06:37:27 PM Thomas Spuhler wrote:
> 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
> 
>                                                          ^^^^
The new rpm install didn't report the script error anymore and they disappeared in the logs as well.
Thanks again for the hint. I probably would have pulled out some of my hair.

-- 
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/20150202/651c8a65/attachment.sig>