| Author |
 Topic  |
|
|
mdntblu
New Member
58 Posts |
 Posted - 09 March 2001 : 01:02:00
|
Can someone please give me some instructions on how to update an older version forum to the latest version without losing all the data? It's an access database, the Snitz forum version is 2.84a beta, and any other info you need I can give you. If you want to have access to my FTP site to edit it and upload changes then I can do that also. The website is www.w2kgamer.com/forum
Please let me know.
sysop@w2kgamer.com
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 09 March 2001 : 04:06:14
|
don't think I've done one from that version yet.
mdntblu,
If you email me a copy of your db, I will work out what needs to be done to it, and write you an update script for the DB.
|
 |
|
|
mdntblu
New Member
58 Posts |
Posted - 10 March 2001 : 18:03:13
|
Problem is that if I email you the database and then you make changes and I upgrade it won't it lose any messages that were posted between the time I downloaded the mdb file and uploaded the new one? I guess it really doesn't matter. Ok I'll email it to you.
Thanks
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 11 March 2001 : 06:44:48
|
The email, is so that I can work out what need sto be done to the DB, if possible I will send you a script to perform the upgrade in situ.
I have received, the DB, will be in touch
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 11 March 2001 : 19:15:08
|
mndtblu,
download the zip file, copy all the files to your forum directory, and execute
convert_snitzdb.asp in your browser.
then upload all the sr4 files from the forum download, and that should be it.
Please, remember, make a copy of your DB before you do this incase you get problems.
Snitz 2.84abeta to 3.1sr4 DB upgrade
|
|
|
|
mdntblu
New Member
58 Posts |
Posted - 13 March 2001 : 14:43:46
|
Ok I ran the file and I get an error.
Microsoft VBScript runtime error '800a01a8'
Object required: 'my_Conn'
/forum/inc_functions.asp, line 176
The URL is http://www.w2kgamer.com/forum/convert_snitzdb.asp
--mdntblu
Edited by - mdntblu on 13 March 2001 15:12:07 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 March 2001 : 17:07:03
|
ok, I guess your code files are slightly different, I will just make a few tweeks and repost it
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 March 2001 : 17:10:45
|
Ok, just need a couple of lines moving around, redownload the zip, and replace the convert_snitzdb.asp file
|
|
|
|
mdntblu
New Member
58 Posts |
Posted - 13 March 2001 : 19:31:01
|
Ok I redownloaded the files and uploaded them to the server and I get a different error.
***********************************
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/forum/convert_snitzdb.asp, line 49
***********************************
Let me know what you want me to do now.
Thanks
Edited by - mdntblu on 13 March 2001 19:31:20 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 March 2001 : 19:45:24
|
is it possible to give me ftp access to your files, I am not familiar with 2.88, and need to look at the files to figure out what I need for he upgrade to work, or maybe email me a zip of your forum files.
|
|
|
|
mdntblu
New Member
58 Posts |
Posted - 14 March 2001 : 01:10:58
|
It is possible to give you access. I sent you 2 emails with the passwords and I never heard back from you. I won't give them out in here but will email it to you. Please reply to this or email me with your email address. The one I used before is the one you have in the profile on Snitz Forums.
sysop@w2kgamer.com
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 14 March 2001 : 07:11:36
|
quote:
It is possible to give you access. I sent you 2 emails with the passwords and I never heard back from you. I won't give them out in here but will email it to you. Please reply to this or email me with your email address. The one I used before is the one you have in the profile on Snitz Forums.
sysop@w2kgamer.com
I just emailed you
|
|
|
|
mdntblu
New Member
58 Posts |
Posted - 18 March 2001 : 16:10:28
|
Huw,
Ok I got it all working great but when I am logged in as Admin and I want to add a URL to the forum it bombs with an error. Here is the error:
******************************************
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The field 'FORUM_FORUM.F_MAIL' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/forum/post_info.asp, line 805
*****************************************
Can you see if you know why it does that?
Thanks
Brad
sysop@w2kgamer.com
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 18 March 2001 : 16:23:36
|
looks like a default value got missed in the update, if you have access, just open your db and set a default value of 0 for the F_EMAIL field
|
|
|
|
mdntblu
New Member
58 Posts |
Posted - 25 March 2001 : 15:38:16
|
I can't find an F_EMAIL field.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 March 2001 : 16:46:25
|
He meant F_MAIL
|
|
|
| |
Topic |
|
Topic Locked
