Roundcube calendar plugin not working

[rosali]

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!

[Dronch]

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)

[Theet]

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?

[rosali]

@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.

[Theet]

@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...

[rosali]

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!

[Theet]

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.

[Theet]

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;

[rosali]

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.

[Theet]

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)

[rosali]

Could you give me remote access?

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

[Theet]

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.

[Theet]

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...

[Theet]

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)

[rosali]

Click on event and hit delete button on the upcoming dialog.