Title: [Plugin: Confirm User Registration] problem with plugin
Last modified: August 19, 2016

---

# [Plugin: Confirm User Registration] problem with plugin

 *  [hetz](https://wordpress.org/support/users/hetz/)
 * (@hetz)
 * [18 years ago](https://wordpress.org/support/topic/plugin-confirm-user-registration-problem-with-plugin/)
 * 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/](http://wordpress.org/extend/plugins/confirm-user-registration/)

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

 *  [xzeed](https://wordpress.org/support/users/xzeed/)
 * (@xzeed)
 * [18 years ago](https://wordpress.org/support/topic/plugin-confirm-user-registration-problem-with-plugin/#post-795288)
 * Thx for the notice,
 * I’ve just released a fix for that error.
    It happened when there are no pending
   users to activate
 *  [msolsyd](https://wordpress.org/support/users/msolsyd/)
 * (@msolsyd)
 * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-confirm-user-registration-problem-with-plugin/#post-795682)
 * 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.

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

The topic ‘[Plugin: Confirm User Registration] problem with plugin’ is closed to
new replies.

 * 2 replies
 * 3 participants
 * Last reply from: [msolsyd](https://wordpress.org/support/users/msolsyd/)
 * Last activity: [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-confirm-user-registration-problem-with-plugin/#post-795682)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics