Hi all!
I am a looooong time user of phpList (installed in 2004) and things were chugging along smoothly, but some time ago (unfortunately I can’t pinpoint when) the confirmation links stopped working. Here’s the flow of events:
- someone signs up through my signup form
- the user gets created as unconfirmed
- user gets the email with the confirmation link
- they click it and see thank you for confirming page
- they receive the welcome email
BUT: the user record is not marked as confirmed.
I have found a workaround by running the query below before I send out any email, marking as confirmed if the user’s history shows they confirmed, but that’s not a good long-term solution.
UPDATE phplist_user_user INNER JOIN phplist_user_user_history ON phplist_user_user.id = phplist_user_user_history.userid SET confirmed = 1 WHERE confirmed = 0 AND summary = 'Confirmation';
I am running phpList 2.10.10 on my production server so I thought I would upgrade to phpList 3.2.4 (long overdue!) before I reported the problem, unfortunately I have the exact same problem on my freshly migrated install of 3.2.4 on my dev server.
Does this issue ring a bell with anyone?
My problem is I’m not exactly sure where to start looking. I tried to poke at the code but couldn’t find my way. Can someone point me to where the confirmation magic happens when users click the confirmation link?
Many thanks in advance for your help,
Clotilde.
phpList version: 2.10.10 and 3.2.4 (freshly migrated from previous)
My site: http://chocolateandzucchini.com
Browser used: doesn’t matter