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 Drupal Modules (Moderator: Donald Lobo) »
  • CiviCRM 3 + Drupal Calendar (events "don't exist")
Pages: [1]

Author Topic: CiviCRM 3 + Drupal Calendar (events "don't exist")  (Read 3237 times)

at02

  • Guest
CiviCRM 3 + Drupal Calendar (events "don't exist")
October 28, 2009, 01:12:34 pm
Hello,

I just upgraded Civicrm to 3 and also upgraded to the latest of the calendar and date modules for drupal (I never did get it working under the "old way"... I'm so glad it all got updated/easier)

I made an event to test out the new calendar, and I get this error, plus the event never shows up:



    * user warning: Table 'jasgcinf_jasgcsite.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(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') <= '2009-10' AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') >= '2009-10')) ORDER BY civicrm_event_start_date ASC in /home2/jasgcinf/public_html/sites/all/modules/views/includes/view.inc on line 759.
    * user warning: Table 'jasgcinf_jasgcsite.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(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') <= '2009-10' AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') >= '2009-10')) ORDER BY civicrm_event_start_date ASC in /home2/jasgcinf/public_html/sites/all/modules/views/includes/view.inc on line 759.


Sorry this is a lot of mess.. but I'm not sure what to do to fix this. The page can be found here.

Thanks in advance for any and all help/suggestions. I tried to do a search for this but I got a lot of unrelated posts instead :\

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviCRM 3 + Drupal Calendar (events "don't exist")
October 28, 2009, 01:31:10 pm

make sure u've followed the steps here:

http://wiki.civicrm.org/confluence/display/CRMDOC/Views2+Integration+Module

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

at02

  • Guest
Re: CiviCRM 3 + Drupal Calendar (events "don't exist")
October 29, 2009, 06:54:17 am
Thanks, I think this should fix it - since I did use different databases for drupal and civicrm.

The only problem is that I don't exactly understand what to do on the second step. Can someone explain that a little clearer? Maybe it's just the sickness clouding my head, but I don't really understand what to do at that point....


Thanks in advance.



[edit] okay, after looking at this site: http://redspire.net/content/civicrm-views-2-integration-remote-civicrm-database it has all become clear, and my calendar works. Thanks again! Also, thanks to everyone who worked to make views+calendar+civicrm work soo much easier! [/edit]
« Last Edit: October 29, 2009, 07:27:36 am by at02 »

at02

  • Guest
Re: CiviCRM 3 + Drupal Calendar (events "don't exist")
November 03, 2009, 09:36:12 am
Okay, well, it worked on our test site, but not on our new website?

We've been working on building a new website for some time now, and now that I've been installing everything (fresh, not copy-pasting anything over) to the new website, I followed the directions above, cleared views cache, cleared drupal cache, cleared my browser's cache, cookies and history, but I just get more errors.

See errors here:



    * user warning: Table 'jasgcorg_site.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(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') <= '2009-11' AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') >= '2009-11')) ORDER BY civicrm_event_start_date ASC in /home3/jasgcorg/public_html/sites/all/modules/views/includes/view.inc on line 759.
    * user warning: Table 'jasgcorg_site.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(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') <= '2009-11' AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') >= '2009-11')) ORDER BY civicrm_event_start_date ASC in /home3/jasgcorg/public_html/sites/all/modules/views/includes/view.inc on line 759.
    * user warning: Table 'jasgcorg_site.civicrm_event' doesn't exist query: SELECT COUNT(*) FROM (SELECT civicrm_event.id AS id FROM civicrm_event civicrm_event WHERE (civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0) ) count_alias in /home3/jasgcorg/public_html/sites/all/modules/views/includes/view.inc on line 729.
    * user warning: Table 'jasgcorg_site.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) ORDER BY civicrm_event_start_date ASC LIMIT 0, 5 in /home3/jasgcorg/public_html/sites/all/modules/views/includes/view.inc on line 755.



I've cleared the cache again but that didn't seem to help. Any ideas? Please?

Thanks in advance.


emmy

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Re: CiviCRM 2 + Drupal Calendar (events "don't exist")
September 16, 2013, 07:41:10 am
Hi Guys,

Where you ever able to solve the above issue? Am in the same boat...
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • CiviCRM 3 + Drupal Calendar (events "don't exist")

This forum was archived on 2017-11-26.