Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Edit Profile Error (9.52 upgrade)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Edit Profile Error (9.52 upgrade)
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
dotster View Drop Down
Newbie
Newbie


Joined: 03 October 2008
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dotster Quote  Post ReplyReply Direct Link To This Post Topic: Edit Profile Error (9.52 upgrade)
    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

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


Edited by dotster - 03 October 2008 at 5:41pm
Back to Top
dotster View Drop Down
Newbie
Newbie


Joined: 03 October 2008
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dotster Quote  Post ReplyReply Direct Link To This Post Posted: 03 October 2008 at 5:33pm
I see another fellow using MSACCESS is having a similar issue with the same line of code
Back to Top
dotster View Drop Down
Newbie
Newbie


Joined: 03 October 2008
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dotster Quote  Post ReplyReply Direct Link To This Post 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 ?


Edited by dotster - 03 October 2008 at 5:53pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
dotster View Drop Down
Newbie
Newbie


Joined: 03 October 2008
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dotster Quote  Post ReplyReply Direct Link To This Post Posted: 03 October 2008 at 5:53pm
See above.. for that info
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
dotster View Drop Down
Newbie
Newbie


Joined: 03 October 2008
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dotster Quote  Post ReplyReply Direct Link To This Post 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.


Edited by dotster - 03 October 2008 at 6:12pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.