Latest update breaks Attendee Output (Unknown column ‘wp_posts.ID’)

  • Resolved David Levine

    (@justlevine)


    5 years, 5 months ago

    After updating to Event Tickets 4.10.6, my debug.log is riddled with database errors, and my Event template is no longer showing attendees.

    All of the errors start with WordPress database error Unknown column 'wp_posts.ID' in 'on clause' for query SELECT DISTINCT customdbname_posts.ID FROM customdbname_posts.

    The issue seems to be caused by src\Tribe\Attendee_Repository.php:263.

    ON ( attendee_optout.post_id = wp_posts.ID uses a hardcoded prefix, and instead of wp_posts.ID, it should be {$wpdb->prefix}posts.ID.

    I’ve created a pull request here: https://github.com/moderntribe/event-tickets/pull/1279

    • This topic was modified 5 years, 5 months ago by David Levine. Reason: formatting
Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi there,

    Thanks for pointing this out! This will be fixed in an upcoming release.

    Appreciate the feedback!

    Sky

    Hey there! This thread has been inactive for a while so we’re going to go ahead and mark it Resolved. Please feel free to open a new thread if any other questions come up and we’d be happy to help. ??

    Thanks
    Courtney ???????

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Latest update breaks Attendee Output (Unknown column ‘wp_posts.ID’)’ is closed to new replies.