{"id":18839390,"date":"2026-03-03T12:09:27","date_gmt":"2026-03-03T12:09:27","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-errors-in-snap-plugin\/"},"modified":"2026-03-03T12:09:27","modified_gmt":"2026-03-03T12:09:27","slug":"sql-errors-in-snap-plugin","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-errors-in-snap-plugin\/","title":{"rendered":"SQL errors in SNAP Plugin"},"content":{"rendered":"\n

Three different problems with plugin<\/p>\n\n\n\n

    \n
  1. Usage of deprecated utf8_decode()<\/code><\/li>\n\n\n\n
  2. Cron Query error unkown column id<\/code><\/li>\n\n\n\n
  3. When on SNAP Log\/History page, selecting filter throws error and nothing is visible in history (due to db error)<\/li>\n<\/ol>\n\n\n\n
    [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<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-18839390","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18839390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18839390\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18839390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}