Error upgrading from 8.03
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=28745
Printed Date: 01 April 2026 at 8:50pm Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error upgrading from 8.03
Posted By: jcnassoc
Subject: Error upgrading from 8.03
Date 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.
- Copied the current 'forum' directory to 'forum10' with the goal of performing the WW Forum upgrade on the 'forum10' copy.
- As our current forum database (Access) is in a folder off the website's host, I copied it to the 'database' folder inside 'forum10'.
- I then followed the upgrade instructions, and all proceeded well until step 12.
- 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
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, http://www.webwiz.net/kb/asp_knowledgebase/server_permissions.asp" rel="nofollow - Checking and Setting up the Correct Permissions on the IIS Server .
|
Replies:
Posted By: WebWiz-Bruce
Date 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.
------------- 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: jcnassoc
Date 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!
|
Posted By: WebWiz-Bruce
Date 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.
------------- 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: jcnassoc
Date 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.
|
Posted By: WebWiz-Bruce
Date 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.
------------- 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: jcnassoc
Date 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" rel="nofollow - 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.
|
Posted By: WebWiz-Bruce
Date 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://%20www.webwiz.net/webwizforums/kb/non_supported_webhosts.asp" rel="nofollow - http://www.webwiz.net/webwizforums/kb/non_supported_webhosts.asp" rel="nofollow - 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.
------------- 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: jcnassoc
Date Posted: 02 August 2010 at 1:06pm
Bruce -
Thanks again for the reply.
1.) I had seen that short list of unsupported hosting companies, but based on the content I thought that 1&1 would not work only for the Premium edition of WW Forum (which is why I hadn't brought up 1&1 earlier... sorry).
From that page you referenced:
1&1
Do not support the Premium Edition of Web Wiz NewsPad.
I can say that we have had the free edition up and running for years (8.03) with no major issues on 1&1... So not sure if this is the end of the road or not. Confirmation from you would be helpful.
2.) Thanks for the info on how we would potentially migrate to one of your servers. If you can throw me a link (if one exists) that walks me through the process I can start to consider that if it turns out all of the WW forums cannot be run on 1and1 hosts.
Thanks!!!
|
Posted By: WebWiz-Bruce
Date Posted: 02 August 2010 at 1:45pm
I think you are looking at the wrong page as it is web wiz forums you are using not web wiz newspad.
1&1 are probably the worse web host you could find, a quick search on the web will show this. If you want a very basic website then they should be fine but for anything else best of keeping away.
I also read a white paper by them on how they are being green and it said in it that they have up to 10,000 websites per server! That is an incredible amount and probably the reason why they are so cheap and only host smaller more basic websites.
If you wanted to migrate your forum to our services then you just need to signup through the pages below, you would then be contacted to discuss a migration plan that would be custom to your specific needs:-
http://www.webwiz.net/forum-hosting/" rel="nofollow - http://www.webwiz.net/forum-hosting/
------------- 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: 123Simples
Date Posted: 02 August 2010 at 7:44pm
Hi jcnassoc
I'd recommend that you do consider swapping hosts - for me personally and I know others too, it was the best decision they made changing over to Web Wiz. 1&1 did me no favours and I guess that most people start with them because they do have a fair share of the market. However, that does not make them better! Have a chat with Bruce via Support.
I know for sure that if you plan on running Premium edition it will work out better for you to shift hosting anyway
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design
|
|