|
Cforce
|
September 12, 2023 at 3:08 pm
Hi there, so the only thing that got changed on my end was Event Espresso updated to the current the current version..
I’m seeing errors in our error logs
AH01071: Got error 'PHP message: WordPress database error Unknown column 'event_start_date' in 'order clause' for query \n\t\t\t\t\tSELECT............)) AND wp_esp_datetime.DTT_EVT_end > '2023-09-12 14:41:42'...
|
|
Tony
|
September 12, 2023 at 3:14 pm
Hi there,
I’ve split your thread into a new one and removed any site-specific details from your post as an opening post can not be private.
That’s the same issue I referenced in the other thread HERE, do you know which specific version number you updated from?
|
|
Cforce
|
September 13, 2023 at 9:03 am
Can you send me the version numbers and when their date was uploaded?
I have been trying to look for a page where I have the option to download the past versions.. As I might need to run some tests..
|
|
Tony
|
September 13, 2023 at 9:11 am
For Event Espresso?
Here: https://eventespresso.com/wiki/ee4-changelog/
|
|
Cforce
|
September 13, 2023 at 10:20 am
This reply has been marked as private.
|
|
Tony
|
September 13, 2023 at 11:08 am
This reply has been marked as private.
|
|
Cforce
|
September 18, 2023 at 8:53 am
So we had the plugin uploaded and checked if everything is now working we are still getting the error
[Mon Sep 18 09:14:22.721747 2023] [proxy_fcgi:error] [pid 21207:tid 139908182091520] [client 185.191.171.16:0] AH01071: Got error ‘PHP message: WordPress database error Unknown column ‘event_start_date’ in ‘order clause’ for query \n\t\t\t\t\tSELECT …………)) AND wp_esp_datetime.DTT_EVT_end > ‘2023-09-18 09:14:22’ AND wp_terms.slug IN (‘TCOLE’) \n\t\t\t\t\tGROUP BY wp_posts.ID \n\t\t\t\t\tORDER BY event_start_date ASC\n\t\t\t\t\tLIMIT 0, 50\n\t\t\t\t made by require(‘wp-blog-header.php’), requir…’
|
|
Tony
|
September 18, 2023 at 3:04 pm
Hi there,
We’ve narrowed this down to be caused by Object caching.
Can you try disabling object caching on your site and see what happens then?
|
|
Cforce
|
September 20, 2023 at 9:44 am
Hi Yes!
it was the Object Caching causing the issue.. We now have resolved this issue.. Thank you so much
|
|
Tony
|
September 20, 2023 at 10:26 am
We’ve had a few reports of this issue but the way in which we run the above queries hasn’t changed in a long time so it looks like either object caching or something within WP_Query has changed (I suspect object caching changed).
Disabling it is currently the only way around it that I’ve found.
|
