autopost stop from update

I believe it’s related to this error: https://wordpress.org/support/topic/badly-formulated-sql-command-in-cron-job/

We have the same issue and are awaiting a fix.

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!

Great, @lacavernamx.

Thank you for the tip!