Ce fil est résolu. Voici une description du problème et la solution proposée.
Problem: Sometimes a View that is filtered by a field from The Events Calendar is returning no results.
Solution: When using date filter operations, it's best to filter by a Types date field. TEC date fields are stored in the database using a different format, which can have unexpected results.
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | - | - |
| 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | - | - |
Supporter timezone: America/New_York (GMT-04:00)
Marqué : Views, Views plugin
Ce sujet contient 27 réponses, a 3 voix.
Dernière mise à jour par Christian Cox Il y a 5 années et 4 mois.
Assisté par: Christian Cox.
Right the issue referenced in https://toolset.com/forums/topic/i-have-a-view-which-sometimes-returns-results-sometimes-not/ is still occurring & more regular than ever - to the point that I am thinking of dropping toolset altogether, to be honest with you - it is convenient and great to use, but if it cannot pull out a simple list of events on a regular basis, it has a failing
The issue rarely happens for a logged in user - but often happens for cached pages - my wonder is if the caching is happening too fast & toolset just gives up on certain queries then says, 'nope didn't find anything'
But the site is significantly slower without the caching provided by WPRocket - so not having that is a no-no
The only way to clear it is to go back in via the admin login - clear the WPRocket cache - kick off another preload & that generally solves it
Occasionally, I have to edit the view, add an exclamation mark or similar, then save it & clear the WPRocket cache - kick off another preload
The issue rarely happens for a logged in user - but often happens for cached pages - my wonder is if the caching is happening too fast & toolset just gives up on certain queries then says, 'nope didn't find anything'
Have you enabled server logs to see if any errors are logged that would indicate such a failure? If you are unfamiliar with server logs, I can show you how to activate one temporarily. Go in your wp-config.php file and look for
define('WP_DEBUG', false);
Change it to:
define('WP_DEBUG', true);
Then add these lines, just before it says 'stop editing here':
ini_set('log_errors',TRUE);
ini_set('error_reporting', E_ALL);
ini_set('error_log', dirname(__FILE__) . '/error_log.txt');
Leave the logs running for a day or two (until the error has been replicated). If any server-side errors are generated, this will create an error_log.txt file in your site's root directory. Please send me its contents. Once that is done, you can revert the changes you made to wp-config.php and delete the log file.
Changes made
Thanks for that, I'll stand by for your update tomorrow.
And it happened - only on certain pages - which is how it happens normally - which makes me think it is something to do with preload
text/plain error_log.txt
ASCII text, with very long lines
[30-Jun-2019 21:32:03 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[30-Jun-2019 21:32:07 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Warning: date() expects parameter 2 to be integer, string given in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 160
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:08 UTC] PHP Notice: Undefined variable: today in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 164
[30-Jun-2019 21:32:09 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:09 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:09 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:09 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:09 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:09 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:09 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:09 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:21 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[30-Jun-2019 21:32:22 UTC] PHP Notice: Undefined property: stdClass::$offers in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3258
[30-Jun-2019 21:32:22 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Trying to get property of non-object in /home/naturesl/public_html/wp-content/plugins/extended-widget-options/includes/widgets/display.php on line 235
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: button_area in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2227
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: event_detail in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2231
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: event_navigation in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3101
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: return_value in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1213
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: tag in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3369
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: post in /home/naturesl/public_html/wp-content/plugins/multiple-featured-images/Controller/KdMfiApp.php on line 280
[30-Jun-2019 21:32:23 UTC] PHP Notice: Trying to get property of non-object in /home/naturesl/public_html/wp-content/plugins/multiple-featured-images/Controller/KdMfiApp.php on line 280
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: tag in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3369
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: post in /home/naturesl/public_html/wp-content/plugins/multiple-featured-images/Controller/KdMfiApp.php on line 280
[30-Jun-2019 21:32:23 UTC] PHP Notice: Trying to get property of non-object in /home/naturesl/public_html/wp-content/plugins/multiple-featured-images/Controller/KdMfiApp.php on line 280
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: tag in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3419
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3428
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2627
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2649
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: deposit_note in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2931
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: flight_note in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2955
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: cuisine_note in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2979
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: luggage_note in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3003
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: agent_note in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3027
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: substitution_note in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3051
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: additional_costs_note in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3075
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2808
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: event_detail in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2840
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3963
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3964
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2671
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: return in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3918
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2745
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: event_detail in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 2767
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: return_value in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1273
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: post_id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1335
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: start_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1340
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: end_date in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1341
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: outputDate in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 1431
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: id in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3602
[30-Jun-2019 21:32:23 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:23 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:23 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:23 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:23 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:25 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[30-Jun-2019 21:32:34 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[30-Jun-2019 21:32:35 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query SELECT DISTINCT wtv_posts.* FROM wtv_posts LEFT JOIN wtv_term_relationships ON (wtv_posts.ID = wtv_term_relationships.object_id) INNER JOIN wtv_postmeta ON ( wtv_posts.ID = wtv_postmeta.post_id ) INNER JOIN wtv_postmeta AS mt1 ON ( wtv_posts.ID = mt1.post_id ) INNER JOIN wtv_postmeta AS mt2 ON ( wtv_posts.ID = mt2.post_id ) LEFT JOIN wtv_postmeta as tribe_event_end_date ON ( wtv_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND (
wtv_term_relationships.term_taxonomy_id IN (3477)
) AND (
wtv_postmeta.meta_key = '_EventStartDate'
AND
(
( mt1.meta_key = 'wpcf-event-start-date-for-types' AND mt1.meta_value > '1561852800' )
AND
( mt2.meta_key = 'wpcf-event-year' AND mt2.meta_value = '2019' )
)
) AND wtv_posts.post_type = 'tribe_events' AND ((wtv_posts.post_status = 'publish')) AND wtv_posts.ID NOT IN ( SELECT ID FROM wtv_posts WHERE post_type IN ('post','page','attachment','blocks','included-element','excluded-element','testimonial-snippet','event-highlight','frm_display','popup','tribe_events') AND ID IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wtv_posts.ID ORDER BY EventStartDate ASC, wtv_postmeta.meta_value ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/index.php'), get_header, locate_template, load_template, require_once('/themes/flatsome/header.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-wrapper.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-bottom.php'), flatsome_header_elements, flatsome_header_nav, wp_nav_menu, apply_filters('wp_nav_menu_objects'), WP_Hook->apply_filters, Mega_Menu->add_widgets_to_menu, Mega_Menu_Widget_Manager->show_widget, WP_Widget->display_callback, WP_Widget_Custom_HTML->widget, apply_filters('widget_text'), WP_Hook->apply_filters, wpv_resolve_internal_shortcodes_for_widgets, do_shortcode, preg_replace_callback, do_shortcode_tag, WP_Views->short_tag_wpv_view, WP_Views->render_view_ex, WP_Views->render_view, wpv_filter_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[30-Jun-2019 21:32:35 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query SELECT DISTINCT wtv_posts.* FROM wtv_posts LEFT JOIN wtv_term_relationships ON (wtv_posts.ID = wtv_term_relationships.object_id) INNER JOIN wtv_postmeta ON ( wtv_posts.ID = wtv_postmeta.post_id ) INNER JOIN wtv_postmeta AS mt1 ON ( wtv_posts.ID = mt1.post_id ) INNER JOIN wtv_postmeta AS mt2 ON ( wtv_posts.ID = mt2.post_id ) LEFT JOIN wtv_postmeta as tribe_event_end_date ON ( wtv_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND (
wtv_term_relationships.term_taxonomy_id IN (3477)
) AND (
wtv_postmeta.meta_key = '_EventStartDate'
AND
(
( mt1.meta_key = 'wpcf-event-start-date-for-types' AND mt1.meta_value > '1561852800' )
AND
( mt2.meta_key = 'wpcf-event-year' AND mt2.meta_value = '2020' )
)
) AND wtv_posts.post_type = 'tribe_events' AND ((wtv_posts.post_status = 'publish')) AND wtv_posts.ID NOT IN ( SELECT ID FROM wtv_posts WHERE post_type IN ('post','page','attachment','blocks','included-element','excluded-element','testimonial-snippet','event-highlight','frm_display','popup','tribe_events') AND ID IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wtv_posts.ID ORDER BY EventStartDate ASC, wtv_postmeta.meta_value ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/index.php'), get_header, locate_template, load_template, require_once('/themes/flatsome/header.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-wrapper.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-bottom.php'), flatsome_header_elements, flatsome_header_nav, wp_nav_menu, apply_filters('wp_nav_menu_objects'), WP_Hook->apply_filters, Mega_Menu->add_widgets_to_menu, Mega_Menu_Widget_Manager->show_widget, WP_Widget->display_callback, WP_Widget_Custom_HTML->widget, apply_filters('widget_text'), WP_Hook->apply_filters, wpv_resolve_internal_shortcodes_for_widgets, do_shortcode, preg_replace_callback, do_shortcode_tag, WP_Views->short_tag_wpv_view, WP_Views->render_view_ex, WP_Views->render_view, wpv_filter_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[30-Jun-2019 21:32:35 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query SELECT DISTINCT wtv_posts.* FROM wtv_posts INNER JOIN wtv_postmeta ON ( wtv_posts.ID = wtv_postmeta.post_id ) INNER JOIN wtv_postmeta AS mt1 ON ( wtv_posts.ID = mt1.post_id ) LEFT JOIN wtv_postmeta as tribe_event_end_date ON ( wtv_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND (
(
SELECT COUNT(1)
FROM wtv_term_relationships
WHERE term_taxonomy_id IN (672)
AND object_id = wtv_posts.ID
) = 1
) AND (
wtv_postmeta.meta_key = '_EventStartDate'
AND
(
( mt1.meta_key = 'wpcf-event-start-date-for-types' AND mt1.meta_value >= '1561852800' )
)
) AND wtv_posts.post_type = 'tribe_events' AND ((wtv_posts.post_status = 'publish')) AND wtv_posts.ID NOT IN ( SELECT ID FROM wtv_posts WHERE post_type IN ('post','page','attachment','blocks','included-element','excluded-element','testimonial-snippet','event-highlight','frm_display','popup','tribe_events') AND ID IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wtv_posts.ID ORDER BY EventStartDate ASC, wtv_postmeta.meta_value ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/index.php'), get_header, locate_template, load_template, require_once('/themes/flatsome/header.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-wrapper.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-bottom.php'), flatsome_header_elements, flatsome_header_nav, wp_nav_menu, apply_filters('wp_nav_menu_objects'), WP_Hook->apply_filters, Mega_Menu->add_widgets_to_menu, Mega_Menu_Widget_Manager->show_widget, WP_Widget->display_callback, WPV_Widget->widget, WP_Views->render_view_ex, WP_Views->render_view, wpv_filter_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[30-Jun-2019 21:32:35 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query SELECT DISTINCT wtv_posts.* FROM wtv_posts LEFT JOIN wtv_term_relationships ON (wtv_posts.ID = wtv_term_relationships.object_id) INNER JOIN wtv_postmeta ON ( wtv_posts.ID = wtv_postmeta.post_id ) INNER JOIN wtv_postmeta AS mt1 ON ( wtv_posts.ID = mt1.post_id ) LEFT JOIN wtv_postmeta as tribe_event_end_date ON ( wtv_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND (
wtv_term_relationships.term_taxonomy_id IN (959)
) AND (
wtv_postmeta.meta_key = '_EventStartDate'
AND
(
( mt1.meta_key = 'wpcf-current-places-available' AND CAST(mt1.meta_value AS SIGNED) > '0' )
)
) AND wtv_posts.post_type = 'tribe_events' AND ((wtv_posts.post_status = 'publish')) AND wtv_posts.ID NOT IN ( SELECT ID FROM wtv_posts WHERE post_type IN ('post','page','attachment','blocks','included-element','excluded-element','testimonial-snippet','event-highlight','frm_display','popup','tribe_events') AND ID IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wtv_posts.ID ORDER BY EventStartDate ASC, wtv_postmeta.meta_value ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/index.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/posts/layout-left-sidebar.php'), get_sidebar, locate_template, load_template, require_once('/themes/flatsome/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, WPV_Widget->widget, WP_Views->render_view_ex, WP_Views->render_view, wpv_filter_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[30-Jun-2019 21:32:35 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:35 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:35 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:35 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:35 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:35 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:35 UTC] PHP Notice: Use of undefined constant depth - assumed 'depth' in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3141
[30-Jun-2019 21:32:36 UTC] PHP Notice: Undefined variable: output in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3157
[30-Jun-2019 21:32:37 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
So this page lien caché shows no events found
Login - view the same page - and the third column still does not show events
Use the Design with toolset menu - edit the view - change No events found!! to No events found!
View lien caché as a logged in user - the third column is showing events now
WPRocket - clear cache - then preload cache
Logout
View lien caché as a logged out user
The third column is showing events now but there is a 50,50 chance of it failing when the cached next gets cleared - about 6 hours unless anything on the site is changed
Specifically it is the events greater than year query and view that is failing
Okay thanks for the log information, this is interesting. I recall another ticket from the past where something similar is happening:
https://toolset.com/forums/topic/view-does-not-show-events-from-tribe-events-calendar-plugin/
However that other ticket seems to be related to another plugin causing a conflict and your site doesn't use the same plugin.
I have a strong suspicion the database error messages like this are directly related to the issue:
[30-Jun-2019 21:32:35 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query...
At first glance, it seems that the query "thinks" the EventStartDate custom field does not exist. Since the field does not seem to exist, and the ordering criteria are based on that custom field, no results would be returned in this query (that's how WordPress works by design). This sounds like what you're experiencing, so I think this is an important piece of information.
I need to be able to pass this all to my 2nd tier support team for further investigation. However, they won't work on a complex issue until all PHP notices and warnings are resolved and non-essential 3rd-party plugins are removed from the mix. I see several messages regarding undefined variables and undefined constants, as well as issues from other 3rd party plugins. We need to be able to eliminate those issues as potential sources of the problem. Any issues from your functions.php file must be resolved first. What can you tell me about these undefined variables and constants? Is it possible that some process used to generate the cache is missing a file somewhere that includes these definitions? Or is the PHP code here going to produce those undefined messages consistently regardless of caching processes?
After resolving those issues, we need to remove 3rd-party plugins so we can eliminate them as sources of conflict. Do you have a staging environment on a similar hosting setup? That would be very helpful for pinning down the problem. If not, I'll have to work with a clone of our site set up on my own local environment. Once the undefined things are resolved, we can work on creating that clone.
I agree with you - but that doesn't explain why most of the time it does work - and why it has got in a tizzy over that fields when the view is built only using your tools
I did just try to create you a staging environment - but I haven't got the space on my host to do so
All the undefined variables and undefined constants are from one plugin - which holds all my custom shortcodes - it is me being lazy - you can take a copy and disable the NaturesLens Site Specific Functionality plugin and those errors disappear - then you just see a load of raw shortcodes as opposed to the shortcode output - but the site still functions - albeit looking odd!
Is it possible that some process used to generate the cache is missing a file somewhere that includes these definitions? No - I just disabled that plugin - and it alters output only - see above!
Or is the PHP code here going to produce those undefined messages consistently regardless of caching processes? Yes - see above
You'll have fun with non-essential 3rd-party plugins - the backend of this is pretty complex
Let me know how you want to proceed
The only pair of references in the view to _EventStartDate are - the order by clause and the great than or equal today clause - this is a query that is used over and over in other parts of the site - in other views - it does not fail there - the only difference here is the addition of the not in 2019 and not in 2020 clauses
Right Christian - I have been through the functions.php file - and sorted out all the undefined notices - now the error log is a lot cleaner
For example
[01-Jul-2019 18:03:56 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[01-Jul-2019 18:04:07 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[01-Jul-2019 18:04:07 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query SELECT DISTINCT wtv_posts.* FROM wtv_posts LEFT JOIN wtv_term_relationships ON (wtv_posts.ID = wtv_term_relationships.object_id) INNER JOIN wtv_postmeta ON ( wtv_posts.ID = wtv_postmeta.post_id ) INNER JOIN wtv_postmeta AS mt1 ON ( wtv_posts.ID = mt1.post_id ) INNER JOIN wtv_postmeta AS mt2 ON ( wtv_posts.ID = mt2.post_id ) LEFT JOIN wtv_postmeta as tribe_event_end_date ON ( wtv_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND (
wtv_term_relationships.term_taxonomy_id IN (3477)
) AND (
wtv_postmeta.meta_key = '_EventStartDate'
AND
(
( mt1.meta_key = 'wpcf-event-start-date-for-types' AND mt1.meta_value > '1561939200' )
AND
( mt2.meta_key = 'wpcf-event-year' AND mt2.meta_value = '2019' )
)
) AND wtv_posts.post_type = 'tribe_events' AND ((wtv_posts.post_status = 'publish')) AND wtv_posts.ID NOT IN ( SELECT ID FROM wtv_posts WHERE post_type IN ('post','page','attachment','blocks','included-element','excluded-element','testimonial-snippet','event-highlight','frm_display','popup','tribe_events') AND ID IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wtv_posts.ID ORDER BY EventStartDate ASC, wtv_postmeta.meta_value ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/index.php'), get_header, locate_template, load_template, require_once('/themes/flatsome/header.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-wrapper.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-bottom.php'), flatsome_header_elements, flatsome_header_nav, wp_nav_menu, apply_filters('wp_nav_menu_objects'), WP_Hook->apply_filters, Mega_Menu->add_widgets_to_menu, Mega_Menu_Widget_Manager->show_widget, WP_Widget->display_callback, WP_Widget_Custom_HTML->widget, apply_filters('widget_text'), WP_Hook->apply_filters, wpv_resolve_internal_shortcodes_for_widgets, do_shortcode, preg_replace_callback, do_shortcode_tag, WP_Views->short_tag_wpv_view, WP_Views->render_view_ex, WP_Views->render_view, wpv_filter_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[01-Jul-2019 18:04:07 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query SELECT DISTINCT wtv_posts.* FROM wtv_posts LEFT JOIN wtv_term_relationships ON (wtv_posts.ID = wtv_term_relationships.object_id) INNER JOIN wtv_postmeta ON ( wtv_posts.ID = wtv_postmeta.post_id ) INNER JOIN wtv_postmeta AS mt1 ON ( wtv_posts.ID = mt1.post_id ) INNER JOIN wtv_postmeta AS mt2 ON ( wtv_posts.ID = mt2.post_id ) LEFT JOIN wtv_postmeta as tribe_event_end_date ON ( wtv_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND (
wtv_term_relationships.term_taxonomy_id IN (3477)
) AND (
wtv_postmeta.meta_key = '_EventStartDate'
AND
(
( mt1.meta_key = 'wpcf-event-start-date-for-types' AND mt1.meta_value > '1561939200' )
AND
( mt2.meta_key = 'wpcf-event-year' AND mt2.meta_value = '2020' )
)
) AND wtv_posts.post_type = 'tribe_events' AND ((wtv_posts.post_status = 'publish')) AND wtv_posts.ID NOT IN ( SELECT ID FROM wtv_posts WHERE post_type IN ('post','page','attachment','blocks','included-element','excluded-element','testimonial-snippet','event-highlight','frm_display','popup','tribe_events') AND ID IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wtv_posts.ID ORDER BY EventStartDate ASC, wtv_postmeta.meta_value ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/index.php'), get_header, locate_template, load_template, require_once('/themes/flatsome/header.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-wrapper.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-bottom.php'), flatsome_header_elements, flatsome_header_nav, wp_nav_menu, apply_filters('wp_nav_menu_objects'), WP_Hook->apply_filters, Mega_Menu->add_widgets_to_menu, Mega_Menu_Widget_Manager->show_widget, WP_Widget->display_callback, WP_Widget_Custom_HTML->widget, apply_filters('widget_text'), WP_Hook->apply_filters, wpv_resolve_internal_shortcodes_for_widgets, do_shortcode, preg_replace_callback, do_shortcode_tag, WP_Views->short_tag_wpv_view, WP_Views->render_view_ex, WP_Views->render_view, wpv_filter_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[01-Jul-2019 18:04:08 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query SELECT DISTINCT wtv_posts.* FROM wtv_posts INNER JOIN wtv_postmeta ON ( wtv_posts.ID = wtv_postmeta.post_id ) INNER JOIN wtv_postmeta AS mt1 ON ( wtv_posts.ID = mt1.post_id ) LEFT JOIN wtv_postmeta as tribe_event_end_date ON ( wtv_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND (
(
SELECT COUNT(1)
FROM wtv_term_relationships
WHERE term_taxonomy_id IN (672)
AND object_id = wtv_posts.ID
) = 1
) AND (
wtv_postmeta.meta_key = '_EventStartDate'
AND
(
( mt1.meta_key = 'wpcf-event-start-date-for-types' AND mt1.meta_value >= '1561939200' )
)
) AND wtv_posts.post_type = 'tribe_events' AND ((wtv_posts.post_status = 'publish')) AND wtv_posts.ID NOT IN ( SELECT ID FROM wtv_posts WHERE post_type IN ('post','page','attachment','blocks','included-element','excluded-element','testimonial-snippet','event-highlight','frm_display','popup','tribe_events') AND ID IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wtv_posts.ID ORDER BY EventStartDate ASC, wtv_postmeta.meta_value ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/index.php'), get_header, locate_template, load_template, require_once('/themes/flatsome/header.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-wrapper.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/header/header-bottom.php'), flatsome_header_elements, flatsome_header_nav, wp_nav_menu, apply_filters('wp_nav_menu_objects'), WP_Hook->apply_filters, Mega_Menu->add_widgets_to_menu, Mega_Menu_Widget_Manager->show_widget, WP_Widget->display_callback, WPV_Widget->widget, WP_Views->render_view_ex, WP_Views->render_view, wpv_filter_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[01-Jul-2019 18:04:08 UTC] WordPress database error Unknown column 'EventStartDate' in 'order clause' for query SELECT DISTINCT wtv_posts.* FROM wtv_posts LEFT JOIN wtv_term_relationships ON (wtv_posts.ID = wtv_term_relationships.object_id) INNER JOIN wtv_postmeta ON ( wtv_posts.ID = wtv_postmeta.post_id ) INNER JOIN wtv_postmeta AS mt1 ON ( wtv_posts.ID = mt1.post_id ) LEFT JOIN wtv_postmeta as tribe_event_end_date ON ( wtv_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND (
wtv_term_relationships.term_taxonomy_id IN (959)
) AND (
wtv_postmeta.meta_key = '_EventStartDate'
AND
(
( mt1.meta_key = 'wpcf-current-places-available' AND CAST(mt1.meta_value AS SIGNED) > '0' )
)
) AND wtv_posts.post_type = 'tribe_events' AND ((wtv_posts.post_status = 'publish')) AND wtv_posts.ID NOT IN ( SELECT ID FROM wtv_posts WHERE post_type IN ('post','page','attachment','blocks','included-element','excluded-element','testimonial-snippet','event-highlight','frm_display','popup','tribe_events') AND ID IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wtv_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wtv_posts.ID ORDER BY EventStartDate ASC, wtv_postmeta.meta_value ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/index.php'), get_template_part, locate_template, load_template, require('/themes/flatsome/template-parts/posts/layout-left-sidebar.php'), get_sidebar, locate_template, load_template, require_once('/themes/flatsome/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, WPV_Widget->widget, WP_Views->render_view_ex, WP_Views->render_view, wpv_filter_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[01-Jul-2019 18:04:19 UTC] PHP Warning: Error while sending QUERY packet. PID=27046 in /home/naturesl/public_html/wp-includes/wp-db.php on line 2007
[01-Jul-2019 18:04:19 UTC] PHP Notice: Undefined index: HTTP_ACCEPT_LANGUAGE in /home/naturesl/public_html/wp-content/plugins/popup-maker/classes/Utils/I10n.php on line 158
[01-Jul-2019 18:04:19 UTC] PHP Notice: /home/naturesl/public_html/wp-content/plugins/the-events-calendar/src/deprecated/TribeEventsAPI.php is deprecated since version 3.10! Use Tribe__Events__API instead. in /home/naturesl/public_html/wp-includes/functions.php on line 4589
[01-Jul-2019 18:04:22 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[01-Jul-2019 18:04:24 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[01-Jul-2019 18:04:49 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[01-Jul-2019 18:04:52 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
[01-Jul-2019 18:04:52 UTC] PHP Notice: Undefined property: stdClass::$offers in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 3357
[01-Jul-2019 18:04:53 UTC] PHP Notice: Trying to get property of non-object in /home/naturesl/public_html/wp-content/plugins/extended-widget-options/includes/widgets/display.php on line 235
[01-Jul-2019 18:04:53 UTC] PHP Notice: Undefined variable: post in /home/naturesl/public_html/wp-content/plugins/multiple-featured-images/Controller/KdMfiApp.php on line 280
[01-Jul-2019 18:04:53 UTC] PHP Notice: Trying to get property of non-object in /home/naturesl/public_html/wp-content/plugins/multiple-featured-images/Controller/KdMfiApp.php on line 280
[01-Jul-2019 18:04:53 UTC] PHP Notice: Undefined variable: post in /home/naturesl/public_html/wp-content/plugins/multiple-featured-images/Controller/KdMfiApp.php on line 280
[01-Jul-2019 18:04:53 UTC] PHP Notice: Trying to get property of non-object in /home/naturesl/public_html/wp-content/plugins/multiple-featured-images/Controller/KdMfiApp.php on line 280
[01-Jul-2019 18:04:53 UTC] PHP Notice: Undefined variable: return in /home/naturesl/public_html/wp-content/plugins/functions/functions.php on line 4046
[01-Jul-2019 18:04:55 UTC] PHP Warning: Declaration of SEO_Auto_Linker_Front::get_meta($post, $key) should be compatible with SEO_Auto_Linker_Base::get_meta($key, $default = '') in /home/naturesl/public_html/wp-content/plugins/seo-auto-linker/inc/front.php on line 0
We are still seeing stupidity about EventStartDate though - over to you
Okay the next step is for me to get a clone of your site installed on a local environment where we can work to strip out irrelevant plugins and such. If you approve I can log in, install the Duplicator plugin and get started on that. Please provide admin login credentials in the private reply fields here. If that's not possible we can discuss other options like a different cloning plugin, or a raw backup of your database and server files.
Christian - rather conveniently right now - the new staging site is being silly
lien caché shows the proper three columns
lien caché is showing the borked third column
As a logged out user
Ok great, I'm in staging now and I have activated the parent Flatsome theme, WP Rocket, The Events Calendar, Types and Views. I can see the problem as a logged-out User, so this is a good indicator we can disregard your child theme, custom code, and all other plugins. That's as far as I can go today. I'll continue testing tomorrow as my day is closing here. Thanks for your help getting the test environment ready to go. If possible, please leave it as-is for me to continue tomorrow.
Okay I created a clone from the staging site and I've been running tests locally all morning. Unfortunately I haven't been able to replicate the database error in my own logs. I've been adding and editing site content and visiting as both a logged-in and logged-out User, but I'm not seeing those errors logged. So I started digging into the View query to see what could be happening here, and it struck me that you're using a custom field filter based on an Events Calendar date field: "The field _EventStartDate is a string that is greater than or equal the following: TODAY()". But The Events Calendar date field is not a Unix timestamp. Views is comparing the field as a string, to another string. I can see you also have the Event Start Date for Types field, and some custom code in your theme that populates it automatically with a Unix timestamp. So it seems like this would work more consistently if you filtered not based on _EventStartDate, but on the Event Start Date for Types field, using an UNSIGNED or number comparison.
Am I understanding correctly that all your Events should have the Event Start Date for Types field value set automatically? If so, can we try switching these View filters to be based on that field?
