Problem with e-mail encoding (activation email)

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
claustrier Members Profile Find Members Posts Groupie Joined: 19 October 2008 Status: Offline Points: 43	Post Options Post Reply Quote claustrier Report Post Thanks(0) Quote Reply Topic: Problem with e-mail encoding (activation email) 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://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... ~~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 Edited by claustrier - 20 November 2010 at 8:02pm

claustrier Members Profile Find Members Posts Groupie Joined: 19 October 2008 Status: Offline Points: 43	Post Options Post Reply Quote claustrier Report Post Thanks(0) Quote Reply Posted: 20 November 2010 at 1:13pm
	I found out the email is encoded wrong; the link 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??? Edited by claustrier - 20 November 2010 at 1:16pm

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

claustrier Members Profile Find Members Posts Groupie Joined: 19 October 2008 Status: Offline Points: 43	Post Options Post Reply Quote claustrier Report Post Thanks(0) Quote Reply 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

claustrier Members Profile Find Members Posts Groupie Joined: 19 October 2008 Status: Offline Points: 43	Post Options Post Reply Quote claustrier Report Post Thanks(0) Quote Reply 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!

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum