Errors after "Check and Update Database"

[curano]

All impex uploaded with modified ImpExConfig.php.
"Check and Update Database" provides the following error messages:

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 refrences 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 origional 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
filedata - importfiledataid OK

---

Testing source against : wowBB ::0.0.1

Valid found tables :


Possibly custom tables or incorrect prefix :

attachments NOT found.
cache NOT found.
categories NOT found.
emoticons NOT found.
forum_permissions NOT found.
forums NOT found.
lexicon NOT found.
mana_transfers NOT found.
manas NOT found.
moderators NOT found.
notifications NOT found.
payment_gateways NOT found.
pm NOT found.
pm_folders NOT found.
pm_texts NOT found.
poll_options NOT found.
poll_questions NOT found.
poll_votes NOT found.
post_texts NOT found.
posts NOT found.
ratings NOT found.
search_index NOT found.
sessions NOT found.
subscription_types NOT found.
topics NOT found.
transactions NOT found.
user_groups NOT found.
users NOT found.
visitor_log NOT found.
watched_forums NOT found.

If you have all red tables, i.e. none correct this could possible be your table prefix :

wowbb_

Failed Check database permissions and connection, or table prefix to ensure its correct


-----------

I didn't have set a table prefix, it's set to ''

Any ideas?

[Trevor Hannant]

When you open phpMyAdmin and look at the list of tables in the left column, how are they shown:

attachments
cache
etc.

or:

prefix_attachments
prefix_cache
etc.

[curano]

It shows:

prefix_database

Should I set the name "database" into the field database and "prefix" without underscore into the field prefix ?

Thanks for your effort

[Jake Bunce]

It shows:

prefix_database

Should I set the name "database" into the field database and "prefix" without underscore into the field prefix ?

Thanks for your effort

If the database name itself has a prefix then that would be part of the $impexconfig['source']['database'] setting in the impex/ImpExConfig.php file. Trevor is talking about the table prefix which would be a common prefix shared by all of the tables within the database. The table prefix is the $impexconfig['source']['tableprefix'] setting.