Title: Does Not Work on my version
Last modified: August 30, 2016

---

# Does Not Work on my version

 *  [Charly86](https://wordpress.org/support/users/charly86/)
 * (@charly86)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/does-not-work-464/)
 * This plugins sounds very nice, but unfortunatly does not work on my WP version
 *     ```
       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 'LEAVE AND wp_comments.comment_author IS NULL ' at line 7]
       SELECT * FROM wp_users LEFT JOIN wp_comments ON (wp_users.user_email = wp_comments.comment_author_email) LEFT JOIN wp_posts ON (wp_users.ID = wp_posts.post_author) LEFT JOIN wp_usermeta ON (wp_users.ID = wp_usermeta.user_id) WHERE wp_usermeta.meta_key = 'wp_capabilities' LEAVE AND wp_comments.comment_author IS NULL AND wp_posts.post_author is NULL GROUP BY display_name ;
       ```
   
 * I need to remove the word LEAVE that mySQL does not seems to understand.
    By 
   the way, this also exclude user that commented without registration, mostly 80%
   of my “real users”, I would like to keep them because I approved their comments,
   they have emails in table wp_comments but not on wp_users
 * [https://wordpress.org/plugins/clean-zombie-users/](https://wordpress.org/plugins/clean-zombie-users/)

The topic ‘Does Not Work on my version’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/clean-zombie-users.svg)
 * [Clean Up Zombie Users (spammers)](https://wordpress.org/plugins/clean-zombie-users/)
 * [Support Threads](https://wordpress.org/support/plugin/clean-zombie-users/)
 * [Active Topics](https://wordpress.org/support/plugin/clean-zombie-users/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/clean-zombie-users/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/clean-zombie-users/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [Charly86](https://wordpress.org/support/users/charly86/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/does-not-work-464/)
 * Status: not resolved