Title: Missing Argument 2 – error message
Last modified: August 21, 2016

---

# Missing Argument 2 – error message

 *  [Profusion](https://wordpress.org/support/users/profusion/)
 * (@profusion)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/missing-argument-2-error-message/)
 * Hi. Thanks for this plugin. I get an error message “Missing argument 2 for wpdb::
   prepare()…” when the user is unflagging a post. I am testing your plugin on a
   XAMPP local host before taking it to my online production website. I really like
   the plugin and it would be great if we can fix this error message of if you think
   it is only due to it not being online.
 * [http://wordpress.org/plugins/virtual-moderator/](http://wordpress.org/plugins/virtual-moderator/)

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

 *  Thread Starter [Profusion](https://wordpress.org/support/users/profusion/)
 * (@profusion)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/missing-argument-2-error-message/#post-4398854)
 * sorry you probably need the rest of the error message as well.
 * “Warning: Missing argument 2 for wpdb::prepare(), called in C:\…\wp-content\plugins\
   virtual-moderator\processor.php on line 102 and defined in C:\…\wp-includes\wp-
   db.php on line 992”
 * Thanks
 *  [Lex Robinson](https://wordpress.org/support/users/lex_robinson/)
 * (@lex_robinson)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/missing-argument-2-error-message/#post-4399160)
 * You can use the following patch to fix this error:
 *     ```
       --- a/wp-content/plugins/virtual-moderator/processor.php
       +++ b/wp-content/plugins/virtual-moderator/processor.php
       @@ -101,16 +101,7 @@ echo flagged();
        		echo flag();
   
        if($user!=0){
       -$wpdb->query( $wpdb->prepare(
       -	"DELETE FROM ".$wpdb->prefix."vmdata
       -	WHERE post_id='".$pid."' AND user_id='".$user."'") );
       -}else{$wpdb->query( $wpdb->prepare(
       -	"
       -		DELETE FROM ".$wpdb->prefix."vmdata
       -		WHERE post_id='".$pid."' AND ip='".$ip."'",
       -        $pid,
       -	$user,
       -	$ip
       -) );
       -
       +$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}vmdata WHERE post_id=%s AND user_id=%s", $pid, $user) );
       +}else{
       +$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}vmdata WHERE post_id=%s AND ip=%s", $pid, $ip ) );
        };};};
       --- a/wp-content/plugins/virtual-moderator/vmoderator.php
       +++ b/wp-content/plugins/virtual-moderator/vmoderator.php
       @@ -138,9 +138,7 @@ function on_publish($postid){
        		//if($culevel>=$vms['canUnflag']){
        		if(wp_get_current_user()->allcaps['level_'.$vms['canUnflag']]){
        			delete_post_meta($postid, '_flags');
       -				$wpdb->query( $wpdb->prepare(
       -			"DELETE FROM ".$wpdb->prefix."vmdata
       -			WHERE post_id='".$postid."'") );
       +				$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}vmdata WHERE post_id=%s", $postid ) );
        		};
        	}
        };
       ```
   
 *  Thread Starter [Profusion](https://wordpress.org/support/users/profusion/)
 * (@profusion)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/missing-argument-2-error-message/#post-4399162)
 * Brilliant thanks

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

The topic ‘Missing Argument 2 – error message’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/virtual-moderator.svg)
 * [Virtual Moderator](https://wordpress.org/plugins/virtual-moderator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/virtual-moderator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/virtual-moderator/)
 * [Active Topics](https://wordpress.org/support/plugin/virtual-moderator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/virtual-moderator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/virtual-moderator/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Profusion](https://wordpress.org/support/users/profusion/)
 * Last activity: [12 years, 5 months ago](https://wordpress.org/support/topic/missing-argument-2-error-message/#post-4399162)
 * Status: not resolved