Importing issues from PHPBBXS...

[phubbell]

Hello everyone! I'm new to the vbulletin world. I currently has a site running PHPBBXS based off PHPBB 2.0.21 I installed VB into a seperate directory, created the MySQL DB and it connects fine. However, when I start all the importing processes, there are a few issues I am running into:

1. No Users import at all. Once I click to run module, it immediately goes to Done and all is blank.

2. Imports 5 categories and 54 forums - but nothing shows in Forum Management?

3. Importing posts, is it supposed to look as below?? Has many blanks entries.. and it says it imported 10K+ posts

2135 62.50% Post ->
2136 68.75% Post -> ack154
2137 62.50% Post ->
2138 62.50% Post ->
2139 62.50% Post ->
2140 68.75% Post -> xTXxBOIx
2141 62.50% Post ->
2142 68.75% Post -> Gunz4Sale
2143 62.50% Post ->
2144 62.50% Post ->
2145 68.75% Post -> xTXxBOIx
2146 62.50% Post ->
2147 62.50% Post ->
2148 62.50% Post ->
2149 68.75% Post -> ack154
2150 68.75% Post -> Gunz4Sale
2151 62.50% Post ->

Is there something I may need to change in the tables?? I tried to lookup PHPBBXS on the forums, I did not locate any with this version of PHPBB.

Thanks in advance for your help!!

Paul

[Jerry]

As I understand it phpbbxs is phpbb with a lot of hacks installed.

1. Probably a different user table.

2. Save the forum display.

3. It's displaying the username of the owner of the post, blank means it didn't find the user who owns that post, though the post was still imported.

[phubbell]

Pardon my ignorance, but on the #2 - Save Forum Display?? Not understanding if I have to do something here??

Also, on the users table, I have inserted the table list:


`phpbb_users` (
`user_id` mediumint(8) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`username` varchar(25) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_http_agents` varchar(255) NOT NULL default '',
`user_lastvisit` int(11) NOT NULL default '0',
`user_regdate` int(11) NOT NULL default '0',
`user_level` tinyint(4) default '0',
`user_posts` mediumint(8) unsigned NOT NULL default '0',
`user_timezone` decimal(5,2) NOT NULL default '0.00',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) default NULL,
`user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_viewemail` tinyint(1) default NULL,
`user_profile_view_popup` tinyint(1) default '0',
`user_attachsig` tinyint(1) default NULL,
`user_setbm` tinyint(1) NOT NULL default '0',
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '1',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_rank` int(11) default '0',
`user_rank2` int(11) default '-1',
`user_rank3` int(11) default '-2',
`user_rank4` int(11) default '-2',
`user_rank5` int(11) default '-2',
`user_avatar` varchar(100) default NULL,
`user_avatar_type` tinyint(4) NOT NULL default '0',
`user_email` varchar(255) default NULL,
`user_icq` varchar(15) default NULL,
`user_website` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_sig` text,
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_aim` varchar(255) default NULL,
`user_yim` varchar(255) default NULL,
`user_msnm` varchar(255) default NULL,
`user_occ` varchar(100) default NULL,
`user_interests` varchar(255) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`ct_logintry` int(2) default '0',
`ct_unsucclogin` int(10) default NULL,
`ct_pwreset` int(2) NOT NULL default '0',
`ct_mailcount` int(10) NOT NULL default '0',
`ct_postcount` int(10) NOT NULL default '0',
`ct_posttime` int(10) NOT NULL default '0',
`ct_searchcount` int(10) NOT NULL default '0',
`ct_searchtime` int(10) NOT NULL default '0',
`user_birthday` int(11) NOT NULL default '999999',
`user_next_birthday_greeting` int(11) NOT NULL default '0',
`user_sub_forum` tinyint(1) NOT NULL default '1',
`user_split_cat` tinyint(1) NOT NULL default '1',
`user_last_topic_title` tinyint(1) NOT NULL default '1',
`user_sub_level_links` tinyint(1) NOT NULL default '2',
`user_display_viewonline` tinyint(1) NOT NULL default '2',
`user_color_group` mediumint(8) unsigned NOT NULL default '0',
`user_gender` tinyint(4) NOT NULL default '0',
`user_lastlogon` int(11) NOT NULL default '0',
`user_totaltime` int(11) default '0',
`user_totallogon` int(11) default '0',
`user_totalpages` int(11) default '0',
`user_calendar_display_open` tinyint(1) NOT NULL default '0',
`user_calendar_header_cells` tinyint(1) NOT NULL default '5',
`user_calendar_week_start` tinyint(1) NOT NULL default '1',
`user_calendar_nb_row` tinyint(2) unsigned NOT NULL default '5',
`user_calendar_birthday` tinyint(1) NOT NULL default '1',
`user_calendar_forum` tinyint(1) NOT NULL default '1',
`user_warnings` smallint(5) default '0',
`user_time_mode` tinyint(4) NOT NULL default '5',
`user_dst_time_lag` tinyint(4) NOT NULL default '60',
`user_pc_timeOffsets` varchar(11) NOT NULL default '0',
`user_skype` varchar(255) default NULL,
`user_registered_ip` varchar(8) default NULL,
`user_registered_hostname` varchar(255) default NULL,
`user_profile_view` smallint(5) NOT NULL default '0',
`user_last_profile_view` int(11) NOT NULL default '0',
`user_topics_per_page` varchar(5) default NULL,
`user_hot_threshold` varchar(5) default NULL,
`user_posts_per_page` varchar(5) default NULL,
`user_allowswearywords` tinyint(1) NOT NULL default '0',
`user_showavatars` tinyint(1) default '1',
`user_showsignatures` tinyint(1) default '1',
`user_login_tries` smallint(5) unsigned NOT NULL default '0',
`user_last_login_try` int(11) NOT NULL default '0',
`user_session_topic` int(11) NOT NULL default '0',
`user_sudoku_playing` int(1) NOT NULL default '0',
`chapter` varchar(255) default 'Scikotics Groupie',
`first_name` varchar(12) default NULL,
`car_model` text,
`my_pic` text,
`user_from_flag` varchar(30) default NULL,
`user_phone` varchar(255) default NULL,
`user_selfdes` text,
`user_upi2db_which_system` tinyint(1) NOT NULL default '1',
`user_upi2db_disable` tinyint(1) NOT NULL default '0',
`user_upi2db_datasync` int(11) NOT NULL default '0',
`user_upi2db_new_word` tinyint(1) NOT NULL default '1',
`user_upi2db_edit_word` tinyint(1) NOT NULL default '1',
`user_upi2db_unread_color` tinyint(1) NOT NULL default '1',
`user_personal_pics_count` int(11) NOT NULL default '0',

[Jerry]

In the forum manager in vBulletin, save the display order at the bottom, it rebuilds the forum cache and that user table looks correct.

[phubbell]

OK, well the forums are in there...thanks very much. Now, just the users are not pulling over :-( Any ideas??

[Jerry]

OK, well the forums are in there...thanks very much. Now, just the users are not pulling over :-( Any ideas??

I can't see why it wouldn't be importing them, the user table appears to be the same, or close enough to phpBB's one.

Are there any ImpEx created usergroups ?

[phubbell]

There are 7 default groups
8 custom with 5 of those being my user groups and the 3 all ready there.

[Jerry]

And the member counts of thoses groups are 0 ?