Missing Calendar and Contacts entries

[Mihai Badici]

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