• Resolved chenlu123

    (@chenlu123)


    Hi,

    I am using the latest events calendar plugin v 6.2.9. In the /events page there is a search box, when type something in it then click on ‘find events’ nothing appear.

    The error log:

    PHP message: WordPress database error Unknown column 'wp_tec_occurrences.start_date' in 'field list' for query SELECT   wp_posts.ID, CAST( wp_tec_occurrences.start_date AS DATETIME ) AS event_date, CAST( wp_tec_occurrences.duration AS DECIMAL ) AS event_durationFROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )WHERE 1=1  AND (((wp_posts.post_title LIKE '%voluntary%') OR (wp_posts.post_excerpt LIKE '%voluntary%') OR (wp_posts.post_content LIKE '%voluntary%')))  AND (wp_posts.post_password = '')  AND (   ( wp_postmeta.meta_key = '_EventEndDate' AND CAST(wp_postmeta.meta_value AS DATETIME) > '2023-12-18 13:28:09' )) AND wp_posts.post_type IN ('ai1ec_event', 'post', 'roundtable', 'sponsoredcontent', 'sponsored_content', 'video_posts', 'job_listing') AND ((wp_posts.post_status = 'publish'))GROUP BY wp_tec_occurrences.occurrence_idORDER BY event_date ASC, event_duration ASC, wp_posts.post_title LIKE '%voluntary%' DESC, wp_posts.post_date ASCLIMIT 0, 13made by WP_Query::get_posts

    But when I exported the sql files, there actually have table wp_tec_occurrences, and the start_date column is there too.

    The website is under a wordpress network site. Any idea?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Hi @chenlu123,

    Please note that the search only works for the upcoming events, so make sure to add some upcoming events.

    For me to understand and learn more about your setup, could you provide the following version of the following?

    1. PHP
    2. WordPress
    3. Theme and Version

    Could you share the direct URL to the page you’re having issues with? Please do not share any credentials, this is for us to follow the WordPress Forum Guidelines.

    • This reply was modified 2 years, 4 months ago by Atousa Najafi.
    Thread Starter chenlu123

    (@chenlu123)

    Hi Atousa,

    We do have upcoming events: https://www.australianageingagenda.com.au/events/,

    PHP 8.1, wordpress 6.4.2, theme is CoverNews 4.5.1

    Thread Starter chenlu123

    (@chenlu123)

    Hi Atousa,

    I have fixed it.

    It caused by another internal plugin, which altered the search query by add_filter. thanks.

    Plugin Support Darian

    (@d0153)

    Hi @chenlu123

    Thanks for your confirmation and I’m glad that it is now working.

    If you have a minute, a great review from you would be amazing!

    https://ww.wp.xz.cn/support/plugin/the-events-calendar/reviews/

    Please do not hesitate to start a new thread if you have other issues at all. This allows us to track topics/issues efficiently and follow the WordPress Forum Guidelines.

    Jos Klever

    (@josklever)

    @d0153, please add this post to TEC-5055 as it also mentions the same error message.

    Plugin Support Darian

    (@d0153)

    Hi @josklever

    The error message was similar, but it was caused by an internal plugin. The matter has already been resolved by their team.

    Jos Klever

    (@josklever)

    I know, but as the error is similar, it might have been triggered by another plugin, but should have been handled by TEC while creating the query. If you let other plugin manipulate your queries, you should check for valid data. I was just collecting issues, because that could increase the priority/impact.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Search box does not work’ is closed to new replies.