Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder

There are 2 places that could have issues:

  1. Your first wpdb::prepare() here:
// Prepare and execute the count query
$count_query = $wpdb->prepare( $count_sql, ...$query_params );

The initial value you set for $count_sql is "SELECT COUNT(*) FROM $table_name WHERE 1=1", and if $filters doesn’t have any key matching your switch, the value of $count_sql will remain as its initial value, and as you can see, there are no placeholders in your initial value, which leads the the error. You can avoid it by giving default placeholder(s) in $count_sql, and default value(s) in $query_params.

  1. The following code (your last wpdb::prepare()) definitely leads to error:
// Prepare and execute the paginated query
$query = $wpdb->prepare( $paginated_sql, ...$query_params );

The reason for this is that you have this query for $paginated_sql:

// Add LIMIT and OFFSET to the SQL query
$paginated_sql = $base_sql . $wpdb->prepare( " LIMIT %d OFFSET %d", $per_page, $offset );

Since you already use $wpdb->prepare() for $paginated_sql, all of its placeholders have been updated with the given values. As a result, there are no placeholders in $paginated_sql anymore, leading to the error when you run $wpdb->prepare() again.

Related Posts:

  1. Any possible way to make $wpdb->get_results() return anything else than array?
  2. Trying to establish connection to External Database
  3. How to insert a single row to WP database table?
  4. SQL error with custom query
  5. Check if values exists DB
  6. How to return number of found rows from SELECT query
  7. $wpdb->delete column values IN ARRAY()?
  8. wpdb::prepare was called incorrectly
  9. Delete post revisions on post publish
  10. How to sort results from a custom database table
  11. WPDB: how to get the value of a field in a custom database table
  12. WP database error for comments_popup_link()
  13. my function doesn’t return my post from today
  14. Prevent Data Resubmission On Page refresh
  15. Why is variable not working on custom sql query using wpdb?
  16. Get stock by custom meta field on all Woocommerce variable products
  17. database interactions using OOP
  18. Accessing the database from a plugin outside of action hooks
  19. Echo a hierarchical list of post data from custom fields
  20. Display fields as values in array from external SQL DB
  21. Create WP_Query to search for posts by their categories or their parent/child categories
  22. Getting id of poll from WP database
  23. Storing Array from returned database query and using the array in a new query
  24. WSoD being caused by this piece of code
  25. only show container with next/prev links if they exist?
  26. $wpdb->update with multiple parameters gives error
  27. ACF: how do I get the fields and its values of a specific group?
  28. Update results, Before deleting the related category [closed]
  29. How WordPress reacts to a lack of memory of the server [closed]
  30. wpdb php get_var query to get ID for URL image doesn’t work for ID over 999
  31. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  32. register_taxonomy() take much queries
  33. Display Data in Table from External Database in WP using Shortcodes
  34. How to retrieve the data from the sever and displaying it in a page?
  35. Can’t update multiple rows with $wpdb query
  36. I can’t update my data through $wpdb
  37. wpdb Cannot Update column in Database
  38. How to use mysql LIKE with wpdb?
  39. PHP -> SQL Query with Summing
  40. Delete database record using plugin from admin panel
  41. Wpdb get->results to out the the month from the db
  42. How to add data to a custom field at the wp_users table?
  43. Change MySQL PDO connection to a WPDB connection
  44. WPDB – Read and write value from / to database
  45. Why my query does not run with prepare
  46. How to Generate a list of Most Commented post?
  47. Undefined variable: row?
  48. Add row to custom database Table and delete all rows older than 1 day
  49. select a single val though a table in wordpress
  50. Add posts to custom table in database instead of wp_posts
  51. Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
  52. Reject all malicious URL requests functions.php
  53. Database entry removed on browser refresh, Ajax PHP jQuery
  54. Change wordpress’ database data using ajax – how to get current user id?
  55. Create a new account on site B with data from the purchase of site A
  56. Using wpdb to connect to a different database is not working
  57. Modify post image in full size
  58. getting the values of hidden inputs to use them in a php mysql query
  59. Offset with ajax load more posts duplicates
  60. How to grab data from input and store it into custom table in database?
  61. How to query a staging database?
  62. How can I display a query in a page?
  63. Echo multiple tasks if a common function exists
  64. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  65. Weird Behaviour: Not all WordPress Posts appearing
  66. How to fetch results from database
  67. Unserializeing multiple column values that are stored in one database results variable
  68. Querying multiple meta_keys in WordPress SQL query
  69. MySQL database migration to WordPress
  70. Fetching wpdb data from a php file seems to break?
  71. Insert into db with foreach problem
  72. posts_clauses drop ACF get_field function
  73. How to get data (not value or name) from radio options to POST to database
  74. Exclude a category ID from the following function
  75. Putting form result in my database
  76. Error Warning: Declaration of description_walker::start_el after PHP upgrade [duplicate]
  77. Access/update database with jQuery
  78. Count the number of times the search form template gets included on a page
  79. PHP code inside shortcodes
  80. Querying wpdb using PHP
  81. Remove echo from shortcode
  82. Copyright info change – Corporate Plus Theme PHP [closed]
  83. Inject class in body when particular page template is used
  84. unable to use ‘new WP_Query’ in AJAX call
  85. wp_force_remove_style’ not found
  86. Pagination on Custom Post
  87. how to save checkbox data for custom setting?
  88. How to add aria role and schema markup to custom walker container
  89. WPDB secure custom form
  90. Remove submenu item from list
  91. Insert content into head tag with function
  92. Getting text from custom field from customizer
  93. why not selecting multiple rows of same standard_id using SQL query from database?
  94. How to include a function in a template with template tag
  95. wordpress all post filter by year
  96. Pulling a variable into the wp_nav_menu function
  97. wp_query on search results page showing all results every time
  98. Problem with function.php.. like
  99. get second ID from array
  100. How to properly prepare a column name if passed to a stored procedure?
tech