Upgrading from 7.9 to current version
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=27170
Printed Date: 02 April 2026 at 8:34pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrading from 7.9 to current version
Posted By: keikokate
Subject: Upgrading from 7.9 to current version
Date Posted: 25 March 2009 at 9:00am
I'm running forum version 7.9, however recently I'm getting about 10-15 pages of spam a day.
I would like to keep the current forum as it is, since it can be quite popular but I can't find a quick way to remove all of these spam messages and accounts being registered...
Whats the easiest way for me to upgrade without touching the database or the styling?
Thanks
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 25 March 2009 at 9:17am
Version 7.9 is about 5 or 6 years old and allot has changed since then.
You need to download the latest version and run the database upgrade tool on the database to upgrade it to the latest version 9.x database. You then replace all the files and images with those form the latest release. Full instructions are with the database upgrade tool.
The best way to stop spam in the latest release is to have email activation enabled for new accounts and not to allow guest posting, this greatly reduces spam posting.
You can even go as far as having it so that new signups need their posts approving by an admin or moderator before they are displayed live in your forum.
-------------
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: keikokate
Date Posted: 25 March 2009 at 1:57pm
|
I'm trying to upgrade the database but keep getting path errors, would I use a web path to the database?
|
Posted By: WebWiz-Bruce
Date Posted: 25 March 2009 at 2:00pm
I take it you are trying to update an Access database then?
If so you need to upload the database upgrade tool to the server that the Access database is on, then use the physical server path to the Access database (not the web URL).
If you want to make things really simple just place the Access database and the upgrade tool in the same folder on your website, all you need to do then is enter the Access database file name and not worry about the path.
-------------
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: keikokate
Date Posted: 25 March 2009 at 4:00pm
I was ideally wanting to upload version 9 files under a different folder and re upload the database there, but it keeps giving a file name error on the database connection file even though the database + databaseconnection file are in same folder.
|
Posted By: 123Simples
Date Posted: 25 March 2009 at 4:09pm
Database connection issues are usually hard to track down sometimes
Ok so you have an old version 7.9 running on Access? Yes or No?
Is your original forum still working?
If so, then you should have a folder called database, and inside that folder a file called database_connection.asp
Somewhere in that original file it should tell you your settings to the original access database
Example:
'******************************************
'*** Microsoft Access ****
'******************************************
If strDatabaseType = "Access" Then
'Microsoft Access is a flat file database system, it suffers from slow performance, limited
'connections, and as a flat file it can be easly downloaded by a hacker if you do not secure
'the database file
'Virtual path to database
strDbPathAndName = Server.MapPath("database/wwForum.mdb") 'This is the path of the database from the applications location
'Physical path to database
'strDbPathAndName = "" 'Use this if you use the physical server path, eg:- C:\Inetpub\private\wwForum.mdb
'PLEASE NOTE: - For extra security it is highly recommended you change the name of the database, wwForum.mdb,
'to another name and then replace the wwForum.mdb found above with the name you changed the forum database to.
'Initilise the DB Connection String
strCon = strDbPathAndName
End If
Now sorry if this sounds a bit obvious, but I assume you have changed the permissions on your server to read and write the database? Otherwise you will have errors
-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design
|
Posted By: keikokate
Date Posted: 25 March 2009 at 9:49pm
Thanks,
I've tried to copy the database from the original working forum and uploading that with the new v9 forum files under a different folder so i can leave the original running... I think from above the issue is with the database and that it needs to be updated?
Is there any other way I could go about this, like converting the access db to MySQL?
|
Posted By: WebWiz-Bruce
Date Posted: 26 March 2009 at 7:42am
A version 7 database will not work with a version 9 forum. The database has to be updated to work with version 9 using the database upgrade tools. The database upgrade tools come with intructions on how to use them you should read these carefully, if you do you should have no problems updating your Access database to version 9.x
Although you can not migrate an Access database to mySQL it is possible to upsize the database from Access to SQL Server. However this can be quite a complex task and often take our enginners who do this 2 or 3 times a week serveral hours to do.
-------------
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: keikokate
Date Posted: 26 March 2009 at 1:22pm
Thanks I have it up and running now :) Is there an easy way to use the styling from my version 7 forum?
I've got most of it over but quick search panel is causing m,e problems and i can't seem to find where to remove it
|
Posted By: 123Simples
Date Posted: 26 March 2009 at 1:30pm
By styling do you mean images? The problems that you will notice (not that I personally see any problems with the latest versions) is actually version 7 uses different images and the css styles are old compared to the latest version files
I'm afraid there is no shortcut - its a case of working through those files and trying your best to keep the layouts as close as possible to what you had
-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design
|
Posted By: keikokate
Date Posted: 26 March 2009 at 3:05pm
|
Thanks, yeah I've got the width etc but I'm trying to remove the quick search panel since it seems to sit outside of the forum table I created... is there a simple way to turn this off or is it a case of going through each individual file and removing the include file for that search?
|
Posted By: WebWiz-Bruce
Date Posted: 26 March 2009 at 3:09pm
There is not a way t remove the search drop down, if you removed it you would loose the search from your forum.
If the search drop down is in the wrong position then I would image lots more would be also. You should go back instead and look how you are creating the table the forum sits in as there most be an issue with that which is coursing the problem.
-------------
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
|
|