Question about the latest WWF release
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=27562
Printed Date: 02 April 2026 at 2:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Question about the latest WWF release
Posted By: iSec
Subject: Question about the latest WWF release
Date Posted: 11 July 2009 at 2:33pm
|
Thanks for this release... I was about to test it on my site but I'm a bit confused. Have the 3 editions of WebWiz Forums (SQL, MySQL, & Access) been combined into one download, or am I missing something?!
|
Replies:
Posted By: Scotty32
Date Posted: 11 July 2009 at 6:48pm
|
I believe they have all been merged into one as there is now a new Setup system which I believe you select your database in. If you are upgrading then you would be using your existing database_connection.asp file as so all database settings would be preserved. ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
Posted By: Nick-V
Date Posted: 11 July 2009 at 7:33pm
|
It does appear there is only one WWF download now and that it now provides an upgrade facility in which you specify your type of database (Access MySQL, MSSQL) and the previous forum (database) version. Consequently, the existing database_connection.asp file is not used (manually). Instead, the upgrade program asks for your connection info and enters it appropriately for you. |
Posted By: iSec
Date Posted: 11 July 2009 at 11:29pm
|
Interesting.. Thanks guys... I tried using the existing database connection files and also modified the other file with the database connection parameters, etc. for my MS-SQL database. Now I'm getting this error:
Server Error in Forum Application
An error has occurred while executing SQL query on database. Please contact the forum administrator. Support Error Code:- err_SQLServer_UnreadPosts() File Name:- functions_common.asp Error details:- Microsoft OLE DB Provider for SQL Server Invalid object name 'Topic'. Was I supposed to run the wizard first? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: Scotty32
Date Posted: 12 July 2009 at 10:00am
Sorry, appears I was wrong, I haven't had chance to upgrade my forums yet so wasnt sure how to upgrade exactly - just assumed it was the same as previous versions. From the above I would imagine that you keep the forums database_connection.asp file and edit the database_settings.asp file. Though maybe somebody who has already upgraded could post the process for you? ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
24. database/database_connection.asp - file changed to support new online setupPosted By: Nick-V
Date Posted: 12 July 2009 at 11:56am
| Don't edit anything. Just run the upgrade facility...install the new pages and go to the forum and it starts automatically (probably due to lack of database info). |
Posted By: Nick-V
Date Posted: 12 July 2009 at 12:16pm
|
Its all well documented under "Upgrade Documentation" at http://www.webwiz.net/webwizforums/kb/default.asp" rel="nofollow - http://www.webwiz.net/webwizforums/kb/default.asp |
Posted By: iSec
Date Posted: 12 July 2009 at 4:55pm
|
Ok it works now... thanks again guys. However, I noticed that the upgrade wizard will NOT run unless the IUSER account has write/modify permission to the 'database' folder. I understand why this would be required for a forum that uses MS Access, but I'm using MS-SQL... why is this required? Can someone explain this please? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: Scotty32
Date Posted: 12 July 2009 at 5:20pm
|
I suspect it would be required for MSSQL and MySQL to write the settings to the config files.
------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
Posted By: 123Simples
Date Posted: 12 July 2009 at 6:36pm
Hi iSec I had no issues like you described when I ran the update on one of our test forums I downloaded the files, unzipped and then uploaded all of them into the forum directory, ran the wizard page and filled in the info - I use SQL Server (not access) so I did not change any permissions anywhere It worked with no problems and no issues. The permissions only need to be set as you correctly say if you are using Access and provided you popped a dot in either of the other two options, SQL or mySQL, then there should not have been any problems Hope that helps ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Nick-V
Date Posted: 12 July 2009 at 6:42pm
|
I believe that write and modify permissions need to be set to the \forum\database folder so that IUSER can write the database setup details entered in the wizard to the asp connection file. The database used is irrelevant. If write and modify permissions already existed for IUSER to that folder then check your other folders as your setup may be insecure. |
Posted By: 123Simples
Date Posted: 12 July 2009 at 6:56pm
|
Thanks Nick - but the permissions on that folder are normal. You would only need IUSER permissions if you were using the access database within that folder itself, otherwise the folder remains locked as such I'm pretty certain (well almost  ) that the setup files run from the main forum folder and providing write and read modifications are set correctly depending on the database being used) then there should be no issues. I suppose if I get time I will try a access install and not set the permissions correctly on the database - in theory this would then produce an errorAs I said, I was actually connecting to a SQL database and so when I entered the connection details, I was already connecting to an existing database ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Nick-V
Date Posted: 12 July 2009 at 8:14pm
|
I use MS SQL - no access database. I am quite certain that IUSER had read-only permissions to the \database folder and therefore the upgrade wizard failed as it could not write the database info to the asp files therein. I provided write/modify permissions and it worked. Read permissions for IUSER is the default (not write/modify) and recommended setting for all other folders to prevent hacking. The WWF instructions tell you to change permissions: "5. The forums database folder located at forum/database needs to have read, write, and modify permissions set on it. Check with your web host that you have these permissions set, or if running the server yourself have a look at Setting Read, Write, and Modify Permissions." |
Posted By: Nick-V
Date Posted: 12 July 2009 at 8:27pm
|
For simplicity, let's just say that following the documented upgrade instructions works fine. Again, they are at http://www.webwiz.net/webwizforums/kb/default.asp" rel="nofollow - http://www.webwiz.net/webwizforums/kb/default.asp . Bruce, as a result of this discussion I have just set IUSER permissions for \database back to read-only as I believe they only need to be write/modify for the upgrade wizard to function at upgrade time. Can you please confirm this (all works fine here) and indeed consider if this action should actually be recommended for security reasons (MS SQL and MySQL not Access). I suspect any Access database should actually be elsewhere to be safe. |
Posted By: iSec
Date Posted: 12 July 2009 at 8:59pm
|
Yes... the wizard fails if write/modify permissions aren't set for the database folder (the wizard actually says that when it errors out).
The suggestions you guys posted all make sense, but how come this was not mentioned anywhere in the release announcement or in a separate topic?!
I hope that Bruce will clarify these questions, including the one mentioned by Nick-V, that the write/modify permissions be removed after completing the update wizard. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 14 July 2009 at 9:50am
|
Yes read and write permissions are needed on the forums database folder when you run the wizard after it is complete you can put it back to read only. If I tell you how the update wizard works then it may make more sense. Rather than having to manually edit the database connection file in notepad and save and upload it the setup wizard now writes the settings for you to the database/database_settings.asp file. ------------- 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: iSec
Date Posted: 14 July 2009 at 11:42am
|
Bruce, Thanks... and yes, I agree that making the wizard take care of updating those files is the proper way of doing business. I'm removing the write/modifying permissions from the database folder now!  ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |