• Resolved etellewyn

    (@etellewyn)


    I am noticing a really strange error — we have a site that uses both The Events Calendar Pro as well as Simple Lightbox. For some reason, SLB is giving me a database error when it is active, while viewing single event pages when the event is recurring. (other pages are fine. It’s just on single event pages and only if the event is recurring)

    The error is:
    Unknown column ‘EventStartDate’ in ‘order clause’

    The complete details of the error as reported by query monitor can be seen here: https://nimbus.everhelper.me/client/notes/share/962020/g8tnrqqga4f4hd2ix0cs

    Any ideas how to resolve this?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Archetyped

    (@archetyped)

    Hi, yes that is a strange error indeed. I’m looking into this, but it currently looks like Events Calendar Pro may be modifying a custom posts query when it shouldn’t be.

    Can you please provide a link to the Events Calendar Pro plugin to ensure that I test the right plugin?

    Thanks.

    Thread Starter etellewyn

    (@etellewyn)

    Hi, thanks so much for your reply.
    Yes, we are running The Events Calendar (by Modern Tribe) Version 4.5.5, and Events Calendar Pro Version 4.4.11.1.

    I’ve been working with them on this as well and they have said that since there is no visible malfunction on the page (just a database error which is only visible when using some kind of debug tool like Query Monitor), they do not feel it’s worth troubleshooting.
    My worry is that it’s an indicator of a larger issue which could surface down the line.

    The steps to reproduce the error (at least on our system):
    1) Create a recurring event with Events Calendar Pro
    2) In Events Calendar Pro settings, check the box for “Show only the first instance of each recurring event”
    3) Make sure Simple LightBox plugin is enabled. (does not need to be active on the page, just enabled)
    4) Install & activate Query Monitor (which will enable you to see the database error)
    5) View a single instance of a recurring event (on the front end).

    Does this give you the information you need?

    Plugin Author Archetyped

    (@archetyped)

    Hi, after reviewing the error further, it appears that The Events Calendar is modifying a query generated by WordPress’ own url_to_postid() function.

    Modifying the query appears to be unnecessary for this function’s purposes, but the developers of The Event Calendar plugin would likely have a better idea of whether they need to update their plugin to avoid such query modifications, as well as whether issues may arise due to the error that it causes.

    I am closing this ticket as it is not directly related to SLB, but rather to WordPress’ built-in url_to_postid() function.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SLB causing Database error when active with Events Calendar Pro, recurring event’ is closed to new replies.