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

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #45 on: December 03, 2010, 06:11:42 AM »
I'm not a visionary. I have asked more than once to check logs. If you are not even able to check your logs, please don't bug me!
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Dronch

  • Newbie
  • *
  • Posts: 7
Roundcube calendar plugin not working
« Reply #46 on: December 03, 2010, 06:19:25 AM »
Quote from: rosali;31655
I'm not a visionary. I have asked more than once to check logs. If you are not even able to check your logs, please don't bug me!

[03-Dec-2010 14:17:01 +0300]: PHP Error: Deprecated hook name. save_preferences -> preferences_save in /www/soundcas/users/soundcas-syntpac/www/htdocs/mail/program/include/rcube_plugin_api.php on line 207 (GET /mail/?_task=dummy&_action=plugin.getEvents&_=1291375019823&start=1290978000&end=1294606800)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
Error Log
« Reply #47 on: December 03, 2010, 07:02:03 AM »
Quote from: rosali;31633
There is something wrong with your setup. I'm not a visionary. Check your logs ...

I have checked the error log, please see enclosure.

check:

1) user for roundcubemail = roundcube (in PostgreSQL)
2) login roundcubemail = a user from synology NAS = is not
    defined in the list of the database (every user has automatich a mail adress for MailStation)
3) looked to the file rcube_mdb2.php and don't know what to do
    he checked before proceeding and gives an error...

mail works fine, calendar does'nt work. I think there must be a redirection to the users of the synology NAS and
not to the users of the roundcubemail, am I right? And how should I make this change?
« Last Edit: December 03, 2010, 08:45:59 AM by Theet »

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #48 on: December 04, 2010, 12:55:21 AM »
@Dronch:

I don't fix things in old versions. Your error log states that you have installed an outdated plugin which uses deprectated hook 'save_preferences'. This is not a recent plugin of mine. I have updated my hooks completely.

@Theet:

There is something wrong with your database (events table). I don't use PostgreSQL.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
Plugin Sticky Note
« Reply #49 on: December 07, 2010, 02:37:30 AM »
Quote from: rosali;31673
@Dronch:

I don't fix things in old versions. Your error log states that you have installed an outdated plugin which uses deprectated hook 'save_preferences'. This is not a recent plugin of mine. I have updated my hooks completely.

@Theet:

There is something wrong with your database (events table). I don't use PostgreSQL.


In the enclosure I have made a PostgreSQL for Sticky Note, it works!
This can be enclosed to the trunk plugins Sticky Note.
I have to begin with small PostgreSQL scripts to understand the script for
the calendar.

What is wrong with the events table in the database, I have no idea...

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #50 on: December 07, 2010, 03:55:10 AM »
Well the screenshot of your logs states that there are problems with the user_id and recurrence_id fields. I can't help you with this issue. My PostgresSQL knowledge is zero.

Thanks for the notes script!
« Last Edit: December 07, 2010, 03:58:36 AM by rosali »
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
Recurrence_id?
« Reply #51 on: December 07, 2010, 04:06:33 AM »
Quote from: rosali;31703
Well the screenshot of your logs states that there are problems with the user_id and recurrence_id fields. I can't help you with this issue. My PostgresSQL knowledge is zero.

Thanks for the notes script!

I know that user_id is the same unique field of the users Synology NAS.
What I have to do with recurrence_id I don't know, but I will try to
solve the problem.

Thanks also for your advice at this moment.
« Last Edit: December 07, 2010, 04:09:24 AM by Theet »

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
Roundcube calendar plugin not working
« Reply #52 on: December 07, 2010, 09:18:30 AM »
Quote from: Theet;31704
I know that user_id is the same unique field of the users Synology NAS.
What I have to do with recurrence_id I don't know, but I will try to
solve the problem.

Thanks also for your advice at this moment.

I have change into database.php "getEvents"
AND ".$this->q('recurrence_id')."<>0", into
AND ".$this->q('recurrence_id')."=?",

Then there will happens nothing, also not an error...
It looks like with user is nothing wrong but recurrence table.

What does the recurrence table doing exactly?

I have also no "fetch_assoc" table.... in my PostgreSQL database.... what is this?

 $recurrences = array();
      while ($result && ($event = $this->rcmail->db->fetch_assoc($result))) {
        $recurrences[] = $event;
« Last Edit: December 07, 2010, 09:21:46 AM by Theet »

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #53 on: December 07, 2010, 09:33:32 AM »
Try:

      $rcmail 
$this->rcmail;
      
$result $this->rcmail->db->query(
        
"SELECT * FROM " $this->table('events') . 
         WHERE "
.$this->q('user_id')."=? AND ".$this->q('recurrence_id')."<>?",
         
$this->rcmail->user->ID,
         
0
      
);


fetch_assoc is ok (Postgres compatibility is garantueed by roundcbuce mdb2 driver).

The query collects all table rows for current user where recurrence_id is not equal 0.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
Try this... "<>?"
« Reply #54 on: December 08, 2010, 12:48:32 AM »
Quote from: rosali;31707
Try:

      $rcmail 
$this->rcmail;
      
$result $this->rcmail->db->query(
        
"SELECT * FROM " $this->table('events') . 
         WHERE "
.$this->q('user_id')."=? AND ".$this->q('recurrence_id')."<>?",
         
$this->rcmail->user->ID,
         
0
      
);


fetch_assoc is ok (Postgres compatibility is garantueed by roundcbuce mdb2 driver).

The query collects all table rows for current user where recurrence_id is not equal 0.


It wil nothing do, the same action with "=?" (no reaction of the server)

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #55 on: December 08, 2010, 03:51:16 AM »
Could you give me remote access?

FTP (read-write) to Roundcube root folder
IMAP test account
Postgres Webaccess
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
remote
« Reply #56 on: December 08, 2010, 06:41:21 AM »
Quote from: rosali;31712
Could you give me remote access?

FTP (read-write) to Roundcube root folder
IMAP test account
Postgres Webaccess

I'am very sorry, but that is not so simple for me, because then you will have all rights in my NAS.
For ftp to roundcubemail you have now login into the linux program of the NAS. Also the phppgadmin
is now an open database, if I change rights, then programs as roundcube will not work.

I will try to make a user so that you can login, but this will costs more time for me.
« Last Edit: December 09, 2010, 09:48:27 AM by Theet »

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
Calendar works!
« Reply #57 on: December 10, 2010, 06:34:53 AM »
Yesterday I have change several settings in my NAS. After that I could'nt login to roundcube mail.

I have build a new database for roundcubemail, setup for roundcube with the plugins: sticky-note, calendar and jqueryui. Changed the backend database.php into "database". (with trunk plugins) After that I restarted the NAS.

Now it works realy fine, also the calendar, a great plugin!!!

I think there was something wrong with the complete setup of the roundcubemail database.

@ Rosali: Thank you very much for the help in the last days!
I hope that I was helpfull for the PostgreSQL script sticky_note...
« Last Edit: December 10, 2010, 07:51:04 AM by Theet »

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to delete posts?
« Reply #58 on: December 10, 2010, 07:50:49 AM »
I can insert events, but not modify/delete? Is there something about
a time in it for modify a message?

(I have tried to modify with a time between login)

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Roundcube calendar plugin not working
« Reply #59 on: December 10, 2010, 08:25:16 AM »
Click on event and hit delete button on the upcoming dialog.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)