CiviCRM Community Forums (archive)

Hello,

I have a Calendar for the CiviCRM Events on a website I'm maintaining and for some reason when I add events they are not showing in the Calendar. I can filter the Calendar between Year, Month & Day but no events are showing. Is there something I need to enable in order for them to be shown?

Attached is an export I did of the Calendar code, any help you can provide is greatly appreciated, thanks.

What is your version of Drupal and CiviCRM?

Did you do the CiviCRM Views Integration step?

CiviCRM: 3.2.0
Drupal: 6.19

I'm not sure what the previous developer had done. I recently switched the servers that the install was sitting on and the events are not showing in the Calendar (I don't think they were enabled before). I'm just trying to sort out how to turn them back on. Do you have a link I could review re: the CiviCRM Views Integration step (perhaps I can work backwards and double check everything)?

Thanks.

http://wiki.civicrm.org/confluence/display/CRMDOC40/Views3+Integration

Thanks for that info, I had not done that. I just followed all of the steps and cleared my cache and there's still no change.

Any suggestions?

Examine the SQL that Views is generating for your view.

What should I be looking for?

This is my code:

$db_prefix = array(
  'civicrm_acl'                              => 'civicrm.',
  'civicrm_acl_cache'                        => 'civicrm.',
  'civicrm_acl_contact_cache'                => 'civicrm.',
  'civicrm_acl_entity_role'                  => 'civicrm.',
  'civicrm_activity'                         => 'civicrm.',
  'civicrm_activity_assignment'              => 'civicrm.',
  'civicrm_activity_target'                  => 'civicrm.',
  'civicrm_address'                          => 'civicrm.',
  'civicrm_address_format'                   => 'civicrm.',
  'civicrm_cache'                            => 'civicrm.',
  'civicrm_case'                             => 'civicrm.',
  'civicrm_case_activity'                    => 'civicrm.',
  'civicrm_case_contact'                     => 'civicrm.',
  'civicrm_component'                        => 'civicrm.',
  'civicrm_contact'                          => 'civicrm.',
  'civicrm_contact_type'                     => 'civicrm.',
  'civicrm_contribution'                     => 'civicrm.',
  'civicrm_contribution_page'                => 'civicrm.',
  'civicrm_contribution_product'             => 'civicrm.',
  'civicrm_contribution_recur'               => 'civicrm.',
  'civicrm_contribution_soft'                => 'civicrm.',
  'civicrm_contribution_type'                => 'civicrm.',
  'civicrm_contribution_widget'              => 'civicrm.',
  'civicrm_country'                          => 'civicrm.',
  'civicrm_county'                           => 'civicrm.',
  'civicrm_currency'                         => 'civicrm.',
  'civicrm_custom_field'                     => 'civicrm.',
  'civicrm_custom_group'                     => 'civicrm.',
  'civicrm_dashboard'                        => 'civicrm.',
  'civicrm_dashboard_contact'                => 'civicrm.',
  'civicrm_dedupe_rule'                      => 'civicrm.',
  'civicrm_dedupe_rule_group'                => 'civicrm.',
  'civicrm_discount'                         => 'civicrm.',
  'civicrm_domain'                           => 'civicrm.',
  'civicrm_email'                            => 'civicrm.',
  'civicrm_entity_file'                      => 'civicrm.',
  'civicrm_entity_financial_trxn'            => 'civicrm.',
  'civicrm_entity_tag'                       => 'civicrm.',
  'civicrm_event'                            => 'civicrm.',
  'civicrm_export_temp'                      => 'civicrm.',
  'civicrm_file'                             => 'civicrm.',
  'civicrm_financial_account'                => 'civicrm.',
  'civicrm_financial_trxn'                   => 'civicrm.',
  'civicrm_grant'                            => 'civicrm.',
  'civicrm_group'                            => 'civicrm.',
  'civicrm_group_contact'                    => 'civicrm.',
  'civicrm_group_contact_cache'              => 'civicrm.',
  'civicrm_group_nesting'                    => 'civicrm.',
  'civicrm_group_organization'               => 'civicrm.',
  'civicrm_im'                               => 'civicrm.',
  'civicrm_line_item'                        => 'civicrm.',
  'civicrm_loc_block'                        => 'civicrm.',
  'civicrm_location_type'                    => 'civicrm.',
  'civicrm_log'                              => 'civicrm.',
  'civicrm_mail_settings'                    => 'civicrm.',
  'civicrm_mailing'                          => 'civicrm.',
  'civicrm_mailing_bounce_pattern'           => 'civicrm.',
  'civicrm_mailing_bounce_type'              => 'civicrm.',
  'civicrm_mailing_component'                => 'civicrm.',
  'civicrm_mailing_event_bounce'             => 'civicrm.',
  'civicrm_mailing_event_confirm'            => 'civicrm.',
  'civicrm_mailing_event_delivered'          => 'civicrm.',
  'civicrm_mailing_event_forward'            => 'civicrm.',
  'civicrm_mailing_event_opened'             => 'civicrm.',
  'civicrm_mailing_event_queue'              => 'civicrm.',
  'civicrm_mailing_event_reply'              => 'civicrm.',
  'civicrm_mailing_event_subscribe'          => 'civicrm.',
  'civicrm_mailing_event_trackable_url_open' => 'civicrm.',
  'civicrm_mailing_event_unsubscribe'        => 'civicrm.',
  'civicrm_mailing_group'                    => 'civicrm.',
  'civicrm_mailing_job'                      => 'civicrm.',
  'civicrm_mailing_spool'                    => 'civicrm.',
  'civicrm_mailing_trackable_url'            => 'civicrm.',
  'civicrm_mapping'                          => 'civicrm.',
  'civicrm_mapping_field'                    => 'civicrm.',
  'civicrm_membership'                       => 'civicrm.',
  'civicrm_membership_block'                 => 'civicrm.',
  'civicrm_membership_log'                   => 'civicrm.',
  'civicrm_membership_payment'               => 'civicrm.',
  'civicrm_membership_status'                => 'civicrm.',
  'civicrm_membership_type'                  => 'civicrm.',
  'civicrm_menu'                             => 'civicrm.',
  'civicrm_msg_template'                     => 'civicrm.',
  'civicrm_navigation'                       => 'civicrm.',
  'civicrm_note'                             => 'civicrm.',
  'civicrm_openid'                           => 'civicrm.',
  'civicrm_openid_associations'              => 'civicrm.',
  'civicrm_openid_nonces'                    => 'civicrm.',
  'civicrm_option_group'                     => 'civicrm.',
  'civicrm_option_value'                     => 'civicrm.',
  'civicrm_participant'                      => 'civicrm.',
  'civicrm_participant_payment'              => 'civicrm.',
  'civicrm_participant_status_type'          => 'civicrm.',
  'civicrm_payment_processor'                => 'civicrm.',
  'civicrm_payment_processor_type'           => 'civicrm.',
  'civicrm_pcp'                              => 'civicrm.',
  'civicrm_pcp_block'                        => 'civicrm.',
  'civicrm_phone'                            => 'civicrm.',
  'civicrm_pledge'                           => 'civicrm.',
  'civicrm_pledge_block'                     => 'civicrm.',
  'civicrm_pledge_payment'                   => 'civicrm.',
  'civicrm_preferences'                      => 'civicrm.',
  'civicrm_preferences_date'                 => 'civicrm.',
  'civicrm_premiums'                         => 'civicrm.',
  'civicrm_premiums_product'                 => 'civicrm.',
  'civicrm_price_field'                      => 'civicrm.',
  'civicrm_price_set'                        => 'civicrm.',
  'civicrm_price_set_entity'                 => 'civicrm.',
  'civicrm_product'                          => 'civicrm.',
  'civicrm_project'                          => 'civicrm.',
  'civicrm_relationship'                     => 'civicrm.',
  'civicrm_relationship_type'                => 'civicrm.',
  'civicrm_report_instance'                  => 'civicrm.',
  'civicrm_saved_search'                     => 'civicrm.',
  'civicrm_state_province'                   => 'civicrm.',
  'civicrm_subscription_history'             => 'civicrm.',
  'civicrm_tag'                              => 'civicrm.',
  'civicrm_task'                             => 'civicrm.',
  'civicrm_task_action_temp'                 => 'civicrm.',
  'civicrm_task_status'                      => 'civicrm.',
  'civicrm_tell_friend'                      => 'civicrm.',
  'civicrm_timezone'                         => 'civicrm.',
  'civicrm_uf_field'                         => 'civicrm.',
  'civicrm_uf_group'                         => 'civicrm.',
  'civicrm_uf_join'                          => 'civicrm.',
  'civicrm_uf_match'                         => 'civicrm.',
  'civicrm_value_additional_participant_informati_8' => 'civicrm.',
  'civicrm_value_application_form_5'         => 'civicrm.',
  'civicrm_value_application_terms_6'        => 'civicrm.',
  'civicrm_value_downloads_2'                => 'civicrm.',
  'civicrm_value_member_records_1'           => 'civicrm.',
  'civicrm_value_member_records_temp_11'     => 'civicrm.',
  'civicrm_value_membership_details_4'       => 'civicrm.',
  'civicrm_value__sponsor_details_7'     => 'civicrm.',
  'civicrm_value_sponsored_link_10'          => 'civicrm.',
  'civicrm_value_sponsored_link_custom_data_9' => 'civicrm.',
  'civicrm_website'                          => 'civicrm.',
  'civicrm_worldregion'                      => 'civicrm.',
);

No, I mean this http://www.inmotionhosting.com/support/edu/drupal-7/views-module-tutorial/display-view-sql-query but that's for D7. Try this also https://drupal.org/node/1172228

Gotcha, i didn't know where you meant, thanks.

When I got under my events view and select "month view", the Query that is produced is the following:

SELECT civicrm_event.id AS id,
   civicrm_event.title AS civicrm_event_title,
   civicrm_event.start_date AS civicrm_event_start_date
 FROM civicrm.civicrm_event civicrm_event
 WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0) AND (civicrm_event.is_template = 0))
    AND ((DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m') <= '2013-08' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m') >= '2013-08'))
   ORDER BY civicrm_event_start_date ASC
Does that look normal?

Thanks again for your continued help.

Yes, looks good. Now run that yourself in MySQL (perhaps phpMyAdmin) and see if any events are found or not. If not, then try adjusting the dates.

Thanks, I actually just thought of doing that myself and upon changing the date range my event is showing up when I run the query in phpMyAdmin!

Any idea why the calendar wouldn't be showing the event, even though the query it spits out seems to be accurate?

Thanks again.

Do you realize what you are asking? For the data range you posted, you saw yourself that the SQL finds no events. So Views is correct to not show any events in the calendar.

You said if you change the dates, then the SQL does get events. Figure out what dates you used and view that section of the View and you should see the events.

Thanks again Hershel. When I view the same date range under Views and on the frontend of the website, nothing is being displayed. For example, I have added an event for Sept 15th, the event is showing in CiviCRM & in the database (as I saw with my query) but when I go to view in the Calendar on the site itself, the event is nowhere to be seen.

So my question is, why would the calendar (whether it be under Views or on the frontend of the site), not display any events (both in the past and in the future)? Is there some way to stop the calendar from displaying any events in the database, but still have it active?

Forgive me, my experience with Drupal and CiviCRM is minimal.

If you are using CiviCRM 3.2 then I would recommend you upgrade to the latest version. Going from 3.2 to 4.3.5 may not be easy and you may need to do it in smaller steps. Definitely read the wiki about upgrading first.