Print Page | Close Window

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

There were no DB changes between 8.03 and 8.05a. Just replacing the modified files should be sufficient.
 
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


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!



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