Title: [PATCH] wpdb::prepare() requires 2 arguments
Last modified: August 20, 2016

---

# [PATCH] wpdb::prepare() requires 2 arguments

 *  [flynsarmy](https://wordpress.org/support/users/flynsarmy/)
 * (@flynsarmy)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/patch-wpdbprepare-requires-2-arguments/)
 * In WP3.5.1 I’m getting awpdb->prepare() error. You shouldn’t be using prepare
   when you’re not substituting anything. You don’t have to worry about sanitizing
   this particular query because wpdb->prefix is already sanitized and you’re not
   substituting any variables.
 * So in /models/group.php function get_for_select()
    replace `$rows = $wpdb->get_results(
   $wpdb->prepare( "SELECT {$wpdb->prefix}redirection_modules.name AS module_name,{
   $wpdb->prefix}redirection_groups.name AS group_name,{$wpdb->prefix}redirection_groups.
   id FROM {$wpdb->prefix}redirection_groups INNER JOIN {$wpdb->prefix}redirection_modules
   ON {$wpdb->prefix}redirection_modules.id={$wpdb->prefix}redirection_groups.module_id
   ORDER BY {$wpdb->prefix}redirection_modules.name,{$wpdb->prefix}redirection_groups.
   position" ) );` with `$rows = $wpdb->get_results( "SELECT {$wpdb->prefix}redirection_modules.
   name AS module_name,{$wpdb->prefix}redirection_groups.name AS group_name,{$wpdb-
   >prefix}redirection_groups.id FROM {$wpdb->prefix}redirection_groups INNER JOIN{
   $wpdb->prefix}redirection_modules ON {$wpdb->prefix}redirection_modules.id={$
   wpdb->prefix}redirection_groups.module_id ORDER BY {$wpdb->prefix}redirection_modules.
   name,{$wpdb->prefix}redirection_groups.position" );`
 * [http://wordpress.org/extend/plugins/redirection/](http://wordpress.org/extend/plugins/redirection/)

Viewing 1 replies (of 1 total)

 *  [paramasivanpn](https://wordpress.org/support/users/paramasivanpn/)
 * (@paramasivanpn)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/patch-wpdbprepare-requires-2-arguments/#post-3574246)
 * I was getting the following error msg.
 * Warning: Missing argument 2 for wpdb::prepare(), called in /home/alfresco/public_html/
   wp-content/plugins/redirection/models/group.php on line 70 and defined in /home/
   alfresco/public_html/wp-includes/wp-db.php on line 990
 * Above patch fixed the problem.
 * Thank you very much !

Viewing 1 replies (of 1 total)

The topic ‘[PATCH] wpdb::prepare() requires 2 arguments’ is closed to new replies.

 * ![](https://ps.w.org/redirection/assets/icon-256x256.jpg?rev=983639)
 * [Redirection](https://wordpress.org/plugins/redirection/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/redirection/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/redirection/)
 * [Active Topics](https://wordpress.org/support/plugin/redirection/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/redirection/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/redirection/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [paramasivanpn](https://wordpress.org/support/users/paramasivanpn/)
 * Last activity: [13 years, 2 months ago](https://wordpress.org/support/topic/patch-wpdbprepare-requires-2-arguments/#post-3574246)
 * Status: not resolved