Does Not Work on my version

  • 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://www.ads-software.com/plugins/clean-zombie-users/

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