Impex - known to be missing Tables

[MistyPotato]

Hello,

I have an Impex Import question. First the essentials....

Environment:
WindowsXP
Local Server (home office)
Apache 1.3
MySql 5.0.27
vBulletin 3.6.3
php 5.2.0
Impex 1.71
Snitz ver. 3.4.05
Type of Import: Merge

Question Setup:
I am at the stage of associating users having successfully passed the stage of "Check and Update Database"
However, I get the following error....

ImpEx Database errormysql error: Invalid SQL: SELECT A_URL FROM FORUM_AVATAR WHERE A_MEMBER_ID=1
mysql error: Table 'oldforum.forum_avatar' doesn't exist
mysql error number: 1146
Date: Thursday 16th 2006f November 2006 12:03:53 PM
Database: Oldforum
MySQL error: Table 'oldforum.forum_avatar' doesn't exist

Since I know that this table does not exist, this error doesn't surprise me.
But here's the part that puzzles me and that I have a question about...


Actual Question...
As I have never had that nor ANY of the following tables in my Snitz forum database and my board has been running for years without that table....How do I get around this?


Additional Info....
None of these tables have ever existed in my Snitz forum MS-SQL database. I'm not sure why, never missed them.

FORUM_ACTIVE_USERS NOT found.
FORUM_ALBUM NOT found.
FORUM_ALBUM_CAT NOT found.
FORUM_ALBUM_CONFIG NOT found.
FORUM_ALBUM_USERS NOT found.
FORUM_AVATAR NOT found.
FORUM_AVATAR2 NOT found.
FORUM_BOOKMARKS NOT found.
FORUM_FILELISTER NOT found.
FORUM_FILELISTER_CAT NOT found.
FORUM_FILELISTER_CONFIG NOT found.
FORUM_FILELISTER_USERS NOT found.
FORUM_FILES NOT found.
FORUM_GB_OPTIONS NOT found.
FORUM_GUESTBOOK NOT found.
FORUM_IPLIST NOT found.
FORUM_IPLOG NOT found.
FORUM_MAILLIST NOT found.
FORUM_NOTES NOT found.
FORUM_PM NOT found.
FORUM_POLLS NOT found.
FORUM_POLL_VOTES NOT found.
FORUM_RATINGS NOT found.
FORUM_REV NOT found.
FORUM_REVIEWS NOT found.
FORUM_REV_OPTIONS NOT found.
FORUM_ANNOUNCE NOT found.


Thanks in advance,

(forgive the 'anal' composition of the post...just wanted to be clear) :)

[Jerry]

What type of database is the source ? MS-SQL ?

I take it there were other tables that were green and found ?

Are the tables upper or lower case in the source database ?

[MistyPotato]

What type of database is the source ? MS-SQL ?
Yes, originally.
I exported the database from MS-SQL to MSACCESS then imported that into MySQL. Then I ran Impex on the newly created MySQL database.

"I take it there were other tables that were green and found ?"
Yes. All the tables that actually existed were found no problem.

Are the tables upper or lower case in the source database ?
I changed them to all upper case.

[Jerry]

Are the tables upper or lower case in the source database ?
I changed them to all upper case.

And they stayed upper case ?

From the looks of the SQL error :

"oldforum.forum_avatar"

ImpEx has a lower case table prefix and lower case table name.

I'm thinking the switch I just added to the ImpExConfig will help here.

[MistyPotato]

Hi again Jerry,

Not sure we're communicating clearly.

I can easily change the tables "case" as desired. I did run into the uppercase/lowercase issue at first but got that licked.

The problem is that Impex is looking for tables that actually do not and have not ever existed in my Snitz forum database.

It's as if I have a version of Snitz (3.4.05) that never had any of these tables....
FORUM_ACTIVE_USERS NOT found.
FORUM_ALBUM NOT found.
FORUM_ALBUM_CAT NOT found.
FORUM_ALBUM_CONFIG NOT found.
FORUM_ALBUM_USERS NOT found.
FORUM_AVATAR NOT found.
FORUM_AVATAR2 NOT found.
FORUM_BOOKMARKS NOT found.
FORUM_FILELISTER NOT found.
FORUM_FILELISTER_CAT NOT found.
FORUM_FILELISTER_CONFIG NOT found.
FORUM_FILELISTER_USERS NOT found.
FORUM_FILES NOT found.
FORUM_GB_OPTIONS NOT found.
FORUM_GUESTBOOK NOT found.
FORUM_IPLIST NOT found.
FORUM_IPLOG NOT found.
FORUM_MAILLIST NOT found.
FORUM_NOTES NOT found.
FORUM_PM NOT found.
FORUM_POLLS NOT found.
FORUM_POLL_VOTES NOT found.
FORUM_RATINGS NOT found.
FORUM_REV NOT found.
FORUM_REVIEWS NOT found.
FORUM_REV_OPTIONS NOT found.
FORUM_ANNOUNCE NOT found.

They simply do not exist in my currently running snitz forum.
If they don't exist, upper and lower case is irrelevant.
I'm wondering why I have a snitz forum without all those other tables...
And how I'm going to import using just the ones I have.

I went over to the Snitz community and posted a question about the missing tables.
Seems like that part may have been more of a Snitz question than a vBulletin question.

[MistyPotato]

Good Morning!

I got a reply from a Snitz developer....

"Those table are a parts of various assorted MODs"

Which I take to mean that they are optional and do not necessarily have to be present.

Given that, Impex is basically saying "the table is not there...so abort"...
or not? Can I proceed even though certain Snitz tables do not exist?

Thanks

[MistyPotato]

After more independent research, as several discussions with Snitz tech support, it seems I will need to download ALL the mods missing from my Snitz install and create the database tables, then add them to my database before I can even attempt a migration.

Jerry, it seems you set up Impex on the assumption that ALL Snitz installs have ALL the mods included but that's not the case.

Of course, I do not presume to know anywher near what I'm sure you do about all this so this was written hoping that you would clarify it.

Thanks

[Jerry]

The table list I made for the Snitz importer was compiled from a few test databases I had been given from customers, they were the same so I believed that to be the default table list.

As it is the only tables ImpEx needs for the import are :


MEMBERS
CATEGORY
FORUM
MODERATOR
PM
POLLS
REPLY
A_REPLY
SMILES
TOPICS
A_TOPICS
MEMBERS
AVATAR


Though you can be missing tables and ImpEx will just not import anything dependant on them.

For example you can be missing PMs and POLLs though the rest will be fine, you just wont' have the PMs or POLLs.

ImpEx gets what it can, its not an all or nothing operation :)