| Author |
 Topic  |
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
 Posted - 06 April 2005 : 22:11:22
|
I have upgraded to the recent version.
after the upgrade, posting is not working
I get this message
error '80040e2f'
/post_info.asp, line 889
the forum is
http://forum.101games.co.uk/default.asp
everything else i have tested so far seems to be working.
what should i do next? |
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 06 April 2005 : 22:14:18
|
Just a thought.. The only change i made was to the config.asp file
strConnString = "Provider=SQLOLEDB;Data Source=xxx.xxx.xxx.xxx;database=xxxxxxx;uid=xxxxx;pwd=xxxxx;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
strTablePrefix = "GAMES_"
strMemberTablePrefix = "FAN_"
strFilterTablePrefix = "FORUM_" 'used for BADWORDS and NAMEFILTER tables |
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
 |
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 06 April 2005 : 22:20:29
|
it gives this error, if the posting, is a reply
error '80040e2f'
/post_info.asp, line 1027
|
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 07 April 2005 : 02:49:05
|
Did you run the setup.asp file after you changed all the files? You need to also update the DB via the setup.asp file for it to work properly.
Give it a shot and let us know.
|
Cheers,
David Greening |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 07 April 2005 : 05:57:17
|
The forum is up and running, just the stats are a bit low:
9 of 23 Members have made 13 posts in 7 forums, with the last post on Jan 07 2003 19:58:39 by: Nathan.
With that I would of started a fresh forum as it seems only 9 members have posted anyway.... |
Cheers,
David Greening |
|
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 07 April 2005 : 07:38:41
|
ruirib..
the forum is up?? did you get an error opening the page?
Classicmotorcycling..
I did run the setup.asp, and that did the datbase upgrade too, although it said there were no errors at the end, it showed a few in the list of things it did..
also, this is one of 7, I am concerned for the others, I tested on this, before upsetting the others.
---
All...
I was trying to create a new user, so yoiu guys can go in, without regestering, and the new user process is also not working got this...
error '80040e2f'
/register.asp, line 568
since its on many pages, and using many processes, could this be datbase related? |
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 07 April 2005 : 20:17:43
|
no..
The only change to the database was done by the setup.asp.
That said. Prior to the upgrade, I did alter the database server being used, but it displayed the forum, and allowed a login, so sugested that the datbase was readable.. it also recognised the login time, as the purple folders went away the next time i logged in, again, sugesting the datbase connection is fine, and allowing writing.
|
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 April 2005 : 04:17:54
|
| So, you moved the SQL Server database from one server to another? How did you do the move? Did you create the database tables by running setup.asp before moving the data using DTS? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 08 April 2005 : 16:12:39
|
I feel you are onto somthing here..
A bit of background..
I have 7 forums all sharing the datbase, with some sharing users etc.. so the tables for 7 forums are all in one datbase.
My old server diedsd a horrible death. and we reserected it for "one night only". we connected to it from another enterprise manager, as the one on the server its self is strugling to open the connection..
We then ran a full export, structure and data to the new server.. changed the connection strings, etc.. and it all looked great as the forums came live.
I think I know what you are going to say next, some of the table properties arn't copied with an export, thus some setting or string lenth etc, is set wrongly, to a default value...
the correct route would have been to build the tables with the setup.asp, then copy the data... TOO LATE , the maden cried...
What options do I have??
is there a script I can run on the tables now they are populated??
or is it clear what tables and settings suffer from this sort of "bad " migration? |
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 April 2005 : 17:42:19
|
You're right, table structure wasn't properly created. I don't know the exact error being generated. It can be an issue with default values, with identity fields or both.
If your forums do not have mods, you could simply try to import the data to an Access DB and then run setup.asp, with config.asp configured each time to a different forum, so that the tables would be properly created. Then you could import the data back from Access.
An alternative to this would be to try and solve the problems as they arose. That would mean dealing with each problem at a time, finding the causes and fixing it. Your current problem, quite likely, results from one field that should be an identity field not being set as such. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 08 April 2005 : 19:29:53
|
the tables have to be empty to do this I asume??
with the datbase holding so many forums, do I have to run the setup.asp for each one?
when i did the setup for the upgrade, it asked what datbase setup i wanted to run.. which should i use?
also, if i run the full setup, will the import work o.k.? as the setup changes the table layout
|
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 April 2005 : 22:09:09
|
This should be done with empty tables. You should run setup.asp?RC=5, so that table structure is recreated. Setup needs to be run for each set of tables, that is, for each forum, which means you should change the table prefixes in config.asp, for each of the forums, and run setup.asp?RC=5 for each forum as well, immediately after changing the prefixes.
The import should work fine, as long as you take the care to ensure that existing table data is deleted and enable identity insert is set, for each of the tables. This is not a difficult process, but it is one that can be done more easily if you have experience with DTS and importing from Access.
Be sure to make a database backup before trying anything. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 08 April 2005 : 23:02:28
|
Well, thats the first one live again..
ruirib.. thanks for your help.
the import had, as you sugested, left the defaults and keys and ID flags missing.. There are about 40 in all, and I set this lot by hand. ( copied settings from a new, updated install )
When I am feeling a bit more adventurouse, I'll do the full export, setup.asp, import method!
Thanks again. |
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
