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 9545 May 4, 2002, 2:50 PM
Thread Re: [HeavyBombers] Existing user ID for e-mail address check
Paul 9251 May 4, 2002, 2:57 PM
Thread Re: [Paul] Existing user ID for e-mail address check
ArmyAirForces 9260 May 4, 2002, 3:09 PM
Post Re: [HeavyBombers] Existing user ID for e-mail address check
Paul 9261 May 4, 2002, 3:18 PM
Post Re: [Paul] Existing user ID for e-mail address check
Franco 9285 May 5, 2002, 8:07 AM
Post Re: [Paul] Existing user ID for e-mail address check
Franco 9225 May 15, 2002, 10:54 AM
Thread Re: [Army Air Forces] Existing user ID for e-mail address check
ArmyAirForces 9176 May 30, 2002, 8:49 AM
Thread Re: [Army Air Forces] Existing user ID for e-mail address check
Franco 9203 May 30, 2002, 10:03 AM
Thread Re: [Franco] Existing user ID for e-mail address check
Franco 9158 May 30, 2002, 10:07 AM
Thread Re: [Franco] Existing user ID for e-mail address check
shiner 9160 Jun 7, 2002, 6:47 AM
Thread Re: [shiner] Existing user ID for e-mail address check
shiner 9148 Jun 7, 2002, 8:08 AM
Thread Re: [shiner] Existing user ID for e-mail address check
yogi 9128 Jun 7, 2002, 8:34 AM
Post Re: [yogi] Existing user ID for e-mail address check
shiner 9134 Jun 7, 2002, 8:48 AM
Thread Re: [yogi] Existing user ID for e-mail address check
ArmyAirForces 9114 Jul 1, 2002, 9:07 AM
Post Re: [ArmyAirForces] Existing user ID for e-mail address check
ArmyAirForces 9093 Jul 1, 2002, 6:11 PM
Thread Re: [ArmyAirForces] Existing user ID for e-mail address check
yogi 9089 Jul 1, 2002, 11:38 PM
Post Re: [yogi] Existing user ID for e-mail address check
ArmyAirForces 9077 Jul 2, 2002, 7:53 AM