<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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">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>