| Author |
 Topic  |
|
|
charlton
Starting Member
26 Posts |
 Posted - 16 November 2006 : 21:29:49
|
I am running snitzforum 3.4.05 and below in GREEN is a list of ALL the tables that are in my database. Below that is a list of tables in RED that are NOT in my database. It has been running like this for over a year with no problem. Can anyone tell me why it seems there are quite a few tables absent?
All these tables are present....
FORUM_ALLOWED_MEMBERS
FORUM_A_REPLY
FORUM_A_TOPICS
FORUM_BADWORDS
FORUM_CATEGORY
FORUM_CONFIG_NEW
FORUM_FORUM
FORUM_GROUPS
FORUM_GROUP_NAMES
FORUM_MEMBERS
FORUM_MEMBERS_PENDING
FORUM_MODERATOR
FORUM_NAMEFILTER
FORUM_REPLY
FORUM_SMILES
FORUM_SMILES2
FORUM_SMILES_CUSTOM
FORUM_SUBSCRIPTIONS
FORUM_TOPICS
FORUM_TOTALS
NONE of these exist in my database
FORUM_ACTIVE_USERS
FORUM_ALBUM
FORUM_ALBUM_CAT
FORUM_ALBUM_CONFIG
FORUM_ALBUM_USERS
FORUM_AVATAR
FORUM_AVATAR2
FORUM_BOOKMARKS
FORUM_FILELISTER
FORUM_FILELISTER_CAT
FORUM_FILELISTER_CONFIG
FORUM_FILELISTER_USERS
FORUM_FILES
FORUM_GB_OPTIONS
FORUM_GUESTBOOK
FORUM_IPLIST
FORUM_IPLOG
FORUM_MAILLIST
FORUM_NOTES
FORUM_PM
FORUM_POLLS
FORUM_POLL_VOTES
FORUM_RATINGS
FORUM_REV
FORUM_REVIEWS
FORUM_REV_OPTIONS
FORUM_ANNOUNCE
|
Edited by - charlton on 16 November 2006 21:31:23 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 16 November 2006 : 22:20:49
|
Those tables are a parts of various assorted MODs.
Incidentally, if your database doesn't have them, and hasn't had them, why are you asking about them as though they've been missing? |
 |
|
|
charlton
Starting Member
26 Posts |
Posted - 17 November 2006 : 09:24:50
|
Snitz is great...and considering it's free it's unbelievable.
Many of my members PREFER it because of it's clean, uncluttered appearance and ease of use.
But...I am needing to move my site to another server which doesn't have ASP capabilities so I had to use a different forum. The forum I'm migrating to needs those tables to process the data from my current SQL tables into their format.
|
|
|
|
RArch
Junior Member
United Kingdom
103 Posts |
Posted - 17 November 2006 : 09:30:11
|
Just track down each mod and run the dbs file for each mod to create the tables. Since the table will be blank it should make the upgrade process easier and quicker.
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 17 November 2006 : 09:37:30
|
quote:
Originally posted by charlton
But...I am needing to move my site to another server which doesn't have ASP capabilities so I had to use a different forum. The forum I'm migrating to needs those tables to process the data from my current SQL tables into their format.
Well, that's weird - I've never heard of a "migration" script that forces you to install a multitude of unnecessry mods to your Snitz forums before you can use it. If anything, it should ignore any tables and fields created by your mods and just copy over the base Snitz tables and fields.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 17 November 2006 : 09:56:11
|
Not to mention the fact that each of those MODs may have changed their data structures since the "migration" script was initially created...
I wonder if the reason it requires those tables is because the software you are moving to has those features and thus requires those tables.  |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 17 November 2006 : 10:01:22
|
Even it did, it should be creating the tables it needs first, then importing any relevant data from the Snitz db.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
charlton
Starting Member
26 Posts |
Posted - 17 November 2006 : 13:05:24
|
quote:
Originally posted by RArch
Just track down each mod and run the dbs file for each mod to create the tables. Since the table will be blank it should make the upgrade process easier and quicker.
That sounds like a nightmare. 20+ Mods all at the same time? Maybe Snitz has an empty copy of the tables somewhere available for download? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 17 November 2006 : 15:32:02
|
You might want to check with the people who put together the migration script and see if you can comment out the parts that reference the tables that don't exist. See how they put the script together in the first place.
I'm having a hard time figuring out why they would be in the script if the tables aren't part of the base install... unless they created the script based on one of the alternate versions (like serverhacker's, or Image's, or MWP, etc.). |
|
|
|
charlton
Starting Member
26 Posts |
Posted - 18 November 2006 : 12:21:07
|
Thanks for the replies fellas.
vBulletin is the forum. One of the support techs wrote a utility called Impex that automatically migrates many different forums to vBulletin.
But like you said, the script was written on the assumption that every install has all the mod tables included.
Is Snitz that much different in that most other forums do not need "add on" tables for mods?
By the way, if push comes to shove, where can I find the mods?
Thanks
|
Edited by - charlton on 18 November 2006 12:22:48 |
|
|
|
charlton
Starting Member
26 Posts |
Posted - 18 November 2006 : 13:08:34
|
quote:
Originally posted by RArch
Just track down each mod and run the dbs file for each mod to create the tables. Since the table will be blank it should make the upgrade process easier and quicker.
Can you tell me the steps to do this?
It doesn't seem quite that simple to me.
Thanks |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 18 November 2006 : 14:24:04
|
Most of the Snitz MODs are hosted over at www.snitzbitz.com
It looks like (and I'm just guessing on most of these) you will need to find:
* Active Users (found here, not on SnitzBitz)
* Avatars (don't know which one)
* IP Gate
* Private Messages
* Guestbook
* Poll MOD
* and I haven't the foggiest on the rest
Keep in mind, most of these MODs have probably been updated since that script was written. You really need to find out from them what versions they wrote the script for. It may be easier to find out what table structures they are looking for and create them yourself. |
|
|
|
RArch
Junior Member
United Kingdom
103 Posts |
Posted - 19 November 2006 : 04:59:48
|
quote:
Originally posted by charlton
quote:
Originally posted by RArch
Just track down each mod and run the dbs file for each mod to create the tables. Since the table will be blank it should make the upgrade process easier and quicker.
Can you tell me the steps to do this?
It doesn't seem quite that simple to me.
Thanks
Download one of the mods from www.snitzbitz.com like AnonJr has suggested. Read the instructions that will be included with it and find the section that deals with upgrading the database. Basically there will be a file named like dbs_xxxx.asp which is run from the "Mod Setup" option within "Admin Options" (note: you need to be logged in as the superadmin). This will will create the tables as necessary for the mod, that all you need to do.
PS: Email me I have a good share of the dbs files you need.
|
|
|
| |
Topic |
|
Topic Locked
