Running version 7.01. Can I upgrade?

Post Reply

Page <123 4 5 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Andersen Members Profile Find Members Posts Groupie Joined: 07 July 2002 Location: Denmark Status: Offline Points: 152	Post Options Post Reply Quote Andersen Report Post Thanks(0) Quote Reply Posted: 23 December 2004 at 9:36pm
	Hmm, Dj Air.. I just made a test, and it didnt went well. What I did was: Installed a new empty database. Restore a backup from my original forum to this new empty database. Made the changes to the stored procedures. Copy the whole directory if WebWiz 7.9 to a new domain. Changed the SQL connection to this new database. When entering the "new" forum now, It�s working fine, just untill I try to enter one of the forum areas. Then I receive this error: ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. /forum_topics.asp, line 424 Looking from the main page, all data seems to have been copied. So I wonder what I made wrong! Btw.. Merry Christmas to all of you!
	Greets Andersen

Andersen Members Profile Find Members Posts Groupie Joined: 07 July 2002 Location: Denmark Status: Offline Points: 152	Post Options Post Reply Quote Andersen Report Post Thanks(0) Quote Reply Posted: 23 December 2004 at 9:40pm
	Hmm.. Just noticed. I can enter all messages using the Active Topics.
	Greets Andersen

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 24 December 2004 at 5:51am
	the error message means that a field is missing from the table. (topics table) but from what i saw in the Version history nothing was done. hjave a look on the line that the error occurs, that hopefullly will tell you whats missing. whjen you say created a new database do you mean blank one.? with No WWF info at all. or do you mean a blank WWF database on the SQL server, with the scructure. you can always try making a blank WWF tables and then import data ONLY.

Andersen Members Profile Find Members Posts Groupie Joined: 07 July 2002 Location: Denmark Status: Offline Points: 152	Post Options Post Reply Quote Andersen Report Post Thanks(0) Quote Reply Posted: 24 December 2004 at 8:19am
	I used the enterprise manager til create a new database (I assume it�s empty). After that I used Enterpriser to restore the database (know it sounds silly, as it�s a new database), but pointed the path to the original database, to restore the data from that one into the new one.
	Greets Andersen

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 24 December 2004 at 9:59am
	can you open the Topic table and see what the last field is called, then we can tell if its because a new field has been entered, you have replaced the stored procedures by deleting the old ones (that will also be imported in think). re run the creation script.

Andersen Members Profile Find Members Posts Groupie Joined: 07 July 2002 Location: Denmark Status: Offline Points: 152	Post Options Post Reply Quote Andersen Report Post Thanks(0) Quote Reply Posted: 24 December 2004 at 8:12pm
	I guess you mean open the database in enterprise manager, go to the tables and doubble click on the tblTopic ? I�m not sure what to look for in here, but the last field is Priority, Smallint, 2, no mark in Nulls, Default empty. I didn�t delete the old procedures (those mentioned in upgrade 7.5) as I thought it didn�t matter.
	Greets Andersen

Andersen Members Profile Find Members Posts Groupie Joined: 07 July 2002 Location: Denmark Status: Offline Points: 152	Post Options Post Reply Quote Andersen Report Post Thanks(0) Quote Reply Posted: 25 December 2004 at 9:22am
	HMMMM.. it has to be something wrong with the msSQL_server_setup.asp file. I tried again, restoring data to the "forum2" database, by using the backup from "forum1", after that I ran the msSQL_server_setup.asp modified to only update the section of the Stored Procedures. I get the same error, but also noticed I got a new error this time: Error Creating the Stored Procedure wwfSpDBinfo (it may already exsist). If you are using MS SQL Server 7 ignore this error (You will not be able to view SQL Server stats in the admin area) The result is the same though. Now.. It seems like there is either something missing in the stored procedures/tabel, or the file forum_topic.asp is corrupted somehow. I really need a good advice now, as I have no more ideas what to do from here.
	Greets Andersen

Andersen Members Profile Find Members Posts Groupie Joined: 07 July 2002 Location: Denmark Status: Offline Points: 152	Post Options Post Reply Quote Andersen Report Post Thanks(0) Quote Reply Posted: 25 December 2004 at 11:04am
	i have just opened the tbltopic tabel, and as far as I can see, they�re totally identical. 2933 topics, and the fields are exactly the same in the two databases..
	Greets Andersen

Post Reply	Page <123 4 5 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum