| Author |
 Topic  |
|
fetch
Starting Member
46 Posts |
 Posted - 21 April 2005 : 17:27:02
|
I've just taken on a job upgrading someone's Snitz2000 forum from Access to SQL, and found the following instructions elsewhere on this board:
1. Create, or have your host create a blank database for you.
2. Run setup.asp?RC=5 to create the Snitz base tables in the database.
3. If you have mods installed, run mod setup for each of your mods, so that the necessary changes and additions are done in the database.
4. Use DTS to transfer the data from your Access database to your SQL Server database. You should make sure that for each table the DTS transform column is configured so that any existing table data is deleted and enable identity insert is checked.
The only problem is step 3. I am certain that there are mods installed, however I don't know what they are and it appears there have been some pretty significant changes to the core code of the forum by the mods. I know this because no matter how I try to import the data from Access to SQL, it still fails to load the forum properly when I changeover my DSN. The best I've been able to do is get the forum displaying all of the old posts, but without much of the formatting and also logins don't work (even though the members exist in the database).
Can someone tell me if there is a light at the end of the tunnel? If I said 'screw it' and wanted to get rid of all mods + formatting, is there a way to JUST import the members, their posts, and maybe a few other key required settings? Or should I just start over with a new database and archive the old forum for posterity? |
http://www.mhsaa.org/4rum/forum/
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
fetch
Starting Member
46 Posts |
Posted - 21 April 2005 : 22:10:19
|
quote:
Originally posted by ruirib
Who modded that forum? Can't you ask that person? Are there any files that start with dbs...something.asp? What Snitz version are you using?
[Snitz Forums 2000 Version 3.3.03]
Here's a listing of files in the mod folder, found in the root of the forum:
The ex-admin of the forums is long gone so no help there. |
http://www.mhsaa.org/4rum/forum/
|
 |
|
|
fetch
Starting Member
46 Posts |
Posted - 21 April 2005 : 22:17:33
|
Actually, I found a listing of the mods in the main admin area:
Mod Configuration panel 1.00 HuwR
Ban Users by IP 1.00 Davio
FAQ Administration 1.00 Huwr
File Attachments 2.00 Huwr
Forum Announcements 1.00 Richard Kinser
New Member Private Message 2.00 Kycable, Huwr
Slash MOD 2.10 animedj
Smiles Manager 1.0 Da_Stimulator
User Fields 1.00 Huwr
So I'd need to figure out where they all are and then re-install them on the new forum?
One more question, sorry if this one is a little too new - where are the forum formatting settings stored? I.e. the color scheme and so forth? I noticed during one of my many DTS imports that the formatting wasn't stored in the db.
|
http://www.mhsaa.org/4rum/forum/
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 April 2005 : 23:43:44
|
You arent't using a modded HuwR's forum are you (have a look at www.magicmushroom.org.uk)? Yes, you need to find out the code for those mods to find the dbs files. If you're using a HuwR's modded forum, I don't know that version, but quite likely setup.asp will create all the table changes it needs. If there are additional mods, then you need to find the code for them and find the associated dbs files. Mod's code can be found at snitzbitz.com or the mod W/Code forum here.
All configuration data is stored in the DB, including colors and such. THey are stored in the FORUM_CONFIG_NEW table, unles the forum version is very old (CONFIG could be used then). |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
fetch
Starting Member
46 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 April 2005 : 05:30:27
|
It does look like one, indeed. It has some changes when compared to the HuwR's forums I have seen, so it's likely that it has some customization.
You always have a baseline alternative when upgrading a DB: Create the tables manually with Enterprise Manager. Analise the Access DB carefully and then create each table in SQL Server manually. Pay special attention to default values, primary keys and convert the data types carefully.
In spite of this, I would visit HuwR's forum and check whether he could help with the migration. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
fetch
Starting Member
46 Posts |
Posted - 24 April 2005 : 22:00:20
|
Ok, I went with the baseline and ran a conversion that turned out sorta ok. You can see the original forum here:
http://www.mhsaa.org/4rum/forum/
and my SQL-powered one here:
http://www.mhsaa.org/4rum/blankforum
Two major things didn't convert -
1. logins don't work anymore
2. None of the topics are being found
Does anyone know why that would be? I've checked and the user/pass exists for all the users. So why wouldn't the login work? I'm not sure where the topics are stored in the database, however I'm pretty sure the were converted cuz there was no db error during the conversion. |
http://www.mhsaa.org/4rum/forum/
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 April 2005 : 06:20:50
|
Regarding the topics disapperance, you just need to choose Show All Topics in the dropdown at the right, above the topics area. The default value seems to be 1 day, so changing it will enable you to see the topics.
Regarding the logins, were the passwords converted? Can you have a look at the DB, FORUM_MEMBERS table to check whether they were encrypted or not? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
fetch
Starting Member
46 Posts |
Posted - 25 April 2005 : 16:46:19
|
Ah, I missed that topic thing. Thanks for pointing that out. I changed it and now I see all the posts. Very good. Is there a way to change that default? In the admin section I imagine? Or is it a user-user setting?
logins: i checked the table and the M_NAME field exists w/data, as wll as the M_PASSWORD field. I did notice that the M_USERNAME field has nothing but NULL values. What is that used for? |
http://www.mhsaa.org/4rum/forum/
|
|
|
|
fetch
Starting Member
46 Posts |
Posted - 25 April 2005 : 22:31:15
|
Someone pointed out that the ASP files aren't the same in the two forums, so I made an EXACT copy of the normal forum and put it into the blank forum. The header information is preserved now, and the logins work, however I get "NO FORUMS FOUND" and the following error:
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'F_URLIMAGE'.
/4rum/blankforum/Default.asp, line 247
as seen on
http://www.mhsaa.org/4rum/blankforum/
Can anyone tell me what that means? |
http://www.mhsaa.org/4rum/forum/
|
|
|
|
fetch
Starting Member
46 Posts |
Posted - 25 April 2005 : 23:15:11
|
Ok, ignore my last post. I started going through the tables and columns one by one, and it seems there were a few that the SQL DTS 'left out'. Sofar I've found three or four, all columns with either a single digit value or NULL that just wasn't copied. So, I've fixed those. Now for some more esoteric problems:
1. The number of topics, number of posts, and date of the last post aren't showing up on the main forum page
2. Posting doesn't appear to have an effect, i.e. the post doesn't get listed. |
http://www.mhsaa.org/4rum/forum/
|
|
|
|
fetch
Starting Member
46 Posts |
Posted - 25 April 2005 : 23:25:21
|
| Got it - allowed NULL for REPLY_ID and whatever the new post ID is, which can't happen both need an ID. Now i just have to figure out how ACCESS created it and why that didn't carry over to SQL. |
http://www.mhsaa.org/4rum/forum/
|
|
|
|
fetch
Starting Member
46 Posts |
Posted - 26 April 2005 : 00:38:16
|
Latest update in the saga that is my conversion effort:
I went through the SQL database and recreated all of the Autonumber fields, which probably prevented about a dozen future errors. Problems remaining:
1. Posting works, but the posts aren't showing up at the top of the forum as they should. I can search the forum and get results from the right category, but the actual post is being buried somewhere.
2. When searching, I get the results along with this error:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cint'
/4rum/blankforum/search.asp, line 531
NOTE: this only happens with post-conversion posts, so that means that my posting method still probably isn't putting everything in the database. I might be able to figure that out myself...
3. The number of topics, number of posts, and date of the last post aren't showing up on the main forum page
I'm open to suggestions for any of these problems. |
http://www.mhsaa.org/4rum/forum/
|
|
|
|
fetch
Starting Member
46 Posts |
Posted - 26 April 2005 : 00:57:22
|
Default values weren't being carried over, which solved 90% of my problems. The only one remaining is
The number of topics, number of posts, and date of the last post aren't showing up on the main forum page
|
http://www.mhsaa.org/4rum/forum/
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
