Impossible to delete subscribers

Hi there @dubok,

Which lists do the subscribers belong to? If they belong to the WordPress users list you need to delete them as WordPress users from your wp-admin > users for them to be removed from MailPoet.

Thanks!

It is impossible to delete from any list, not only WP.

Hi there @dubok,

We’ve tried replicating but haven’t been able to yet.

When you try and delete a subscriber from a list what message returns?

Thanks!

0 subscribers moved to trash – the message appears when tried to delete
before the update i deleted the subscribers successfully
there are no errors in developer console in chrome or in server logs

Can you have a look at the databasetable, I suspect that the userno is not blank but has value 0. And then mailpoet does not delete the user!

yes, seems the issue is in db. Will try to reinstall.
Thanmks

i reinstalled the plugin, the issue was not fixed, also i checked db but did not find the issue there.

PS all new subscribers are deleted without a problem, so the issue is definetely in db but where exactly? i checked wp_mailpoet_subscribers table

Have you imported the users in the past? Then possibly the userno contains the value ‘0’. Mailpoet does not delete a record with userno ‘0’. That is a problem I already reported.
Can you check this value ?

I found the issue, all subscribers for unknown reason have become WP users, though they didn’t before… I do not know why.

Ok then you cannot delete them via mailpoet.
But if they became wordpress users, that is very strange.
Mailpoet normally does not add subscribers to wp.

No, I meant they became wp users in wp_mailpoet_subscribers table (is_woocommerce_user changed from 0 to 1 for most subscribers but not all – 27 of 411 were not changed). Actually there are 237 wp users on my website, all others subscribed via form.
Very strange issue…

Ok that explains the fact that you cannot delete them. It appears to me that for some reason the boolean for subscribing has been put into wrong field if all these subscribers became user 1
Does user “1” exist in wp as a normal user?
To be able to delete the subscriber, the userno should be empty e.g. no value in the field userno

Hi there @dubok,

Do you use WooCommerce? If so, it appears the existing values are being updated to the fact that the user is a WooCommerce guest (value 1) preventing the delete. Can you please confirm?

@psmits1567 Thanks for your assistance. ??

yes, seems you are right.
could you please let me know how to fix this?

Hi there @dubok,

In your wp-admin > MailPoet > Settings > WooCommerce, please try unchecking the box that reads “Subscribe old WooCommerce customers”.

Thanks!