Hey Guy, I have been looking for my notes that I took when I converted, but I have been packing things up because I am moving from NH to NC in a few weeks.. and I can't find the notebook for the site.
I remember it was in the Profile Portal table that was giving me trouble. I had to add a few fields to the table, the ones it was missing to get the importer to run correctly.
The fields I added weren't there to begin with, so there was no date, so I added a empty field for each of them that was missing the Impex ran without a problem and converted everything as expected.
The only thought I came away with was it had to be one of the community apps from IPB I had installed since it was looking for links, and one of the apps I installed was IP.Links.
Here is the table structure for the Profile Portal table on my old vB database I converted to xF. On your test site load this up and compare it to your test site.
CREATE TABLE IF NOT EXISTS `profile_portal` (
`pp_member_id` int(10) NOT NULL default '0',
`pp_profile_update` int(10) unsigned NOT NULL default '0',
`pp_bio_content` text,
`pp_last_visitors` text,
`pp_comment_count` int(10) unsigned NOT NULL default '0',
`pp_rating_hits` int(10) unsigned NOT NULL default '0',
`pp_rating_value` int(10) unsigned NOT NULL default '0',
`pp_rating_real` int(10) unsigned NOT NULL default '0',
`pp_friend_count` int(5) unsigned NOT NULL default '0',
`pp_main_photo` varchar(255) NOT NULL default '',
`pp_main_width` int(5) unsigned NOT NULL default '0',
`pp_main_height` int(5) unsigned NOT NULL default '0',
`pp_thumb_photo` varchar(255) NOT NULL default '',
`pp_thumb_width` int(5) unsigned NOT NULL default '0',
`pp_thumb_height` int(5) unsigned NOT NULL default '0',
`pp_gender` varchar(10) NOT NULL default '',
`pp_setting_notify_comments` varchar(10) NOT NULL default 'email',
`pp_setting_notify_friend` varchar(10) NOT NULL default 'email',
`pp_setting_moderate_comments` tinyint(1) NOT NULL default '0',
`pp_setting_moderate_friends` tinyint(1) NOT NULL default '0',
`pp_setting_count_friends` int(2) NOT NULL default '0',
`pp_setting_count_comments` int(2) NOT NULL default '0',
`pp_setting_count_visitors` int(2) NOT NULL default '0',
`pp_profile_views` int(10) NOT NULL default '0',
`pp_about_me` mediumtext,
`pp_reputation_points` int(10) NOT NULL default '0',
`notes` text,
`links` text,
`bio` text,
`ta_size` varchar(3) default NULL,
`signature` text,
`avatar_location` varchar(255) default NULL,
`avatar_size` varchar(9) NOT NULL default '0',
`avatar_type` varchar(15) default NULL,
`pconversation_filters` text,
`fb_photo` text,
`fb_photo_thumb` text,
`fb_bwoptions` int(10) unsigned NOT NULL default '0',
`pp_status` text,
`pp_status_update` varchar(13) NOT NULL default '0',
`tc_last_sid_import` bigint(20) unsigned NOT NULL default '0',
`tc_photo` text,
`tc_bwoptions` int(10) unsigned NOT NULL default '0',
`pp_customization` mediumtext,
PRIMARY KEY (`pp_member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Sorry I can't be more help. When I was at work looking at this thread, I thought it would be easy to find my notebook.. not so when you're in the middle of packing..
Jamie