field list error message importing....

[Benz0]

any ever get this error? I am importing from phpBB1 > 3.6.8, both db's are o nteh same server and connections are not a problem...
I get to importing the posts and this comes up everytime...ideas?


ImpEx Database errormysql error: Invalid SQL:
SELECT post_text, post_title FROM phpbb_posts_text
WHERE
post_id='528'


mysql error: Unknown column 'post_title' in 'field list'

mysql error number: 1054

Date: Friday 10th of August 2007 10:51:07 AM
Database: geekcube_oldvroc
MySQL error: Unknown column 'post_title' in 'field list'

[Jerry]

What version of phpBB1 ? as in 1.4 they are valid fields.

[Benz0]

I am trying to get that info from them


I tried both php version but I get some red fields on 1.4 here:


phpbb_Moderator_Action NOT found.
phpbb_access NOT found.
phpbb_backup NOT found.
phpbb_forum_access NOT found.
phpbb_forum_mods NOT found.
phpbb_free_email NOT found.
phpbb_headermetafooter NOT found.
phpbb_ignore_list NOT found.
phpbb_installdefs NOT found.
phpbb_lforums NOT found.
phpbb_markread NOT found.
phpbb_poll_data NOT found.
phpbb_poll_topics NOT found.
phpbb_priv_msgs NOT found.
phpbb_sessionkeys NOT found.
phpbb_smiles NOT found.
phpbb_spellcheck_words NOT found.
phpbb_subscribe NOT found.
phpbb_visitors NOT found.
phpbb_whosonline NOT found.

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

# phpbb_auth_


but when I use phpBB2 I only get the following error tables:


Possibly custom tables or incorrect prefix :

phpbb_attachments NOT found.
phpbb_attachments_desc NOT found.

[Jerry]

With that many missing it's most likely an older version 1. Though finding out will help us proceed and get it imported.

[Benz0]

With that many missing it's most likely an older version 1. Though finding out will help us proceed and get it imported.

I was told it's phpBB 2.0.22

[Jerry]

I was told it's phpBB 2.0.22

Well then use the phpBB2 importer and not the phpBB1 and see what tables show, if there are lots of hacks or mods there will be some tables that are red as long as you have green ones : users, groups, categories etc then it will be ok.

[Benz0]

Thanks - I ran the phpBB2 and here are the results - there looks to be a couple of missing tables but I will see if the rest of the Import process works out...


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 :

phpbb_auth_access found.
phpbb_banlist found.
phpbb_categories found.
phpbb_config found.
phpbb_confirm found.
phpbb_disallow found.
phpbb_forum_prune found.
phpbb_forums found.
phpbb_groups found.
phpbb_posts found.
phpbb_posts_text found.
phpbb_privmsgs found.
phpbb_privmsgs_text found.
phpbb_ranks found.
phpbb_search_results found.
phpbb_search_wordlist found.
phpbb_search_wordmatch found.
phpbb_sessions found.
phpbb_smilies found.
phpbb_themes found.
phpbb_themes_name found.
phpbb_topics found.
phpbb_topics_watch found.
phpbb_user_group found.
phpbb_users found.
phpbb_vote_desc found.
phpbb_vote_results found.
phpbb_vote_voters found.
phpbb_words found.

Possibly custom tables or incorrect prefix :

phpbb_attachments NOT found.
phpbb_attachments_desc NOT found.

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

# phpbb_


Thanks!
Ben

[Jerry]

Just means you don't have the attachment mod installed, so just skip that module.