Conversation
supportHi, since I updated from 4.4.3 to 4.4.6, the plugin not “auto post”. Please check thanks
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.
the same problem
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!
For developer of Snap NextScripts But is not possibile resolve with an update with resolve this bug? thanks for support!
Great, @lacavernamx . Thank you for the tip!
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.
the same problem
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!
For developer of Snap NextScripts But is not possibile resolve with an update with resolve this bug? thanks for support!
Great, @lacavernamx . Thank you for the tip!