Hermeswein Posted May 21, 2016 Share Posted May 21, 2016 Hi there, I'm using the "blocknewsletter" module (2.3.1) on Prestashop 1.6.1.5 to allow users to sign up to newsletters. I observed two strange things (assuming that an eMail address is only registered for a newsletter, and does not have a corresponding customer account with the same eMail address): Let's assume someone signs up for the newsletter, but does not click on the confirmation link that is sent by Prestashop, but instead (accidentally) deletes the eMail. In case he wants to register again, he cannot do this because he only receives the error message "This email address is already registered." when attempting to sign up again. From what I can see, he does not have the possibility anymore to have a proper registration process, unless I delete his eMail address "hardcode" from the SQL table ps_newsletter.Correct? Let's assume someone correctly registers for the newsletter (by clicking on the confirmation link). In that case, there is no possibility for him to unsubscribe from the newsletter? This has to be done manually in the BO (by clicking on the green mark) or by setting his "active"-flag in the SQL table ps_newsletter to 0. Correct? In case I deactivate someone's subscription (because the person cannot do it himself, see above) in "Modules --> Blocknewsletter" by clicking on the green mark, it correctly flags him as "de-active" in ps_newsletter ("active" is set to "0") and makes him disappear from the list in the module. However, in that case, the person cannot sign up again (getting the "This email address is already registered"-error message) and I also cannot re-activate him from the backend, because he completely disappeared from the list (but is still in the SQL table ps_newsletter). So I either have to manually delete his entry from the SQL table ps_newsletter, or set his "active" flag back to "1" in the SQL table ps_newsletter. Correct? All these three observations sound very odd to me, and I'm just wondering if these are bugs, or if I'm just getting something wrong... Best regards, Stefan Link to comment Share on other sites More sharing options...
ortizkic Posted December 2, 2016 Share Posted December 2, 2016 Same problem here. Any help? Link to comment Share on other sites More sharing options...
selectshop.at Posted December 3, 2016 Share Posted December 3, 2016 The native module from Prestashop has no unsubscribe function for the user. If you need it, you should take into consideration to buy a proper/paid module for this: http://addons.prestashop.com/en/search?id_category=0&search_query=newsletter+unsubscribe For to deactivate users you should do it manually on back-office. Behaviour 1) is correct behaviour of the module Behaviour 2) it is correct. Behaviour 3) cannot confirm this behaviour. I can deactivate newsletter and activate it again without problems. You are sure you deactivated the newsletter and not the user ? Which php version is in use ? Which PS version exactly ? Link to comment Share on other sites More sharing options...
Kaper Posted February 15, 2018 Share Posted February 15, 2018 Is there please any way how to add unsubscribe link into newsletter_confirmation template? I really need it due tue GPDR. Thanks Link to comment Share on other sites More sharing options...
SMALLJIM Posted February 23, 2018 Share Posted February 23, 2018 I have the same issue: 3. In case I deactivate someone's subscription (because the person cannot do it himself, see above) in "Modules --> Blocknewsletter" by clicking on the green mark, it correctly flags him as "de-active" in ps_newsletter ("active" is set to "0") and makes him disappear from the list in the module.However, in that case, the person cannot sign up again (getting the "This email address is already registered"-error message) and I also cannot re-activate him from the backend, because he completely disappeared from the list (but is still in the SQL table ps_newsletter). So I either have to manually delete his entry from the SQL table ps_newsletter, or set his "active" flag back to "1" in the SQL tableps_newsletter. Someone can help us to solve it? Thanks so much. Link to comment Share on other sites More sharing options...
henlon Posted May 25, 2018 Share Posted May 25, 2018 Hi guys I have just started to use the Newsletter module in my Prestashop 1.6.1.18 I just discovered the same problem when I tried to re-subscribed an unsubscribed emailaddress Is there any other way than the hard way to direct edit the field "Active" inte ps_newsletter table? Link to comment Share on other sites More sharing options...
Luca Bios Posted October 25, 2020 Share Posted October 25, 2020 Same problem here... anyone who can help me please? I got 1.7.6.4 Cheers Link to comment Share on other sites More sharing options...
SalDan Posted April 6, 2021 Share Posted April 6, 2021 salve possibile che nessuno ha risolto il problema ....come possiamo risolvere anche con un semplice link Unsubscribe AIUTOOOOOOO☹️ Link to comment Share on other sites More sharing options...
GrinGEO Posted August 29, 2021 Share Posted August 29, 2021 any solution ideas how to cleanup the newsletter database with unwanted users? Link to comment Share on other sites More sharing options...
masterx Posted June 23, 2022 Share Posted June 23, 2022 You can setup a SQL query with the SQL manager within the prestashop. Something like: Then I went into the table directly (need phpMyAdmin) ps_request_sql and i simply modified the SQL statement to DELETE... (need phpMyAdmin because PrestaShop does not allow to directly add a delete query) You can execute the query within presta shop now anytime you need it. (It will execute and kinda show a crash message.... However it WILL run the query... simply return to your shop and all non active users are deleted. BEWARE... with this method, depending what SQL query you write... you can destroy your shop... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now