IntegraMOD

We have two forums on the same server and two databases. The forum we use currently is a basic installation of phpbb version 2.0.16. That forum is in the root folder of our server. Then we have integramod v. 1.40 with phpbb 2.0.17. Both of the forums have their own database setups with the same prefix.

We tried to move our database from the old forum to integramod with directions from http://www.minds.nuim.ie/~page/serendip ... l#extended
Everything went smoothly without any errors we wouldn't have expected. We have posts and topics like we should have in our integramodinstallation. The problem is that the phpbb_rpgusers table isn't transferred so we don't have any users in our new forum.

What we have tried to do to fix the problem?
We've tried to upload the whole database again. Twice. Same result.
We've tried to upload only the table containing users with the following result:
ERROR 1136 at line xxxx: Column count doesn't match value count on row 1
We've tried to alter the table containing users so that it has the same amount of columns than the table on integramod has. Then we got errors like "*some_column_name_here* cannot be null" etc.

The structure of the users table in integramod installation:

Code: Select all

-- phpMyAdmin SQL Dump-- version 2.6.4-pl2-- [url=http]http://www.phpmyadmin.net--[/url] -- Server: localhost-- Creation time: 22.10.2006 klo 11:58-- Version on server: 4.0.27-- PHP version: 4.3.11-- -- Database: `xxx_xxx`--  -- --------------------------------------------------------  -- -- Rakenne taulukolle `phpbb_rpgusers`--  CREATE TABLE `phpbb_rpgusers` (   `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_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_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_notify_donation` tinyint(1) NOT NULL default '0',   `user_popup_pm` tinyint(1) NOT NULL default '0',   `user_rank` int(11) default '0',   `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_skype` 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,   `user_realname` varchar(25) NOT NULL default '',   `user_gender` tinyint(1) unsigned NOT NULL default '0',   `user_birthday` varchar(8) NOT NULL default '0',   `user_last_birthday` int(11) unsigned NOT NULL default '0',   `user_home_phone` varchar(20) default NULL,   `user_home_fax` varchar(20) default NULL,   `user_work_phone` varchar(20) default NULL,   `user_work_fax` varchar(20) default NULL,   `user_cellular` varchar(20) default NULL,   `user_pager` varchar(20) default NULL,   `user_summer_time` tinyint(1) unsigned NOT NULL default '0',   `user_list_option` varchar(255) default NULL,   `user_allow_email` tinyint(1) NOT NULL default '1',   `user_allow_website` tinyint(1) NOT NULL default '1',   `user_allow_messenger` tinyint(1) NOT NULL default '1',   `user_allow_real` tinyint(1) NOT NULL default '1',   `user_allow_sig` tinyint(1) NOT NULL default '1',   `user_viewpm` tinyint(1) NOT NULL default '1',   `user_viewwebsite` tinyint(1) NOT NULL default '1',   `user_viewmessenger` tinyint(1) NOT NULL default '1',   `user_viewreal` tinyint(1) NOT NULL default '1',   `user_viewavatar` tinyint(1) NOT NULL default '1',   `user_viewsig` tinyint(1) NOT NULL default '1',   `user_viewimg` tinyint(1) NOT NULL default '1',   `user_buddy_friend_display` tinyint(1) default '1',   `user_buddy_ignore_display` tinyint(1) default '1',   `user_buddy_friend_of_display` tinyint(1) default '1',   `user_buddy_ignored_by_display` tinyint(1) default '1',   `user_watched_topics_per_page` smallint(3) default '15',   `user_privmsgs_per_page` smallint(3) default '5',   `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_announcement_date_display` tinyint(1) NOT NULL default '1',   `user_announcement_display` tinyint(1) NOT NULL default '1',   `user_announcement_display_forum` tinyint(1) NOT NULL default '1',   `user_announcement_split` tinyint(1) NOT NULL default '1',   `user_announcement_forum` tinyint(1) NOT NULL default '1',   `user_calendar_display_open` tinyint(1) NOT NULL default '0',   `user_calendar_header_cells` tinyint(1) NOT NULL default '7',   `user_fdow` 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_last_topics_from_started` tinyint(2) NOT NULL default '3',   `user_last_topics_from_replied` tinyint(2) NOT NULL default '3',   `user_last_topics_from_ended` tinyint(2) NOT NULL default '3',   `user_last_topics_from_split` tinyint(1) NOT NULL default '1',   `user_last_topics_from_forum` tinyint(1) NOT NULL default '1',   `user_split_global_announce` tinyint(1) NOT NULL default '1',   `user_split_announce` tinyint(1) NOT NULL default '1',   `user_split_sticky` tinyint(1) NOT NULL default '1',   `user_split_topic_split` tinyint(1) NOT NULL default '0',   `user_points` int(11) NOT NULL default '0',   `user_unread_topics` text,   `user_topics_last_per_page` smallint(2) NOT NULL default '15',   `user_flag` varchar(25) default NULL,   `user_holidays` tinyint(1) unsigned NOT NULL default '2',   `user_warnings` smallint(5) default '0',   `user_rules` int(11) NOT NULL default '0',   `rating_status` tinyint(3) unsigned NOT NULL default '0',   `user_photo` smallint(3) NOT NULL default '0',   `user_extra` tinyint(2) NOT NULL default '0',   `user_allowsignature` tinyint(1) NOT NULL default '1',   `user_actviate_date` int(11) default '0',   `user_expire_date` int(11) default '0',   `user_inactive_emls` tinyint(1) NOT NULL default '0',   `user_inactive_last_eml` int(11) NOT NULL default '0',   `user_state` char(3) NOT NULL default '0',   `user_country` char(3) NOT NULL default '0',   `phpBBSecurity_answer` text NOT NULL,   `phpBBSecurity_question` text NOT NULL,   `phpBBSecurity_login_tries` smallint(5) NOT NULL default '0',   `phpBBSecurity_pm_sent` smallint(1) NOT NULL default '0',   PRIMARY KEY  (`user_id`),   KEY `user_session_time` (`user_session_time`)) TYPE=MyISAM;  

The structure of the users table on the old installation (after the alterations as suggested on the web site I pointed out earlier):

Code: Select all

 Tietokanta temp_DB  - taulu phpbb_rpgusers  palvelimella localhost  # phpMyAdmin MySQL-Dump# version 2.3.2# [url=http]http://www.phpmyadmin.net/[/url] (download page)## Palvelin: localhost# Luontiaika: 22.10.2006 klo 19:01# Palvelimen versio: 4.00.00# PHP:n versio: 4.2.3# Tietokanta : `temp_DB`# --------------------------------------------------------  ## Rakenne taululle `phpbb_rpgusers`#  CREATE TABLE `phpbb_rpgusers` (   `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_lastvisit` int(11) NOT NULL default '0',   `user_regdate` int(11) NOT NULL default '0',   `user_level` tinyint(4) default NULL,   `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_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 NULL,   `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,   `user_notify_donation` tinyint(1) NOT NULL default '0',   `user_realname` varchar(25) NOT NULL default '',   `user_gender` tinyint(1) unsigned NOT NULL default '0',   `user_birthday` varchar(8) NOT NULL default '0',   `user_last_birthday` int(11) unsigned NOT NULL default '0',   `user_home_phone` varchar(20) default NULL,   `user_home_fax` varchar(20) default NULL,   `user_work_phone` varchar(20) default NULL,   `user_work_fax` varchar(20) default NULL,   `user_cellular` varchar(20) default NULL,   `user_pager` varchar(20) default NULL,   `user_summer_time` tinyint(1) unsigned NOT NULL default '0',   `user_list_option` varchar(255) default NULL,   `user_allow_email` tinyint(1) NOT NULL default '1',   `user_allow_website` tinyint(1) NOT NULL default '1',   `user_allow_messenger` tinyint(1) NOT NULL default '1',   `user_allow_real` tinyint(1) NOT NULL default '1',   `user_allow_sig` tinyint(1) NOT NULL default '1',   `user_viewpm` tinyint(1) NOT NULL default '1',   `user_viewwebsite` tinyint(1) NOT NULL default '1',   `user_viewmessenger` tinyint(1) NOT NULL default '1',   `user_viewreal` tinyint(1) NOT NULL default '1',   `user_viewavatar` tinyint(1) NOT NULL default '1',   `user_viewsig` tinyint(1) NOT NULL default '1',   `user_viewimg` tinyint(1) NOT NULL default '1',   `user_buddy_friend_display` tinyint(1) default '1',   `user_buddy_ignore_display` tinyint(1) default '1',   `user_buddy_friend_of_display` tinyint(1) default '1',   `user_buddy_ignored_by_display` tinyint(1) default '1',   `user_watched_topics_per_page` smallint(3) default '15',   `user_privmsgs_per_page` smallint(3) default '5',   `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_announcement_date_display` tinyint(1) NOT NULL default '1',   `user_announcement_display` tinyint(1) NOT NULL default '1',   `user_announcement_display_forum` tinyint(1) NOT NULL default '1',   `user_announcement_split` tinyint(1) NOT NULL default '1',   `user_announcement_forum` tinyint(1) NOT NULL default '1',   `user_calendar_display_open` tinyint(1) NOT NULL default '0',   `user_calendar_header_cells` tinyint(1) NOT NULL default '7',   `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_last_topics_from_started` tinyint(2) NOT NULL default '3',   `user_last_topics_from_replied` tinyint(2) NOT NULL default '3',   `user_last_topics_from_ended` tinyint(2) NOT NULL default '3',   `user_last_topics_from_split` tinyint(1) NOT NULL default '1',   `user_last_topics_from_forum` tinyint(1) NOT NULL default '1',   `user_split_global_announce` tinyint(1) NOT NULL default '1',   `user_split_announce` tinyint(1) NOT NULL default '1',   `user_split_sticky` tinyint(1) NOT NULL default '1',   `user_split_topic_split` tinyint(1) NOT NULL default '0',   `user_points` int(11) NOT NULL default '0',   `user_unread_topics` text,   `user_rules` int(11) NOT NULL default '0',   `user_topics_last_per_page` smallint(2) NOT NULL default '15',   `user_holidays` tinyint(1) unsigned NOT NULL default '2',   `user_warnings` smallint(5) default '0',   `rating_status` tinyint(3) unsigned NOT NULL default '0',   `user_photo` smallint(3) NOT NULL default '0',   `user_flag` varchar(25) default NULL,   PRIMARY KEY  (`user_id`),   KEY `user_session_time` (`user_session_time`)) TYPE=MyISAM;

I would really appreciate any help or suggestion you might have for me. The problem is really a pain in the admin's ass as we would really like to keep our old users. Ask if you need any more info about our system.

Thanks.

Thanks for the file but we already found a solution. We deleted the users-table from integramod and then transferred the users-table from the old forum. Then we added the columns that were missing (by comparing the two databases) and that's it.