Convertor Script for upgrading from 7.x to 8 beta1
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=17964
Printed Date: 30 March 2026 at 12:24am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Convertor Script for upgrading from 7.x to 8 beta1
Posted By: Cem Alacayir
Subject: Convertor Script for upgrading from 7.x to 8 beta1
Date Posted: 15 January 2006 at 8:44am
|
I wrote a ASP script (updateDB.asp) for upgrading Access database from version 7.x to version 8 beta1. I have not tested with SQL Server or other versions, I think it will probably fail with them. You can download the script from http://www.gleamtech.com/download/updateDB.zip - here
Update procedure: 1. Install version 8 beta1 package and test if it works ok with the default db.
2. Put your old 7.x mdb file in the forum8\database folder. Make sure you have a backup copy of your old database before proceeding.
3. Open forum8\includes\database_configuration.asp and edit the variable strDbPathAndName to refer to the 7.x mdb file.
4. Put updateDB.asp file in the root of your forum folder (forum8\updateDB.asp).
5. Run forum8\updateDB.asp , the script will change the structure of the db and insert some required data.
6. After the script finishes, you will have a working v8 forum.
7. Probably you won't be able to see the forum titles on the main page especially as a guest. This is because the permissions system is changed.
You will need to examine and set group permissions on the forum administration area manually.
I have upgraded my v7.96 database successfully, hope it works for you too.
|
Replies:
Posted By: superlative
Date Posted: 15 January 2006 at 9:25am
Good job. I tested it works. I will referer my http://forums.webwiz.net/forum_posts.asp?TID=17957 - [Pre-Upgrade Works] My implement & explain how to topic to this topic.
But some small problems. New forum permissions not apply old db. You must set manually forum permissions. After run this script, i can not see forums in the main forum page. For mor information check above link. ------------- http://www.knowhow.gen.tr" rel="nofollow"> 
|
Posted By: mass
Date Posted: 15 January 2006 at 12:26pm
good Jop  I well test today
|
Posted By: Silvereye
Date Posted: 15 January 2006 at 6:03pm
|
I followed your instructions but i couldn´t make it work. When trying to access a forum i get this message:
Great job anyway! Makes things alot easyer with a script like this. ------------- Webmaster @ www.streetcars.se - www.streetcars.se |
Microsoft JET Database Engine (0x80040E07)Posted By: graper
Date Posted: 16 January 2006 at 12:17am
GOOD I well test today  ------------- WWF论坛讨论QQ群:2652358 WWF论坛讨论: Http://Www.CNWWF.Com/Forum/ - Http://Www.CNWWF.Com/Forum/ |
Posted By: vassabi
Date Posted: 16 January 2006 at 7:44am
| It upgraded successfuly but doesn't show any forum on the main page, in admin area it shows wverything ok but not in forum main page. |
Posted By: vassabi
Date Posted: 16 January 2006 at 8:01am
|
I got this error when posting new message after converting The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. /norq.net/forum/new_post.asp, line 824 |
Posted By: superlative
Date Posted: 16 January 2006 at 9:09am
Check it my above message ^ ------------- http://www.knowhow.gen.tr" rel="nofollow">
|
Posted By: Cem Alacayir
Date Posted: 16 January 2006 at 10:54am
|
Superlative, ok I updated the instructions in my first post to mention the permissions issue.
Silvereye, I guess the error is about date format. You may try setting the variable Session.LCID to your local id at the beginning of the code (commented out) in common.asp file.
vassabi, do you get that error every time you try to post a new message?
What was your old database version, maybe it's an earlier 7.x version and it has a slightly different db structure.
|
Posted By: cenkilic
Date Posted: 16 January 2006 at 4:57pm
|
thanks a lot i was looking for that
but do you have a script to make RTE work in freehosts??
|
Posted By: WebWiz-Bruce
Date Posted: 16 January 2006 at 5:22pm
|
The RTE will not work with free web hosts and is disabled in the 7.x Lite version.
------------- 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: megetron
Date Posted: 16 January 2006 at 8:44pm
|
nice but doesn't working:
Updating Web Wiz Forums database from version 7.x to version 8 beta 1...
Please wait... -> Changing table tblForum... Added fields. -> Changing table tblTopic... Added fields. -> Changing table tblThread... Added fields. -> Changing table tblPermissions... Added fields. Renamed a field. -> Changing table tblAuthor... Added fields. -> Changing table tblConfiguration... Added fields. -> Changing table tblDateTimeFormat... Added fields. -> Creating table tblPollVote... Done. -> Re-synchronizing forums... Microsoft JET Database Engine error '80004005'Unrecognized database format 'c:\inetpub\wwwroot\gvion\forum\database\wwForum.mdb'. /gvion/forum/functions/functions_common.asp, line 641 |
Posted By: javi712
Date Posted: 17 January 2006 at 1:42am
|
Hi Guys. I have a quick question. Borg mentioned that there will still be database changes to the final release of 8.0. Will there be another upgrade script available from beta to final release?
Thanks in advance! |
Posted By: WebWiz-Bruce
Date Posted: 17 January 2006 at 10:33am
|
Beta versions are for testing purposes ONLY, as they are no complete and NOT stable, and should not be used on a production server, which is why there is no official upgrade application yet. Once the full version is released I will make available an official 7.x to 8.x upgrade tool, but there will be no official upgrade tool between beta versions. If you go down this path now, and use a beta version on a production server with your 7.x database converted to 8.x, you may not be able to upgrade to the full version when it is released. ------------- 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: Ozan
Date Posted: 21 January 2006 at 1:09pm
Hata Tipi:
Microsoft JET Database Engine (0x80040E07) 'tblThread.Author_ID=tblAuthor.Author_ID AND LastThread.Author_ID=LastAuthor.Author_ID AND tblTopic.Start_Thread_ID=tblThread.Thread_ID AND tblTopic.Last_Thread_ID=LastThread.Thread_ID AND (tblTopic.Forum_ID=47 OR (tblTopic.Priority=3) OR (tblTopic.Moved_I' sorgu ifadesi içindeki Tarihte sözdizimi hatası /forum8/forum_topics.asp, line 371  help |
Posted By: Mikero
Date Posted: 29 January 2006 at 4:09pm
Ok, I moved a copy of my forum to a test site and updated from v7.97 to v8 beta using the script that Cem Alacayir supplied (Thank You Cem Alacayir). Now I would like to go from v8 access to v8 mysql. Does anyone have a script to move the data from v8 access to v8 mysql? Thank You,µ
|
Posted By: superlative
Date Posted: 30 January 2006 at 7:22pm
|
Mikero, you and me in the same state. I am waiting final version of WWF 8. Because software development still continue. When Borg publish final version I upgrade my forum to V8 access then to v8 final SQL version. I can help you while upgrade access to sql. You must wait for the stabile version. ------------- http://www.knowhow.gen.tr" rel="nofollow">
|
Posted By: Bedirhan
Date Posted: 03 February 2006 at 6:04pm
|
can we convert to 8,0 to 7.x ?? help me please |
Posted By: ishfaq
Date Posted: 25 May 2006 at 8:14pm
| The download link is not working. Can someone post a new link please. |