Events page only showing 5 events

[byronclinic]

Despite having set the “Number of events to show per page” to 99, my events page at http://byronclinic.com/workshops/ is only showing 5 events and the “next” and “previous” links aren’t paginating correctly, they both point to the url:

http://byronclinic.com/workshops/list/

Any assistance with this would be appreciated.

[byronclinic]

Please disregard this post. I discovered some overrides that were impacting the listing.

[byronclinic]

Sorry, I was too premature in asking you to close the ticket: I’m still only seeing 5 events here http://byronclinic.com/workshops/ despite changing the “Number of events to show per page” setting.

[George]

Hey @byronclinic,

Sorry you’ve been having some trouble with this – I’m curious, what exactly did you find when you wrote the following in your second post on this thread:

I discovered some overrides that were impacting the listing.

Do you mean theme/template overrides that you created yourself? If so:

1. Are these still in place on your site?
2. Did removing them indeed make a difference in behavior on your site with this issue?

Next, if possible, can you activate a default theme like 2015 and see how the pagination and events-per-page option are handled in that? Does anything improve with regards to these two things?

Thanks!
George

[byronclinic]

Yes, if I swap themes to TwentyFifteen, the full list displays, so somehow the issue resides in my theme?

[byronclinic]

If I monitor SQL queries for that page I can see the relevant query is limiting the results to 5:

SELECT SQL_CALC_FOUND_ROWS DISTINCT bcwp_posts.*, MIN(bcwp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate
FROM bcwp_posts 
INNER JOIN bcwp_postmeta
ON ( bcwp_posts.ID = bcwp_postmeta.post_id )
LEFT JOIN bcwp_postmeta as tribe_event_end_date
ON ( bcwp_posts.ID = tribe_event_end_date.post_id
AND tribe_event_end_date.meta_key = '_EventEndDate' ) 
WHERE 1=1 
AND ( bcwp_postmeta.meta_key = '_EventStartDate' )
AND bcwp_posts.post_type = 'tribe_events'
AND (bcwp_posts.post_status = 'publish'
OR bcwp_posts.post_status = 'private')
AND (bcwp_postmeta.meta_value >= '2015-08-12 12:47:46'
OR (bcwp_postmeta.meta_value <= '2015-08-12 12:47:46'
AND tribe_event_end_date.meta_value >= '2015-08-12 12:47:46' ))
GROUP BY bcwp_posts.ID
ORDER BY EventStartDate ASC
LIMIT 0, 5

But I’m not sure where that LIMIT is coming from…

[byronclinic]

OK, I’ve realised that the Divi theme has it’s own setting for how many posts to display on an archive page, independent of the WordPress Reading settings. It is set to 5 by default and so it was overriding both the WordPress “Blog pages show at most” setting and the Events calendar setting.

[Brian]

I am glad to see you were able to figure it out. I brought this up with our support team as it is the second time I have seen this mentioned today.

I am going to go ahead and close this ticket. If you have a similar issue or another in the future, please do not hesitate to create a new ticket.

Thanks!

[George]

Thanks for the update @byronclinic, I didn’t know this about the Divi theme so it’s good to know!

And thanks to Brian for covering for me a bit while I was out this week! 🙂

Cheers,
George

[Author]

Posts