jon

@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.

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!

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

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.

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

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?

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.

Thanks for a great plugin!

I’ll chime in here and say i’m having the same issue with the placemark div sizing. It looks beautiful on the sample site, the placemark changes size to fit the contents of each different contents, but on my site the placemarks don’t resize, and i get scroll bars on everything.

I’m able to use custom CSS to mange the text inside, but the div itself just doesn’t size nicely. Hope you can track this one down and get it fixed.

I’m having the exact same problem. All my e-mail settings are correct, the e-mail is working, but wp-mail.php pops up with that error. This is a major part of the site i’m working on, the owners need easy access for updates.

Anyone have suggestions out there on how to troubleshoot this?