bug in plugins/calendar/SQL/postgres.sql

[cyndo]

This report refers to:

• URL: ​http://myroundcube.googlecode.com/svn/plugins/calendar
• Repository Root: ​http://myroundcube.googlecode.com/svn
• Repository UUID: 3cbd2854-75cd-d53f-53e9-07c40916dcbf
• Revision: 101

Error Message (log):

[2012-Jul-13 14:09:17 +0000]: DB Error: MDB2 Error: no such field Query: _doQuery: [Error message: Could not execute statement] [Last executed query: UPDATE "events"  SET "del"=2, "timestamp"='2012-07-13 14:09:17' WHERE "user_id"='1' AND "url"='https://my-davical-server.example.org/caldav.php/my-username/home'] [Native message: ERROR:  column "url" does not exist ZEILE 3:                 WHERE "user_id"='1' AND "url"='https://davic... ^]  in /usr/share/roundcube/program/include/rcube_mdb2.php on line 722 (POST /roundcube/?_task=dummy&_action=plugin.getSettings?_task=&_action=)

This can be fixed with the following patch:

--- postgres.sql        2012-07-12 19:57:54.000000000 +0000
+++ postgres.sql-fixed     2012-07-13 14:16:10.000000000 +0000
@@ -21,7 +21,7 @@
    categories varchar(255) NOT NULL DEFAULT '',
    "group" text,
    caldav text,
-   all_day integer NOT NULL DEFAULT 0,
+   url text,
    "timestamp" text,
    del smallint NOT NULL DEFAULT 0,
    reminder integer DEFAULT NULL,

Regards

Frank

[thomasb]

Please report to ​https://code.google.com/p/myroundcube/issues/list

[rosali]

No need to open a ticket. I noticed it and will fix it. Thanks.