Moving the forum
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=22041
Printed Date: 08 April 2026 at 1:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Moving the forum
Posted By: AlanP
Subject: Moving the forum
Date Posted: 27 November 2006 at 2:13pm
|
I have the forum set up on one domain (electrodynamics.ork.uk/forum) and would like to move it to another domain (unifiedtheory.org.uk/forum). The client wants to keep all the old posts etc. from the old forum and move them into the new one.
What is the smoothest way to do this? Is it just a matter of saving and moving the database file, or are there others that need to move with it?
Thanks for the help.
|
Replies:
Posted By: iSec
Date Posted: 27 November 2006 at 2:18pm
|
Yes all you need is properly transfer the db, then run the forum, login as admin and go to the control panel... change the forum configuration by changing the site's name, url, logo url, etc... If this is a MS-SQL db, make sure that when you transfer the db you exclude the roles of the db. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: AlanP
Date Posted: 02 December 2006 at 1:54pm
Thanks for this. Here is my situation in a bit more detail.
The domain the forum sits on will not be renewed when it expires next July. The owner wants the forum moved to his other domain. It is the Access version of Web Wiz.
I installed Web Wiz onto the unifiedtheory domain and all works well. I moved the wwForum.mdb to a directory outside htdocs and changed the name and everything still works well. But when I download the database file (electro.mdb) from the old electrodynamics site and redirect database_connection.asp to this file, everything stops.
Logging on to the forum gets this message:
"Server Error in Forum Application
An error has occured while reading user data from the database. Please contact the forum administrator. Support Error Code:- err_Access_getUserData()_get_member_data
File Name:- functions_login.asp Error details:-
Microsoft JET Database Engine No value given for one or more required parameters." When I change back to pointing at the other mdb file, everything works again.
The electrodynamics site is using Web Wiz version 7.96. The unifiedtheory site is using version 8.04, but I wouldn't imagine that would cause a problem.
Any clues?
|
Info_Tech wrote:Posted By: dpyers
Date Posted: 02 December 2006 at 2:02pm
|
You can't use a 7.x db with 8.x. You have to upgrade the db to 8.x. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: iSec
Date Posted: 02 December 2006 at 2:05pm
7.x is very different from 8.x
Before upgrading to version 8 you MUST upgrade your db using an upgrade tool available from the download page on WWG:
|
Posted By: AlanP
Date Posted: 02 December 2006 at 4:11pm
|
Thank you very much. It worked smoothly and efficiently.
All the best.
|
Posted By: jacobisrael
Date Posted: 03 December 2006 at 1:28am
|
The 8.x files were uploaded and the old 7.x files were deleted, the database was updated using the update tool, the database_connection.asp ran ok, but none of the messages, members, ec., appear. Several of the tables in the database have today's date, but most of them are dated to the prior install. The following are the errors we got when running the database tool: atabase Updated Started
Stage 1: Database Connection..... Complete Stage 2: Creating New Database Tables and Fields..... Error Updating the Table tblForum Column names in each table must be unique. Column name 'Sub_ID' in table 'jacobisrael.tblForum' is specified more than once. Error Updating the Table tblTopic Column names in each table must be unique. Column name 'Icon' in table 'jacobisrael.tblTopic' is specified more than once. Error Update the Table tblThread Column names in each table must be unique. Column name 'Hide' in table 'jacobisrael.tblThread' is specified more than once. Error Updating the Table tblPermissions Column names in each table must be unique. Column name 'View_Forum' in table 'jacobisrael.tblPermissions' is specified more than once. Error Dropping Contraints in Table tblPermissions ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'. Error Altering the Table tblAuthor Column names in each table must be unique. Column name 'No_of_PM' in table 'jacobisrael.tblAuthor' is specified more than once. Error Altering the Table tblConfiguration Column names in each table must be unique. Column name 'ID' in table 'jacobisrael.tblConfiguration' is specified more than once. Error Altering the Table tblDateTimeFormat Column names in each table must be unique. Column name 'ID' in table 'jacobisrael.tblDateTimeFormat' is specified more than once. Error Creating the Table tblPollVote There is already an object named 'tblPollVote' in the database. Error Creating the Table tblSession There is already an object named 'tblSession' in the database. Complete Stage 3: Creating Index's on database..... Error Creating one or more Index's There is already an index on table 'tblSession' named 'Session_ID'. Complete Stage 4: Entering default values for new fields..... Complete Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete)..... Permissions are reset to original defaults, you may need to update them once the upgrade is complete. Complete Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete Stage 7: Populating Database with Topic Statistics (this may take some time to complete)..... Complete Error Discription: There is already an index on table 'tblSession' named 'Session_ID'. SQL Server database is set up, but with Error! Gulp. Sure hope we haven't lost all the messages and email addresses and member information etc.?
|
Posted By: MadDog
Date Posted: 03 December 2006 at 1:31am
|
Guessing from the error messages, you ran the tool on a v8 database or you ran it one to many times.
If you really do have a v7 database, run the tool on it once and only once. ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: iSec
Date Posted: 03 December 2006 at 1:36am
|
also backup your original db and make a copy of it..do the conversion on a the copy and see if it works... this way you won't lose everything like I "stupid me" did once. |
Posted By: jacobisrael
Date Posted: 03 December 2006 at 2:31am
| Well, stupid me is even more stupider than "stupid you", as there seems to be no way to back up a database on Godaddy, and I have no other copy. Does that mean it's lost, forever? |
Posted By: iSec
Date Posted: 03 December 2006 at 2:44am
| I hope not... can you talk to them to restore it? they should do backups every now and then...can you ask them to restore it for the date before you did the upgrade? |
Posted By: jacobisrael
Date Posted: 03 December 2006 at 3:40am
| Well, just spoke with tech support at Godaddy, and they do have backups of the regular part of the web site, but the sql database is on a different server which they don't back up. oops. I'm worried that we've lost all this data, a year's worth of posts and membership info? Is that the case? Is there no way to fix this data base as it is? |
Posted By: iSec
Date Posted: 03 December 2006 at 3:43am
|
I'm afraid not. I almost cried when I lost about 50,000 posts and 1000 members last year.
If you're good with ASP you can retreive your data and apply it on a new database. Don't get rid of what you have now. Back it up... use a backup tool like Enterprise Manager and back it up on your local machine.
|
Posted By: dpyers
Date Posted: 03 December 2006 at 3:58am
|
I'd try the app against the db first. In a 7.x version, I ran a db conversion twice but the db was ok... nothing deleted, just a bunch of error messages saying it couldn't create stuff - because it was already created. Try running 8.04 wwf against the 8.04 db. nothing to lose ! -------------
Lead me not into temptation... I know the short cut, follow me. |
Posted By: jacobisrael
Date Posted: 03 December 2006 at 5:31am
|
Thanks for all the great advice, especially this time of night. Wish I'd asked for it before the database was blown. Am installing Enterprise Manager right now--Godaddy confirmed that you can't back up the database on Godaddy, and they don't back up the server with the databases on it. So hopefully, after what remains of the database is backed up, the 250,000 messages and 3,000 member data can somehow be restored.
It's encouraging, dpyers, that you were able to save some of it. How much and what kind of expertise is required to fix it?
|
Posted By: jacobisrael
Date Posted: 03 December 2006 at 5:40am
Just ran mssql_server_setup.asp again and this is what it produced. And of course it still doesn't find the members or messages:
|
Posted By: SMR Group
Date Posted: 03 December 2006 at 5:56pm
Can I just say that from a hosting point of view, that's ridiculous and a good reason to move. Most people have backups of their HTML and graphic files on their own computer, it's the fluid data stored server-side that people forget to keep copies of. It also tends to be mission critical data, so that's what Godaddy should be backing up. |
Posted By: Mikey
Date Posted: 03 December 2006 at 6:26pm
 Move hosts now!------------- Handyman man? |
Posted By: jacobisrael
Date Posted: 03 December 2006 at 11:02pm
Very true. Godaddy has been so good in so many other areas that it just wasn't expected that they didn't back up the server [read: pc?] with the databases on it. That seems to be a major flaw, since it ought to be pretty easy to back it up. The sql program has an entry for "csv output" and "xml output", but it doesn't seem to be activated. So, once Enterprise Manager is functional, it will be good for future backups, but it sure seems that this database is lost for good. Yikes. What a mess. Any other ideas on how to salvage some part of it would be greatly appreciated, and thanks again for all the great and timely [almost ); ] inputs.
|
Posted By: jacobisrael
Date Posted: 04 December 2006 at 7:25pm
| It seems that all the data is still in the database, and that there is a way to restore SOME of it in xml. But the large files just hang up and don't create the xml file. Also, Enterprise Manager won't work on Godaddy because Godaddy doesn't permit direct access to the database, for security reasons. |
Posted By: jacobisrael
Date Posted: 06 December 2006 at 5:35am
This will probably be the stupidest question you've heard in two weeks, but is there any way at all to go backwards, back to 7.x? It's clear from the tables that all the data is still there, and just difficult to extract.
|