Tasks dissapeared after Kolab 16 upgrade

[Hernan Saltiel]

Some new information I found digging a bit here, and configuring as debug
for everything:

This is from iRony logs:

[22-Sep-2019 17:19:04,864095 -0300]: PHP Error: Could not parse Kolab
object data in message 5 (Tasks). UID =
5d2a3eb1-463f-4ff7-8a6a-002b6234829e in
/usr/share/roundcubemail/plugins/libkolab/lib/kolab_storage_folder.php on
line 578 (REPORT /iRony/calendars/user at domain.com.ar
<https://lists.kolab.org/mailman/listinfo/users>/5ca8109b-27a0-4ab4-8557-1ab6369b32da/)


Checking the roundcube sql.log, y found that this query:

SELECT * FROM `kolab_cache_configuration` WHERE `folder_id` = '69' AND
`type` = 'relation' AND `tags` LIKE '% category:tag %' LIMIT 100; is
providing the full list of tasks, based on the filenames (I checked
several, and all are files.ics).


I'll continue digging here, but if this is something anybody already
saw in the past, please let me know.

Thanks, and best regards,

HeCSa.


On Sun, Sep 22, 2019 at 1:16 PM Hernan Saltiel <hsaltiel at gmail.com> wrote:

> Hi experts,
>
>     I'm having a huge issue after upgrading from 16.0.1-12 to 16.0.1-38.
>     Webmail seem to work just fine, but Tasks and Calendar items
> disappeared. A user that has a lot of tasks complains about having no tasks
> on his list, and checking his Tasks folder
> (/var/spool/imap/domain/e/<example_domain>/r/<example_user>/Tasks) still
> has all his files there.
>     Just an important thing: He has more that 20.000 tasks (he keeps the
> completed tasks on his machine), but no more than 700 active ones.
>     Another important thing: I already checked, because of some googling,
> that the /usr/share/roundcubemail/plugins/libkolab/SQL/mysql/2018122700.sql
> script ran successfully. I do not have all the "xml" columns on the MySQL
> roundcube database.
>     When selecting, using the roundcube interface, the Tasks tab, I see it
> uses some time trying to load everything, but only after some time, it only
> show two or three, all the time the same two or three.
>     Please, help me understand what can be done in order to have all the
> tasks again there...this user is a key one in order to accept Kolab 16 as
> the groupware solution.
>     Thanks a lot for your time and attention and best regards.
>
> --
> HeCSa
>


-- 
HeCSa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kolab.org/pipermail/users/attachments/20190922/e30b44b2/attachment.html>