Missing Calendar and Contacts entries

[Mihai Badici]

In fact the sql template I published was not intended to clear cache but
to fix the database structure. Clearing the cache was collaterally.

The debian installer for that version of kolab had an outdated sql
template. IMHO a structure dump will be useful for each version of kolab.

It  is still possible you have the same problem because of many updates
in roundcube and activesync. I don't know if there is a special patch
for kolab, I used the sql updates provided by roundcube ( the SQL
folder) to fix the missing fields.

So if you activate the sql debug  and see this kind of errors you can
easy identify  the sql template who add that field and apply all newest
updates.

On 7/16/19 8: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
> _______________________________________________
> users mailing list
> users at lists.kolab.org
> https://lists.kolab.org/mailman/listinfo/users