| Author |
 Topic  |
|
|
olaitan.malomo
Starting Member
6 Posts |
 Posted - 19 August 2008 : 10:45:20
|
Hi all,
I just migrated a forum to a new server but the new instance keeps returning to the setup page.
The process I have used for the migration is:
1) Installed a MySql 5 server instance on new server
2) Backed up data from old MySql 4 server
3) Loaded data into ne MYSQL instance
4) Set up user credentials to be the same on both DB instances
5) Deleted annonymous user on new DB instance
6) Copied over the files (ASP, images etc) from old instance to new server
7) Created DSN on new server
8) Updated config.asp to match new environment
7) Configured IIS to serve enable the forum
The config is as such:
strDBType = "mysql"
strConnString = "forums"
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
strFilterTablePrefix = "FORUM_"
Const intAdminMemberID = 1
Const intCookieDuration = 30
Has anyone encountered this isse/know how to get the new instance to work without attempting to rerun setup?
Thanks
< |
--
Olaitan Malomo
Professional services, Altio
Integra SP LTD |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
olaitan.malomo
Starting Member
6 Posts |
Posted - 19 August 2008 : 11:06:05
|
No, the setup page suggests that the tables will be re-created. This should be ok as I do have a back up of the old DB should this process clear the data I have loaded on the new DB instance.
I am just looking for the path of least risk bys asking before trying that.
Thanks< |
--
Olaitan Malomo
Professional services, Altio
Integra SP LTD |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 August 2008 : 11:22:03
|
| Hmmm... the tables being recreated doesn't sound so good. If the tables are there and you're linking to the same database, it's hard to see how setup.asp can't find them. If you do have the backup, run setup.asp and see what is done. Maybe there is some case issue on table names, I don't see what else could be.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
olaitan.malomo
Starting Member
6 Posts |
Posted - 19 August 2008 : 11:30:38
|
I have tried to run setup with credentials I know to be valid (I tested them against using the MySql command line tool) but I keep getting errors with the first of them being the one below.
[MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt]No database selected
It looks like it is not resolving the right database name from the DSN.
Any ideas on this?
Thanks< |
--
Olaitan Malomo
Professional services, Altio
Integra SP LTD |
|
|
|
olaitan.malomo
Starting Member
6 Posts |
Posted - 19 August 2008 : 11:37:16
|
Thanks, the issue was with the DSN not being properly configured. The database name field was not saved.
Correcting this is now allowing the forum to run but still not properly. The data is being pulled back but all the formatting and display (grids, navbar etc) are not being displayed.< |
--
Olaitan Malomo
Professional services, Altio
Integra SP LTD |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
olaitan.malomo
Starting Member
6 Posts |
Posted - 19 August 2008 : 11:48:02
|
HI again,
I keep getting the error below when I try to navigate to any page.
Microsoft VBScript runtime error '800a000d'
Type mismatch
/forums_beta/search.asp, line 341
Also, the page being displayed does not show a link to get into the admin section.
Any advice?
< |
--
Olaitan Malomo
Professional services, Altio
Integra SP LTD |
|
|
|
olaitan.malomo
Starting Member
6 Posts |
Posted - 19 August 2008 : 11:56:54
|
I have applied the patch and the formatting as well as the login fields have returned.
However, the error from my last post is still being displayed in the Statistics section on the default page and when I follow any link.< |
--
Olaitan Malomo
Professional services, Altio
Integra SP LTD |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
