IMPortal is very much "do it yourself" ...

[Coder]

Sounds harsh? After asking several times here about upgrading a vanilla phpBB with IMPortal to IM 1.4.1 I came to the conclusion that the dev team have lost interest! All this new space-invader stuff has gone to their heads, they don't even look back here any more. Witness the number of responses made to questions by posters here, where the response isn't from the OP themselves along the lines of "NM, I figured it out" or no response (they deleted the whole thing and started over??) !!

For those who, like me, made the mistake of downloading IMPortal thinking it was upgradeable to later versions, the bad news is, it isn't! The following is a series of sql changes - save this as a .sql file and apply it to your IMPortal database after you back it up. Once done, back up the modified database again (to a separate file). Then you can install IM 1.4.1 and edit your backup. You will need to remove all the board config stuff from the backup, leaving basically the groups, users, posts and priv stuff. Upload your modified backup and you should be pretty well online - once you've configured IM 1.4.1 the way you want it that is!!!

Here's the changes for the tables from IMPortal to IM 1.4.1 code]  ALTER TABLE `phpbb_auth_access` ADD `auth_global_announce` tinyint(1) NOT NULL default '0' AFTER `auth_announce` ;   ALTER TABLE `phpbb_auth_access` ADD `auth_download` tinyint(1) NOT NULL default '0';   ALTER TABLE `phpbb_auth_access` ADD `auth_news` tinyint(1) NOT NULL default '0';   ALTER TABLE `phpbb_auth_access` ADD `auth_cal` tinyint(1) NOT NULL default '0';   ALTER TABLE `phpbb_auth_access` ADD `auth_ban` tinyint(1) NOT NULL default '0';   ALTER TABLE `phpbb_auth_access` ADD `auth_greencard` tinyint(1) NOT NULL default '0';   ALTER TABLE `phpbb_auth_access` ADD `auth_bluecard` tinyint(1) NOT NULL default '0';   ALTER TABLE `phpbb_auth_access` ADD `auth_delayedpost` tinyint(4) NOT NULL default '3';     ALTER TABLE `phpbb_banlist` CHANGE `ban_userid` `ban_userid` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL ;   ALTER TABLE `phpbb_banlist` CHANGE `ban_ip` `ban_ip` varchar( 8 ) NOT NULL;   ALTER TABLE `phpbb_banlist` AUTO_INCREMENT = 1;     ALTER TABLE `phpbb_categories` CHANGE `cat_order` `cat_order` mediumint( 8 ) UNSIGNED default '0' NOT NULL;   ALTER TABLE `phpbb_categories` ADD `cat_main_type` char( 1 ) default NULL;   ALTER TABLE `phpbb_categories` ADD `cat_main` mediumint( 8 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_categories` ADD `cat_desc` text NOT NULL;   ALTER TABLE `phpbb_categories` ADD `icon` varchar( 255 ) default NULL;   ALTER TABLE `phpbb_categories` AUTO_INCREMENT = 4;     ALTER TABLE `phpbb_config` CHANGE `config_name` `config_name` varchar( 255 ) NOT NULL;   ALTER TABLE `phpbb_config` CHANGE `config_value` `config_value` varchar( 255 ) NOT NULL;     ALTER TABLE `phpbb_confirm` CHANGE `code` `code` char( 10 ) NOT NULL;     ALTER TABLE `phpbb_forum_prune` CHANGE `forum_id` `forum_id` smallint( 5 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_forum_prune` CHANGE `prune_days` `prune_days` smallint( 5 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_forum_prune` CHANGE `prune_freq` `prune_freq` smallint( 5 ) unsigned NOT NULL default '0';     ALTER TABLE `phpbb_forums` CHANGE `forum_id` `forum_id` smallint( 5 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_forums` CHANGE `cat_id` `cat_id` mediumint( 8 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_forums` ADD `auth_global_announce` tinyint( 2 ) NOT NULL default '0' AFTER `auth_announce` ;   ALTER TABLE `phpbb_forums` ADD `auth_download` tinyint( 2 ) NOT NULL default '0';   ALTER TABLE `phpbb_forums` ADD `auth_news` tinyint( 2 ) NOT NULL default '2';   ALTER TABLE `phpbb_forums` ADD `forum_link` varchar( 255 ) default NULL;   ALTER TABLE `phpbb_forums` ADD `forum_link_internal` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_forums` ADD `forum_link_hit_count` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_forums` ADD `forum_link_hit` bigint( 20 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_forums` ADD `icon` varchar( 255 ) default NULL;   ALTER TABLE `phpbb_forums` ADD `main_type` char( 1 ) default NULL;   ALTER TABLE `phpbb_forums` ADD `auth_cal` tinyint( 2 ) NOT NULL default '0';   ALTER TABLE `phpbb_forums` ADD `auth_ban` tinyint( 2 ) NOT NULL default '3';   ALTER TABLE `phpbb_forums` ADD `auth_greencard` tinyint( 2 ) NOT NULL default '5';   ALTER TABLE `phpbb_forums` ADD `auth_bluecard` tinyint( 2 ) NOT NULL default '1';   ALTER TABLE `phpbb_forums` ADD `auth_delayedpost` tinyint( 4 ) NOT NULL default '3';     ALTER TABLE `phpbb_groups` CHANGE `group_name` `group_name` varchar( 40 ) NOT NULL;   ALTER TABLE `phpbb_groups` CHANGE `group_de.scription` `group_de.scription` varchar( 255 ) NOT NULL;   ALTER TABLE `phpbb_groups` ADD `group_count` int( 4 ) unsigned default '99999999';   ALTER TABLE `phpbb_groups` ADD `group_count_max` int( 4 ) unsigned default '99999999';   ALTER TABLE `phpbb_groups` ADD `group_count_enable` smallint( 2 ) unsigned default '0';   ALTER TABLE `phpbb_groups` ADD `group_amount` float default '0';   ALTER TABLE `phpbb_groups` ADD `group_period` int( 11 ) default '1';   ALTER TABLE `phpbb_groups` ADD `group_period_basis` VARCHAR( 10 ) DEFAULT 'M';   ALTER TABLE `phpbb_groups` ADD `group_first_trial_fee` float default '0';   ALTER TABLE `phpbb_groups` ADD `group_first_trial_period` int( 11 ) default '0';   ALTER TABLE `phpbb_groups` ADD `group_first_trial_period_basis` varchar( 10 ) default '0';   ALTER TABLE `phpbb_groups` ADD `group_second_trial_fee` float default '0';   ALTER TABLE `phpbb_groups` ADD `group_second_trial_period` int( 11 ) default '0';   ALTER TABLE `phpbb_groups` ADD `group_second_trial_period_basis` varchar( 10 ) default '0';   ALTER TABLE `phpbb_groups` ADD `group_sub_recurring` int( 11 ) default '1';   ALTER TABLE `phpbb_groups` ADD `group_sub_recurring_stop` int( 11 ) default '0';   ALTER TABLE `phpbb_groups` ADD `group_sub_recurring_stop_num` int( 11 ) default '0';   ALTER TABLE `phpbb_groups` ADD `group_sub_reattempt` int( 11 ) default '1';   ALTER TABLE `phpbb_groups` AUTO_INCREMENT = 6;     ALTER TABLE `phpbb_posts` CHANGE `poster_ip` `poster_ip` varchar( 8 ) NOT NULL ;   ALTER TABLE `phpbb_posts` ADD `post_attachment` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_posts` ADD `post_icon` tinyint( 2 ) default NULL;   ALTER TABLE `phpbb_posts` ADD `post_bluecard` tinyint( 1 ) default NULL;   ALTER TABLE `phpbb_posts` ADD `rating_rank_id` smallint( 5 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_posts` ADD INDEX `post_icon` ( `post_icon` ) ;   ALTER TABLE `phpbb_posts` ADD INDEX `posts_ratingrankid` ( `rating_rank_id` ) ;   ALTER TABLE `phpbb_posts` AUTO_INCREMENT = 3;     ALTER TABLE `phpbb_posts_text` CHANGE `bbcode_uid` `bbcode_uid` varchar( 10 ) NOT NULL;   ALTER TABLE `phpbb_posts_text` CHANGE `post_subject` `post_subject` varchar( 60 ) default NULL ;     ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_ip` `privmsgs_ip` varchar( 8 ) NOT NULL ;   ALTER TABLE `phpbb_privmsgs` ADD `privmsgs_attachment` tinyint( 1 ) NOT NULL default '0' ;   ALTER TABLE `phpbb_privmsgs` AUTO_INCREMENT = 1;     ALTER TABLE `phpbb_privmsgs_text` CHANGE `privmsgs_bbcode_uid` `privmsgs_bbcode_uid` varchar( 10 ) NOT NULL default '0' ;     ALTER TABLE `phpbb_ranks` CHANGE `rank_title` `rank_title` varchar( 255 ) NOT NULL;   ALTER TABLE `phpbb_ranks` ADD `rank_max` mediumint( 8 ) NOT NULL default '0' AFTER `rank_min` ;   ALTER TABLE `phpbb_ranks` AUTO_INCREMENT = 2;     ALTER TABLE `phpbb_sessions` CHANGE `session_id` `session_id` varchar( 32 ) NOT NULL ;   ALTER TABLE `phpbb_sessions` CHANGE `session_ip` `session_ip` varchar( 8 ) NOT NULL default '0' ;   ALTER TABLE `phpbb_sessions` ADD `session_robot` varchar( 32 ) default NULL AFTER `session_logged_in` ;     ALTER TABLE `phpbb_themes` AUTO_INCREMENT = 2;     ALTER TABLE `phpbb_topics` CHANGE `topic_title` `topic_title` varchar( 60 ) NOT NULL ;   ALTER TABLE `phpbb_topics` ADD `topic_desc` varchar( 255 ) default '' AFTER `topic_title` ;   ALTER TABLE `phpbb_topics` ADD `topic_info` varchar( 20 ) default NULL AFTER `topic_status` ;   ALTER TABLE `phpbb_topics` ADD `topic_attachment` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_topics` ADD `news_id` int( 10 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_topics` ADD `topic_announce_duration` mediumint( 5 ) NOT NULL default '0';   ALTER TABLE `phpbb_topics` ADD `topic_calendar_time` int( 11 ) default NULL;   ALTER TABLE `phpbb_topics` ADD `topic_calendar_duration` int( 11 ) default NULL;   ALTER TABLE `phpbb_topics` ADD `topic_icon` tinyint( 2 ) default NULL;   ALTER TABLE `phpbb_topics` ADD `topic_calendar_repeat` varchar( 4 ) default NULL;   ALTER TABLE `phpbb_topics` ADD `rating_rank_id` smallint( 5 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_topics` ADD INDEX `news_id` ( `news_id` )                         ;   ALTER TABLE `phpbb_topics` ADD INDEX `topic_calendar_time` ( `topic_calendar_time` ) ;   ALTER TABLE `phpbb_topics` ADD INDEX `topics_ratingrankid` ( `rating_rank_id` )      ;   ALTER TABLE `phpbb_topics` ADD INDEX `topic_first_post_id` ( `topic_first_post_id` ) ;   ALTER TABLE `phpbb_topics` AUTO_INCREMENT = 3;     ALTER TABLE `phpbb_user_group` ADD `group_moderator` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_user_group` ADD `ug_expire_date` int( 11 ) default '0';   ALTER TABLE `phpbb_user_group` ADD `ug_active_date` int( 11 ) default '0';     ALTER TABLE `phpbb_users` CHANGE `user_id` `user_id` mediumint( 8 ) NOT NULL default '0' ;   ALTER TABLE `phpbb_users` CHANGE `username` `username` varchar( 25 ) NOT NULL ;   ALTER TABLE `phpbb_users` CHANGE `user_password` `user_password` varchar( 32 ) NOT NULL ;   ALTER TABLE `phpbb_users` ADD `user_setbm` tinyint( 1 ) NOT NULL default '0' AFTER `user_attachsig` ;   ALTER TABLE `phpbb_users` ADD `user_allowphoto` tinyint( 1 ) NOT NULL default '1' AFTER `user_allowavatar` ;   ALTER TABLE `phpbb_users` ADD `user_photo` varchar( 100 ) default NULL AFTER `user_avatar_type` ;   ALTER TABLE `phpbb_users` ADD `user_photo_type` tinyint( 4 ) NOT NULL default '0' AFTER `user_photo` ;   ALTER TABLE `phpbb_users` CHANGE `user_sig_bbcode_uid` `user_sig_bbcode_uid` varchar( 10 ) default NULL ;   ALTER TABLE `phpbb_users` ADD `user_skype` varchar( 255 ) default NULL AFTER `user_msnm` ;   ALTER TABLE `phpbb_users` ADD `ct_search_time` int( 11 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_search_count` mediumint( 8 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_last_mail` int( 11 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_last_post` int( 11 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_post_counter` mediumint( 8 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_last_pw_reset` int( 11 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_enable_ip_warn` tinyint( 1 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_last_used_ip` varchar( 16 ) default `0.0.0.0`;   ALTER TABLE `phpbb_users` ADD `ct_login_count` mediumint( 8 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_login_vconfirm` tinyint( 1 ) default '0';   ALTER TABLE `phpbb_users` ADD `ct_last_pw_change` int( 11 ) default '1';   ALTER TABLE `phpbb_users` ADD `ct_global_msg_read` tinyint( 1 ) default '0';   ALTER TABLE `phpbb_users` ADD `ct_miserable_user` tinyint( 1 ) default '0';   ALTER TABLE `phpbb_users` ADD `ct_last_ip` varchar( 16 ) default `0.0.0.0`;   ALTER TABLE `phpbb_users` ADD `user_realname` varchar( 25 ) NOT NULL;   ALTER TABLE `phpbb_users` ADD `user_gender` tinyint( 1 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_birthday` varchar( 8 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_last_birthday` int( 11 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_home_phone` varchar( 20 ) default NULL;   ALTER TABLE `phpbb_users` ADD `user_home_fax` varchar( 20 ) default NULL;   ALTER TABLE `phpbb_users` ADD `user_work_phone` varchar( 20 ) default NULL;   ALTER TABLE `phpbb_users` ADD `user_work_fax` varchar( 20 ) default NULL;   ALTER TABLE `phpbb_users` ADD `user_cellular` varchar( 20 ) default NULL;   ALTER TABLE `phpbb_users` ADD `user_pager` varchar( 20 ) default NULL;   ALTER TABLE `phpbb_users` ADD `user_summer_time` tinyint( 1 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_list_option` varchar( 255 ) default NULL;   ALTER TABLE `phpbb_users` ADD `user_allow_email` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_allow_website` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_allow_messenger` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_allow_real` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_allow_sig` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_viewpm` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_viewwebsite` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_viewmessenger` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_viewreal` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_viewavatar` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_viewphoto` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_viewsig` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_viewimg` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_buddy_friend_display` tinyint( 1 ) default '1';   ALTER TABLE `phpbb_users` ADD `user_buddy_ignore_display` tinyint( 1 ) default '1';   ALTER TABLE `phpbb_users` ADD `user_buddy_friend_of_display` tinyint( 1 ) default '1';   ALTER TABLE `phpbb_users` ADD `user_buddy_ignored_by_display` tinyint( 1 ) default '1';   ALTER TABLE `phpbb_users` ADD `user_watched_topics_per_page` smallint( 3 ) default `15`;   ALTER TABLE `phpbb_users` ADD `user_privmsgs_per_page` smallint( 3 ) default `5`;   ALTER TABLE `phpbb_users` ADD `user_sub_forum` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_split_cat` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_last_topic_title` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_sub_level_links` tinyint( 1 ) NOT NULL default '2';   ALTER TABLE `phpbb_users` ADD `user_display_viewonline` tinyint( 1 ) NOT NULL default '2';   ALTER TABLE `phpbb_users` ADD `user_announcement_date_display` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_announcement_display` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_announcement_display_forum` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_announcement_split` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_announcement_forum` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_calendar_display_open` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_calendar_header_cells` tinyint( 1 ) NOT NULL default `7`;   ALTER TABLE `phpbb_users` ADD `user_fdow` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_calendar_nb_row` tinyint( 2 ) unsigned NOT NULL default `5`;   ALTER TABLE `phpbb_users` ADD `user_calendar_birthday` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_calendar_forum` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_last_topics_from_started` tinyint( 2 ) NOT NULL default '3';   ALTER TABLE `phpbb_users` ADD `user_last_topics_from_replied` tinyint( 2 ) NOT NULL default '3';   ALTER TABLE `phpbb_users` ADD `user_last_topics_from_ended` tinyint( 2 ) NOT NULL default '3';   ALTER TABLE `phpbb_users` ADD `user_last_topics_from_split` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_last_topics_from_forum` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_split_global_announce` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_split_announce` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_split_sticky` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_split_topic_split` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_points` decimal( 11,0 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_unread_topics` text;   ALTER TABLE `phpbb_users` ADD `user_topics_last_per_page` smallint( 2 ) NOT NULL default `15`;   ALTER TABLE `phpbb_users` ADD `user_flag` varchar( 25 ) default NULL;   ALTER TABLE `phpbb_users` ADD `user_holidays` tinyint( 1 ) unsigned NOT NULL default '2';   ALTER TABLE `phpbb_users` ADD `user_warnings` smallint( 5 ) default '0';   ALTER TABLE `phpbb_users` ADD `user_rules` int( 11 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `rating_status` tinyint( 3 ) unsigned NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_extra` tinyint( 2 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_allowsignature` tinyint( 1 ) NOT NULL default '1';   ALTER TABLE `phpbb_users` ADD `user_actviate_date` int( 11 ) default '0';   ALTER TABLE `phpbb_users` ADD `user_expire_date` int( 11 ) default '0';   ALTER TABLE `phpbb_users` ADD `user_inactive_emls` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_inactive_last_eml` int( 11 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_state` varchar( 3 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `user_country` varchar( 3 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `phpBBSecurity_answer` text NOT NULL;   ALTER TABLE `phpbb_users` ADD `phpBBSecurity_question` text NOT NULL;   ALTER TABLE `phpbb_users` ADD `phpBBSecurity_login_tries` smallint( 5 ) NOT NULL default '0';   ALTER TABLE `phpbb_users` ADD `phpBBSecurity_pm_sent` smallint( 1 ) NOT NULL default '0';     ALTER TABLE `phpbb_vote_desc` ADD `vote_max` int( 3 ) NOT NULL default '1';   ALTER TABLE `phpbb_vote_desc` ADD `vote_voted` int( 7 ) NOT NULL default '0';   ALTER TABLE `phpbb_vote_desc` ADD `vote_hide` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_vote_desc` ADD `vote_tothide` tinyint( 1 ) NOT NULL default '0';   ALTER TABLE `phpbb_vote_desc` AUTO_INCREMENT = 1;     ALTER TABLE `phpbb_vote_results` CHANGE `vote_option_text` `vote_option_text` varchar( 255 ) NOT NULL ;     ALTER TABLE `phpbb_vote_voters` CHANGE `vote_user_ip` `vote_user_ip` char( 8 ) NOT NULL ;     ALTER TABLE `phpbb_words` CHANGE `word` `word` char( 100 ) NOT NULL ;   ALTER TABLE `phpbb_words` CHANGE `replacement` `replacement` char( 100 ) NOT NULL ;   ALTER TABLE `phpbb_words` AUTO_INCREMENT = 1;[/code]These changes are all written as individual sql statements, so if one fails due to an installed mod you can simply pick up from the next one.

Hope that helps someone!

[found it]

uninstall importal from vanilla phpbb (10 mins) then upgrade to integramod...

[Coder]

As I said, it isn't upgradeable! A full uninstall of Portal - done manually - means reverting the databases to their original configuration. That will take a little longer than your 10 minutes on an active forum since it means examining each table for any changes and undoing those changes. I think my solution is a little more elegant and a lot less work since I already did all the work.

Too bad you couldn't have replied to any of the earlier questions on this same subject!

[found it]

As the tables for importal do not affect any users or posts or any relevent information that will mess up your forum it is a simple case of deleting the tbles

The reason I haven't answered any other questions is I haven't been able to get online for personal reasons...

[DjPorkchop]

I have done this a couple times for people and have found as Foundit said, that it effects none of that at all either. And later on have never had any issues at ll. I did the same and simply deleted the tables it did create. No problem.

Sry hadnt replied earlier. I too have had issues preventing me from logging on as well. Have a nice day.

[inetmarketing]

Hey,

So what version of IM Portal is stable? Is it still 1.2.0?

I'm assuming IM 1.4 is the full integramod download. I have IM Potal 1.2.0 installed for some time now on a
phpbb 2.0+ forum and it still looks ok.

Robert

[Helter]

1.2.0 is the latest stable release of IMPortal.

[RiverFox]

Would that explain in 1.4.x - there are a lot of missing files??

A few links in the ACP return a 404... <img>

[CaNNon]

Would that explain in 1.4.x - there are a lot of missing files??

integramod is much more that just the portal, but still i don't think it's missing any files.
You should go over your install and make sure the folders and files have the
chmod permissions set properly you may have missed a setting. This could cause your 404 errors.

[DjPorkchop]

yeah I JUST downloaded the files the other day and grabbed a latest phpBB 2 version and did a install for a guy and it went off without a hitch. There are no missing files NOR any errors to report from the ACP whilst using IM Portal 1.2.0 and phpBB 2.0.22

[CaNNon]

He is posting about 1.4.x MWE_001 thats the full integramod he's not on topic! <img>

[DjPorkchop]

Good point Cannon. <img> that'll teach me to pay closer attention. I just thought it was a mis reference to a Im Portal version