WPIntell

Source evidence

autopost stop from update

NextScripts: Social Networks Auto-Poster · support · 2024-06-25T21:23:00+00:00

complaintsentiment
mediumseverity
0.86relevance
5replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

4 / 32 rows with source links

12.5% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

28 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
folletti unresolved
Hi, 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!

Comments

5 shown
DFC005 2024-06-26T06:06:00+00:00

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.

lacavernamx 2024-06-28T18:09:00+00:00

the same problem

lacavernamx 2024-06-28T19:26:00+00:00

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!

folletti 2024-08-11T11:39:00+00:00

For developer of Snap NextScripts But is not possibile resolve with an update with resolve this bug? thanks for support!

Junior Miranda 2024-10-24T23:45:00+00:00

Great, @lacavernamx . Thank you for the tip!