<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi,</p>
<p>thanks for the info.<br>
I will try that in the evening.<br>
So if the template is old and not up to date, how to correct
roundcube db to be up to date and delete cache?<br>
Is there bettere way to delete kolab cache?<br>
Why the kolab update did not delete cache?</p>
<p>Thanks.<br>
Thomas<br>
</p>
<div class="moz-cite-prefix">On 7/16/19 6:19 AM, Mihai Badici wrote:<br>
</div>
<blockquote type="cite"
cite="mid:b8e61e7b-9748-3d60-e4f1-7ed5859d3a81@badici.ro">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p>I wasn't aware this sql template is still used :)</p>
<p>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.<br>
</p>
<p>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<br>
</p>
<p>in roundcube: $config['sql_debug'] = true;</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 7/15/19 9:53 PM, Thomas wrote:<br>
</div>
<blockquote type="cite"
cite="mid:32a03dae-c1b2-ef82-cadf-fc882a462905@krokodylci.cz">
<p>Hi,</p>
<p>I had maybe same issue with contacts.<br>
One user of 5 on my kolab installation reported me yesterday
that her contacts suddenly disappeared.<br>
This users using only contact sync with her mobile phone (no
mails, no calendar).<br>
</p>
<p>The contacts was missing on her phone (synced using
ActiveSync) and also in Roundcube.<br>
The contacts was still as files on disk in the imap spool.<br>
</p>
<p>I tried things around index, but no luck.<br>
Now I found this about kolab cache.<br>
<a class="moz-txt-link-freetext"
href="https://lists.kolab.org/pipermail/users/2014-August/017704.html"
moz-do-not-send="true">https://lists.kolab.org/pipermail/users/2014-August/017704.html</a></p>
<p>I first tried to disable kolab cache in
/etc/roundcubemail/libkolab.inc.php<br>
The change is active immediately (no restart of any service
neede).<br>
If then you can see your contacts, this means that kolab cache
is corrupted.<br>
</p>
<p>I then:<br>
- enabled cache again<br>
- backed up roundcube databse<br>
<i>mysqldump -u roundcube -p roundcube >
roundcube-backup.sql</i><br>
- delete cache from database using this sql:<i><a
href="http://mihai.badici.ro/linux/machinet/debian/kolab.sql"
moz-do-not-send="true"><br>
http://mihai.badici.ro/linux/machinet/debian/kolab.sql</a><br>
mysql -u roundcube -p roundcube < kolab.sql<br>
</i></p>
<p>Maybe it can help you.<br>
</p>
<p>I didn't find out why the cache was corrupted.</p>
<p>Thomas</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 7/11/19 5:30 AM, Eric B Munson
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:3ec135a4c041f5d204e41504049a1b40@mgebm.net">I have
opened an issue on maniphest for this problem: <br>
<br>
<a class="moz-txt-link-freetext"
href="https://git.kolab.org/T5501" moz-do-not-send="true">https://git.kolab.org/T5501</a>
<br>
<br>
On 2019-07-10 17:02, Eric B Munson wrote: <br>
<blockquote type="cite">Over night (with no kolab updates
AFAICT) my calendar and contacts <br>
entries have disappeared. The files are still on disk in the
imap <br>
spool but they are no longer being displayed in the
roundcube <br>
interface and they are missing from CardDAV/CalDAV. Any
hints on how <br>
to bring them back? <br>
<br>
Thanks, <br>
Eric <br>
_______________________________________________ <br>
users mailing list <br>
<a class="moz-txt-link-abbreviated"
href="mailto:users@lists.kolab.org" moz-do-not-send="true">users@lists.kolab.org</a>
<br>
<a class="moz-txt-link-freetext"
href="https://lists.kolab.org/mailman/listinfo/users"
moz-do-not-send="true">https://lists.kolab.org/mailman/listinfo/users</a>
<br>
</blockquote>
_______________________________________________ <br>
users mailing list <br>
<a class="moz-txt-link-abbreviated"
href="mailto:users@lists.kolab.org" moz-do-not-send="true">users@lists.kolab.org</a>
<br>
<a class="moz-txt-link-freetext"
href="https://lists.kolab.org/mailman/listinfo/users"
moz-do-not-send="true">https://lists.kolab.org/mailman/listinfo/users</a>
<br>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:users@lists.kolab.org" moz-do-not-send="true">users@lists.kolab.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kolab.org/mailman/listinfo/users" moz-do-not-send="true">https://lists.kolab.org/mailman/listinfo/users</a></pre>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:users@lists.kolab.org">users@lists.kolab.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kolab.org/mailman/listinfo/users">https://lists.kolab.org/mailman/listinfo/users</a></pre>
</blockquote>
</body>
</html>