Re: Missing Calendar and Contacts entries

Thanks. It was bad char in one of contact. I managed to find it, but it 
was hard. ufff.
The thing was, that cache was cleraed.
When it was enabled, contacts was not displayed.
When it was disabled I could see contacts, but I cannot listed contacts. 
I was seeing only first page and no matter what contact I selected there 
was detail only of last contact added to addressbook.
After I found contact with bad char and deleted it and enabled 
kolab_cache, then it start to works.

Many thanks.

Thomas

On 7/16/19 10:54 PM, Mihai Badici wrote:
> 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@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
>>>>>>> [email protected]
>>>>>>> https://lists.kolab.org/mailman/listinfo/users
>>>>>>> _______________________________________________
>>>>>>> users mailing list
>>>>>>> [email protected]
>>>>>>> https://lists.kolab.org/mailman/listinfo/users
>>>>>> _______________________________________________
>>>>>> users mailing list
>>>>>> [email protected]
>>>>>> https://lists.kolab.org/mailman/listinfo/users
>>>>>>
>>>>>> _______________________________________________
>>>>>> users mailing list
>>>>>> [email protected]
>>>>>> https://lists.kolab.org/mailman/listinfo/users
>>>>>> _______________________________________________
>>>>>> users mailing list
>>>>>> [email protected]
>>>>>> https://lists.kolab.org/mailman/listinfo/users
>>>> _______________________________________________
>>>> users mailing list
>>>> [email protected]
>>>> https://lists.kolab.org/mailman/listinfo/users
>>> _______________________________________________
>>> users mailing list
>>> [email protected]
>>> https://lists.kolab.org/mailman/listinfo/users
>> _______________________________________________
>> users mailing list
>> [email protected]
>> https://lists.kolab.org/mailman/listinfo/users
> _______________________________________________
> users mailing list
> [email protected]
> https://lists.kolab.org/mailman/listinfo/users
_______________________________________________
users mailing list
[email protected]
https://lists.kolab.org/mailman/listinfo/users