Edit Profile Error (9.52 upgrade)
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=26342
Printed Date: 03 April 2026 at 4:49am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Edit Profile Error (9.52 upgrade)
Posted By: dotster
Subject: Edit Profile Error (9.52 upgrade)
Date Posted: 03 October 2008 at 5:24pm
|
I upgraded from 8.03 to 9.52
moved old 8.03 code, upgraded the database, put in new 9.52 code most everything seemed fine.. here is something I came across editing/saving anyone's profile from the profile screen produced this error Microsoft OLE DB Provider for SQL Server error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /forum/register.asp, line 910 So after looking at that line in the code and doing a little googling I went into the SQL 2005 database and changed the Date_format field in tblAuthor table from
nvarchar(10) to nvarchar(20) And no more error...I can now save/edit that profile screen without issue Now I didn't really spend a lot of time on this and the value 20 is something I just tried as a higher value. I don't know if this was the best way to correct the problem or if anyone else will even have the problem. So maybe the developer can chime in and knows what was going on or can say exactly how big that field needs to be. Other then this issue and the RTE file upload issue discussed at the following thread everything else seems fine so far.
http://forums.webwiz.net/forum_posts.asp?TID=26341 - http://forums.webwiz.net/forum_posts.asp?TID=26341 More information.. Running IIS6, SQL Server 2005 Enterprise Edition, on a Server with all USA regional settings. I also double checked that I used the SQL 2005 verion of the 9.52 code. Best Regards |
Replies:
Posted By: dotster
Date Posted: 03 October 2008 at 5:33pm
|
I see another fellow using MSACCESS is having a similar issue with the same line of code
http://forums.webwiz.net/forum_posts.asp?TID=26340 - http://forums.webwiz.net/forum_posts.asp?TID=26340
|
Posted By: dotster
Date Posted: 03 October 2008 at 5:49pm
|
Bruce.. You suggested I make sure I was using all the newest files so I just checked
copied in all new files for the heck of it... changed the field back to nvarchar 10 and same error.. So I changed the field back to nvarchar 20 and saved it .. then looked at the field in the database to see what was there <</mm/yy seems to be about 14 characters maybe this will help you ? |
Posted By: WebWiz-Bruce
Date Posted: 03 October 2008 at 5:51pm
|
The register.asp page has not been changed and there is nothing in the code to course this error and can not replicate this at all. If the data is above 10 characters then it would not function correctly anyway. Could you have a look in your database at those members you have updated the profiles for and see what it in the Date_format field? ------------- 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: dotster
Date Posted: 03 October 2008 at 5:53pm
| See above.. for that info |
Posted By: WebWiz-Bruce
Date Posted: 03 October 2008 at 5:55pm
The format should be dd/mm/yy if you have <</mm/yy then it will not work anyway. I can't see how you would end up with <</mm/yy in your database and can only asume that there must be a corrupted file somewhere. Try reuploading the original files in the functions folder. ------------- 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 |
dotster wrote:Posted By: dotster
Date Posted: 03 October 2008 at 6:08pm
|
Bruce, I just copied in all new files again .. Everything except the database connection file..
It's one of my servers so I am remoted in and everthing is going from a freshly downloaded zip file, to an extracted folder, to right into the web. They are not being ftp'd in where corruption is more likely to occur. Anyway, after putting in the new files in the web the same thing happens with the error I understand that you can't produce the error.. I am a developer as well and I have been there many times. My forum is closed right now I am in no hurry so let's wait and see if anyone else has the issue. If you need me to try anything else else just ask. For now I have put the field value back to 10 because obviously that is what it should be. I'll start going through the code and see if I see anything. |
Posted By: WebWiz-Bruce
Date Posted: 03 October 2008 at 6:14pm
|
You are not the only person to report this error. The register.asp file and the functions_filters.asp files have not been changed in the latest release so there is no reason for this bug. Have also tested a numerous forums running updates that have been done today and none of them have this issue. This leaves only 1 place were this bug may have arisen is with a corrupted to the zip files. To fix this issue what will have to do is repackage all the zip files and release a new version to fix the issue. ------------- 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: dotster
Date Posted: 03 October 2008 at 6:20pm
|
Bruce, I did some old fashion debuggging and I have found the following info as well
the value is fine until it hits the removeAllTags function that function changes it to <</mm/yy EDIT- <</mm/yy As for corrupted files.. not sure ? It's worth trying but in my experience with asp corrupted files usually don't work at all. Maybe you have seen some exceptions but I have not. But who knows.  happens right. Then again ya got a real good point with the other installations working fine.We'll figure it out. Thanks for the support. |
Posted By: WebWiz-Bruce
Date Posted: 03 October 2008 at 6:27pm
|
This type of issue often happens with corrupted files. It should be dd/mm/yy I image a corruption has got into the removeAllTagsfunction in functions/functions_filters.asp with is converting 'd' into &lit; This file has not been changed and also can not replicate here or on any forums installed from original files so it points to a corruption in the zip files. ------------- 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: Simon
Date Posted: 03 October 2008 at 6:27pm
|
Hello.
The self is in the Admin Statistic Panel.
IP-Adress Format <<92.<<68.0.<<8 ??
Simon
|
Posted By: WebWiz-Bruce
Date Posted: 03 October 2008 at 6:35pm
|
Yes it appears that the zip files is corrupted, do not use it until a new version can be released with repackaged zip files
------------- 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: Simon
Date Posted: 03 October 2008 at 6:44pm
|
Yes I drink a cafe
 |
Posted By: WebWiz-Bruce
Date Posted: 03 October 2008 at 6:51pm
|
The repackaged zip files are just being uploaded to the server now. The fixed version is 9.53 ------------- 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: Simon
Date Posted: 03 October 2008 at 7:05pm
|
Hello.
Tested, Profile edit and save its OK.
Forum Statistic IP-Adress is "<63.<76.0.<5"
Thanks for the fast Service !
|
Posted By: 123Simples
Date Posted: 03 October 2008 at 7:09pm
Bruce is the man 
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: dotster
Date Posted: 03 October 2008 at 7:10pm
|
The new files with the changes to register.asp work fine..
Thanks for taking care of this.. and best regards.. |
Posted By: WebWiz-Bruce
Date Posted: 03 October 2008 at 7:13pm
|
You should also ensure that you update the other files as well as I believe the issue was within one of the function contained in another file.
------------- 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: dotster
Date Posted: 03 October 2008 at 7:19pm
|
roger that.. I did replace all files.. best regards |
Posted By: Simon
Date Posted: 04 October 2008 at 8:55am
|
Hello.
Im copy all forum 9.53, the problem with save profile is ok.
When i copy my German Files "RTE_language_file_inc.asp" or "language_file_inc.asp" to the language folder then i have the problem that the edit and save profile the Username, Occupation, Location has false signals (<!imon) etc....
I've searched the my language-files but can not find fault
 You can Download my language-files from this forum...
what is the problem ??
The Problem with the Forum Statistics IP-Adress is also compatible with the original english files...
Thanks Simon |
Posted By: Simon
Date Posted: 04 October 2008 at 10:07am
|
Hello.
I have tested my Language-Files copy to Verson 9.08.
It works fine, all OK.
What is the Problem in Version 9.53 ?
mfg Simon
|
Posted By: WebWiz-Bruce
Date Posted: 04 October 2008 at 10:11am
|
The latest release 9.52 was mainly a bug fix release and very little
was changed, certainly nothing that would course this issue. It seems that every time the input is parsed by the removeAllTags function to remove any malicious scripting that some characters are being changed to '<'. This function has not been changed since version 9 was released over a year ago and there is no reason for this to happen and only seems to be effecting some installations and not all. Certainly none in our development lab or the ones we host on our own servers which makes it even harder to track down the issue. The first thing you should do is try replacing the functions/functions_filters.asp with the latest version incase it is corrupted. If that doesn't work then if you could give a link to your forum so that it can be looked to try and workout why this is happening. Also have you changed any locales, character encoding, or using an Vietnamese? ------------- 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 |