I have no PHPBB2 data transfers at import

[semaXD]

Here is my server info first.



I have Impex installed and I have the phpbb2 database from my other server and forum uploaded. When I run the import modules it runs but does not bring the data in. I get this on the first module:

<--------------------------------------------------------->
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 Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed

Valid found tables :

ranks found.

Possibly custom tables or incorrect prefix :

attachments NOT found.
attachments_desc NOT found.
auth_access NOT found.
banlist NOT found.
categories NOT found.
config NOT found.
confirm NOT found.
disallow NOT found.
forum_prune NOT found.
forums NOT found.
groups NOT found.
posts NOT found.
posts_text NOT found.
privmsgs NOT found.
privmsgs_text NOT found.
search_results NOT found.
search_wordlist NOT found.
search_wordmatch NOT found.
sessions NOT found.
smilies NOT found.
themes NOT found.
themes_name NOT found.
topics NOT found.
topics_watch NOT found.
user_group NOT found.
users NOT found.
vote_desc NOT found.
vote_results NOT found.
vote_voters NOT found.
words NOT found.

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


phpbb_

<------------------------------------------------------------------->

I didnt need to run the 2nd module as it is a fresh install.
this a shot after i ran all the modules.



I went through each module in order. below are the screen shots of the ones that are unique and the rest got nothing.
module 005

Module 009

the rest said this


so what am i missing here? did i do the install wrong?
any help would be appriciated

thanks, Jim

[Steve Machol]

As noted in the error message:

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

phpbb_

You need to set the source table prefix to: phpbb_

[semaXD]

here is a copy of the file on the database do all of these nee that prefix i see some have it but not all fo them

[Jerry]

As Steve said, You need to set the source table prefix to: phpbb_.

Edit your ImpExConfig to include this :



$impexconfig['source']['tableprefix'] = 'phpbb_';

[semaXD]

oh, duh hahah thanks i was over thinking it that did it!

One question if I want to update the database i just loaded to VB with the post and users that have been added to my phpbb2 forum since i started this change over what is the best way to do that

[Steve Machol]

There is no way to do a partial import. The best way to do this is to remove all the imported data and redo your import from scratch.

[semaXD]

thanks steve kinda what i figured thought id check though
jim