Official Web Wiz Forums v7.x to v8.x Upgr
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=18817
Printed Date: 30 March 2026 at 3:53am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Official Web Wiz Forums v7.x to v8.x Upgr
Posted By: WebWiz-Bruce
Subject: Official Web Wiz Forums v7.x to v8.x Upgr
Date Posted: 21 March 2006 at 9:59am
|
The following tools allow you to update your version 7.x Web Wiz Forums database to the new version 8 database. Please Note:- Use these upgrade tools at your own risk, and make sure you backup your database first. http://download.webwiz.net/web_wiz_forums_SQL_Server_7_to_8_update.zip - Full version upgrade tools are now located on the Web Wiz Forums download page. Please Note:- If you have modified your version 7.x database yourself you may need to un-modify the database inorder for this update to work. |
Replies:
Posted By: Mikey
Date Posted: 21 March 2006 at 10:12am
Links are back to front 
------------- Handyman man? |
Posted By: WebWiz-Bruce
Date Posted: 21 March 2006 at 10:22am
Ops 
|
Posted By: Adrina
Date Posted: 21 March 2006 at 11:53am
| Is it possible to Convert a Ms Access Db (from version 7.x) to a MySQL Db (version 8)? |
Posted By: WebWiz-Bruce
Date Posted: 21 March 2006 at 12:07pm
|
There isn't a tool to do this, but MS Access has an Upsize Tool for moving databases from Access to SQL Server. It is a bit hit and miss, so you just have to try different ways of using the tool till you find one that works for you. |
Posted By: VBScript
Date Posted: 21 March 2006 at 3:35pm
|
Adrina, You can always upgrade your access database from 7.9x to 8 and use my tool to http://forums.webwiz.net/forum_posts.asp?TID=18490&PID=100978#100978 - convert from access to mysql ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: xjmajor
Date Posted: 21 March 2006 at 5:16pm
|
Hi Borg, thanks for your wonderful work. There is a little problem after converting Access DB from 7.92 to 8: e-mail address in profile view is shown: mailto:ldangel2%40ford%2Ecom - myname%40mydomain%2Ecom and not myname@mydomain.com I don't know if it is an issue about RC1 or conversion tool. Thank you again for all. Damiano |
Posted By: javi712
Date Posted: 21 March 2006 at 5:26pm
Hi VBScript, would you happen to have an access to SQL conversion script also? Thanks in advance! |
VBScript wrote:Posted By: xjmajor
Date Posted: 21 March 2006 at 6:32pm
|
Another issue: On my forum I have a non ladder group, named "staff", flagged as moderator group in all forums. The members of this group, after conversion, are not able to view edit, hide and delete buttons in all messages. On 7.92 all is ok. |
Posted By: WebWiz-Bruce
Date Posted: 21 March 2006 at 6:49pm
|
Permissions may need to be reset after the update. It does say this while updating, but I guess I need to make it more obvious A new permissions engine is used on version 8 and permissions will not carry over, so default permissions are set for everyone. |
Posted By: VBScript
Date Posted: 21 March 2006 at 6:56pm
|
javi712 I am afraid I do not have an access to MSSQL application. I tried for several days to research MSSQL databases and how to convert it but I am afraid I did not get very far. Sorry about that, if I find anything I will let you know ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: xjmajor
Date Posted: 21 March 2006 at 7:18pm
|
Ok, my fault, I didn't read... I don't understand why after conversion I see the permission table reflecting the permissions before conversion. I tried to remove moderation rights to the "staff" group, and apply again, but it doesn't work. How can I reset all permissions and apply again? Thanks a lot |
Posted By: javi712
Date Posted: 21 March 2006 at 7:25pm
|
Please do let me know if you do! Thank you very much anyways VBScript... much appreciated!
|
Posted By: iSec
Date Posted: 25 March 2006 at 9:43am
|
I have a question about using the conversion tool, there is an arcade mod I added to my forum... Will that carry over? Actually, I'm not worried about the fact that game scores will get lost, but I'm worried that the DB wolud crush. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 27 March 2006 at 11:14am
|
It all depends if the arcade mod uses table column names the same as those in the new database. AS I don't know of this mod, the best thing to do is back-up your database and give the upgrade ago. If you get know errors it's fine, if you get errors the error message should give you a clue as to what column names are conflicting, and so need to be removed from the database. |
Posted By: Scotty32
Date Posted: 27 March 2006 at 11:39am
|
Info_Tech if your talking about AirHeads Arcade mod on Breath of Air, then it wont "upgrade" the arcade, but, theres nothing to "upgrade" database wise in the Arcade Mod, though Aaron will need to update the arcade to comply with the new Skining system, i believe hes waiting for the forum to be offically released before he upgrades it (incase of any skinning changes) if its another arcade mod - then sorry, i dont know  ------------- 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: iSec
Date Posted: 27 March 2006 at 12:48pm
|
Yes I'm using AirHead's Arcade mod. I hope it will get updated to match the new version settings. People like it a lot, they have already scored above 59,000 in that Air Fox game..lol I hope that the mod will get amended so we can use it in version 8 of webwiz forums because I will upgrade to the new version anyways. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: iSec
Date Posted: 28 March 2006 at 6:34am
Speaking of database backup, I am confused as to which method to use to back up my forum database. On the Microsoft website they state that I do a right-click on the db I want to backup and then back it up using Enterprise Manager like shown here:
 At first, I used the Import and Export Data method assuming that it's the right way of doing it and I set the option to back it up to 'Local' ...the problem is i don't know where on my computer the back up was stored...
Should I use the http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EMMAC - backup method that Microsoft suggests?
------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 28 March 2006 at 10:53am
| I've not tried Microsofts method but I usually install SQL Server locally (or MSDE), create a blank database on it, then use the import/export DTS tools to export the database to my locally installed SQL Server database. |
Posted By: iSec
Date Posted: 28 March 2006 at 11:54am
|
Ok cool, I have done that... One last question before I go ahead and convert the db... Should I wait for the final release or is it okay to use RC1 and then update when the full version is released? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 28 March 2006 at 12:40pm
|
I have just released version 8 RC1.1 which fixes a few issues with the RC1 release. Most issues with version 8 should now be sorted out ready for the final release at Easter. |
Posted By: iSec
Date Posted: 28 March 2006 at 2:33pm
Way to go mate  ... my db backup is now in progress, using DTS Import/Export... we'll see how it goes. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: iSec
Date Posted: 28 March 2006 at 2:59pm
|
Ok I get page cannot be displayed when I try to open msSQL_server_update.asp, what am I doing wrong? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: Sander
Date Posted: 28 March 2006 at 3:04pm
I have successfully upgraded my database to version 8 
|
Posted By: WebWiz-Bruce
Date Posted: 28 March 2006 at 3:10pm
You need to start a new topic and include the actual error message, not just the IE generic page can not be displayed. |
Posted By: Andersen
Date Posted: 28 March 2006 at 8:03pm
|
Will the MsSQL database run directly under MySQL. I´m planning an upgrade here, and I might as well skip the MsSQL and go for MySQL insted. But I cant see anything which need to be converted etc.
------------- Greets Andersen |
Posted By: WebWiz-Bruce
Date Posted: 29 March 2006 at 9:50am
|
mySQL is very different to SQL Server. There are tools available on the mySQL site for database conversion, but you would need to upgrade to the version 8 database first. |
Posted By: dj air
Date Posted: 01 April 2006 at 2:18am
|
Regards to the arcade mentioned it uses the existing database structure and inserts new values. i have almost changed the arcade to work with V8, i just need to do the arcade edit games page and a few bugs. to upgrade the arcade the best way or way you can do it is to just change the names of the table prefixs of the V7 to the V8 prefix and add 2 fields to the author table and 1 to the Common.asp file. as i said all you have to do is copy the tables over |
Posted By: wistex
Date Posted: 03 April 2006 at 5:36pm
I assume that it will only be a problem if we added a column with the same name as a column you are adding, correct? Will it leave our columns alone as long as they don't have the same name as yours? ------------- http://www.wistex.com" rel="nofollow - WisTex Solutions http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums |
Posted By: wistex
Date Posted: 03 April 2006 at 7:59pm
|
Another question: Will this tool upgrade from any version 7.x or is there a minimum version number (i.e. 7.5x)? Based on the name, I assume it supports everything from 7.0x to 7.9x. Am I correct? Or would I need to do multiple upgrades like we've had to do in the past?
------------- http://www.wistex.com" rel="nofollow - WisTex Solutions http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums |
Posted By: Mikey
Date Posted: 03 April 2006 at 11:06pm
That is correct, i had other columns, tables etc in my database and had no problems updating ------------- Handyman man? |
Posted By: WebWiz-Bruce
Date Posted: 04 April 2006 at 11:04am
It will work on all version 7.x databases as the tables and columns remained the same for all version 7.x databases. |
Posted By: maddhacker24
Date Posted: 07 April 2006 at 4:54pm
|
Hello,
After running the update tool I get the following error message when trying to render default.asp on my forums.
Server Error in Forum Application
An error has occured while connecting to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_db_connection File Name:- common.asp Error details:- Microsoft OLE DB Provider for SQL Server Invalid authorization specification I've done this 2 times now. The update tool says that everything finished successfully. Not really sure whats happening. Any help would be appreciated.
Administrator
KillSomeTime.com
|
Posted By: WebWiz-Bruce
Date Posted: 08 April 2006 at 11:38am
| Please start a new topic with more details such as if the upgrade tool reported that the database was updated successfully. |
Posted By: visiblepulse
Date Posted: 14 April 2006 at 7:54pm
Where did they go? or, does the final version 8 automatically update the old database?
|
Posted By: WebWiz-Bruce
Date Posted: 15 April 2006 at 10:04am
|
The full version upgrade tools are located on the main forum download page. |
Posted By: meta
Date Posted: 15 April 2006 at 1:51pm
Hi, I just figured out why this error has occured when upgrading from 7.9x to 8.0. There is a new directory named /database in the 8.0 version and it must be modified in order for the upgrade to work.
Hi boRg, could you also maybe add a line in the 7 to 8 upgrade kit that "the file in the /database directory must be updated" in order for the version 8 to work"
Very nice job
Thank you very much
meta
|
Posted By: ToJaRo
Date Posted: 19 April 2006 at 9:29pm
|
Ok, non DB issue... and I have not tried the upgrade yet.
I have custom images, graphics, and colors which I assume will be lost (or at least have to be reconfigured) when I move from 7.96 to 8... is that correct? Is there a way to overlay those old custom files with the new ones? This is not a huge issue in my book just a longer upgrade process if there is no way of doing it. ------------- ToJaRo http://www.thesoupbone.com - The SoupBone Community |
Posted By: WebWiz-Bruce
Date Posted: 20 April 2006 at 9:19am
|
Most of the graphics and images remain the same, but with some new ones added. The skins change though a they are now done purely through CSS which allows greater control of the look and feel of the 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 |