WordPress database error Unknown column ‘wp_tec_occurrences.start_date_utc’ ..

  • Resolved Ov3rfly

    (@ov3rfly)


    1 year, 8 months ago

    Getting empty result on website and this in error log with theme Impreza when using ajax “load more” function in blog or search results like /?s=e

    WordPress database error Unknown column 'wp_tec_occurrences.start_date_utc' in 'field list' for query 
			SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, CAST( wp_tec_occurrences.start_date_utc AS DATETIME ) AS event_date_utc
			FROM wp_posts  LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_EventHideFromUpcoming' )  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
			WHERE 1=1  AND (((wp_posts.post_title LIKE '%e%') OR (wp_posts.post_excerpt LIKE '%e%') OR (wp_posts.post_content LIKE '%e%')))  AND ( 
  wp_postmeta.post_id IS NULL 
  AND 
  ( mt1.meta_key = '_EventStartDateUTC' AND CAST(mt1.meta_value AS DATETIME) >= '2023-06-13 21:15:30' )
) AND wp_posts.post_type IN ('page', 'post', 'tribe_events') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'tribe-ea-success' OR wp_posts.post_status = 'tribe-ea-failed' OR wp_posts.post_status = 'tribe-ea-schedule' OR wp_posts.post_status = 'tribe-ea-pending' OR wp_posts.post_status = 'tribe-ea-draft' OR wp_posts.post_status = 'private'))
			GROUP BY wp_tec_occurrences.occurrence_id
			ORDER BY event_date_utc DESC, wp_posts.post_title ASC, wp_posts.post_date ASC
			LIMIT 12, 12
		 made by do_action('wp_ajax_us_ajax_grid'), WP_Hook->do_action, WP_Hook->apply_filters, us_ajax_grid, us_load_template, include('/plugins/us-core/templates/us_grid/listing.php'), apply_filters('us_grid_listing_query_args'), WP_Hook->apply_filters, the_events_calendar_us_grid_listing_query_args, tribe_get_events, Tribe__Events__Query::getEvents, WP_Query->get_posts

    If plugin The Events Calendar is deactivated, the same ajax “load more” works fine and shows results.

    In database wp_tec_occurrences.start_date_utc exists and has values.

    WP 6.2.2, theme Impreza 8.16 (latest), The Events Calendar 6.0.13.1

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support Darian

    (@d0153)

    Hi @ov3rfly

    I’m sorry to hear that you’re having this issue. Let me help you with this one.

    There could be a plugin/theme conflict on your end. Could you try activating only our plugin and use a basic theme like the WP’s 2020 theme and see if that makes a difference? [See- conflict test]?

    As always, please do the test on a Staging Server.

    Moreover, are you using a widget or a page builder where the “load more” is showing? Could I ask for the direct URL of the page where I can see the issue? I want to check it further on my end.

    Looking forward to your reply.

    Thread Starter Ov3rfly

    (@ov3rfly)

    How can I send direct URL to you? Can’t post URL in public.

    Plugin Support Darian

    (@d0153)

    Hi @ov3rfly

    If it’s not possible sharing your website URL. Can I ask for a screenshot or screen recording instead?

    Moreover, have you tried testing for a plugin/theme conflict?

    If that doesn’t help, may I ask for steps on how we could replicate the issue on our side? I’d like to investigate this further.

    Looking forward to your response.

    Thread Starter Ov3rfly

    (@ov3rfly)

    How can I send direct URL to you? Can’t post URL or screenshot or screen recording of URL in public.

    Plugin Support Darian

    (@d0153)

    Hi @ov3rfly

    Unfortunately, as per WP’s forum guidelines, I could not provide contact information on this forum. However, if you have a premium license, you can open a Support Ticket on our Help Desk.

    If you don’t have a premium license, please provide steps on how we can replicate the issue on our side. I’d like to check it further on my side.

    Moreover, could you try activating only our plugin and use a basic theme like WP’s 2020 theme and see if the issue persists? [See-?conflict test]? As always, please do the test on a?Staging Server.

    Looking forward to your reply.

    Plugin Support Darian

    (@d0153)

    Hi @ov3rfly

    This thread has been inactive for a while, so we’ll go ahead and mark it Resolved. Please open a new thread if any other questions arise, and we’d be happy to help.

    Thread Starter Ov3rfly

    (@ov3rfly)

    The issue is not resolved, a staging server for your devs has been set up and supplied and your devs are actively working on it.

    Plugin Support Darian

    (@d0153)

    Hi @ov3rfly

    I hope you’re doing well. I just wanted to touch base and check in with you. It’s been a little while since we’ve heard from you. Could you confirm if this issue is now resolved?

    Let me know if there’s anything I can assist you with.

    Plugin Support Darian

    (@d0153)

    It appears that there hasn’t been any recent activity on this thread, so we’ll consider it resolved. However, if you have any additional questions or concerns, feel free to start a new thread.

    I’m seeing errors of the same shape reported here. I note that the wp_tec_occurrences table is not mentioned in the FROM and JOIN clauses of the query, so it’s no wonder that the query is invalid.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘WordPress database error Unknown column ‘wp_tec_occurrences.start_date_utc’ ..’ is closed to new replies.