7.3->7.4 Database Migration

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
dj devil Members Profile Find Members Posts Newbie Joined: 06 April 2003 Status: Offline Points: 4	Post Options Post Reply Quote dj devil Report Post Thanks(0) Quote Reply Topic: 7.3->7.4 Database Migration Posted: 07 April 2003 at 11:10am
	How do you use your DSN-based mdb from 7.3 to 7.4? I get an error: Error Type: ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal. /forum2/common.asp, line 254 I've also tried DSN-less way, but same thing. What needs to be ammended? I like the new features of 7.4 and I am not a programmer lol. I've changed the DSN in common.asp files but that does not do it. Using original mdb from the zip file, however, works. Thx! Edited by dj devil

adawg Members Profile Find Members Posts Groupie Joined: 10 February 2003 Status: Offline Points: 42	Post Options Post Reply Quote adawg Report Post Thanks(0) Quote Reply Posted: 07 April 2003 at 2:39pm
	I assume that you allready manually edited your mdb (added the new fields and tables and set the relationships) file to make it compatible with the beta4 correct?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 07 April 2003 at 2:58pm
	Like I have said about 200 times, don't use beta versions on a lve web site, also there are no upgrade tools between beta versions, so the only way you can do this is compair old and new databases and use the version history file to create the new fields and tables in the old database.
	Web Wiz Forums Hosting ASP.NET Web Hosting

dj devil Members Profile Find Members Posts Newbie Joined: 06 April 2003 Status: Offline Points: 4	Post Options Post Reply Quote dj devil Report Post Thanks(0) Quote Reply Posted: 07 April 2003 at 5:01pm
	Adawg & Borg... I thought there might be an easier way to do it, other than restructurizing the DB... I guess not. thx anywayz

adawg Members Profile Find Members Posts Groupie Joined: 10 February 2003 Status: Offline Points: 42	Post Options Post Reply Quote adawg Report Post Thanks(0) Quote Reply Posted: 07 April 2003 at 11:09pm
	While we are on the subject, I upgraded my V7beta3 DB to beta4, and everything works fine except when I try to make a new post. When I refresh the topics I get this error: Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'CInt' /testforum/forum_topics.asp, line 377 at the top of the forum page, and only anouncements show up. No regular topics do. Can anyone help? Edit: As soon as I remove the new post via using the search option/active topics to find it (only way to display it) the topics all show up again. I also turned off ALL the options on the forum and the error continues. Edited by adawg

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 08 April 2003 at 2:36am
	Make sure you have also set the default values for any new fields.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

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