After I activated the plugin, I get this error in the "Confirm user Registration":
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY display_name' at line 1]
SELECT id, display_name, user_email FROM wp_users WHERE id IN () ORDER BY display_name
http://wordpress.org/extend/plugins/confirm-user-registration/
Thx for the notice,
I've just released a fix for that error.
It happened when there are no pending users to activate
msolsyd
Member
Posted 10 months ago #
I hate to be the bearer of bad tidings, but this plugin appears to have killed half of my site. Two days ago I lost 20 pages and sub-pages on my site...twice. The first time I was able to retrieve them because my hosting service had a backup but the second time their backup was of the half-eaten site...so I had to go back and manually reconstruct all of these lost pages...very distressing.
At first I didn't want to believe that it was the plugin which caused this problem (it was a solution to another issue I am experiencing with registration), but I had only installed it the day before and then used it for the first time on the day of the disaster. I have since deleted it from my site and thankfully everything seems OK.
Just wanted to let you know.