WordPress.org

1. computercourage
   Member
   Posted 8 months 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. roblagatta
   Modern Tribe Support
   Plugin Author
   Posted 8 months 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 8 months ago #
   

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

4. Barry
   Member
   Posted 8 months ago #
   

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

Reply

You must log in to post.