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 This might have happened after upgrading to 9.69, but I am not sure as I tooka long time to discover the error...
 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!
|