Author Topic: Event location goes missing after 24 hours (Read 417 times)

SarahG (FountainTribe) · February 15, 2012, 10:13:43 am

I am setting up a number of events with an associated location and a map. This works as expected initially, but after 24 hours the event location is removed from the event. Ideas on what to investigate?

SarahG (FountainTribe) · February 15, 2012, 03:07:36 pm

As part of researching this issue, I ran the SQL:
SELECT * FROM `civicrm_event` e, civicrm_loc_block lb
where e.loc_block_id = lb.id
and lb.address_id is null

which seems to be finding the problem events. How/what would cause the field "address_id" in the table "civicrm_loc_block" to be null? This seems odd. In this situation, the records in the table "civicrm_loc_block" have nulls for all the other fields as well, not just the "address_id" field.

CiviCRM Community Forums (archive)

News:

Author Topic: Event location goes missing after 24 hours (Read 417 times)

SarahG (FountainTribe)

Event location goes missing after 24 hours

SarahG (FountainTribe)

Re: Event location goes missing after 24 hours