Author: 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.
