|
lee@safeswim.com
|
March 6, 2019 at 6:43 pm
Hello,
A couple of our pages are not loading that we use the Event Table List View on. When I disable the plugin the pages loads but when I activate it doesn’t load. It seems to only affect the pages with the largest event lists. Below is a link to one of the pages that will not load that has about 700 events in the list: https://www.cprtrainingpro.com/find-a-class/
Most of the pages are not affected just a couple with the biggest lists.
Any suggestions or ideas on what may cause this?
Thanks.
|
|
Tony
|
March 7, 2019 at 3:53 am
Hi there,
Most likely, the queries used to pull those 700 events are timing out.
If you check the servers error logs and check the time for around when you try to load that page, do you see any errors there?
Or you can add the snippet posted here:
https://eventespresso.com/wiki/troubleshooting-checklist/#wpdebug
To your wp-config.php and retest the errors should be logged to /wp-content/debug.log so we can confirm, however your getting error 500 on the page after ~30 which would tie into the page timing out due to the amount of time it would take to pull in 700 events onto a single page.
If you add a limit to the shortcode, like so limit=100 does the page then load fine?
|
|
lee@safeswim.com
|
March 7, 2019 at 9:16 am
Today, The issue has resolved itself, not exactly sure how but the pages now load. Now time to hold my breath again! 🙂
|
|
Josh
|
March 7, 2019 at 9:55 am
What you could do to help that page load more quickly is check your custom table template and make a change to where it checks for sold out events.
If you go in to edit the customized “espresso-events-table-template.template.php” file, and look around the middle of the file for this:
if ( $event->is_sold_out() || $event->is_sold_out(TRUE ) ) {
if you find that exact code, you can change it to:
if ( $event->is_sold_out() ) {
What that will do is reduce the number of queries to the database when the list of events loads.
|
|
lee@safeswim.com
|
March 8, 2019 at 7:33 am
It would be extremely helpful if you had a video on how to edit a file. Just a generic video for us novice because I fear breaking something and my website being out of order which means my business is out too.
|
|
Tony
|
March 8, 2019 at 8:03 am
Whilst in theory that sounds great, the problem is that a single incorrect character can bring your whole site down anyway.
Knowing ‘how’ to change a file, doesn’t mean you are not going to make a mistake and end up in exactly the same situation, it’s all down to experience and a video of ‘Here is how you to edit a file’ actually increases the chances of that happening because a little bit of knowledge can be dangerous in the bigger picture.
If you have a custom template using the above code (EE’s default template has the change Josh mentioned already) then someone moved that template to your themes root directory so its assumed whoever would do that would be familiar with editing the files.
|
