iRony errros with MySQL table ('roundcube.chwala_locks' doesn't exist)

[g6094199 at freenet.de]

Hi Brad!
 
me stupid! :-)
in germany we say: "wer lesen kann ist klar im vorteil", which means something like: you have to read carefully..
 
duno why it ends up in the wrong table, but now i manually added it to the roundcube table and  the kolab table. everything seems to be fine now.
 
many thanks for showning me the obvious! :-)
 
regads
sash
 
 
 
-----Ursprüngliche Nachricht-----
 Von: "Brad Rubenstein" [brad.rubenstein at gmail.com]
 Gesendet: Do. 31.03.2016 17:46
 An: g6094199 at freenet.de
 Kopie: users at lists.kolab.org
 Betreff: Re: iRony errros with MySQL table ('roundcube.chwala_locks' doesn't exist)

     Hi sw. Your chwala_locks table is in the kolab database, but it needs to be in the roundcube database.
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,
and the sql file did not have a "USE roundcube" statement.  It looks like you loaded it while you were in the kolab database.

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:
# mysql
> use kolab
>  chwala_invitations;  chwala_locks;  chwala_sessions;
> use roundcube
> source mysql.initial.sql
> quit
On Thu, Mar 31, 2016 at 5:04 AM,  <g6094199 at freenet.de> wrote:
 Hi guys,
 
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.
error:
 
[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 at localhost/calendars/xxxx.de/7bd1ba69565844f3/fdbc643f-7026-4eb3-9fed-9c17c2c1639a.ics' OR (`uri` IN ('imap://xxxx.de@localhost/calendars','imap://xxxxx.de@localhost/calendars/xxxxde','imap:/xxxxx.de at localhost/calendarsxxxx.de/7bd1ba69565844f3') AND `depth` <> 0)) AND `expires` > now()) in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 543 (PUT /iRony/calendars/xxxx.de/7bd1ba69565844f3/fdbc643f-7026-4eb3-9fed-9c17c2c1639a.ics)
 
so i checked the mysql tables, hoping that they are simply missing...
 
mysql> _in_kolab    |
+--------------------+
| chwala_invitations |
| chwala_locks       |
| chwala_sessions    |
| group_types        |
| options            |
| ou_types           |
| policy_result      |
| resource_types     |
| role_types         |
| sharedfolder_types |
| statistic          |
| user_types         |
+--------------------+
12 rows in set (0.00 sec)
 
i also checked the source at https://git.kolab.org/diffusion/C/browse/master/doc/SQL/mysql.initial.sql which gives me also the tables i already have.
but the tables are there. am i something missing here?
 
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.
on my pc i use thunderbird and it logs an similar error.
 
i searched the mailing list archive and found a guy with the same error some time ago, but with no answer to the problem...
 
 
regards
sw
 
---
Mail & Cloud Made in Germany mit 3 GB Speicher! Jetzt kostenlos anmelden
_______________________________________________
 users mailing list
 users at lists.kolab.org
 https://lists.kolab.org/mailman/listinfo/users
-----Ursprüngliche Nachricht Ende-----


---
Mail & Cloud Made in Germany mit 3 GB Speicher! Jetzt kostenlos anmelden
-------------- n�chster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <http://lists.kolab.org/pipermail/users/attachments/20160401/6e1943ce/attachment.html>