Badly formulated SQL command in cron job

Yup, I’m getting the same.

I have the solution, in the file nxs_functions_engine.php in the line 151, it’s the problem:

$ttr = "FROM ". $wpdb->prefix . "nxs_query WHERE timetorun<'".date_i18n('Y-m-d H:i:s')."'"; $quPostsCnt = $wpdb->get_var($wpdb->prepare("SELECT COUNT(id) %s", $ttr));*

change the code to this:

$ttr = $wpdb->prefix . "nxs_query WHERE timetorun < %s"; $current_time = date_i18n('Y-m-d H:i:s'); $query = $wpdb->prepare("SELECT COUNT(id) FROM $ttr", $current_time);
$quPostsCnt = $wpdb->get_var($query);

If you have problems with the query/timeline and log/history, the problems are other queries, cheers!

• This reply was modified 5 months ago by lacavernamx.

Thanks @lacavernamx – I’ve applied your fix, can tell you tomorrow if all is good.

Sadly I’m still seeing similr (not identical) entries in my log. I’ve condensed the old and new entries to make them a bit easier to read:

OLD:
WHERE flt = ‘cron’ AND id NOT IN (
SELECT id FROM…’ at line 1 for query DELETE FROM ‘b3wp_nxs_log’ WHERE flt = ‘cron’ AND id NOT IN (
SELECT id FROM (
SELECT id FROM ‘b3wp_nxs_log’ ORDER BY id DESC LIMIT 360
) foo
) made by do_action_ref_array(‘nxs_hourly_event’), WP_Hook->do_action, WP_Hook->apply_filters, nxs_do_this_hourly, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query

NEW:
SELECT id FROM ( S…’ at line 1 for query DELETE FROM ‘b3wp_nxs_log’ WHERE id <= ( SELECT id FROM ( SELECT id FROM ‘b3wp_nxs_log’ ORDER BY id DESC LIMIT 1 OFFSET 150 ) foo ) made by do_action_ref_array(‘nxs_hourly_event’), WP_Hook->do_action, WP_Hook->apply_filters, nxs_do_this_hourly, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query

I’ve decided to deactivate the plugin, the site is hardly active in the respect covered anyway.

In fact I mentioned that I still had to make changes so that the log/history and the query/timeline could be seen, the code I passed only activates the autopost, the errors you show must be due to the log and the query. My plugin is working.

• This reply was modified 4 months, 4 weeks ago by lacavernamx.
• This reply was modified 4 months, 4 weeks ago by lacavernamx.