Title: Database error Unknown column ‘id’
Last modified: June 27, 2024

---

# Database error Unknown column ‘id’

 *  [net](https://wordpress.org/support/users/krstarica/)
 * (@krstarica)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/database-error-unknown-column-id/)
 *     ```wp-block-code
       WordPress database error Unknown column 'id' in 'field list' for query SELECT COUNT(id) 'FROM wp_nxs_query WHERE timetorun<\'2024-06-27 21:38:32\'' made by WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Cron_Event_Command->run, Cron_Event_Command::run_event, do_action_ref_array('nxs_querypost_event'), WP_Hook->do_action, WP_Hook->apply_filters, nxs_checkQuery
       ```
   

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

 *  [OldGrumpyDE](https://wordpress.org/support/users/oldgrumpyde/)
 * (@oldgrumpyde)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/database-error-unknown-column-id/#post-17859033)
 * Yeah, developer got confused about how prepared statements work. I’ve fixed it
   manually for an important client’s site today. Hopefully the next update will
   fix this. I’ll backup my modifications for sure. The error you posted isn’t the
   only one. Log functionality is also broken due to same reason. Sigh.
 *  Thread Starter [net](https://wordpress.org/support/users/krstarica/)
 * (@krstarica)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/database-error-unknown-column-id/#post-17930340)
 * Any workaround?
 *  Thread Starter [net](https://wordpress.org/support/users/krstarica/)
 * (@krstarica)
 * [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-unknown-column-id/#post-18156164)
 * To fix this issue edit wp-content/plugins/social-networks-auto-poster-facebook-
   twitter-g/inc/nxs_functions_engine.php and replace:
 *     ```wp-block-code
       $quPostsCnt = $wpdb->get_var($wpdb->prepare("SELECT COUNT(id) %s", $ttr));
       ```
   
 * with:
 *     ```wp-block-code
       $quPostsCnt = $wpdb->get_var( "SELECT COUNT(id) ".$ttr );
       ```
   

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

The topic ‘Database error Unknown column ‘id’’ is closed to new replies.

 * ![](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/)

 * 3 replies
 * 2 participants
 * Last reply from: [net](https://wordpress.org/support/users/krstarica/)
 * Last activity: [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-unknown-column-id/#post-18156164)
 * Status: not resolved