Error with ver 3.0 and WP 4.1.1

If I may add my voice to this thread, I’m getting the same first warning, but not the second.

Warning: mysql_real_escape_string() expects parameter 1
to be string, object given in /wp-includes/wp-db.php on
line 1036

However, I’m seeing this on the front end and not in the admin. I’m using Gravity Forms and their User Registration Add-on. When the registration form is submitted, the warning is displayed but the user is still registered.

Something to note though, I think AMA’s count_multiple_accounts function is being called twice during this process, once without the user ID, and the second time with the new user ID.

I came to that conclusion two ways:

1. I’m receiving two New User Registration emails from WordPress with the same info in each email, for each registration.

2. I modified the code in that function to echo the $sql variable, and it prints out the SQL string without the ” AND ID != %d”, and then with it, all in one line.

When I comment out the line in that function that includes $wpdb->prepare, the warning doesn’t appear.

Don’t know if that will help. I worked on the AMA code for a while last night trying to solve this, but I need to move ahead with some other aspects of this project now.

And Scott, thanks for the helpful plugin!

Scott,

I didn’t even think about $user_id being the object that was causing the warning. I figured it was somehow $email since the warning stated that parameter 1 needed to be a string.

No, only one email gets sent when using the WP Add New User form in the admin. That’s the form you were referring to, correct?

Okay, I just deactivated AMA and then registered with Gravity Forms User Registration Add-on. Still received two emails, so I’m going to assume that issue has nothing to do with your plugin.

I think we’re good then!

Forgot about that default form!

No, this site is a unique set-up where the client wanted to allow users to register who (supposedly) don’t have email addresses, so I did some custom coding that assigns a default email address to anyone who checks that option on the registration form. So there’s only one email address that’s allowed to be used for multiple users. And it’s an email address that doesn’t actually exist.

But your questions reminded me that I’m also running Theme My Login, and there’s a setting in that plugin to disable the admin notification email for new users. I selected that option, thinking that TML and GF User Registration were BOTH sending the email, and that solved the problem.

Thanks for the nudge in the right direction!