Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Moving the forum
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Moving the forum
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
AlanP View Drop Down
Newbie
Newbie
Avatar

Joined: 24 December 2005
Location: Canada
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote AlanP Quote  Post ReplyReply Direct Link To This Post Topic: Moving the forum
    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.
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
AlanP View Drop Down
Newbie
Newbie
Avatar

Joined: 24 December 2005
Location: Canada
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote AlanP Quote  Post ReplyReply Direct Link To This Post Posted: 02 December 2006 at 1:54pm
Originally posted by Info_Tech Info_Tech wrote:

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.

 
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?
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Posted: 02 December 2006 at 2:05pm
Originally posted by AlanP AlanP wrote:

 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.
 
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:
 
Originally posted by Web Wiz Guide Web Wiz Guide wrote:

MS Access Version 7.x to 8.x Database Upgrade Tool v1
This tool will upgrade your Web Wiz Forums version 7.x Access Database so that it is compatible with version 8.x of Web Wiz Forums.
......
Back to Top
AlanP View Drop Down
Newbie
Newbie
Avatar

Joined: 24 December 2005
Location: Canada
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote AlanP Quote  Post ReplyReply Direct Link To This Post Posted: 02 December 2006 at 4:11pm
Thank you very much. It worked smoothly and efficiently.
 
All the best.
Back to Top
jacobisrael View Drop Down
Newbie
Newbie


Joined: 13 December 2005
Status: Offline
Points: 19 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jacobisrael Quote  Post ReplyReply Direct Link To This Post 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.?
 
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply Page  123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.