Roundcube calendar plugin not working

[Theet]

Try this package.

Notice:
#1-Re-build database from scratch! It is working for me on PostgreSQL.
#2-Re-configure it

Sorry, I have registered the "jqueryui" plugin first in plugin, after that "calendar", now it shows a loading screen.
It takes a long time, I will not see the events now

[rosali]

Check attached version and update jqueryui (it is included in the zip).

[Theet]

Check attached version and update jqueryui (it is included in the zip).

Wow, Perfect! I can connect with the database to set some appointments with different times in it. But when I want to change the duration of the appointment it comes with an error... see attachment. The most of it will work now!

[rosali]

Well, give me remote access. Don't worry, just trust me.

[rosali]

... or try to update to postgres 9.x

[admins]

Thanks. It works very well.
Has someone integreated an alert feautre?
Or has someone a plugin for syncing the calendar to / from outlook?

Thx

[Theet]

... or try to update to postgres 9.x

Is there something special with PostgreSQL 9.0, now i'm uses the ajax
NAS v8.3.11

Can I setup a new version of PostgreSQL without problems over the older version? (copy the files into the map?) I have looked to the site of
PostgreSQL: The world's most advanced open source database, there are different versions... which version
I need to update?

[rosali]

I have 9.0.2-1 running.

[Andreas72]

sorry, how can I install Calendar, there is this tutorial?

[thomas_g]

Hey!
I just installed the RC Calender Plugin (version 5.4) and now I have also the problem that appointments I want to create are not shown.
In the error log is the following statement:

[19-Oct-2011 20:15:19 +0200]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_49e9d474b45d4ff562d28042d68fbba9a257486b3 FROM 'SELECT * FROM `eventsroundcubemail` \r\n         WHERE `user_id`=? AND `start`>? AND `start`?']
[Native code: 1146]
[Native message: Table 'roundcubemail.eventsroundcubemail' doesn't exist]
 in /*...*/webmail/program/include/rcube_mdb2.php on line 285 (GET /?_task=dummy&_action=plugin.getEvents&_gmtoffset=-2&_realgmtoffset=-1&_dststart=1301187600&_dstend=1319936400&_start=1318802400&_end=1319666400&_category=&_tzname=Europe%2FBerlin&_echo=1&_=1319048133556)

I checked the database and there is really no table "eventsroundcubemail", but there are no instructions to create such a table in the mysql.sql file.
The database backend test indicates the same problem ("eventsroundcubemail_caldav" doesn't exist, too), but there is also the statement "Currently we need tables 'events', 'events_caldav' and 'events_cache' for this plugin."

What went wrong? What's to do?

Greetings
thomas

[rosali]

Did you change the following settings?


/* Database table mapping */
// notice: leading underscore
$rcmail_config['backend_db_table_map'] = array(
  'dummy' => '', // no db table
  'database' => '', // default db table
  'caldav' => '_caldav', // caldav db table (= default db table) extended by _caldav
);

/* database table name (main table) */
$rcmail_config['db_table_events'] = 'events';
$rcmail_config['db_sequence_events'] = 'events_ids';

/* database table name (cache) */
$rcmail_config['db_table_events_cache'] = 'events_cache';
$rcmail_config['db_sequence_events_cache'] = 'events_cache_ids';

/* database table name reminders */
$rcmail_config['db_table_events_reminders'] = 'reminders';