WordPress.org

Forums

The Events Calendar
[resolved] No upcoming events found for logged out users. (4 posts)

  1. computercourage
    Member
    Posted 2 years ago #

    Hi,

    The events list is returning no events for users who are not logged in. I've dumped the query, and it's returning:

    SELECT DISTINCT SQL_CALC_FOUND_ROWS  wp_posts.*,
    eventStart.meta_value as EventStartDate,
    IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME),
    INTERVAL eventDuration.meta_value SECOND),
    eventEnd.meta_value) as EventEndDate
    FROM wp_posts
    LEFT JOIN wp_postmeta as hideUpcoming ON( wp_posts.ID = hideUpcoming.post_id AND hideUpcoming.meta_key = '_EventHideFromUpcoming')
    LEFT JOIN wp_postmeta as eventStart ON( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = '_EventStartDate')
    LEFT JOIN wp_postmeta as eventDuration ON( wp_posts.ID = eventDuration.post_id AND eventDuration.meta_key = '_EventDuration')
    LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = '_EventEndDate')
    WHERE 1=1  AND wp_posts.post_type = 'tribe_events'
    AND (wp_posts.post_status = 'publish')
    AND (eventStart.meta_value > '2012-08-24 00:00:00' OR (eventStart.meta_value <= '2012-08-24 00:00:00' AND  IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value)  >= '2012-08-24 00:00:00' ))
    AND (hideUpcoming.meta_value != 'yes' OR hideUpcoming.meta_value IS null)
    AND (meta_value IS NULL OR meta_value <= 0)
    ORDER BY DATE(eventStart.meta_value) ASC, TIME(eventStart.meta_value) ASC LIMIT 0, 12

    And running it directly in my phpMyAdmin, I get the error "Column 'meta_value' in where clause is ambiguous".

    http://wordpress.org/extend/plugins/the-events-calendar/

  2. Rob La Gatta
    Modern Tribe Support
    Plugin Author

    Posted 2 years ago #

    Hi there computercourage. Thanks for the note here, and for reaching out. Sorry to hear you're having problems...as this isn't something we've had reported by other users, my guess is there is something else specific to your install here.

    Can we take a look at the site directly? If you could provide a link it'd be helpful. Otherwise, please confirm a few points for me:

    * That you're running the latest version of the plugin (2.0.8) and the latest version of WordPress (3.4.1).
    * That you've got permalinks enabled.
    * That you haven't modified user roles in any way and aren't using a third-party role manager plugin.
    * That this issue persists even with all your other plugins deactivated.

    Let me know about these and we'll do what we can. Thanks for your patience so far.

  3. computercourage
    Member
    Posted 2 years ago #

    Your suspicion was correct, the MemberwingX plugin was messing up the query. Thanks for the help!

  4. Barry
    Member
    Posted 2 years ago #

    Thanks for reporting back computercourage - could be useful for other users, too :-)

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • The Events Calendar
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.