| Author |
 Topic  |
|
matko
New Member
54 Posts |
 Posted - 11 August 2005 : 08:03:59
|
One of my users is trying to change his registered e-mail but the system is refusing to do so, stating that "E-mail Address already in use, Please Choose Another"
Since I am running forum on access I downloaded the database to my computer and manually searched forum_members and forum_members_pending tables for that particular e-mail, but such an e-mail doesn't exist.
What could be the reason for system refusing to accept this e-mail? is there any other place in the database I sould search? |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 August 2005 : 08:09:49
|
It must be there, otherwise the message wouldn't show. How did you search for it? Building a query would be the surest way to find the email in question.
Anyway, you can turn off the requirement for unique emails, let the user change the email address and then turn the requirement on again. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 11 August 2005 : 08:10:49
|
Did you search the M_NEW_EMAIL field in the MEMBERS table as well? When a member changes their profile e-mail address the new address is inserted in this field, pending validation. It may be that another member on your forums had tried to change their e-mail address to the same one and has not yet validated it.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
matko
New Member
54 Posts |
Posted - 11 August 2005 : 08:13:36
|
I have searched the databse more troughoutly and I have found that prticular e-mail in field m_newemail in forum_members table.
What is this field used for?
Is there any way how to delete this field using code insted of closing forum, downloading the databse, deleting manually and again uploading? Database is now 26 MBs and I my ADSL has only 128 kbits upload so really prefere not to close forum for half an hour or so.
Thanks for help. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
matko
New Member
54 Posts |
Posted - 11 August 2005 : 08:20:23
|
| I meant to delete just that particular value, not a field as such. Sorry for using incorrect term. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
matko
New Member
54 Posts |
Posted - 11 August 2005 : 09:30:14
|
I don't understand. What is this script suppose to do?
I can't change the e-mail address of the user, because it is already in the database.
But speaking about the script, could you please help me to transform this SQL command
UPDATE FORUM_MEMBERS
SET FORUM_MEMBERS.M_NEWEMAIL = ""
WHERE MEMBER_ID=41;
into script, co I can use it in alternate mod setup window? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
matko
New Member
54 Posts |
Posted - 11 August 2005 : 11:14:06
|
| Thank you very much. |
|
|
|
matko
New Member
54 Posts |
Posted - 11 August 2005 : 16:36:25
|
I have tried your script but unfortunately it doesn't work. I am getting this message:
Updating Forum Values..
UPDATE FORUM_MEMBERS SET M_NEW_EMAIL = '' WHERE MEMBER_ID=41
-2147217904 | No value given for one or more required parameters. |
|
|
|
matko
New Member
54 Posts |
Posted - 11 August 2005 : 16:43:30
|
Sorry for bothering, it is solved now. Problem was that field name is m_newemail not m_new_email. I haven't notice that you changed that name in your script.
Thanks a lot. BTW where can I find general description of syntax used for Mod Setup?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
matko
New Member
54 Posts |
Posted - 29 August 2005 : 10:32:26
|
| Thanks a lot, for the link. |
|
|
|
kgrimsby
New Member
USA
72 Posts |
Posted - 10 April 2006 : 01:48:27
|
quote:
Originally posted by matko
One of my users is trying to change his registered e-mail but the system is refusing to do so, stating that "E-mail Address already in use, Please Choose Another" ... What could be the reason for system refusing to accept this e-mail?
There is actually a bug in the Snitz code that leads to this problem. Here's what happens:
When a member changes her e-mail address, the new address is placed in the M_NEWEMAIL field of her record in the members table. The M_EMAIL field retains her original address, pending her response to the verification e-mail, which is sent to the new address.
However, if the member does not respond successfully to the verification e-mail (perhaps she didn't receive it because her ISP's mail server was down), the member would reasonably attempt to change her e-mail address one more time. Indeed, her profile would still show her original address (read from the M_EMAIL field).
However, when the member changes her e-mail address the second time, the change isn't allowed because the address is already in use. Indeed, the new address already appears in the M_NEWEMAIL field of the member's very own record!
So it really is a bug in the Snitz code! The code should exclude the member from the search of the M_NEWEMAIL field for addresses already in use. When this fix is made, the member in the scenario above would simply be sent a second verification e-mail. When she responds to it, the address in the M_NEWEMAIL field is moved to the M_EMAIL field.
Here's the fix (around line 1100 of pop_profile.asp):
strSql = "SELECT M_NEWEMAIL FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_NEWEMAIL = '" & Trim(ChkString(Request.Form("Email"),"SQLString")) & "'"
strSql = strSQL & " AND M_NAME <> '" & ChkString(Request.Form("Name"), "SQLString") & "'"
The only change is the addition of the last assignment statement.
Ken |
Edited by - kgrimsby on 10 April 2006 02:12:52 |
|
|
|
Doc Orac
Starting Member
Netherlands
28 Posts |
Posted - 12 April 2006 : 04:16:47
|
The same happens, when deleting a member from the table, a.k.a, disabling the account, the field M_NEWEMAIL isn't reset. So the email-adress can't be used again. If that email-adress isn't allowed to be used, than locking that account is the solution, so that field M_NEWEMAIL isn't reset. It looks like the way the field M_NEWEMAIL is used, should be looked at, and change if necessary.
See also: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=60365 |
Have A Nice Day!
Doc Orac (Remco Beekmans) @ Rotterdam (NL) |
|
|
|
Topic |
|
Topic Locked
