WordPress.org

Forums

[Plugin: The Events Calendar] Upcoming/past events list not showing (24 posts)

  1. rajaman
    Member
    Posted 4 years ago #

    When clicking the "Event List" view neither upcoming nor previous events show up. "Calendar" view and everything else seems to work fine. Does anyone have a solution to this problem?

    I'm using WP 2.9.2 and plugin version 1.5.6

  2. Shane Pearlman
    Modern Tribe
    Posted 4 years ago #

    Hi Rajaman,

    We found the bug that was driving this and that has been patched for 1.6.

    -S

    For updates, release information and tips about our open source plugins, follow us on twitter @justlikeair.

  3. rajaman
    Member
    Posted 4 years ago #

    Hello Shane

    I've just updated to the new version 1.6, but the issue still exists. As before, the calendar view works fine, but neither upcoming nor past events are displayed under "Event List". Any idea how to solve this problem?

    PS: The issue exists with both pretty and regular permalinks.

  4. Steve Weblin
    Member
    Posted 4 years ago #

    I had the same issue and more with 1.6 so have reverted to 1.5.6.

    If I was logged in the first upcoming effect would show. But nothing would get any past or forthcoming events to appear on list.

  5. justinendler
    Member
    Posted 4 years ago #

    @rajaman

    You experienced your issue in both 1.5.6 and 1.6, correct? Can you post a link? Also, are you using custom view templates (list.php or single.php) ?

    Justin

  6. Steve Weblin
    Member
    Posted 4 years ago #

    I see the same behaviour in both 1.5.6 and 1.6.
    http://www.angelicbulldog.org.uk/
    I am using custom view templates (list.php or single.php) but only change I made was to get the header and footer from my theme into the page. I think the way header and footer are called may have changed since I hacked the view templates - maybe I need to revise the changes - will investigate tomorrow.

  7. rajaman
    Member
    Posted 4 years ago #

    @justinendler

    Yes, I've had the same problem in 1.5.6 and 1.6. I've been using custom view templates in 1.5.6, but upgrading to 1.6 overwrote them and I'm now using the standard templates. Here's a link to the calendar view: http://rohvolution.ch/category/events

  8. justinendler
    Member
    Posted 4 years ago #

    @rajaman and @Steve Weblin

    I'm still not able to reproduce this, but just a tip for now:
    instead of hacking the view files in our plugin, you can make custom versions of list.php, gridview.php, single.php, and/or table.php, place them in wp-content/themes/<your-theme>/events/ and the plugin will use those. That way they don't get overwritten every time you upgrade.

    Justin

  9. Steve Weblin
    Member
    Posted 4 years ago #

    Thanks - I have installed 1.6.2 and it all works for me.

    Revised versions of list.php, gridview.php, single.php, and/or table.php had been introduced at some point so my versions in the theme folder were not consistant with the main versions in the plugin.

    The method of calling the other parts of the theme to make a page has changed so I have had to review my custom files in the theme.

    Also I have WP Super Cache on my site. It is probably worth reminding people to clear the cache when updating especially if they have custom files in the theme.

  10. Steve Weblin
    Member
    Posted 4 years ago #

    After logging out of WordPress admin I see that the list view of events still does not work if the site visitor is not logged in.

  11. justinendler
    Member
    Posted 4 years ago #

    @Steve Weblin and @rajaman

    This one's killer! rajaman's Event List and Calendar urls look normal. Steve, yours are a little more rare, but in my mind should still work. What are your permalinks settings? Also, upon activating the plugin, the category "Events" is created. Did you by chance change that category name?

    Feeling around here...

    Justin

  12. Steve Weblin
    Member
    Posted 4 years ago #

    Permalinks are set to http://www.angelicbulldog.org.uk/2010/06/02/sample-post/

    I already had Event as a category and your plugin uses Events.

    I have tried the toggling use pretty URLs. With pretty URLs on things are worse I get "404 page not found" rather than a page with no content. (The top and bottom of the page appear but the post or posts are missing)

    http://www.angelicbulldog.org.uk/

    http://www.angelicbulldog.org.uk/category/events/?eventDisplay=upcoming

    my categories look like this:
    http://www.angelicbulldog.org.uk/category/education/

    I am using the All in One SEO plugin might that be conflicting but why only when I am logged on?

  13. kelseydamas
    Member
    Posted 4 years ago #

    Which other plugins are in play here? If you are seeing an empty loop for the upcoming/past pages, then it is possible that another plugin is interfering with the posts_where or posts_join filters which tell the plugin which posts are part of the upcoming/past loops.

    Can you try disabling some other plugins one by one to see if there is a specific plugin that may be conflicting with ours?

  14. muaythai
    Member
    Posted 4 years ago #

    I had the same issue and it turns out the conflict was with the WPML Multilingual CMS plug-in. I'm in a bit of a pickle here because my site is bilingual so I need the WPML on, but there are so many events in my calendar I need to use the event list view.

    Any suggestions?

  15. rajaman
    Member
    Posted 4 years ago #

    @justinendler, @kelseydamas, @muaythai

    Finally! I've figured out my problem: it's the WPML Multilingual CMS plugin. Everything works except when the WPML plugin is activated the event list view doesn't work anymore. Does anyone know how to fix this?

  16. sabjetravels
    Member
    Posted 4 years ago #

    Hi guys,

    I also recognised this problem with the WPML plugin. Are there already people who found a solution? The calendar is working properly, it's just the event list that fails.

    Short side question: how can you increase the amount of events showed in the event list (when it works)?

    Thanks a lot!

  17. scottrosene
    Member
    Posted 4 years ago #

    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.

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

  18. Jacob
    Member
    Posted 4 years ago #

    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!

  19. georgiePorg
    Member
    Posted 4 years ago #

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

  20. Jacob
    Member
    Posted 4 years ago #

    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!

  21. georgiePorg
    Member
    Posted 4 years ago #

    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

  22. Jacob
    Member
    Posted 4 years ago #

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

  23. bleggate
    Member
    Posted 4 years ago #

    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.

    http://wordpress.org/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.

  24. rajaman
    Member
    Posted 4 years ago #

    @georgiePorg Excellent, your fix solved my listview problem as well! Many thanks for that. :)

Topic Closed

This topic has been closed to new replies.

About this Topic