CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Integrating CiviEvents with Drupal Calendar
Pages: [1] 2 3 4

Author Topic: Integrating CiviEvents with Drupal Calendar  (Read 56993 times)

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Integrating CiviEvents with Drupal Calendar
July 16, 2009, 09:21:22 am
Step by step instructions: http://wiki.civicrm.org/confluence/display/CRMDOC/Using+Drupal+Calendar+with+CiviEvent
« Last Edit: July 16, 2009, 09:52:46 am by emilyf »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Integrating CiviEvents with Drupal Calendar
July 16, 2009, 12:51:07 pm
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
Protect your investment in CiviCRM by  becoming a Member!

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
Re: Integrating CiviEvents with Drupal Calendar
August 24, 2009, 01:50:50 pm
Emily,

Thank you!

Shai Gluskin
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

choster

  • I’m new here
  • *
  • Posts: 29
  • Karma: 2
    • Lattice Group
  • CiviCRM version: 4.3,4.4,4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.39
  • PHP version: 5.5.15
Re: Integrating CiviEvents with Drupal Calendar
October 02, 2009, 03:20:45 pm
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

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 0
Re: Integrating CiviEvents with Drupal Calendar
October 06, 2009, 11:00:35 am
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

« Last Edit: October 06, 2009, 11:02:37 am by nextwave »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Integrating CiviEvents with Drupal Calendar
October 06, 2009, 01:06:45 pm
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.
Protect your investment in CiviCRM by  becoming a Member!

nextwave

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 0
Re: Integrating CiviEvents with Drupal Calendar
October 06, 2009, 01:10:32 pm
Quote from: Dave Greenberg on October 06, 2009, 01:06:45 pm
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.

« Last Edit: October 15, 2009, 09:35:44 am by nextwave »

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Integrating CiviEvents with Drupal Calendar
October 15, 2009, 08:45:32 am
is civicrm in a different db than drupal?

nextwave

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 0
Re: Integrating CiviEvents with Drupal Calendar
October 15, 2009, 08:52:06 am
Quote from: emilyf on October 15, 2009, 08:45:32 am
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
« Last Edit: October 15, 2009, 09:01:57 am by nextwave »

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Integrating CiviEvents with Drupal Calendar
October 15, 2009, 09:15:49 am
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 post occasionally
  • **
  • Posts: 62
  • Karma: 0
Re: Integrating CiviEvents with Drupal Calendar
October 15, 2009, 09:35:12 am
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
« Last Edit: October 15, 2009, 09:37:11 am by nextwave »

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Integrating CiviEvents with Drupal Calendar
October 15, 2009, 09:47:24 am
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

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 0
Re: Integrating CiviEvents with Drupal Calendar
October 15, 2009, 09:56:00 am
Quote from: emilyf on October 15, 2009, 09:47:24 am
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

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Integrating CiviEvents with Drupal Calendar
October 15, 2009, 10:22:48 am
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

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 0
Re: Integrating CiviEvents with Drupal Calendar
October 15, 2009, 10:25:04 am
Quote from: emilyf on October 15, 2009, 10:22:48 am
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.
Pages: [1] 2 3 4
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Integrating CiviEvents with Drupal Calendar

This forum was archived on 2017-11-26.