Roudncubemail addressbook empty (was: rebuild roundcube cache)

[Henning]

Hi,

I fought this problem today. It seems that there were some columns
missing in the kolab_cache_contact table (roundcubemail error logs).

Bug: https://issues.kolab.org/show_bug.cgi?id=2867

You have to manually update the mysql layout and insert the columns
name, surname, firstname and email. You can use the statement posted by
Daniel Hoffend

ALTER TABLE kolab_cache_contact
  ADD (
    `name` VARCHAR(255) NOT NULL,
    `firstname` VARCHAR(255) NOT NULL,
    `surname` VARCHAR(255) NOT NULL,
    `email` VARCHAR(255) NOT NULL);

Regards,
Henning

Am 26.05.2014 08:32, schrieb Thomas Brüderli:
> Michael Stuber wrote:
>> > Hi all
>> > 
>> > Kolab 3.1 on centos
>> > 
>> > After a:
>> > mysql --password=pw roundcube -e "truncate table
>> > kolab_cache_contact;truncate table cache_index;truncate table
>> > cache_messages;"
>> > 
>> > no more contacts are showing up in roundcube's address books ( though
>> > mails are still in cyrus mailbox). How can I rebuild the roundcube cache?
> Hello Michael
> 
> The data for determining whether the cache needs an update is stored in
> the folab_folders table. You should also remove the entries for contact
> folders from there or clear the ctag value of them:
> 
>   UPDATE kolab_folders SET ctag=NULL where type='contact';
> 
> Kind regards,
> Thomas