| Author |
 Topic Search  Topic Options
|
keikokate 
Newbie
Joined: 25 March 2009
Status: Offline
Points: 7
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Upgrading from 7.9 to current version
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
keikokate
Newbie
Joined: 25 March 2009
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
keikokate
Newbie
Joined: 25 March 2009
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
keikokate
Newbie
Joined: 25 March 2009
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
