[Jen Russo]

Aloha Geoff

so glad you are picking up this thread. So actually if you go to my first post on this issue – you can see – I have deleted all of the recurring events that have happened at rita’s. however the venue is still showing them there.

so to recap: i have already deleted all of the events that are showing up on the rita’s venue. That is the mystery we need to crack.

let me know what i need to do from here….but i really want the events to not show up once deleted.

thanks

jen

[Jen Russo]

This reply is private.

• This reply was modified 10 years, 6 months ago by Jen Russo.

[Jen Russo]

my screen shots

back end when isolating events linked to rita’s, shows no posts

[Jen Russo]

HI Nico!

i have 445 venues in my TECP

I have 296 organizers

you can see it in action at http://mauitime.com/events

thanks,

Jen

[Jen Russo]

This reply is private.

[Jen Russo]

Ok I have deleted and re-added – but now i have a new fatal error – when i click into an event

Warning: Missing argument 4 for mt_tribe_event_featured_image() in /nas/wp/www/staging/mauitime/wp-content/plugins/9s-core-functionality/inc/custom-tribe-events.php on line 49

Fatal error: Call to undefined function the_field() in /nas/wp/www/staging/mauitime/wp-content/themes/mauitime/tribe-events/single-event.php on line 58

[Jen Russo]

you specifically want me to do it through ftp rather than delete the files through my wordpress backend?

[Jen Russo]

thanks Brian

I actually decided to unlink my main site and add the licenses to the dev site so that i could replicate exactly how updates would go down on my site.

i have updated to the current version and have a major fatal error

Fatal error: Class ‘Tribe__Events__Pro__Geo_Loc_Filter’ not found in /nas/wp/www/staging/mauitime/wp-content/plugins/events-calendar-pro/src/Tribe/Geo_Loc.php on line 103

where do i go from here?

file:///var/folders/tb/ch1m8std4znggbw16bywd6180000gn/T/com.skitch.skitch/DMD35433370-C03C-4D29-9A77-7414DB635274/Fullscreen_9_17_15_2_11_PM.jpg

find it at http://mauitime.staging.wpengine.com/

[Jen Russo]

[Jen Russo]

This reply is private.

[Jen Russo]

I’ve also read in in this post that they needed a new license key. Could this be also the culprit? Would my license page inform me that there is an license issue?

[Jen Russo]

Barry – Thank you for your reply. Yes, I have switched the current theme to an unmodified Twenty Fifteen theme with all plugins uninstalled except the TEC plugins and it will still throw a 502 Bad Gateway. Disabling the Filter Bar with the unmodified Twenty Fifteen theme allows the page to load correctly.

[Jen Russo]

Geoff,

thank you so much. created a new field with ACF – but now wondering how can i get this new field to show on my venue page.

for example:

http://mauitime.com/venue/cane-and-canoe-bar-montage-kapalua/

I am collecting the data – but where do i add this field so it will show up on the venue page?

Jen

[Jen Russo]

Hey Geoff –
We’re on WPE, but I tried cranking PHP memory to 512MB and PHP timeout to 300s. Still fails with a error log that reads:

[Mon Mar 16 21:39:02 2015] [error] [client 23.241.209.91] WordPress database error Lost connection to MySQL server during query for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = 'tribe_events', wp_postmeta.meta_value, wp_posts.post_date) AS post_date, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as wp_postmeta on wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_EventStartDate' LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' ) WHERE 1=1 AND wp_posts.post_type IN ('post', 'tribe_events') AND (wp_posts.post_status = 'publish') GROUP BY IF( wp_posts.post_parent = 0, wp_posts.ID, wp_posts.post_parent ) ORDER BY wp_posts.post_date DESC LIMIT 0, 50 /* From [mauitime.com/feed/] in [/nas/wp/www/cluster-10442/mauitime/index.php:17] */ made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

I ran an EXPLAIN on that.

It’s querying 100,000+ rows. It’s not a PHP issue, it’s MySQL

Those LEFT JOINs are blowing things up, but I think their needed or you’d only get back event posts.

Seems like it might be more efficient to do something like getting the last 20 posts by date and last 20 events by date separately, then take those 2 arrays for 20 posts and merge them.

Postmeta just isn’t made for querying on like this and I’m not sure how it could be indexed.

[Jen Russo]

Thank you george, I will change that and let you know how it goes.

[Author]

Posts