Month view says ‘no results found’, other views show events just fine

Even more odd, when you download the ical .ics file it contains all of the monthly events, they only don’t show up in the monthly display view. Something about how the monthly view pulls events and renders them is not working.

Hey @skiboyjon,

Thanks for using our plugins! Since you’re using TEC PRO, I recommend reaching out to our support on our premium forums. They have the capacity to provide more technical and rapid support.

Let me know if you need anything else!

Best,

Shelby ??

Thanks for that suggestion, but I’m on a non-profit PRO license, no access to forums. Any ideas about the month view loop working on Microsoft IIS servers or conflicts?

Hi @skiboyjon,

Just to clarify Shelby’s point above, we are actually prohibited from providing support for our premium products here on www.ads-software.com, per WordPress guidelines. We provide the nonprofit licenses for free for qualified organizations with the understanding that they do not include support.

Just to confirm: does this issue continue to happen if you deactivate Events Calendar PRO? If so, please leave it deactivated and we’d be happy to help check it out with you here since that indicates support for The Events Calendar instead of our premium plugin. ??

Cheers!
Geoff

Ahh, thank you for the follow up Geoff, that makes perfect sense!

It does happen without Events Calendar Pro, only the standard plugin. It worked great on my stand-alone WP install on dev environment linux box, but moving it to production seemed to be the difference between working/not working. All other calendar settings are identical, no other plugins activated, using twenty fourteen (and all other themes for testing) still with the same result.

PHP version is 5.6.27 on Dev.
PHP version is 5.5.27 on Production

Got more details about the production system… they’re using Project Nami (https://projectnami.org) to run WordPress on a Microsoft SQL server, not IIS/WPMU like I originally though. Perhaps this could be the cause of the conflict?

– Jon

The plot thickens…. it appears this could be related to Project Nami, there was an issue documented in their forums a while back https://support.projectnami.org/viewtopic.php?f=7&t=44.

It was The Events Calendar 3.1.1 on Project Nami version 1.0x, but it was supposedly fixed sometime in PN version 1.06. I will follow up with my contacts running the production server and PN install to see if they can figure anything out.

Hi @skiboyjon,

Thanks for following up with some more information here–great find with the Project Nami forum link! Unfortunately, we’re not typically able to provide detailed support for non-traditional server setups such as these, but perhaps one of our users on a similar setup may be able to offer some suggestions. We’d be grateful for any information you can share that may help us to better support other customers with similar configurations!

Thank you, and best of luck! ??

A follow up… I was able to use debug bar plugin to see the database queries that have errors. I’m totally guessing here but maybe it could possibly be related to a time formatting difference between MySQL and MSSQL. The error points to a “:” in the query. I’m guessing that would require a database change or a plugin change to get them to work nicely together, both considerable feats at this point that aren’t likely to be overcome for this small project, so I may have to abandon the awesome Events Calendar plugin that I love and use some other substitute ??

Error:

SELECT DISTINCT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) 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.ID IN (234165) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’ OR wp_posts.post_status = ‘private’) AND ((wp_postmeta.meta_value >= ‘2016-12-30 00:00:00’ AND wp_postmeta.meta_value <= ‘2016-12-30 23:59:59’) OR (tribe_event_end_date.meta_value >= ‘2016-12-30 00:00:00’ AND wp_postmeta.meta_value <= ‘2016-12-30 23:59:59’ ) OR (wp_postmeta.meta_value < ‘2016-12-30 00:00:00’ AND tribe_event_end_date.meta_value >= ‘2016-12-30 23:59:59’ )) ORDER BY CASE( wp_posts.ID ) WHEN 234165 THEN 0:1482451200:234165 END OFFSET 0 ROWS FETCH NEXT 3 ROWS ONLY
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ‘:’. Code – 102

@skiboyjon,

I think you may be on to something there! Sorry we can’t be of more assistance for this particular issue.

Best of luck with your project!

Shelby ??

I spoke to the developers of Project Nami and they pinpointed the error at the ORDER BY CASE statement. I’m looking through the plugin code to try and find where that query is constructed (it looks like it might be part of the geo location stuff) and then see if I can figure out how to fix it to work properly.

I’m not sure if it’s the ORDER BY CASE(wp_posts.ID) part that its he problem or if it’s the WHEN/THEN statement after. Hope to keep troubleshooting and get this fixed, it’s the last and only problem with the entire site and I’m trying not to give up on The Events Calendar plugin because it just works so well when it works!

@skibyjon

any luck finding the right page to change that SQL code?
I’ve figured out what the correct syntax would be for MSSQL, but can’t find the right file to change it in.

Matt

@mwilliams42 sadly no, i’ve been working with the Project Nami team to try and figure it out, but I don’t have access to the production server where this is occurring so I can’t properly troubleshoot and diagnose the issue.

https://github.com/ProjectNami/projectnami/issues

Sounds like it might be something that needs to be changed in the translations file in project nami, but I don’t know enough about that system to know how to fix it.