Author Topic: Roundcube calendar plugin not working  (Read 42847 times)

Offline toootooo

  • Jr. Member
  • **
  • Posts: 11
Roundcube calendar plugin not working
« Reply #15 on: September 09, 2010, 10:00:24 AM »
And what should I do?

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #16 on: September 09, 2010, 11:43:25 AM »
@ 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?
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline alec

  • Hero Member
  • *****
  • Posts: 1,155
Roundcube calendar plugin not working
« Reply #17 on: September 10, 2010, 02:35:08 AM »
Code: [Select]

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.

Offline toootooo

  • Jr. Member
  • **
  • Posts: 11
Roundcube calendar plugin not working
« Reply #18 on: September 10, 2010, 07:14:42 AM »
After adding this code rcube_mdb2::quote_identifier('end') to plugins/calendar/program/backend/database.php:

Quote
$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:

Quote
PHP Fatal error:  Call to undefined method Database::db_connect() in /usr/local/etc/httpd/webmail/program/include/rcube_mdb2.php on line 456,
« Last Edit: September 10, 2010, 09:09:07 AM by toootooo »

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #19 on: September 13, 2010, 12:22:18 AM »
Check new release.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline toootooo

  • Jr. Member
  • **
  • Posts: 11
Roundcube calendar plugin not working
« Reply #20 on: September 13, 2010, 03:01:14 AM »
Quote from: rosali;29992
Check new release.

Thanx! The calendar plugin is working just fine now!

P.S: Russian translation attached!

Good luck!

Offline K9Marc

  • Newbie
  • *
  • Posts: 7
Roundcube calendar plugin not working
« Reply #21 on: September 22, 2010, 03:31:48 PM »
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

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #22 on: September 23, 2010, 01:32:55 AM »
Do you have installed jqueryui plugin? Could you give me remote access to your server. PM'me details.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline K9Marc

  • Newbie
  • *
  • Posts: 7
Roundcube calendar plugin not working
« Reply #23 on: September 24, 2010, 04:33:31 PM »
Yes sir, plugin installed and PM sent with access to my site.

Thanks again

Marc

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #24 on: September 26, 2010, 07:51:04 AM »
You missed to configure the plugin to use database backend instead of using the demo mode. Check your mails.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline nerbrume

  • Jr. Member
  • **
  • Posts: 11
Roundcube calendar plugin not working
« Reply #25 on: October 01, 2010, 09:17:29 AM »
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]
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]
$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.

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #26 on: October 17, 2010, 02:55:30 AM »
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.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
Roundcube calendar & jqueryui-1.8.2.1
« Reply #27 on: November 30, 2010, 09:34:03 AM »
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)

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #28 on: November 30, 2010, 09:50:03 AM »
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.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
Which database backend?
« Reply #29 on: November 30, 2010, 10:28:47 AM »
Quote from: rosali;31582
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...