Title: SQL errors in SNAP Plugin
Last modified: March 3, 2026

---

# SQL errors in SNAP Plugin

 *  [Ashish](https://wordpress.org/support/users/ashishpatel1992/)
 * (@ashishpatel1992)
 * [2 months, 2 weeks ago](https://wordpress.org/support/topic/sql-errors-in-snap-plugin/)
 * Three different problems with plugin
    1. Usage of deprecated `utf8_decode()`
    2. Cron Query error unkown column `id`
    3. When on SNAP Log/History page, selecting filter throws error and nothing is 
       visible in history (due to db error)
 *     ```wp-block-code
       [03-Mar-2026 11:59:06 UTC] PHP Deprecated:  Function utf8_decode() is deprecated in /var/www/html/wp-content/plugins/social-networks-auto-poster-facebook-twitter-g/inc/nxs_functions.php on line 21[03-Mar-2026 11:59:06 UTC] WordPress database error Unknown column 'id' in 'SELECT' for query SELECT COUNT(id) 'FROM wp_nxs_query WHERE timetorun<\'2026-03-03 07:59:06\'' made by do_action_ref_array('nxs_querypost_event'), WP_Hook->do_action, WP_Hook->apply_filters, nxs_checkQuery[03-Mar-2026 12:00:11 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''wp_nxs_log WHERE  (flt = \"snap\" OR (flt = \"cron\" AND (type = \"E\" OR ty...' at line 1 for query SELECT * FROM 'wp_nxs_log WHERE  (flt = \"snap\" OR (flt = \"cron\" AND (type = \"E\" OR type=\"W\"))) ' ORDER BY id DESC LIMIT 0, 300 made by do_action('snapautoposter_page_nxs-log'), WP_Hook->do_action, WP_Hook->apply_filters, nxs_adminMgmt->showPage_log, nxs_adminMgmt->showPage, do_meta_boxes, nxs_adminMgmt->metabox_log, nxs_SNAP->showLogHistoryTab, nxs_getnxsLog[03-Mar-2026 12:00:16 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''wp_nxs_log WHERE  (flt = \"snap\" OR flt = \"cron\") ' ORDER BY id DESC LIMI...' at line 1 for query SELECT * FROM 'wp_nxs_log WHERE  (flt = \"snap\" OR flt = \"cron\") ' ORDER BY id DESC LIMIT 0, 300 made by do_action('wp_ajax_nxs_rfLgo'), WP_Hook->do_action, WP_Hook->apply_filters, nxs_rfLgo_ajax, nxs_getnxsLog[03-Mar-2026 12:00:17 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''wp_nxs_log WHERE  (flt = \"snap\" OR flt = \"cron\" OR flt = \"sys\") ' ORDE...' at line 1 for query SELECT * FROM 'wp_nxs_log WHERE  (flt = \"snap\" OR flt = \"cron\" OR flt = \"sys\") ' ORDER BY id DESC LIMIT 0, 300 made by do_action('wp_ajax_nxs_rfLgo'), WP_Hook->do_action, WP_Hook->apply_filters, nxs_rfLgo_ajax, nxs_getnxsLog
       ```
   

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [Ashish](https://wordpress.org/support/users/ashishpatel1992/)
 * (@ashishpatel1992)
 * [2 months, 2 weeks ago](https://wordpress.org/support/topic/sql-errors-in-snap-plugin/#post-18839395)
 * Snap Plugin Version: 4.4.7
 * DB version: mariadb:10.6
 * php version: 8.2
 * WordPress Version: 6.9.1
 *  Thread Starter [Ashish](https://wordpress.org/support/users/ashishpatel1992/)
 * (@ashishpatel1992)
 * [2 months, 2 weeks ago](https://wordpress.org/support/topic/sql-errors-in-snap-plugin/#post-18839536)
 * I have created a patch fix for this at [https://github.com/ashishpatel1992/NextScripts-SNAP-Plugin-Contribution](https://github.com/ashishpatel1992/NextScripts-SNAP-Plugin-Contribution)
 * After downloading as zip file, extract it rename the folder to `social-networks-
   auto-poster-facebook-twitter-g` and zip it again, then upload it to WordPress
   Plugins
 *  [DFC005](https://wordpress.org/support/users/dfc005/)
 * (@dfc005)
 * [2 months, 2 weeks ago](https://wordpress.org/support/topic/sql-errors-in-snap-plugin/#post-18840105)
 * Oh excellent work. I was coming here to look for a solution to why our autoposting
   had stopped but your fix also fixed that. Thanks mate!
 *  Thread Starter [Ashish](https://wordpress.org/support/users/ashishpatel1992/)
 * (@ashishpatel1992)
 * [2 months, 2 weeks ago](https://wordpress.org/support/topic/sql-errors-in-snap-plugin/#post-18840250)
 * Thanks [@dfc005](https://wordpress.org/support/users/dfc005/)

Viewing 4 replies - 1 through 4 (of 4 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsql-errors-in-snap-plugin%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/social-networks-auto-poster-facebook-twitter-g/assets/icon-
   256x256.png?rev=1106267)
 * [NextScripts: Social Networks Auto-Poster](https://wordpress.org/plugins/social-networks-auto-poster-facebook-twitter-g/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/social-networks-auto-poster-facebook-twitter-g/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/social-networks-auto-poster-facebook-twitter-g/)
 * [Active Topics](https://wordpress.org/support/plugin/social-networks-auto-poster-facebook-twitter-g/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/social-networks-auto-poster-facebook-twitter-g/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/social-networks-auto-poster-facebook-twitter-g/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Ashish](https://wordpress.org/support/users/ashishpatel1992/)
 * Last activity: [2 months, 2 weeks ago](https://wordpress.org/support/topic/sql-errors-in-snap-plugin/#post-18840250)
 * Status: not resolved