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 5447 May 4, 2002, 2:50 PM
Thread Re: [HeavyBombers] Existing user ID for e-mail address check
Paul 5275 May 4, 2002, 2:57 PM
Thread Re: [Paul] Existing user ID for e-mail address check
ArmyAirForces 5281 May 4, 2002, 3:09 PM
Post Re: [HeavyBombers] Existing user ID for e-mail address check
Paul 5281 May 4, 2002, 3:18 PM
Post Re: [Paul] Existing user ID for e-mail address check
Franco 5301 May 5, 2002, 8:07 AM
Post Re: [Paul] Existing user ID for e-mail address check
Franco 5248 May 15, 2002, 10:54 AM
Thread Re: [Army Air Forces] Existing user ID for e-mail address check
ArmyAirForces 5195 May 30, 2002, 8:49 AM
Thread Re: [Army Air Forces] Existing user ID for e-mail address check
Franco 5225 May 30, 2002, 10:03 AM
Thread Re: [Franco] Existing user ID for e-mail address check
Franco 5178 May 30, 2002, 10:07 AM
Thread Re: [Franco] Existing user ID for e-mail address check
shiner 5174 Jun 7, 2002, 6:47 AM
Thread Re: [shiner] Existing user ID for e-mail address check
shiner 5165 Jun 7, 2002, 8:08 AM
Thread Re: [shiner] Existing user ID for e-mail address check
yogi 5157 Jun 7, 2002, 8:34 AM
Post Re: [yogi] Existing user ID for e-mail address check
shiner 5145 Jun 7, 2002, 8:48 AM
Thread Re: [yogi] Existing user ID for e-mail address check
ArmyAirForces 5131 Jul 1, 2002, 9:07 AM
Post Re: [ArmyAirForces] Existing user ID for e-mail address check
ArmyAirForces 5117 Jul 1, 2002, 6:11 PM
Thread Re: [ArmyAirForces] Existing user ID for e-mail address check
yogi 5101 Jul 1, 2002, 11:38 PM
Post Re: [yogi] Existing user ID for e-mail address check
ArmyAirForces 5110 Jul 2, 2002, 7:53 AM