Print Page | Close Window

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
Originally posted by dotster dotster wrote:

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 ?


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


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-   &lt;&lt;/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 LOL


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 Thumbs Up

-------------
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 Cry
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



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