Email unique column not working

Need help,

I don't know if there is anything else that I need to modify in order to make sure that two users cannot register with the same email, I can see the error message in the files, but when the site is live and try to register with the same email, I get no error, the registration goes on with no problem.

thx

How are you validating / checking the email address that is entered?

Are you doing it based on the contents of a recordset, or using the WA Validation Toolkit?

Cheers
Ian

please send a copy of the registration page in a zip archive so we can see what you have set up so far.

I am using the automatic set, and let even security access create a database table directly while creating the security pages.

I am attaching also the index page, because, if a use is a certain page, and are forced to log gin, they are not sent to the previous URL, they are being sent to the log gin success page again.

thx

It looks like you have run the wizard multiple times on these pages and haven't fully cleared them out in between. This is probably the cause of your issue. Please try deleting these pages and starting from scratch. If you still have issues then send a copy of the newly created pages and we can help debug it.

I created a complete new testing site, and made the same steps, just once, and didn't do any modifications on the generated pages, but still I could register the same email several times, so I am attaching the complete folder to this email.

thx

It looks like some files are missing in the
configuration\shared\lWebAssist\ibrary folder

Ray was able to resolve the problem in a connect meeting by manually copying all the files from the
configuration\shared\lWebAssist\SecurityAssist\library folder to the
configuration\shared\lWebAssist\ibrary folder

once the files were copied to that location it appeared to start functioning properly.

Regards
Rune

Im having the same problem! I can register several users with same email!?? I created a standard SA wizard set without modifications. Fresh DW install, fresh extensions install, all cleared before building the standard pages! Of course one could set email field in db as unique but the server validation behaviour should take care of that check!? I have tried manually editing the WA server validations in the registration page but nothing can be changed in that dialog!? If I delete a value and try to reapply it nothing changes! There is a validation typ "unique database value" which I tried to apply on the email field in addition to the "Email address" validation type but it does not work!?

/Martin J.

Martin,

When you say it doesn't work, do you mean you get a Javascript error or that the extension applies the validation but then doesn't work?

If you get the Javascript error there may be a file or two missing from your installation so you will need to get a support call logged with WA so that they can correct it for you.

I find that the Unique Database Value validation works very well after getting over the Javascript error hurdle.

Cheers
Ian

Ian, what I meant was that it's possible to register with the same email over and over and just exchanging the values like name, address etc for the other fields in the registration form. I did not reflect over it until I saw this post and tested. Im still in a very initial stage building my site and when Ive tested I always used different email adresses. What do you alter to prevent user from register if trying to enter the same email adress like a previously registered user? I have tried changing values in the WA server validation behaviour but it's impossible to change anything in that dialogue after the wizard set has been built! I now almost have given up on SA wizard and started building the pages manually with Form Builder and applying the server behaviours afterwards. This works good but some elements created by SA wizard, like the forgotpassword page, is difficult to recreate manually. At least for a newbie like me.

/Martin J.