Missing Calendar and Contacts entries

[Thomas]

Thanks, I didn't know that.
And I didn't search the docs.
I searched only google and not explecetly for clearing cache, but for 
the problem with not showing contacts and found only the old solution I 
mentioned.

Could you please advise me how to repair/recreate roundcube database 
table structure.
Because I found out that by using the old kolab.sql script i broke 
roundcube database and I have now a lot of errors.
Mainly about missing column 'expires' in 'cache' table. But there could 
be more problems.

Thanks in advance.

Thomas


On 7/16/19 7:43 PM, Daniel Hoffend wrote:
> Sure there's a command line utitity
>
> root at mx01:/usr/share/roundcubemail# plugins/libkolab/bin/modcache.sh 
> clear -a
> 37 records deleted from 'kolab_folders'
>
> You can even do this for domains or single users. Or do this only for 
> specific cache types.
>
> -- 
> Regards
> Daniel
>
>
>
> Am 2019-07-16 08:49, schrieb Thomas:
>> Hi,
>>
>> thanks for the info.
>> I will try that in the evening.
>> So if the template is old and not up to date, how to correct roundcube
>> db to be up to date and delete cache?
>> Is there bettere way to delete kolab cache?
>> Why the kolab update did not delete cache?
>>
>> Thanks.
>> Thomas
>> On 7/16/19 6:19 AM, Mihai Badici wrote:
>>
>>> I wasn't aware this sql template is still used :)
>>>
>>> Please notice that during the time there are some fields added to
>>> sql tables, some of them where missing from the installer's
>>> template. This template is pretty old so could be more fields
>>> missing.
>>>
>>> You can enable the sql debug in roundcube and syncroton to see if
>>> there are more fields missing in mysql tables.  In roundcube source
>>> there is a folder named SQL which contain the succesive updates to
>>> mysql table structure, you can compare with  the erors in mysql log
>>>
>>> in roundcube: $config['sql_debug'] = true;
>>>
>>> On 7/15/19 9:53 PM, Thomas wrote:
>>>
>>> Hi,
>>>
>>> I had maybe same issue with contacts.
>>> One user of 5 on my kolab installation reported me yesterday that
>>> her contacts suddenly disappeared.
>>> This users using only contact sync with her mobile phone (no mails,
>>> no calendar).
>>>
>>> The contacts was missing on her phone (synced using ActiveSync) and
>>> also in Roundcube.
>>> The contacts was still as files on disk in the imap spool.
>>>
>>> I tried things around index, but no luck.
>>> Now I found this about kolab cache.
>>> https://lists.kolab.org/pipermail/users/2014-August/017704.html
>>>
>>> I first tried to disable kolab cache in
>>> /etc/roundcubemail/libkolab.inc.php
>>> The change is active immediately (no restart of any service neede).
>>> If then you can see your contacts, this means that kolab cache is
>>> corrupted.
>>>
>>> I then:
>>> - enabled cache again
>>> - backed up roundcube databse
>>> _mysqldump -u roundcube -p roundcube > roundcube-backup.sql_
>>> - delete cache from database using this sql:
>>> http://mihai.badici.ro/linux/machinet/debian/kolab.sql
>>> mysql -u roundcube -p roundcube < kolab.sql
>>>
>>> Maybe it can help you.
>>>
>>> I didn't find out why the cache was corrupted.
>>>
>>> Thomas
>>>
>>> On 7/11/19 5:30 AM, Eric B Munson wrote:
>>> I have opened an issue on maniphest for this problem:
>>>
>>> https://git.kolab.org/T5501
>>>
>>> On 2019-07-10 17:02, Eric B Munson wrote:
>>> Over night (with no kolab updates AFAICT) my calendar and contacts
>>> entries have disappeared. The files are still on disk in the imap
>>> spool but they are no longer being displayed in the roundcube
>>> interface and they are missing from CardDAV/CalDAV.  Any hints on
>>> how
>>> to bring them back?
>>>
>>> Thanks,
>>> Eric
>>> _______________________________________________
>>> users mailing list
>>> users at lists.kolab.org
>>> https://lists.kolab.org/mailman/listinfo/users
>>> _______________________________________________
>>> users mailing list
>>> users at lists.kolab.org
>>> https://lists.kolab.org/mailman/listinfo/users
>>
>> _______________________________________________
>> users mailing list
>> users at lists.kolab.org
>> https://lists.kolab.org/mailman/listinfo/users
>>
>> _______________________________________________
>> users mailing list
>> users at lists.kolab.org
>> https://lists.kolab.org/mailman/listinfo/users
>> _______________________________________________
>> users mailing list
>> users at lists.kolab.org
>> https://lists.kolab.org/mailman/listinfo/users