Support

Home Forums Event Espresso Premium Event Category Listings Page Not Working After Upgrade

Event Category Listings Page Not Working After Upgrade

Posted: June 1, 2018 at 7:55 am


Nathan Almquist

June 1, 2018 at 7:55 am

Hello. After the latest EE upgrade our landing pages for individual event categories are no longer displaying events.

https://grandmaraisartcolony.org/event-category/adult-classes/
https://grandmaraisartcolony.org/event-category/youth-classes/

Any ideas? We’ve already combed through all of our theme code, updated theme, flushed cache on our web application firewall, etc.


Josh

  • Support Staff

June 1, 2018 at 8:14 am

Hi Nathan,

We’ve received your request for priority support. This might be an issue with the child theme’s custom archive.php template. I’ll see what I can do to troubleshoot locally as the FTP connection will not connect, it’s timing out. I’ll let you know what I find.


Josh

  • Support Staff

June 1, 2018 at 8:53 am

OK here’s an update: I loaded up the Enfold theme locally and the event listings displayed on the local site. Then I went in and changed the theme options > Blog Layout (in Blog Layout) to Grid and the same thing happened locally, no events displayed. So I tried changing the Enfold option > Blog Layout to a different layout option and the events display on your site now.

So apparently something in the archive’s Grid Layout loop code is resulting in a database error.


Nathan Almquist

June 1, 2018 at 12:57 pm

Thanks Josh. Partial answers are better than none. Unfortunately, what we had on that page and need for users is a grid layout. These pages display all classes in Event Espresso that fit a specific category or sub-category but because there are so many the grid is necessary with featured image, event title, date brief description. As I mentioned, the latest EventEspresso release broke the pages. Can you elaborate on what changed in the release that would be causing “the archive’s Grid Layout loop code is resulting in a database error”? Nothing we’ve read in the release notes is sticking out.


Josh

  • Support Staff

June 1, 2018 at 2:56 pm

Hey Nathan,

May I ask what part of your question did I not answer?

As far as I can tell, the Enfold theme runs a second query when the Grid Layout template is used for the post archive. Specifically, the global WP Query already queried for the events, then the avia_sc_postslider class gets instantiated and runs more queries for events. The database error happens on that second query.


Josh

  • Support Staff

June 1, 2018 at 3:52 pm

Here’s how you can avoid the database error and get back up and running with that grid template layout:

Open the child theme’s archive.php and just before line 74 add this:

remove_all_filters('posts_where');
remove_all_filters('posts_join');

so the end result will look like this:

remove_all_filters('posts_where');
remove_all_filters('posts_join');
$blog = new avia_post_slider($atts);
$blog->query_entries();

The support post ‘Event Category Listings Page Not Working After Upgrade’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso