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) »
  • Where is the event location stored in the DB?
Pages: [1]

Author Topic: Where is the event location stored in the DB?  (Read 505 times)

tiepolo

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 3.4
  • CMS version: Drupal 6
  • MySQL version: 4.1
  • PHP version: 4.4.0
Where is the event location stored in the DB?
April 17, 2014, 02:24:33 pm
I am trying to create a Drupal View that allows people to search for events created in CiviCRM, but the event location is not showing up in the list of available fields to expose. I am looking for where the event's address or location is stored in the database, but I can't find it. Any help is appreciated.

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Where is the event location stored in the DB?
April 17, 2014, 05:02:31 pm
The event address it stored in civicrm_address.   When I create a view for events they are just there available for use, but then I am using Civicrm 4.4 not 3.4 .

Your whole install (php, mysql, drupal and civicrm) uses very old versions.

Are you able to upgrade these?

tiepolo

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 3.4
  • CMS version: Drupal 6
  • MySQL version: 4.1
  • PHP version: 4.4.0
Re: Where is the event location stored in the DB?
April 18, 2014, 08:55:13 am
Unfortunately I am not able to upgrade at this point. At least not easily. There was a lot of customization done to our current version and would need to do a lot of regression testing. Thanks for your reply! I will look to see if I can figure out how to do an events View.

tiepolo

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 3.4
  • CMS version: Drupal 6
  • MySQL version: 4.1
  • PHP version: 4.4.0
Re: Where is the event location stored in the DB?
April 21, 2014, 08:42:28 am
Joanne, your reply helped out tremendously. I was under the impression that the address for an event would be in a separate table than the address for a constituent. When looking at the fields to expose in Drupal Views, it showed "CiviCRM: Address" even though I had created a Drupal View for CiviCRM: Event, so I was confused.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Where is the event location stored in the DB?

This forum was archived on 2017-11-26.