Roundcube Community Forum

 

Roundcube calendar plugin not working

Started by pinemail11, April 20, 2010, 01:23:03 PM

Previous topic - Next topic

Theet

#75
Quote from: rosali;31835Try 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).
Regards,
Rosali

Theet

#77
Quote from: rosali;31851Check 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.
Regards,
Rosali

rosali

Regards,
Rosali

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

Quote from: rosali;31858... 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

Regards,
Rosali

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';
Regards,
Rosali