Roundcube calendar plugin not working

[toootooo]

And what should I do?

[rosali]

@ alec:

Could you please explain how the queries have to be modified?

Currently f.e.:

      $query = $this->rcmail->db->query(
        "UPDATE " . get_table_name('events') . " 
         SET start=?, end=?, all_day=?, timestamp=?, notified=?
         WHERE event_id=?
         AND user_id=?",
        $start,
        $end,
        $allDay,
        date('Y-m-d H:i:s', time()),
        0,        
        $id,
        $this->rcmail->user->ID
      );


Or would it be better to rename the 'end' table column?

[alec]

Code Select Expand


SET start=?, ".$this->rcmail->db->quote_delimiter('end')."=?, all_day=?, timestamp=?, notified=?

also, to be sure that other columns in different databases are working ok, you should probably use quote_identifier on all columns. I think this will be simpler and prefered than column name change.

[toootooo]

After adding this code rcube_mdb2::quote_identifier('end') to plugins/calendar/program/backend/database.php:

$query = $this->rcmail->db->query(
        "INSERT INTO " . get_table_name('events') . "
         (user_id, start,". rcube_mdb2::quote_identifier('end').", summary, description, location, categories, all
_day, recurring, rr, expires, occurrences, byday, bymonth, bymonthday, recurrence_id, uid, timestamp)
         VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",...

I got this error:

PHP Fatal error:  Call to undefined method Database::db_connect() in /usr/local/etc/httpd/webmail/program/include/rcube_mdb2.php on line 456,

[rosali]

Check new release.

[toootooo]

Check new release.

Thanx! The calendar plugin is working just fine now!

P.S: Russian translation attached!

Good luck!

[K9Marc]

Hello Rosali,

I have hMailserver running with Roundcube as the webmail portal.

I installed the latest calendar plugin from you and I must have not done something I need to. It has a bunch of items already posted and I cant seem to save any new items, delete or open the existing ones.

Is there a step by step instruction area I can refer to for these plugins?

It looked like I got the "Event" table creatated in MySql ok.

Thanks for any assistance!!

Marc

[rosali]

Do you have installed jqueryui plugin? Could you give me remote access to your server. PM'me details.

[K9Marc]

Yes sir, plugin installed and PM sent with access to my site.

Thanks again

Marc

[rosali]

You missed to configure the plugin to use database backend instead of using the demo mode. Check your mails.

[nerbrume]

Hi Rosali, and thanks for this plugin.

I have to small (non-blocking) problem, don't know if they are related.

First, my roundcube log warns me with :

Code Select Expand

roundcube: PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/wwws/mail/plugins/calendar/calendar.php on line 1094

the corresponding line is : $enabled = in_array($num, $workdays);
I'v check my config, and workdays seems well defined to me :

Code Select Expand

$rcmail_config['workdays'] = array(1,2,3,4,5);


Next problem is the use of the "first_hour" parameter. Is this supposed to fix the hour at wich the view of the calendar starts ?
Because my calendar view always start at 00h, and ends at 24h, causing very small cells. I'don't see any effect when changing "first_hour"

I hope I was clear enough, I can provide precisions if needed.

[rosali]

Sorry for delayed reply due to vacations.

So you use recent version from myroundcube - Project Hosting on Google Code ?

I do not see the warning here. Also first hour setting works for me.

[Theet]

I have installed the calendar & jqueryui-1.8.2.1 plugin, it seems to be working perfectly, but it is read only.

How can I fully use the calendar without dummy appointments?

Have I change a setting?

I use the calendar in roundcube v0.4 for Synology NAS (PostgreSQL, files calendar includes a PostgreSQL update)

[rosali]

Configure it to use database backend. Do not miss to create database table. If you use beta version from Downloads - myroundcube - Project Hosting on Google Code don't miss to upgrade Roundcube to 0.5 beta.

[Theet]

Configure it to use database backend. Do not miss to create database table. If you use beta version from Downloads - myroundcube - Project Hosting on Google Code don't miss to upgrade Roundcube to 0.5 beta.

I have just installed roundcube 0.5 beta and also put the plugin calendar and jqueryui in de map plugins.
What I have to do with the database backend? I don't understand it...