Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Upgrading from 7.01 to 7.97
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upgrading from 7.01 to 7.97
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Corey Bryant View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Status: Offline
Points: 18 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Corey Bryant Quote  Post ReplyReply Direct Link To This Post Topic: Upgrading from 7.01 to 7.97
    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!
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: 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.
Back to Top
Corey Bryant View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Status: Offline
Points: 18 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Corey Bryant Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Corey Bryant View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Status: Offline
Points: 18 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Corey Bryant Quote  Post ReplyReply Direct Link To This Post Posted: 04 March 2006 at 2:16pm
The exact message is
Quote Sorry, only members with sufficient permission can access this page
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: 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.
Back to Top
Corey Bryant View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Status: Offline
Points: 18 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Corey Bryant Quote  Post ReplyReply Direct Link To This Post 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
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: 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.
Back to Top
Corey Bryant View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Status: Offline
Points: 18 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Corey Bryant Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
 Post Reply Post Reply Page  12>

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.