Print Page | Close Window

Problem with e-mail encoding (activation email)

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28969
Printed Date: 01 April 2026 at 4:05pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Problem with e-mail encoding (activation email)
Posted By: claustrier
Subject: Problem with e-mail encoding (activation email)
Date Posted: 20 November 2010 at 12:10pm
I have problems with my activation email - the link generated ends in an error on the activate.asp page.
 
I get a HTTP 500 error - the link looks like this;
 

http://%20" rel="nofollow - http://www.forumname.com/forum/activate.asp?ID=111test%2D8865%2DDAB%2D3AB1%2D9Z2Z&USD=388

 
If i remove everything after /activate.asp the page shows as expected, and even if i remove the text &USD=388 at the end - but directly linked as above i get a HTTP error 500
 
This might have happened after upgrading to 9.69, but I am not sure as I tooka long time to discover the error...Angry
 
EDIT: Funny thing happened, tried to delete the last character in the link ('8') and activation is successful. What is this ????
 
see question in next post



Replies:
Posted By: claustrier
Date Posted: 20 November 2010 at 1:13pm
I found out the email is encoded wrong;
 
the link

http://" rel="nofollow - http://www.forumname.com/forum/activate.asp?ID=aaa123%2D7FBC%2DCAZ%2D21FZ%2DZF77&USD=390

 
has the hash aaa123-7FBC-CAZ-21FZ-ZF77 in the database. So the email replaces '-' with '%'
 
I use ISO-8859 and it work all the way through the forum except for the activation email, the other PM emails look fine with local characters.
 
What is wrong here???


Posted By: WebWiz-Bruce
Date Posted: 22 November 2010 at 5:11pm
The way email activation works has not changed for about 5 years, so know that it works.

The activation link is URL encoded, which means that the '-' would be changed to %2D. This is the correct encoding for URL's for the '-' sign.

I suspect that something else is causing your error. However, to findout what the problem is you need to make sure the server is showing detailed error messages and turn off Friendly Error Messages in your browser. The resulting detailed error message will the tell us what the exact problem is.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: claustrier
Date Posted: 22 November 2010 at 7:55pm
Firefox gives me this;
 

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Query-based update failed because the row to update could not be found.

/forum/activate.asp, line 113



Posted By: claustrier
Date Posted: 22 November 2010 at 8:23pm
...and I found the error - I was completely off, so your little hint helped me a lot;
 
I had earlier added some rows to tblAuthor (golf forum, so things like home club, handicap and so on..), and after upgrading, the new register.asp of course did not have my extra fields that i had added to register.asp earlier.
 
Adding my own code to the new register.asp did the trick :-) Thanks a lot for your kind help, much appreciated!



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net