Missing Calendar and Contacts entries

[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 
>> <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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kolab.org/pipermail/users/attachments/20190716/3268c6c1/attachment-0001.html>