Support

Home Forums Event Espresso Premium Filter not working for EE Table View

Filter not working for EE Table View

Posted: April 21, 2017 at 9:53 am


youtech2012

April 21, 2017 at 9:53 am

I am using the table view add-on to to create a list of my active courses. It seems on some computers, the title search and category filter are not working at all. All computers are using Chrome, and both Mac and PC’s are having the issue. It works completely fine for some people, but not at all for others. I first had it set up with pagination, but got rid of that thinking that was the issue. It didn’t seem to make a difference. Any help would be appreciated as we have many courses and the filter function needs to be working properly to be user-friendly!


Josh

  • Support Staff

April 21, 2017 at 10:21 am

Hi there,

Can you post a link to the page so we can take a look?


youtech2012

April 24, 2017 at 9:24 am

Sure thing! Here’s the link https://adultfinancialed.org/course-list/


youtech2012

April 24, 2017 at 9:29 am

Also, the client just called to say that when some of the marketers are looking at the site in Firefox, the page is only loading a few classes (like 3-4). I just downloaded Firefox on my mac and tested it, and it works perfectly fine for me (it’s loading all the classes). Thanks for your help, I’m stumped!


Josh

  • Support Staff

April 24, 2017 at 11:02 am

Hi there,

I checked with a few computers using Chrome and Firefox and the table view filters and initial load of the table works for me.

Can you reach out to the folks that reported an issue and ask them for a clear definition of what they mean by “Not working at all”? For example, are they selecting a specific state and when they select that state is it not returning the expected results? If they can take a screenshot that may also help.


youtech2012

April 25, 2017 at 8:27 am

This is a message from one of the agents regarding this issue

“Would not let me search by course code either.

Went to the site to see what my classes looked like. When I click on register it pulled up just a few courses only one mine and only through 4/27/17, but I couldn’t figure out how to scroll further down. Also, when I told it to look at only Virginia classes it did not change anything.”

It seems for him, the sort function for both searching by title and filtering by category/state (we made a category for each state) just does not filter. He is also only seeing through 4/17 when we have classes going until 5/25. I removed pagination a few weeks ago to see if it solved the problem so all the classes should load on one page.

I can certainly reach out for screenshots if that would help you figure out what could possibly going on!

Thanks!


Josh

  • Support Staff

April 25, 2017 at 10:02 am

This is a guess because I have little information to work with, but what may be happening is the server is running low on memory so if there’s any amount of traffic at a given time, the server may be throwing an out of memory error when that particular page is being generated when it’s being served. Due to the number of events, categories, and venues listed on that page, there’s going to be a higher number of database queries that run when that page is generated.

You can verify by check the PHP error logs or even set up WP_DEBUG logging:

https://codex.wordpress.org/Debugging_in_WordPress#Example_wp-config.php_for_Debugging

So you could bump up the amount of memory available to WordPress
>http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP

You could also use the WP Super Cache plugin to serve a cached version of that page, but you’ll ideally set the cache to expire after a few hours since the information on that page will need to be updated when classes expire, sell out, and get added when new events are added.


youtech2012

April 25, 2017 at 1:25 pm

We’ve doubled the memory and we have reviewed the PHP error logs and found nothing.

Here is the screenshot that one of the agents took.
https://www.evernote.com/shard/s583/sh/e771691f-cfd9-43a0-8638-2e3d0c38ce0d/2ecfdf72b487275cbf25db46d22d8058
It doesn’t show that he is trying to filter, but it does show that his courses stop at ten.

The shortcode on the course list page is [ESPRESSO_EVENTS_TABLE_TEMPLATE table_pages=1000].


Josh

  • Support Staff

April 25, 2017 at 2:01 pm

It really does look like the page is hitting an error and stopping at rendering. Do you see in the screenshot how it’s also missing the page title and the bottom of the table?

What you could do is turn on WP_DEBUG and then you’ll be able to capture the error that’s thrown.


youtech2012

April 26, 2017 at 8:06 am

We’re going to turn on WP_DEBUG and take a look.

Thanks!


Josh

  • Support Staff

April 26, 2017 at 8:32 am

While you’re in editing the wp-config.php file, you can also add:

define( 'SAVEQUERIES', true );

Then you install and activate the debug bar plugin.

https://wordpress.org/plugins/debug-bar/

Then you visit the page with the table view while logged in as admin, then you click on “Debug”. There you will see a “TOTAL QUERIES:” count. You can check with your host to see if they set a total query limit. So for example, if the host sets a query limit of 600, and the debug bar reports a total query count that’s really close to 600, then that may be why some visitors to the site aren’t seeing a full render of the webpage.

The support post ‘Filter not working for EE Table View’ 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