Can't create event in calendar.

[andries78]

Goodevening!
I am a beginner but hope that you can help me

I have installed Roundcube Roundcube 0.5.1 and it works correctly.
Then I have copy the "calendar" and "jqueryui" folder in the plugins folder of "roundcube".
Then I have add the line

$rcmail_config['plugins'] = array(
  'jqueryui',
  'calendar'
  );

in the "main.inc.php" in the "roundcube\config" folder

And I have run the followed SQL:

Code: [Select]


CREATE TABLE `events` (
  `event_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` text,
  `recurrence_id` text,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `start` int(10) unsigned NOT NULL DEFAULT '0',
  `end` int(10) unsigned NOT NULL DEFAULT '0',
  `expires` int(10) unsigned NOT NULL DEFAULT '0',
  `rr` varchar(1) default NULL,
  `recurring` text NOT NULL,
  `occurrences` int(11) DEFAULT '0',
  `byday` text,
  `bymonth` text,
  `bymonthday` text,
  `summary` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `location` varchar(255) NOT NULL DEFAULT '',
  `categories` varchar(255) NOT NULL DEFAULT '',
  `all_day` tinyint(1) NOT NULL DEFAULT '0',
  `group` text,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `del` int(1) NOT NULL DEFAULT '0',
  `notified` int(1) NOT NULL default '0',
  `client` text,
 PRIMARY KEY (`event_id`),
 CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
)  ENGINE=INNODB   CHARACTER SET utf8 COLLATE utf8_general_ci

CREATE TABLE `events_cache` (
  `event_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` text,
  `recurrence_id` text,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `start` int(10) unsigned NOT NULL DEFAULT '0',
  `end` int(10) unsigned NOT NULL DEFAULT '0',
  `expires` int(10) unsigned NOT NULL DEFAULT '0',
  `rr` varchar(1) default NULL,
  `recurring` text NOT NULL,
  `occurrences` int(11) DEFAULT '0',
  `byday` text,
  `bymonth` text,
  `bymonthday` text,
  `summary` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `location` varchar(255) NOT NULL DEFAULT '',
  `categories` varchar(255) NOT NULL DEFAULT '',
  `all_day` tinyint(1) NOT NULL DEFAULT '0',
  `group` text,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `del` int(1) NOT NULL DEFAULT '0',
  `notified` int(1) NOT NULL default '0',
  `client` text,
 PRIMARY KEY (`event_id`),
 CONSTRAINT `user_id_fk_events_cache` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
)  ENGINE=INNODB   CHARACTER SET utf8 COLLATE utf8_general_ci



I think, so far so good.

Now I can clicked on the "Calendar" button right from the webpage and it loads correctly

But now the problem.
If I clicked on a day/time there is a popup where I can fill a event.
The I clicked "save".
But in the calendar I can't see the event!
What's wrong?


Greetings,
Andries

[SKaero]

In the /plugins/calendar/config/config.inc.php file did you change $rcmail_config['backend'] to database?

[AmpSys]

In the /plugins/calendar/config/config.inc.php file did you change $rcmail_config['backend'] to database?

Not to steal the OPs thunder here, but I'm having the exact same issue, except that changing the backend to 'database' results in the message:

Server Error! (SERVICE CURRENTLY NOT AVAILABLE!)

I also get the same thing when trying to import any of the test .ics appts.

I have to be missing something - is webcalendar supposed to be installed in a subdirectory of the rc folder with its db named as the backend?

Thanks for any help!

[SKaero]

What's in your error log?

[andries78]

Thanks for your reply.

In the /plugins/calendar/config/config.inc.php file did you change $rcmail_config['backend'] to database?

If have checked the "/plugins/calendar/config/" folder and there is one file, "config.inc.php.dst".
Mhh.. ok, I have renamed the file in "config.inc.php" and change the "backend" param to the correct Database.

But when I rename the file, the roundcube mail is DOWN!
(Error http:500)

no error log found.

If I change the file back to "config.inc.php.dst" the roundcube mail is worked correctly.

Is there perhaps a install script to install the calendar correctly?
(When I install roundcube, there is a installer folder with a simple wizard!)

[rosali]

Error 500 indicates there is something wrong with database settings.

What did you change in renamed config.inc.php exactly?

[andries78]

I have change two lines.

$rcmail_config['backend'] = "roundcube";
(I have create a database "roundcube")

And
$rcmail_config['cron_rc_url'] = 'http://www.webadress.com/roundcube/';

[dshepherd]

Your backend variable is incorrect and likely to be your problem.

You need to change
$rcmail_config['backend'] = "roundcube";

to
$rcmail_config['backend'] = "database";

[andries78]

Thanks!

I have changed the param "roundcube" back to "database" and now..

It works!:)


I'm happy!

[andries78]

oops, there is another error.
If I try it on a windows 7 pc with IE8, the calendar works great!
But if I open the calendar with windows xp and ie7 there is a error.
below the ie7 page with "Common_agenda not defined." :-(

[AmpSys]

What's in your error log?

Here's what shows in the log when trying to add a calendar event:

Code: [Select]


[13-Feb-2011 12:31:53] PHP Fatal error:  Call to undefined function curl_init() in /var/www/clients/client1/web14/web/plugins/calendar/program/utils.php on line 23
[13-Feb-2011 12:32:13] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_30899b38b21d5662d2343cc0191623dc692d05a39 FROM 'INSERT INTO `events`\r\n         (`user_id`, `start`, `end`, `summary`, `description`, `location`, `categories`, `all_day`, `recurring`, `rr`, `expires`, `occurrences`, `byday`, `bymonth`, `bymonthday`, `recurrence_id`, `uid`, `client`, `timestamp`)\r\n         VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)']
[Native code: 1054]
[Native message: Unknown column 'location' in 'field list']

[13-Feb-2011 12:32:13 -0500]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_30899b38b21d5662d2343cc0191623dc692d05a39 FROM 'INSERT INTO `events`\r\n         (`user_id`, `start`, `end`, `summary`, `description`, `location`, `categories`, `all_day`, `recurring`, `rr`, `expires`, `occurrences`, `byday`, `bymonth`, `bymonthday`, `recurrence_id`, `uid`, `client`, `timestamp`)\r\n         VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)']
[Native code: 1054]
[Native message: Unknown column 'location' in 'field list']
 in /var/www/clients/client1/web14/web/program/include/rcube_mdb2.php on line 268 (POST /?_task=dummy&_action=plugin.newEvent?_task=&_action=)


[rosali]

The first step is to install PHP module CURL.
Without CURL it won't run at all.

The database errors indicate that there is something wrong with
'events' and/or 'events_cache' table.

Which script did you use to create the tables?

[AmpSys]

The first step is to install PHP module CURL.
Without CURL it won't run at all.

The database errors indicate that there is something wrong with
'events' and/or 'events_cache' table.

Which script did you use to create the tables?

Thanks, Rosali.

I ran my info.php file and you're right - CURL module not listed.

So I installed CURL, listed the extension in my php.ini file and restarted apache.

Tested again - same problem.

I was running the script that was included in the "bug fix" release from a couple days ago.

I dropped the events table and re-ran the events portion of the mysql.sql file in that bug-fix release.

Tested again and now all is working.

Thanks so much for your help - not sure how the events table got borked the first time, but dropping it and re-creating it seemed to do the trick and not having CURL was a definite miss on my part.