Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Error upgrading from 8.03
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error upgrading from 8.03

 Post Reply Post Reply Page  12>
Author
jcnassoc View Drop Down
Newbie
Newbie


Joined: 25 November 2006
Location: United States
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote jcnassoc Quote  Post ReplyReply Direct Link To This Post Topic: Error upgrading from 8.03
    Posted: 27 July 2010 at 5:28pm
Hi all -

First of all let me make clear that I am not a web developer by training and that I've not installed/upgraded a WebWiz forum installation in the past. So, I may be missing something basic or not providing enough information. If that's the case please let me know.

We're currently running WW Forum 8.03 and I am testing the upgrade to 9.69. I wanted to test the upgrade before doing it on our live forum so this is what I did.

  1. Copied the current 'forum' directory to 'forum10' with the goal of performing the WW Forum upgrade on the 'forum10' copy.
  2. As our current forum database (Access) is in a folder off the website's host, I copied it to the 'database' folder inside 'forum10'.
  3. I then followed the upgrade instructions, and all proceeded well until step 12.
  4. In step 12 I received the error shown below.
Since there are many postings here and in the instructions that discuss permissions to the database, I of course looked to see if permissions were set. Our site is hosted by a hosting company, and with their technical support help I went through and verified that the 'database' folder and the Access MDB file's permissions allowed for full access (i.e., read and write) for the IUSR_##### account. I also compared these permissions to those of our current (the WW Forum 8.03) database folder and MDB file, and they are the same.

So, I am sort of stuck here... Can someone suggest how best to troubleshoot this further? If you need more information please do let me know and I will provide as much as I can.

Thanks!

Error Error An Error Occurred Writing the Database Settings File

Please check that you have Read, Write, and Modify Permissions on the Web Wiz Forums 'Database' Directory.

For further information on setting permissions take a look at the following knowledgebase article, Checking and Setting up the Correct Permissions on the IIS Server.


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: 27 July 2010 at 5:42pm
The error means that the IUSR account can not write to the 'database' folder within the forums root folder.

This is most certainly a permissions issue so looks like your host has not setup read, write, and modify permissions correctly on the forums database folder for the account your website is running under.

You would need to go back to your web host and ask them to set the correct permissions.
Back to Top
jcnassoc View Drop Down
Newbie
Newbie


Joined: 25 November 2006
Location: United States
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote jcnassoc Quote  Post ReplyReply Direct Link To This Post Posted: 27 July 2010 at 6:03pm
Hi Bruce.

Thanks for the quick reply.

I just went back in and gave full permissions (read, write, read & execute, and modify) to the three accounts we have on the site. I did this for the 'database' folder, as well as for all the files inside the 'database' folder.

I still get: Please check that you have Read, Write, and Modify Permissions on the Web Wiz Forums 'Database' Directory.

Is it the MDB file that the setup wizard is looking to write to? If so, does it matter that that MDB is a copy of the one from 8.03, or does the setup wizard handle hitting against MDBs from different versions?

I feel as if I am real close... just have get over this hurdle!

Thanks for your help!
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: 28 July 2010 at 8:58am
The setup wizard is trying to write to the configuration files in the database folder, not the database itself at this stage.
Back to Top
jcnassoc View Drop Down
Newbie
Newbie


Joined: 25 November 2006
Location: United States
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote jcnassoc Quote  Post ReplyReply Direct Link To This Post Posted: 30 July 2010 at 12:46am
Ok, I must be missing something. So I have the old WW Forum 8.03 installation still running. It's installed on my web host in WebWiz/forum/, and the database is found in db/ off the root. The new installation (9.69) is found in WebWiz/forum10/, and I copied all of the files that had been in the db/ folder for 8.03 into the database/ folder in forum10/.

When I ran setup for 9.69, I specified database\ as the location for the database, and the Test Connection step is successful. Hitting Next, however, generates the error that started this post.

Based on your replies I've checked both the 8.03's db/ folder and files, as well as those for 9.69's database/ folder. I'm not seeing any problem with permissions... here's what I am seeing.

Old WW Forum 8.03 root\db folder has three users:
  • iUSR_######## - All four permissions are set on (Read, Write, Modify, Read & Execute)
  • Network_services - Read & Execute, and Read are on.
  • ######### - All four permissions are on


The only files in the db/ folder are : wwXXForum.mdb and wwXXforum-backup.mdb; no other files (i.e., anything with settings) is found.


In WW Forum 9.69's database/ folder in forum10

  • All three users have full access (i.e., all four permissions are on)
  • Files in database are: Same two .MDBs as above, plus database_settings.asp and database_connection.asp. All of these files have all four permissions turned on.

I'm hoping the above details will help you help me. From a permissions perspective at both the folder and file level I can't understand why there's be a permissions issue writing to the folder or any of its files as all permissions are turned on.

Any help is greatly appreciated.

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: 30 July 2010 at 1:13pm
You need to have a look in IIS what user or users the website and the application pool for the website are running under. They may well not be running under the IUSR account at all. Then give Read, Write, and Modify permissions to the database folder for those users. Also make sure it propagates down to the files in that folder, including the database_setup.asp file.

You may also want to write click and select properties  on the database_setup.asp file and make sure that the 'Read-Only' attribute has not somehow got checked, preventing the file being written to.
Back to Top
jcnassoc View Drop Down
Newbie
Newbie


Joined: 25 November 2006
Location: United States
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote jcnassoc Quote  Post ReplyReply Direct Link To This Post Posted: 01 August 2010 at 6:47pm

Bruce -


Appreciate your help... this is becoming quite the endeavor, which I thought would not be the case as we already have 8.03 up and running.


Don't know if any of the following will help you help me.


1.) I've forwarded your message to the 1and1 technical support staff... hopefully that helps them help me.


2.) If I end up using the WW hosted forum (basically means I've given up on this), will the existing MS Access forum database we are using be migrated over so we don't lose any postings?

 

3.) Did the permission requirements change between 8.03 and 9.69? Is that why this upgrade is failing?

 

4.)http://www.webwiz.net/webwizforums/kb/moving_access_database.asp has different content for database_connection.asp v. the database_connection.asp I see in the database folder. Are updated instructions available?


Thanks again... I appreciate all of your help.

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: 02 August 2010 at 9:21am
You did not mention 1&1 before. That is wher you have your problem. Web Wiz Forums will not run on 1&1 as they are one of the few Windows web hosts who can not support the software due to the limitations they place on their servers.

The page below lists those few web hosts that do not support the software:-

http://www.webwiz.net/webwizforums/kb/non_supported_webhosts.asp

If you did wish to move your forum to our Forum Hosting service then there is a migration service which includes moving the forum and it's files, upsizing the Access database to SQL Server, checking the database for errors, upgrading to the latest version, and setting up the forum to run on our network.


Edited by WebWiz-Bruce - 02 August 2010 at 1:40pm
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.