IMPEX Failing to see database tables

[DirtyBirdNJ]

Hello, I have been working on trying to import from an eve/groupee forum to vBulletin 3.7. Today I got into work and noticed that 3.8 went gold... so my first order of business is upgrading to 3.8 from 3.7.4.

So here's my problem... I spent about a day backing up our database because the only access we have to it is through phpMyAdmin... and the execution time limit prevented me from doing one contiguous DB dump. SO... I backed up each of the 116 tables one by one... and I'm finally done.

Now when I try to run impex... it's telling me it can't see certian tables that are most definately there. First... here is the output of "SHOW TABLES;" on my backed up old forum data:

mysql> use eve_import;
Database changed
mysql> show tables;
+---------------------------------+
| Tables_in_eve_import            |
+---------------------------------+
| c_categories                    |
| c_items                         |
| c_revision_logs                 |
| c_revisions                     |
| c_staging                       |
| c_tag_to_rev_join               |
| c_tags                          |
| cache                           |
| content_islands                 |
| current_db_version              |
| database_info                   |
| forums                          |
| group_topic_events              |
| group_topic_participants        |
| group_topics                    |
| ip_a_album                      |
| ip_a_album_image                |
| ip_album_images                 |
| ip_albums                       |
| ip_archived_topics              |
| ip_banned_users                 |
| ip_c_content                    |
| ip_c_content_island             |
| ip_c_content_lookup             |
| ip_c_content_report             |
| ip_c_content_type               |
| ip_c_extended_data              |
| ip_c_guest_user                 |
| ip_c_moderated_content          |
| ip_c_rated_content              |
| ip_c_search_event               |
| ip_c_upload                     |
| ip_c_user_favorite              |
| ip_c_user_interest_log          |
| ip_cat_category                 |
| ip_cat_resource_category        |
| ip_chat_emote                   |
| ip_chat_message                 |
| ip_chat_moderated_message       |
| ip_chat_participant             |
| ip_chat_room                    |
| ip_chat_topic_messages          |
| ip_chat_topic_unmod_queue       |
| ip_chat_topics                  |
| ip_clone_source_and_dest        |
| ip_content_subscriptions        |
| ip_cust_album_category          |
| ip_cust_location                |
| ip_custom_codes                 |
| ip_custom_profile_fields        |
| ip_display_options              |
| ip_display_res_associations     |
| ip_display_resources            |
| ip_event_log                    |
| ip_f_forum                      |
| ip_f_forum_accepted_post_type   |
| ip_f_forum_attachment_rule      |
| ip_f_forum_mod_content_type     |
| ip_f_forum_stats                |
| ip_f_forum_topic                |
| ip_f_stats_consolidation        |
| ip_group_users                  |
| ip_groups                       |
| ip_highlighted_topics           |
| ip_ignored_users                |
| ip_im_active_menus              |
| ip_im_participants              |
| ip_karma_levels                 |
| ip_message_alerts               |
| ip_p_poll                       |
| ip_p_poll_answer                |
| ip_p_poll_question              |
| ip_p_poll_response              |
| ip_permissions                  |
| ip_premium_group_settings       |
| ip_private_web_directories      |
| ip_profiles                     |
| ip_pt_private_topic             |
| ip_pt_private_topic_participant |
| ip_resources                    |
| ip_rights                       |
| ip_rw_locks2                    |
| ip_session_activity             |
| ip_settings                     |
| ip_ss_image_dimensions          |
| ip_statistics                   |
| ip_street_addresses             |
| ip_style_sets                   |
| ip_style_settings               |
| ip_t_archived_message           |
| ip_t_archived_topic             |
| ip_t_message                    |
| ip_t_message_to_delete          |
| ip_t_topic                      |
| ip_t_topic_stats                |
| ip_template_files               |
| ip_template_page_types          |
| ip_template_set_usage           |
| ip_template_sets                |
| ip_template_support_info        |
| ip_topics                       |
| ip_unconfirmed_users            |
| ip_user_contact_info            |
| ip_user_favorites               |
| ip_user_resource_info           |
| ip_user_stats                   |
| ip_users                        |
| ip_wordlet_sets                 |
| ip_wordlets                     |
| polls                           |
| style_sheets                    |
| unmod_message_queue             |
| uploads                         |
| url_lookup                      |
| user_info                       |
| xsl_schemes                     |
+---------------------------------+
116 rows in set (0.00 sec)

OK! Finally got all the tables imported... or so I thought. This is what I get when I run the first step of impex:

Altering tables
ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining references between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the original vB userid.
moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
usernote - importusernoteid OK
phrase - importphraseid OK
subscription - importsubscriptionid OK
subscriptionlog - importsubscriptionlogid OK

Valid found tables :


Possibly custom tables or incorrect prefix :

CACHE NOT found.
CONTENT_ISLANDS NOT found.
CURRENT_DB_VERSION NOT found.
C_CATEGORIES NOT found.
C_ITEMS NOT found.
C_REVISIONS NOT found.
C_REVISION_LOGS NOT found.
C_STAGING NOT found.
C_TAGS NOT found.
C_TAG_TO_REV_JOIN NOT found.
DATABASE_INFO NOT found.
FORUMS NOT found.
GROUP_TOPICS NOT found.
GROUP_TOPIC_EVENTS NOT found.
GROUP_TOPIC_PARTICIPANTS NOT found.
IP_ALBUMS NOT found.
IP_ALBUM_IMAGES NOT found.
IP_ARCHIVED_TOPICS NOT found.
IP_A_ALBUM NOT found.
IP_A_ALBUM_IMAGE NOT found.
IP_BANNED_USERS NOT found.
IP_CAT_CATEGORY NOT found.
IP_CAT_RESOURCE_CATEGORY NOT found.
IP_CHAT_TOPICS NOT found.
IP_CHAT_TOPIC_MESSAGES NOT found.
IP_CHAT_TOPIC_UNMOD_QUEUE NOT found.
IP_CLONE_SOURCE_AND_DEST NOT found.
IP_CONTENT_SUBSCRIPTIONS NOT found.
IP_CUSTOM_CODES NOT found.
IP_CUSTOM_PROFILE_FIELDS NOT found.
IP_C_CONTENT NOT found.
IP_C_CONTENT_ISLAND NOT found.
IP_C_CONTENT_LOOKUP NOT found.
IP_C_CONTENT_REPORT NOT found.
IP_C_CONTENT_TYPE NOT found.
IP_C_EXTENDED_DATA NOT found.
IP_C_GUEST_USER NOT found.
IP_C_MODERATED_CONTENT NOT found.
IP_C_RATED_CONTENT NOT found.
IP_C_UPLOAD NOT found.
IP_C_USER_FAVORITE NOT found.
IP_C_USER_INTEREST_LOG NOT found.
IP_DISPLAY_OPTIONS NOT found.
IP_DISPLAY_RESOURCES NOT found.
IP_DISPLAY_RES_ASSOCIATIONS NOT found.
IP_EVENT_LOG NOT found.
IP_F_FORUM NOT found.
IP_F_FORUM_ACCEPTED_POST_TYPE NOT found.
IP_F_FORUM_ATTACHMENT_RULE NOT found.
IP_F_FORUM_MOD_CONTENT_TYPE NOT found.
IP_F_FORUM_STATS NOT found.
IP_F_FORUM_TOPIC NOT found.
IP_GROUPS NOT found.
IP_GROUP_USERS NOT found.
IP_HIGHLIGHTED_TOPICS NOT found.
IP_IGNORED_USERS NOT found.
IP_IM_ACTIVE_MENUS NOT found.
IP_IM_PARTICIPANTS NOT found.
IP_KARMA_LEVELS NOT found.
IP_MESSAGE_ALERTS NOT found.
IP_PERMISSIONS NOT found.
IP_PREMIUM_GROUP_SETTINGS NOT found.
IP_PROFILES NOT found.
IP_PT_PRIVATE_TOPIC NOT found.
IP_PT_PRIVATE_TOPIC_PARTICIPANT NOT found.
IP_P_POLL NOT found.
IP_P_POLL_ANSWER NOT found.
IP_P_POLL_QUESTION NOT found.
IP_P_POLL_RESPONSE NOT found.
IP_RESOURCES NOT found.
IP_RIGHTS NOT found.
IP_RW_LOCKS2 NOT found.
IP_SESSION_ACTIVITY NOT found.
IP_SETTINGS NOT found.
IP_SS_IMAGE_DIMENSIONS NOT found.
IP_STATISTICS NOT found.
IP_STREET_ADDRESSES NOT found.
IP_STYLE_SETS NOT found.
IP_STYLE_SETTINGS NOT found.
IP_TEMPLATE_FILES NOT found.
IP_TEMPLATE_PAGE_TYPES NOT found.
IP_TEMPLATE_SETS NOT found.
IP_TEMPLATE_SET_USAGE NOT found.
IP_TEMPLATE_SUPPORT_INFO NOT found.
IP_TOPICS NOT found.
IP_T_ARCHIVED_MESSAGE NOT found.
IP_T_ARCHIVED_TOPIC NOT found.
IP_T_MESSAGE NOT found.
IP_T_TOPIC NOT found.
IP_T_TOPIC_STATS NOT found.
IP_UNCONFIRMED_USERS NOT found.
IP_USERS NOT found.
IP_USER_CONTACT_INFO NOT found.
IP_USER_FAVORITES NOT found.
IP_USER_RESOURCE_INFO NOT found.
IP_WORDLETS NOT found.
IP_WORDLET_SETS NOT found.
POLLS NOT found.
UNMOD_MESSAGE_QUEUE NOT found.
UPLOADS NOT found.
URL_LOOKUP NOT found.
USER_INFO NOT found.
IP_C_SEARCH_EVENT NOT found.
IP_T_MESSAGE_TO_DELETE NOT found.
IP_USER_STATS NOT found.

Ok... the tables are there but impex won't or can't see them. Maybe it's a case sensitivity issue? I tried to rename the cache table to "CACHE", and mysql told me that the table already exists.

Very confused... and no idea where to go from here. I tried to post on the official vBulletin forums in their IMPEX board... but I'm not allowed to post yet because I just registered there today.

--------------- Added [DATE]1231449930[/DATE] at [TIME]1231449930[/TIME] ---------------

Hello everybody, I wanted to post the solution I just recieved from a vBulletin help ticket.

In the ImpExConfig.php file, there is a line like this:

define('lowercase_table_names', true);

Like you can see above, all my table names are lowercase... and all the tables that impex was looking for were uppercase. Setting this to 'true' solved my problem quicker than I had ever imagined.