Upgrade from 7.5 to Latest Stable Version

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rjcarter Members Profile Find Members Posts Newbie Joined: 27 June 2011 Status: Offline Points: 14	Post Options Post Reply Quote rjcarter Report Post Thanks(0) Quote Reply Topic: Upgrade from 7.5 to Latest Stable Version Posted: 27 June 2011 at 9:11pm
	Is this possible? I did pay for my version and would that license extend to the new version?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 28 June 2011 at 10:22am
	To upgrade just download the latest release and follow the Upgrade Instructions which will guide you through the upgrade from Web Wiz Forums 7.x to the latest version. Generally licenses include minor version upgrades for the life or the product (eg. 9.1 to 9.2) and include 1 year upgrade protection to new major version releases (eg. 9.x to 10.x).
	Web Wiz Forums Hosting ASP.NET Web Hosting

rjcarter Members Profile Find Members Posts Newbie Joined: 27 June 2011 Status: Offline Points: 14	Post Options Post Reply Quote rjcarter Report Post Thanks(0) Quote Reply Posted: 28 June 2011 at 4:12pm
	Thanks for the info. I have downloaded the latest version and I am running an upgrade test. I was able to run through the upgrade script. When I went to the home page of my forum. It appears that all my data migrated successfully. Great Job, so painless, for being so many versions back. However, when I try to login with my Admin Account it is giving a wrong password error. I have tried other accounts and get the same problem. In addition, I cannot send email to reset the password. Any suggestions here?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 28 June 2011 at 4:28pm
	This is very strange as the login data is stored in the same way. I suspect that it maybe the page encoding which now uses UTF-8. If you are using version 9.x then open the includes/setup_options_inc.asp file in notepad and change the page encoding form UTF-8 to iso-8859-1, which was the default for version 7.x. The page below tells you how to reset the admin password in the database, which may help if you are running version 10 and need to get in to the admin area to change the page encoding:- Web Wiz Forums Admin Account Login / Password Reset
	Web Wiz Forums Hosting ASP.NET Web Hosting

rjcarter Members Profile Find Members Posts Newbie Joined: 27 June 2011 Status: Offline Points: 14	Post Options Post Reply Quote rjcarter Report Post Thanks(0) Quote Reply Posted: 29 June 2011 at 4:25pm
	Here's my environment. Windows 2003 SQL Server Express 2005 Web Wiz Forums 10 How I am testing my upgrade. Backed up current database. Restored backup database into a new Test Database Installed WWF10 in a new application on IIS Ran setup to upgrade database from 7.x to 10.x Existing users cannot login to the WWF10 test application without requesting a password reset email. I have tried changing the page encoding from UTF-8 to Western-iso-8859-1. This did not seem to solve the problem. After I changed the page encoding I bounced the server.

rjcarter Members Profile Find Members Posts Newbie Joined: 27 June 2011 Status: Offline Points: 14	Post Options Post Reply Quote rjcarter Report Post Thanks(0) Quote Reply Posted: 29 June 2011 at 5:29pm
	Databases: PROD - 7.x database TEST - 10.x (upgraded from 7.x) Websites: PROD Website physical directory, c:\forums IIS website as virtual host, prod.example.com TEST Website physical directory, c:\forums_test IIS Website as virtual host, test.example.com This is what I did. I backed-up the PROD database to a .bak file. I created the Empty TEST database I restored the Empty TEST database with the .bak file from the PROD backup. Opened a browser to http://test.example.com and ran the upgrade wizard to upgrade the TEST 7.x database to 10.x database. Users could not login until they requested a password reset email. I did notice in the tblAuthor that the column User_code was different from the prod 7.x database after the upgrade. I tried updating this column to match the PROD 7.x database, but it did not solve the problem. I did not use the import/export tools. Everything I did was from the SQL Express Server Management GUI.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 29 June 2011 at 5:36pm
	The User_code field does not affect login. The fields used for login are Username, Password, and Salt. The Password field should be 160bit encrypted unless you disabled the password encryption, if you did then the passwords would be in plain text and may explain why your members can not login. If your passwords are in plain text you would need to edit the includes/setup_options_inc.asp file and disable password encryption.
	Web Wiz Forums Hosting ASP.NET Web Hosting

rjcarter Members Profile Find Members Posts Newbie Joined: 27 June 2011 Status: Offline Points: 14	Post Options Post Reply Quote rjcarter Report Post Thanks(0) Quote Reply Posted: 29 June 2011 at 7:55pm
	I have verified that the Username, password and salt are the same in both databases. I looked at the includes/setup_options_inc.aps I have not changed because my passwords where already encrypted. After some investigation in the I believe there something has changed in the login form or register.asp functions. I edited the functionshash1way.asp file so I would have a constant salt value. I went to my old system and updated the password of two accounts to make sure they generated the same encrypted password. Check. I went to the new system change the functionshash1way.asp file to have a constant salt value. I went in the new system and ATTEMPTED to update the passwords of two accounts to make sure they generated the same encrypted password. Check. Another thing I did notice. Passwords in the 7.x system are NOT case sensitive. Passwords in the 10.x system ARE case sensitive. Maybe this is why the encrypted passwords are not validating until you reset them. Based on your comments of the code not changing in the functionshash1way.asp file. I verified this via a diff function. And my above observations, I don't know where else to investigate. We would like to upgrade to this version, but this issue is a show stopper for us. I don't want my users to have to request a new password to login after we upgrade. I hope I have provided you with enough information to see if you can fix this problem in a future release. Until then I don't think we can upgrade at this time.

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum