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

[Brad Rubenstein]

     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
> drop table chwala_invitations; drop table chwala_locks; drop table
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
> <https://email.freenet.de/mail/Uebersicht?epid=e9900000450>
>
> _______________________________________________
> users mailing list
> users at lists.kolab.org
> https://lists.kolab.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kolab.org/pipermail/users/attachments/20160331/581e1dd9/attachment.html>