Print Page | Close Window

Upgrading from 7.01 to 7.97

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=18585
Printed Date: 13 April 2026 at 1:46am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Upgrading from 7.01 to 7.97
Posted By: Corey Bryant
Subject: Upgrading from 7.01 to 7.97
Date Posted: 03 March 2006 at 5:05pm
I am helping someone out on this upgrade but using his database - when I try to access the Administration side to enter the Web Wiz Key and configure the new functions, it tells me I do not have the correct permissions.
 
I can use the new Web Wiz Database and gain access to the Admin side but of course that won't help too much.  
 
Is there anything extra that has to be done?  I have upgraded sites before - just nothing this far back.   Thanks!


-------------
Corey
http://www.loudcommerce.com - Merchant Accounts



Replies:
Posted By: WebWiz-Bruce
Date Posted: 04 March 2006 at 12:47pm
You been a bit vague on the exact issue so a bit hard to tell, but one thing you should check is that there are 2 common.asp files in version 7.x (there is also one in the admin folder), make sure they both point to the same database.


Posted By: Corey Bryant
Date Posted: 04 March 2006 at 2:11pm
Sorry of course I have updated those.  Are there any fields in the new database that are not in the old database? I guess the reason at being vague is because that is what is happening - it is telling me the Admin does not have the permissions on the new database.  Connectivity does not seem to be a problem

-------------
Corey
http://www.loudcommerce.com - Merchant Accounts


Posted By: Corey Bryant
Date Posted: 04 March 2006 at 2:16pm
The exact message is
Quote Sorry, only members with sufficient permission can access this page


-------------
Corey
http://www.loudcommerce.com - Merchant Accounts


Posted By: WebWiz-Bruce
Date Posted: 04 March 2006 at 2:55pm
If you are using the SQL Server version you will need to update and alter some of the stored procedures, with the Access version just replace the ASP files keeping the original database file.

Version 8 should be out within the next few months for which there will be a 7.x to 8 convertion tool so, it maybe worth waiting till then.


Posted By: Corey Bryant
Date Posted: 04 March 2006 at 2:58pm
No - MS Access is still being used here actually.  I log in via the Admin, and hit the Admin link at the top - it takes me to another login screen wanting my user name / password and then an image.  I enter that and get the above error

-------------
Corey
http://www.loudcommerce.com - Merchant Accounts


Posted By: WebWiz-Bruce
Date Posted: 04 March 2006 at 3:08pm
If you have moved the location of your database make sure you also update the common.asp file in the admin area.

If you have done this, make sure your server is capable of using session variables and session cookies. There are a number of posts on this.


Posted By: Corey Bryant
Date Posted: 04 March 2006 at 3:12pm
Thanks - yes the DB connection is not an issue.
 
I'll move everything over to my server since I was trying to do everything on his site and let you know.  Thanks!


-------------
Corey
http://www.loudcommerce.com - Merchant Accounts


Posted By: Corey Bryant
Date Posted: 04 March 2006 at 3:46pm
Thanks - that was it - hopefully the person who sent me the PM will see this as well :)

-------------
Corey
http://www.loudcommerce.com - Merchant Accounts


Posted By: jacksonian
Date Posted: 09 March 2006 at 4:07am
This is what the server says about cookies,

HTTP_COOKIE: ASPSESSIONIDCQTBRTRS=HBBKINBDEJKLBNMBKCCNNKBH

Is this OK for version 7+


Posted By: WebWiz-Bruce
Date Posted: 09 March 2006 at 1:26pm
Not sure what you are asking.

The cookie you have there is an ASP Session ID cookie that all IIS servers with ASP enable set on a user browser.


Posted By: Corey Bryant
Date Posted: 09 March 2006 at 1:51pm
Well I can get the forum to work on my server - no problems.  But on Jacksonian's server, I get that error message that I pointed out.

-------------
Corey
http://www.loudcommerce.com - Merchant Accounts


Posted By: WebWiz-Bruce
Date Posted: 09 March 2006 at 2:11pm
Is it just for the admin area login?

If so it sounds like an issue with the server keeping hold of the ASP session.

Windows 2003 server does have several settings and issues that need to be addressed so that the server holds the ASP session.

Make sure that you are running the latest patches and Service Packs on the server. Also make sure that the app pool is setup to not recycle to often (once every 24 hours should be enough), and make sure that app pool is not set to use a Web Garden.


Posted By: Corey Bryant
Date Posted: 09 March 2006 at 2:17pm
Yes as far as I can tell - it is just for the admin area. 

-------------
Corey
http://www.loudcommerce.com - Merchant Accounts


Posted By: WebWiz-Bruce
Date Posted: 09 March 2006 at 3:13pm
You need to get the forum admin to look into the things I suggested in my last post.

However, if you can wait a few more weeks for version 8 to be released it has a new login system that uses a proprietary session handling system that I have designed to not use cookies. It can also be setup to use application variables for more performance or use the database for those servers that can not work with application and session variables, such as load balanced web servers or app pools using web gardens.



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