Missing Calendar and Contacts entries

[Mihai Badici]

Well, that part should be the funny part :)

$config['log_errors'] = true;
$config['log_session'] = true;
$config['debug_level'] = 8;

Could be something related to   non-latin characters in the database, or
maybe a field too long or...

You also can inspect the sql cache to see if there is something stored
there...

On 7/16/19 11:10 PM, Thomas wrote:
> Thanks for update and provided sql.
> I managed to repair the database.
> For clearing cache I'm using now the command intended for doing so.
>
> But after I repaired the database I have still problem with contacts
> of one of my users.
> When kolab_cache is enabled contacts can't be seen in roundcube and
> mobile as well.
> When I disable kolab_cache contacts is loaded in roundcube.
> I can't figure out what is causing problem.
> Other users contacts are ok.
>
> Thanks for any ideas.
>
> Thomas
>
>
> On 7/16/19 8:41 PM, Mihai Badici wrote:
>> 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
>> _______________________________________________
>> 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