Missing argument 2 for wpdb::prepare()

Hello John,

we are also getting this error. It appears in Tools -> Redirection only.

Thanks,
Martin

I had this issue in my functions.php

BEFORE
$post_count = $wpdb->get_var( $wpdb->prepare($sql));

AFTER
$post_count = $wpdb->get_var( $wpdb->prepare($sql, $count));

I do not understand it exactly, but I looked it up on CODEX and everything still works, I just added the $count at the end.

It’s unfortunately not a WordPress bug … it’s a developers mistake like MCM confirms 🙂

See also: Prepare Missing Argument and PHP Warning Missing Argument.

Same problem here. This error should not be hard to fix but I am traveling right now.
Line 70:
$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" ) );

Also there seems to be a bad link with the URL at the top of the page “Redirections for group: Redirections”

/wp-admin/redirection?page=redirection.php&sub=groups&id=1
/wp-admin/tools.php?page=redirection.php&sub=groups&id=1

I also noticed there has not been any development since 2012. Does anyone recommend an updated plugin or want to start the development back up for this one?

Here is the fix
https://gist.github.com/theandystratton/4565222

On line 70 of redirection/models/group.php
Remove the “( $wpdb->prepare” and ” )” at the end

@laserjobs; Thanks!!! it works.

Also had this problem and the gist fix works. Thanks.