Missing Calendar and Contacts entries

[Mihai Badici]

I can't provide an official dump but I made a dump of my running setup
using roundcube 1.3.4. just for you.

It will fix at least the "expires" errors but i think is pretty up-to-date.

http://mihai.badici.ro/linux/machinet/debian/roundcube-1.3.4.sql


Unfortunately I was busy last years with different projects so I
neglected kolab but I'm still follow the product. 

On 7/16/19 9:15 PM, Thomas wrote:
> 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
> _______________________________________________
> users mailing list
> users at lists.kolab.org
> https://lists.kolab.org/mailman/listinfo/users