Scott

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • in reply to: Goecoding venues caused 503 error #1476705
    Scott
    Participant

    I solved my issue by migrating my site to a more robust server via my
    cloudhost provider.

    in reply to: events on map view in spain, but map for event is correct. #1448544
    Scott
    Participant

    So sorry for dropping off. I have the same situation happening again.

    Map of all events display multiple events at the intersection of the GMT
    and the equator
    https://ameriestate.com/events/

    But the individual event’s map is correct
    https://ameriestate.com/event/turlock-ca-free-living-trust-seminar-mar-15-2018-2/

    Scott
    Participant

    I am getting the EXACT same thing happening. Migrated my site to a VPS for a more controlled test with same results.

    WP, themes, and plugins are all updated.

    I rely on this feature heavily. CSV import was one to the two features that I require for my project which lead me to choose this plugin and loosing CSV import would be very bad.

    Thanks

    in reply to: CSV Import and Venue Names #1007094
    Scott
    Participant

    I tested this theory by concatenating venue name and venu city as the imported venue name and that worked. However I do not think that alone will be good enough because we also host at Marie Calendars and I can for see hosting an event at different Marie Calendars in the same city.

    So it would be best to use the full address as the match. But then that would look ugly with all the preformated templates that display venue name. My thought was to redo all my templated and then do a php function to display the venue name but stripping off the info added for the import matching.

    I have posted my request to user voice.

    Thank you for your response.

    in reply to: replacing geo_loc.php into my theme #998095
    Scott
    Participant

    So what options would one have to replace the default placeholder text in the tribe bar without the changes getting wiped by an update?

    Scott
    Participant

    I did it the old fashioned way, sql. Here is my select statement incase if proves helpful to others.

      SELECT
        wp_posts.ID AS id
        , wp_posts.post_type AS post_type
        , wp_posts.post_title AS _EventTitle
        , (SELECT (e.meta_value) FROM wp_postmeta AS e WHERE e.post_id = wp_posts.ID AND e.meta_key = '_EventStartDate') AS _EventStartDate
        , (SELECT (e.meta_value) FROM wp_postmeta AS e WHERE e.post_id = wp_posts.ID AND e.meta_key = '_EventVenueID')
        , (SELECT (v.meta_value) FROM wp_postmeta AS v WHERE v.post_id = (SELECT (e.meta_value) FROM wp_postmeta AS e WHERE e.post_id = wp_posts.ID AND e.meta_key = '_EventVenueID') AND v.meta_key = '_VenueCity') AS _VenueCity
        , (SELECT (v.meta_value) FROM wp_postmeta AS v WHERE v.post_id = (SELECT (e.meta_value) FROM wp_postmeta AS e WHERE e.post_id = wp_posts.ID AND e.meta_key = '_EventVenueID') AND v.meta_key = '_VenueProvince') AS _VenueProvince 
    FROM
        manageda_wp977.wp_posts
    WHERE 
        (wp_posts.post_type LIKE '%tribe_event%')
        AND (SELECT (e.meta_value) FROM wp_postmeta AS e WHERE e.post_id = wp_posts.ID AND e.meta_key = '_EventStartDate') > '2015-08-10'
    ORDER BY 
        (SELECT (v.meta_value) FROM wp_postmeta AS v WHERE v.post_id = (SELECT (e.meta_value) FROM wp_postmeta AS e WHERE e.post_id = wp_posts.ID AND e.meta_key = '_EventVenueID') AND v.meta_key = '_VenueProvince') ASC
        , (SELECT (e.meta_value) FROM wp_postmeta AS e WHERE e.post_id = wp_posts.ID AND e.meta_key = '_EventStartDate') ASC
Viewing 6 posts - 1 through 6 (of 6 total)