upgrading from 8.03 to 8.05a
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=23232
Printed Date: 07 April 2026 at 6:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: upgrading from 8.03 to 8.05a
Posted By: johnnyjcorp
Subject: upgrading from 8.03 to 8.05a
Date Posted: 01 May 2007 at 6:57pm
|
I have a quick question. I'm upgrading from 8.03 to 8.05a (SQL SERVER), but I have made a few changes to some of the original source code. I have a log of all of the changes that I have made to the original source code. I was wondering the easiest way to upgrade? I have compared the Version History for the files listed that have been updated since 8.03 and I've only changed two of the files listed in Version History.txt. Should I just copy over the 27 files or so listed in the Version History and then reapply the changes that I made to the two files that I had modified that are listed in Version History?Or do I need to do a complete install/upgrade and then reapply all of the changes that I made to a all of the files that I have modified?
The previous option would be nice and work if the only upgrades since 8.03 are just the ones listed in Version History. (and no upgrades to the SQL Server at all).
Thanks!
JohnnyJ
|
Replies:
Posted By: javi712
Date Posted: 01 May 2007 at 7:40pm
| There were no DB changes between 8.03 and 8.05a. Just replacing the modified files should be sufficient. |
Posted By: johnnyjcorp
Date Posted: 01 May 2007 at 9:12pm
Are you sure? If I try to modify the Member API to pass in the email address I get an error on the following code:
==========
'Save the new usercode back to the database and the password incase it has been changed
rsCommon.Fields("User_code") = strNewUserCode rsCommon.Fields("Password") = strPassword rsCommon.Fields("Salt") = strSalt If strEmail <> "" Then rsCommon.Fields("Email") = strEmail rsCommon.Update 'If an error has occured write an error to the page
If Err.Number <> 0 Then Call errorMsg("An error has occured while writing to the database.", "existingMemberAPI()_update_pass", "functions_member_API.asp") ========== So it seems like it can't find the Email field in the database?
Thanks!
JohnnyJ
|
javi712 wrote:Posted By: johnnyjcorp
Date Posted: 02 May 2007 at 4:31pm
|
It seems that perhaps an Email field was added to the database, and that is why I'm getting an error when the recordset tries to call the Email field. Please let me know which table and what field type and length I should add it to, along with any other database changes. Thanks! JohnnyJ |
Posted By: WebWiz-Bruce
Date Posted: 02 May 2007 at 5:50pm
|
There is a mistake in the file, change 'Email' to 'Author_email' eg:- If strEmail <> "" Then rsCommon.Fields("Author_email") = strEmail ------------- 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: johnnyjcorp
Date Posted: 10 May 2007 at 11:45pm
| That fixed it. Thanks! |