[Plugin: The Events Calendar] Upcoming/past events list not showing

I’m having the same problem. Neither the “event list” nor the “calendar” buttons lead anywhere. Same when clicking on the previous month or next month hyperlinks. (but selecting month from dropdown works ok) They just say “page not found.”

I don’t use the WPML Multilingual CMS plugin, but the Global Translator plugin instead. Might it have a similar conflict?

Also noticed the sidebar disappears on the calendar page. Not sure if that’s normal, but it does look odd, since the calendar is not centered on the page.

https://www.yfcasiapacific.org/intranet/http:/www.yfcasiapacific.org/intranet/archives/category/events

Hi, everyone!
Same problem here with WPML plugin…
It’s been over 6 months since the last comment on this post…did anyone figure it out how to solve it?

Thanks!

I also have the WPML Multilingual CMS installed and I noticed that when click on the View all Events, the events list comes up empty..

Think i found the problem here:
I had a look at the SQL statement that was being generated and for me it generated the following:

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, eventStart.meta_value as EventStartDate, eventEnd.meta_value as EventEndDate FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type IN ('post_post','post_page') JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1LEFT JOIN wp_postmeta as eventStart ON( wp_posts.ID = eventStart.post_id ) LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id ) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('6') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') AND t.language_code='en' AND ( eventStart.meta_key = "_EventStartDate" AND eventEnd.meta_key = "_EventEndDate" ) AND ( eventStart.meta_value > "2011-02-24 9:57:37" OR ( eventStart.meta_value < "2011-02-24 9:57:37" AND eventEnd.meta_value > "2011-02-24 9:57:37" ) ) GROUP BY wp_posts.ID ORDER BY eventStart.meta_value ASC LIMIT 0, 10

now it seems that there is missing a whitespace between the join for the language code and the join for the event start date.
not sure if it’s the right solution, but i just added a whitespace to the end of the JOIN statements in the function posts_join_filter in sitepress-multilingual-cms/sitepress.class.php. Suddenly the list now shows up. There might be a better fix.. But i’m not sure who is responsible for the whitespace here..?

Hi georgiePorg!

I am not really familiar with php. I’ve found the sitepress.class.php file but I couldn’t understand where is the “end of the JOIN statements in the funcition posts_join_filter”.

Could you go a little bit deeper on that, please?
Thanks!

i also tried adding the whitespace in the the-events-calendar.class.php in the function events_search_join and that did the job too..

here’s the function if you want to change it there and try.

/**
		 * join filter for standard wordpress templates.  Adds the postmeta tables for start and end queries
		 *
		 * @param string join clause
		 * @return string modified join clause
		 */
		public function events_search_join( $join ) {
			global $wpdb;
			if( !$this->in_event_category() ) {
				return $join;
			}
			$join .= " LEFT JOIN {$wpdb->postmeta} as eventStart ON( {$wpdb->posts}.ID = eventStart.post_id ) ";
			$join .= " LEFT JOIN {$wpdb->postmeta} as eventEnd ON( {$wpdb->posts}.ID = eventEnd.post_id ) ";
			return $join;
		}

all i did was add a whitespace in front of the LEFT JOIN bit of the query

@georgieporg

Hey, it did solved the issue!

Since I’m not a programmer, I don’t know how exactly such a simple modification could solve an annoying bug like that – but it did.

Thank you very much georgiePorg!

We definitely need people like you to keep this plugin running since it looks it’s been abandoned by the developers.

HI Guys

You seem to be on the button on updateing the code for the events calander.

I have just upgraded to wordpress 3.1 and no joy, the posts now do not display.

If you could take a look at this thread I would appreciate your thoughts and GeorgiePorg it seems like you are on to it.

https://www.ads-software.com/support/topic/plugin-the-events-calendar-compatibility-with-wordpress-31?replies=5#post-1965364

Thank you and it is forums like these that keep us all wanting to make wordpress better. Thanks for your time.

@georgieporg Excellent, your fix solved my listview problem as well! Many thanks for that. ??