Integrating CiviEvents with Drupal Calendar

[emilyf]

Step by step instructions: http://wiki.civicrm.org/confluence/display/CRMDOC/Using+Drupal+Calendar+with+CiviEvent

[Dave Greenberg]

Emily - documentation looks AWESOME - thanks for pulling this together! I've also added a link to your doc from the CiviEvents Admin section on displaying event blocks and calendars (so people can find your page :-) ):

http://wiki.civicrm.org/confluence/display/CRMDOC/Event+Display+Blocks+and+Calendars

[Shai]

Emily,

Thank you!

Shai Gluskin

[choster]

Note that the CiviEvent Calendar does not integrate natively with Drupal's Calendar Popup module, which assumes its input will be nodes. http://drupal.org/node/513066 .

[nextwave]

Followed the steps but when I try to view, I get this error:



    * user warning: Table 'dir_drpl1.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') <= '2009-10-11' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2009-10-11')) ORDER BY civicrm_event_start_date ASC in /home/<dir>/public_html/sites/all/modules/views/includes/view.inc on line 759.
    * user warning: Table 'dir_drpl1.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, dir_event.title AS civicrm_event_title FROM civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') <= '2009-10-11' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2009-10-11')) ORDER BY civicrm_event_start_date ASC in /home/<dir>/public_html/sites/all/modules/views/includes/view.inc on line 759.


Any help?
Thanks

[Dave Greenberg]

A bit confusing since your profile says you are running "Standalone" and NOT Drupal ? This post is about using the Drupal Calendar - which definitely requires that you be running CiviCRM inside Drupal.

[nextwave]

A bit confusing since your profile says you are running "Standalone" and NOT Drupal ? This post is about using the Drupal Calendar - which definitely requires that you be running CiviCRM inside Drupal.

I will edit my profile. Am using Drupal. Thanks.

[emilyf]

is civicrm in a different db than drupal?

[nextwave]

is civicrm in a different db than drupal?

they have different database, isn't that the way it was setup ?

drpl1 is my drupal database
civicrm is my civicrm database

[emilyf]

try putting this line in your drupal settings.php file after the mysql area:

$db_prefix = array('default'=>'drupaldbhere','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');

where 'drupaldbhere' is the name of your drupal db. if that doesn't work try putting your civi db name there - i honestly cant remember right now which one is correct.

let me know if that fixes it, and if so which one was correct.

[nextwave]

I tried both drupal and civicrm database name, got this same error message:

Warning: Table 'c0mm1sh_drpl1.c0mm1sh_drpl1access' doesn't exist query: SELECT 1 FROM c0mm1sh_drpl1access WHERE type = 'host' AND LOWER('69.61.183.202') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /home/c0mm1sh/public_html/includes/database.mysql.inc on line 128

Warning: Table 'c0mm1sh_drpl1.c0mm1sh_drpl1users' doesn't exist query: SELECT u.*, s.* FROM c0mm1sh_drpl1users u INNER JOIN c0mm1sh_drpl1sessions s ON u.uid = s.uid WHERE s.sid = 'hex_number' in /home/c0mm1sh/public_html/includes/database.mysql.inc on line 128

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/c0mm1sh/public_html/includes/database.mysql.inc:128) in /home/c0mm1sh/public_html/includes/bootstrap.inc on line 1037

Warning: Table 'c0mm1sh_drpl1.c0mm1sh_drpl1cache' doesn't exist query: SELECT data, created, headers, expire, serialized FROM c0mm1sh_drpl1cache WHERE cid = 'variables' in /home/c0mm1sh/public_html/includes/database.mysql.inc on line 128

Warning: Table 'c0mm1sh_drpl1.c0mm1sh_drpl1variable' doesn't exist query: SELECT * FROM c0mm1sh_drpl1variable in /home/c0mm1sh/public_html/includes/database.mysql.inc on line 128

Warning: Table 'c0mm1sh_drpl1.c0mm1sh_drpl1cache' doesn't exist query: UPDATE c0mm1sh_drpl1cache SET data = '', created = 1255624086, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /home/c0mm1sh/public_html/includes/database.mysql.inc on line 128

Warning: Table 'c0mm1sh_drpl1.c0mm1sh_drpl1system' doesn't exist query: SELECT name, filename, throttle FROM c0mm1sh_drpl1system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /home/c0mm1sh/public_html/includes/database.mysql.inc on line 128

Warning: Cannot modify header information - headers already sent by (output started at /home/c0mm1sh/public_html/includes/database.mysql.inc:128) in /home/c0mm1sh/public_html/includes/bootstrap.inc on line 636

Warning: Cannot modify header information - headers already sent by (output started at /home/c0mm1sh/public_html/includes/database.mysql.inc:128) in /home/c0mm1sh/public_html/includes/bootstrap.inc on line 637

Warning: Cannot modify header information - headers already sent by (output started at /home/c0mm1sh/public_html/includes/database.mysql.inc:128) in /home/c0mm1sh/public_html/includes/bootstrap.inc on line 638

Warning: Cannot modify header information - headers already sent by (output started at /home/c0mm1sh/public_html/includes/database.mysql.inc:128) in /home/c0mm1sh/public_html/includes/bootstrap.inc on line 639

Warning: Table 'c0mm1sh_drpl1.c0mm1sh_drpl1url_alias' doesn't exist query: SELECT COUNT(pid) FROM c0mm1sh_drpl1url_alias in /home/c0mm1sh/public_html/includes/database.mysql.inc on line 128

[emilyf]

what exactly did you put in the file? by the looks of it you have written something incorrectly.
i honestly can't remember exactly right now, but i believe correctly configuring that line is what worked for me when i did this with 2 separate databases.

the other way you can do this is to merge your DBs. obviously back up and test this before doing it on your production server.

[nextwave]

what exactly did you put in the file? by the looks of it you have written something incorrectly.
i honestly can't remember exactly right now, but i believe correctly configuring that line is what worked for me when i did this with 2 separate databases.

the other way you can do this is to merge your DBs. obviously back up and test this before doing it on your production server.

$db_prefix = array('default'=>'c0mm1sh_drpl1','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');

[emilyf]

welp that is obviously not fixing it. as far as i know, that line allows you to switch between dbs. but it's a table prefix in drupal which is why you were getting those errors (if you read the errors, you see it's using that entry to prefix your drupal tables directly). so don't do that. it must not be related (it was just a guess, as it wasn't working in my setup without it).

i did get this working in 2 dbs though. however, all the other people who have gotten this working have merged their dbs. so i suggest you give that a try. or else someone who is more skilled and not sick with a 104 degree fever can chime in as i'm not exactly in my right mind today.

[nextwave]

welp that is obviously not fixing it. as far as i know, that line allows you to switch between dbs. but it's a table prefix in drupal which is why you were getting those errors (if you read the errors, you see it's using that entry to prefix your drupal tables directly). so don't do that. it must not be related (it was just a guess, as it wasn't working in my setup without it).

i did get this working in 2 dbs though. however, all the other people who have gotten this working have merged their dbs. so i suggest you give that a try. or else someone who is more skilled and not sick with a 104 degree fever can chime in as i'm not exactly in my right mind today.

Sorry about your illness, hope you get better soon.
 do I merge the databases and still keep the original ones?
Thanks for taking your time to help me out.