Bug: Change user email address does not update email lists

[AbleMods]

ac_EMailListUsers is not updating when a user changes his email address.

This breaks him from all lists to which the user has subscribed if the user ever changes their email address.

More importantly, the table design is wrong. It should be tying back to ac_Users with UserId so updates and deletes can cascade. Currently it just has email address as the connecting element to the user account.

Email list entries are orphaned when a user is deleted by the admin. This is gonna get ugly real fast on an active site.

[Logan Rhodehamel]

ac_EMailListUsers is not updating when a user changes his email address.

This breaks him from all lists to which the user has subscribed if the user ever changes their email address.

More importantly, the table design is wrong. It should be tying back to ac_Users with UserId so updates and deletes can cascade. Currently it just has email address as the connecting element to the user account.

Email list entries are orphaned when a user is deleted by the admin. This is gonna get ugly real fast on an active site.

People can subscribe / unsubscribe without being registered members of the site. That's why it's not linked into the ac_Users table.

If a user has an updated email address we probably should update the email list.

If the admin deletes a user, do you think it is required to remove the listing?

[AbleMods]

The only place I see email lists being rendered is in the Account page. That page can't render unless the user authenticates i.e. registers, right?

That's why I assumed email lists were specific to registered users. My apologies if that assumption was wrong.

If a user gets to the point where they specifically ask me to remove him from my site, it's a pretty sure bet he isn't interested in receiving any more email from me.

I like it being restricted to registered users, but I'm a control freak so that would make sense

[jmestep]

We have thousands of people on our email list who aren't registered customers. Johnny hasn't talked Mommy into buying him a paintball gun yet.

[AbleMods]

Judy, it's really tough to argue a point when you are continually using your years of experience and wisdom

That's a really, really good point you have made. Where in AC7 can you see email lists now without having authenticated the site?

Currently, I have my mail server software handling my email lists needs until AC7 develops a little more. I should probably link those up on the home page somewhere so the authentication isn't required.

Judy rocks!

[Logan Rhodehamel]

SubscribeToEmailList

Summary: Displays a simple email list signup form. This form can be added to side bars.

Usage: [[ConLib:SubscribeToEmailList Caption="Subscribe To Email List" EmailListId="0"]]

Properties:
Caption
Possible value can be any string. Title of the control.
EmailListId
Possible value can be any integer. This is the ID of the Email List to be subscribed to. If no email list is specified the store's default email list is used.

[Logan Rhodehamel]

Johnny hasn't talked Mommy into buying him a paintball gun yet.

Yeah... Johnny wants an invert mini this year.

[jmestep]

Logan, I know you didn't find that out on company time.

[Logan Rhodehamel]

Logan, I know you didn't find that out on company time.

No I found it out last night. The kids are turning in their wishlists, and he is the only one that didn't want "MONEY".