Gossamer Forum
Home : Products : Gossamer Forum : Development, Plugins and Globals :

Re: [Franco] Existing user ID for e-mail address check

Quote Reply
Re: [Franco] Existing user ID for e-mail address check In reply to
I spent some time today looking at the code. If you use how user names are treated and tested for duplicates as your guide - the process should be simple. There does not appear to be an if/then series to rule out people from using the same user names. Rather, it is handled from the database. You will notice that the value for user_name is limited to unique values. By making the user_email field a unique variable, it will then limit users to haveing one account registered to any one e-mail address.

THIS IS NOT A FIX - BUT RATHER A START

Now - I tried this, but found that if you have offenders already in the system - you can not use this method to fix the problem. The database will return an error with the first offender notifying you that there are duplicate entries in the db.

If you do not have offenders - you can do it, but when you enter this - here is the error message your user gets when they try to register with a dulpicate:

A fatal error has occurred:


Failed to execute query: 'INSERT INTO gforum_User (user_last_logon,user_title,user_password,user_enabled,user_template,user_status,user_val_code,
user_registered,user_admin_validated,user_username,user_email,user_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,NULL)' Reason: Duplicate entry 'duplicate@somedomain.com' for key 2 at GForum::User::signup_submit line 352.




Please enable debugging in setup for more details.



I am trying to identify how the error messaging works - if I get it, I will post. I think this is a needed feature and hopefully someone more knowlegable than this newbie can look at it and identify a SIMPLE fix.

Last edited by:

shiner: Jun 7, 2002, 8:04 AM
Subject Author Views Date
Thread Existing user ID for e-mail address check ArmyAirForces 9541 May 4, 2002, 2:50 PM
Thread Re: [HeavyBombers] Existing user ID for e-mail address check
Paul 9248 May 4, 2002, 2:57 PM
Thread Re: [Paul] Existing user ID for e-mail address check
ArmyAirForces 9257 May 4, 2002, 3:09 PM
Post Re: [HeavyBombers] Existing user ID for e-mail address check
Paul 9258 May 4, 2002, 3:18 PM
Post Re: [Paul] Existing user ID for e-mail address check
Franco 9282 May 5, 2002, 8:07 AM
Post Re: [Paul] Existing user ID for e-mail address check
Franco 9222 May 15, 2002, 10:54 AM
Thread Re: [Army Air Forces] Existing user ID for e-mail address check
ArmyAirForces 9173 May 30, 2002, 8:49 AM
Thread Re: [Army Air Forces] Existing user ID for e-mail address check
Franco 9199 May 30, 2002, 10:03 AM
Thread Re: [Franco] Existing user ID for e-mail address check
Franco 9155 May 30, 2002, 10:07 AM
Thread Re: [Franco] Existing user ID for e-mail address check
shiner 9156 Jun 7, 2002, 6:47 AM
Thread Re: [shiner] Existing user ID for e-mail address check
shiner 9145 Jun 7, 2002, 8:08 AM
Thread Re: [shiner] Existing user ID for e-mail address check
yogi 9125 Jun 7, 2002, 8:34 AM
Post Re: [yogi] Existing user ID for e-mail address check
shiner 9131 Jun 7, 2002, 8:48 AM
Thread Re: [yogi] Existing user ID for e-mail address check
ArmyAirForces 9111 Jul 1, 2002, 9:07 AM
Post Re: [ArmyAirForces] Existing user ID for e-mail address check
ArmyAirForces 9090 Jul 1, 2002, 6:11 PM
Thread Re: [ArmyAirForces] Existing user ID for e-mail address check
yogi 9086 Jul 1, 2002, 11:38 PM
Post Re: [yogi] Existing user ID for e-mail address check
ArmyAirForces 9074 Jul 2, 2002, 7:53 AM