| Author |
 Topic  |
|
|
DareDevil
Starting Member
12 Posts |
 Posted - 11 May 2002 : 12:20:07
|
Hello,
I realize this topic has been brought up a few times before, but I feel it should be brought up again (not only because I’m trying to figure it out). Right now, I am running a large message board using the ASP-DEv system. I would like to upgrade to Snitz, but I’m having some problems. I was hoping we could put all our knowledge into this and finally lick the problem of converting from an ASP-DEv database to a Snitz database.
I compared the two databases, and they’re almost exactly the same. Maybe one or two tables have had a name change, but the only other difference is the addition of tables that weren’t present with ASP-DEv. I figure the best way to convert would be through Access (unless your professional opinion would be an SQL conversion). It may be possible that if we can get the tables to match the current version, we can then run the built in converter in setup.asp.
We’ll need some of the higher level support staff to dish out their knowledge on past database structures also. Speaking of past databases, it may be worth while to convert ASP-DEv to the oldest possible Snitz version (the oldest on the conversion list) and then upgrade. Is there a section were we can download past versions of Snitz?
Thanks for the help guys; I’m sure more than a few people would really benefit from a good set of conversion instructions. If you can help me do this, I plan to write detailed conversion guide.
Thanks again,
Derek
P.S. I hope this is the right section to post in!
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
DareDevil
Starting Member
12 Posts |
Posted - 11 May 2002 : 15:31:45
|
Thank you Nathan.
|
 |
|
|
DareDevil
Starting Member
12 Posts |
Posted - 11 May 2002 : 20:08:10
|
Nathan, would you happen to know where I can find Snitz Forums 3000 V3 RC1? Or, at least it's Access database file. I'm very close to cracking this... One more version jump should do it!
Edit: Also, I'm not sure what to do about this error:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/snitz/default.asp, line 211
Edited by - DareDevil on 11 May 2002 20:15:19 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 11 May 2002 : 21:07:10
|
That particular error usually occurs when your using an old database on new code.
I dont have a 3.0 sr 1 in my stash, someone around here might though.
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
DareDevil
Starting Member
12 Posts |
Posted - 12 May 2002 : 01:34:21
|
Okay, the database has been completely transferred. Now I need to convert the time format. ASP-DEv used Access's native "21/03/2001 7:36:00 PM" time format, we need "20010725010000". Has anyone done this before? I though I might ask before I go ahead and work on a conversion for it.
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 12 May 2002 : 02:10:09
|
Take a look at DatetoStr function in the Snitz inc_functions.asp file.
www.daoc-halo.com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
DareDevil
Starting Member
12 Posts |
Posted - 12 May 2002 : 10:52:18
|
It works beautifully, thank you! I wonder what's next. Everything seems to be working fine. (Except for the fact that all the dates and times are today’s date and time :))
|
|
|
|
DareDevil
Starting Member
12 Posts |
Posted - 12 May 2002 : 12:26:23
|
Are the links between the tables necessary?
|
|
|
| |
Topic |
|
Topic Locked
