<div dir="ltr"><span style="font-size:12.8px"> Hi sw. Your chwala_locks table is in the kolab database, but it needs to be in the roundcube database.</span><br style="font-size:12.8px"><span style="font-size:12.8px">I do know there was a problem in Kolab3.4 (the chwala mysql.initial.sql was left out at of the distribution), and I had to add it manually,</span><br style="font-size:12.8px"><span style="font-size:12.8px">and the sql file did not have a "USE roundcube" statement. It looks like you loaded it while you were in the kolab database.</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px">So: if you have the chwala mysql.initial.sql file (it is part of the kolab-16 chwala distribution), I guess you could do like so:</span><br style="font-size:12.8px"><span style="font-size:12.8px"># mysql</span><br style="font-size:12.8px"><span style="font-size:12.8px">> use kolab</span><br style="font-size:12.8px"><span style="font-size:12.8px">> drop table chwala_invitations; drop table chwala_locks; drop table chwala_sessions;</span><br style="font-size:12.8px"><span style="font-size:12.8px">> use roundcube</span><br style="font-size:12.8px"><span style="font-size:12.8px">> source mysql.initial.sql</span><br style="font-size:12.8px"><span style="font-size:12.8px">> quit</span><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Mar 31, 2016 at 5:04 AM, <span dir="ltr"><<a href="mailto:g6094199@freenet.de" target="_blank">g6094199@freenet.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u><div><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><p style="margin:0px;padding:0px">Hi guys,</p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px">updated my Kolab3.4 to 16 a few day ago. did and test upgrade on an snapshot of my system. everything was fine, so i did the upgrade on the live machine. everything fine on the live system,too.....almost. yesterday i found some errors in the iRony log and now im hunting for an fix.</p>
<p style="margin:0px;padding:0px">error:</p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px">[31-Mar-2016 13:33:43,000000 +0200]: DB Error: [1146] Table 'roundcube.chwala_locks' doesn't exist (SQL Query: `chwala_locks` WHERE (`uri` = 'imap:/xxxx.de@localhost/calendars/<a href="http://xxxx.de/7bd1ba69565844f3/fdbc643f-7026-4eb3-9fed-9c17c2c1639a.ics" target="_blank">xxxx.de/7bd1ba69565844f3/fdbc643f-7026-4eb3-9fed-9c17c2c1639a.ics</a>' OR (`uri` IN ('imap://xxxx.de@localhost/calendars','imap://xxxxx.de@localhost/calendars/xxxxde','imap:/xxxxx.de@localhost/<a href="http://calendarsxxxx.de/7bd1ba69565844f3" target="_blank">calendarsxxxx.de/7bd1ba69565844f3</a>') AND `depth` <> 0)) AND `expires` > now()) in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 543 (PUT /iRony/calendars/<a href="http://xxxx.de/7bd1ba69565844f3/fdbc643f-7026-4eb3-9fed-9c17c2c1639a.ics" target="_blank">xxxx.de/7bd1ba69565844f3/fdbc643f-7026-4eb3-9fed-9c17c2c1639a.ics</a>)</p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px">so i checked the mysql tables, hoping that they are simply missing...</p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px">mysql> _in_kolab |<br>+--------------------+<br>| chwala_invitations |<br>| chwala_locks |<br>| chwala_sessions |<br>| group_types |<br>| options |<br>| ou_types |<br>| policy_result |<br>| resource_types |<br>| role_types |<br>| sharedfolder_types |<br>| statistic |<br>| user_types |<br>+--------------------+<br>12 rows in set (0.00 sec)</p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px">i also checked the source at <a href="https://git.kolab.org/diffusion/C/browse/master/doc/SQL/mysql.initial.sql" target="_blank">https://git.kolab.org/diffusion/C/browse/master/doc/SQL/mysql.initial.sql</a> which gives me also the tables i already have.</p>
<p style="margin:0px;padding:0px">but the tables are there. am i something missing here?</p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px">the clients are outlook2007 with outlookcaldavsyncronizer (big thank to the guys for this nice piece of software!) which are logging erros, too, on the client side. but calendar syncing does work in general,but i cant change or delete entries.</p>
<p style="margin:0px;padding:0px">on my pc i use thunderbird and it logs an similar error.</p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px">i searched the mailing list archive and found a guy with the same error some time ago, but with no answer to the problem...</p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px"> </p>
<p style="margin:0px;padding:0px">regards</p>
<p style="margin:0px;padding:0px">sw</p>
<p style="margin:0px;padding:0px"> </p></div><br><br>---<br><div style="font-family:arial;font-size:10pt">Mail & Cloud Made in Germany mit 3 GB Speicher! <a style="font-family:arial;font-size:10pt" href="https://email.freenet.de/mail/Uebersicht?epid=e9900000450" target="_blank">Jetzt kostenlos anmelden</a></div></div>
<br>_______________________________________________<br>
users mailing list<br>
<a href="mailto:users@lists.kolab.org">users@lists.kolab.org</a><br>
<a href="https://lists.kolab.org/mailman/listinfo/users" rel="noreferrer" target="_blank">https://lists.kolab.org/mailman/listinfo/users</a><br></blockquote></div><br></div>