2013-04-02, 12:30 AM
So I currently have an older version of a usertable I want to import into mybb_users. It imports correctly, without errors, but when it's done, the users don't show up.
Here are the tables of the one i'm using now:
Here are the ones I'm trying to import:
How should I go about changing them so that when I import, it will import correctly.
Here are the tables of the one i'm using now:
CREATE TABLE IF NOT EXISTS `mybb_users` (
`uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(120) NOT NULL DEFAULT '',
`password` varchar(120) NOT NULL DEFAULT '',
`salt` varchar(10) NOT NULL DEFAULT '',
`loginkey` varchar(50) NOT NULL DEFAULT '',
`email` varchar(220) NOT NULL DEFAULT '',
`postnum` int(10) NOT NULL DEFAULT '0',
`avatar` varchar(200) NOT NULL DEFAULT '',
`avatardimensions` varchar(10) NOT NULL DEFAULT '',
`avatartype` varchar(10) NOT NULL DEFAULT '0',
`usergroup` smallint(5) unsigned NOT NULL DEFAULT '0',
`additionalgroups` varchar(200) NOT NULL DEFAULT '',
`displaygroup` smallint(5) unsigned NOT NULL DEFAULT '0',
`usertitle` varchar(250) NOT NULL DEFAULT '',
`regdate` bigint(30) NOT NULL DEFAULT '0',
`lastactive` bigint(30) NOT NULL DEFAULT '0',
`lastvisit` bigint(30) NOT NULL DEFAULT '0',
`lastpost` bigint(30) NOT NULL DEFAULT '0',
`website` varchar(200) NOT NULL DEFAULT '',
`icq` varchar(10) NOT NULL DEFAULT '',
`aim` varchar(50) NOT NULL DEFAULT '',
`yahoo` varchar(50) NOT NULL DEFAULT '',
`msn` varchar(75) NOT NULL DEFAULT '',
`birthday` varchar(15) NOT NULL DEFAULT '',
`birthdayprivacy` varchar(4) NOT NULL DEFAULT 'all',
`signature` text NOT NULL,
`allownotices` int(1) NOT NULL DEFAULT '0',
`hideemail` int(1) NOT NULL DEFAULT '0',
`subscriptionmethod` int(1) NOT NULL DEFAULT '0',
`invisible` int(1) NOT NULL DEFAULT '0',
`receivepms` int(1) NOT NULL DEFAULT '0',
`receivefrombuddy` int(1) NOT NULL DEFAULT '0',
`pmnotice` int(1) NOT NULL DEFAULT '0',
`pmnotify` int(1) NOT NULL DEFAULT '0',
`threadmode` varchar(8) NOT NULL DEFAULT '',
`showsigs` int(1) NOT NULL DEFAULT '0',
`showavatars` int(1) NOT NULL DEFAULT '0',
`showquickreply` int(1) NOT NULL DEFAULT '0',
`showredirect` int(1) NOT NULL DEFAULT '0',
`ppp` smallint(6) NOT NULL DEFAULT '0',
`tpp` smallint(6) NOT NULL DEFAULT '0',
`daysprune` smallint(6) NOT NULL DEFAULT '0',
`dateformat` varchar(4) NOT NULL DEFAULT '',
`timeformat` varchar(4) NOT NULL DEFAULT '',
`timezone` varchar(4) NOT NULL DEFAULT '',
`dst` int(1) NOT NULL DEFAULT '0',
`dstcorrection` int(1) NOT NULL DEFAULT '0',
`buddylist` text NOT NULL,
`ignorelist` text NOT NULL,
`style` smallint(5) unsigned NOT NULL DEFAULT '0',
`away` int(1) NOT NULL DEFAULT '0',
`awaydate` int(10) unsigned NOT NULL DEFAULT '0',
`returndate` varchar(15) NOT NULL DEFAULT '',
`awayreason` varchar(200) NOT NULL DEFAULT '',
`pmfolders` text NOT NULL,
`notepad` text NOT NULL,
`referrer` int(10) unsigned NOT NULL DEFAULT '0',
`referrals` int(10) unsigned NOT NULL DEFAULT '0',
`reputation` bigint(30) NOT NULL DEFAULT '0',
`regip` varchar(50) NOT NULL DEFAULT '',
`lastip` varchar(50) NOT NULL DEFAULT '',
`longregip` int(11) NOT NULL DEFAULT '0',
`longlastip` int(11) NOT NULL DEFAULT '0',
`language` varchar(50) NOT NULL DEFAULT '',
`timeonline` bigint(30) NOT NULL DEFAULT '0',
`showcodebuttons` int(1) NOT NULL DEFAULT '1',
`totalpms` int(10) NOT NULL DEFAULT '0',
`unreadpms` int(10) NOT NULL DEFAULT '0',
`warningpoints` int(3) NOT NULL DEFAULT '0',
`moderateposts` int(1) NOT NULL DEFAULT '0',
`moderationtime` bigint(30) NOT NULL DEFAULT '0',
`suspendposting` int(1) NOT NULL DEFAULT '0',
`suspensiontime` bigint(30) NOT NULL DEFAULT '0',
`suspendsignature` int(1) NOT NULL DEFAULT '0',
`suspendsigtime` bigint(30) NOT NULL DEFAULT '0',
`coppauser` int(1) NOT NULL DEFAULT '0',
`classicpostbit` int(1) NOT NULL DEFAULT '0',
`loginattempts` tinyint(2) NOT NULL DEFAULT '1',
`failedlogin` bigint(30) NOT NULL DEFAULT '0',
`usernotes` text NOT NULL,
`akismetstopped` int(11) NOT NULL DEFAULT '0',
`automedia_use` varchar(1) NOT NULL DEFAULT 'Y',
`newpoints` decimal(16,2) NOT NULL DEFAULT '0.00',
`newpoints_items` text NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`),
KEY `usergroup` (`usergroup`),
KEY `birthday` (`birthday`),
KEY `longregip` (`longregip`),
KEY `longlastip` (`longlastip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
Here are the ones I'm trying to import:
CREATE TABLE IF NOT EXISTS `members` (
`member_id` mediumint(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`member_group_id` smallint(3) NOT NULL DEFAULT '0',
`email` varchar(150) NOT NULL DEFAULT '',
`joined` int(10) NOT NULL DEFAULT '0',
`ip_address` varchar(46) NOT NULL,
`posts` mediumint(7) DEFAULT '0',
`title` varchar(64) DEFAULT NULL,
`allow_admin_mails` tinyint(1) DEFAULT NULL,
`time_offset` varchar(10) DEFAULT NULL,
`skin` smallint(5) DEFAULT NULL,
`warn_level` int(10) DEFAULT NULL,
`warn_lastwarn` int(10) NOT NULL DEFAULT '0',
`language` mediumint(4) DEFAULT NULL,
`last_post` int(10) DEFAULT NULL,
`restrict_post` varchar(100) NOT NULL DEFAULT '0',
`view_sigs` tinyint(1) DEFAULT '1',
`view_img` tinyint(1) DEFAULT '1',
`bday_day` int(2) DEFAULT NULL,
`bday_month` int(2) DEFAULT NULL,
`bday_year` int(4) DEFAULT NULL,
`msg_count_new` int(2) NOT NULL DEFAULT '0',
`msg_count_total` int(3) NOT NULL DEFAULT '0',
`msg_count_reset` int(1) NOT NULL DEFAULT '0',
`msg_show_notification` int(1) NOT NULL DEFAULT '0',
`misc` varchar(128) DEFAULT NULL,
`last_visit` int(10) DEFAULT '0',
`last_activity` int(10) DEFAULT '0',
`dst_in_use` tinyint(1) DEFAULT '0',
`coppa_user` tinyint(1) DEFAULT '0',
`mod_posts` varchar(100) NOT NULL DEFAULT '0',
`auto_track` varchar(50) DEFAULT '0',
`temp_ban` varchar(100) DEFAULT '0',
`login_anonymous` char(3) NOT NULL DEFAULT '0&0',
`ignored_users` text,
`mgroup_others` varchar(255) NOT NULL DEFAULT '',
`org_perm_id` varchar(255) NOT NULL DEFAULT '',
`member_login_key` varchar(32) NOT NULL DEFAULT '',
`member_login_key_expire` int(10) NOT NULL DEFAULT '0',
`has_blog` text,
`has_gallery` tinyint(1) NOT NULL DEFAULT '0',
`members_auto_dst` tinyint(1) NOT NULL DEFAULT '1',
`members_display_name` varchar(255) NOT NULL DEFAULT '',
`members_seo_name` varchar(255) NOT NULL DEFAULT '',
`members_created_remote` tinyint(1) NOT NULL DEFAULT '0',
`members_cache` mediumtext,
`members_disable_pm` int(1) NOT NULL DEFAULT '0',
`members_l_display_name` varchar(255) NOT NULL DEFAULT '',
`members_l_username` varchar(255) NOT NULL DEFAULT '',
`failed_logins` text,
`failed_login_count` smallint(3) NOT NULL DEFAULT '0',
`members_profile_views` int(10) unsigned NOT NULL DEFAULT '0',
`members_pass_hash` varchar(32) NOT NULL DEFAULT '',
`members_pass_salt` varchar(5) NOT NULL DEFAULT '',
`member_banned` tinyint(1) NOT NULL DEFAULT '0',
`member_uploader` varchar(32) NOT NULL DEFAULT 'default',
`members_bitoptions` int(10) unsigned NOT NULL DEFAULT '0',
`fb_uid` bigint(20) unsigned NOT NULL DEFAULT '0',
`fb_emailhash` varchar(60) NOT NULL DEFAULT '',
`fb_lastsync` int(10) NOT NULL DEFAULT '0',
`members_day_posts` varchar(32) NOT NULL DEFAULT '0,0',
`live_id` varchar(32) DEFAULT NULL,
`twitter_id` varchar(255) NOT NULL DEFAULT '',
`twitter_token` varchar(255) NOT NULL DEFAULT '',
`twitter_secret` varchar(255) NOT NULL DEFAULT '',
`notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
`tc_lastsync` int(10) NOT NULL DEFAULT '0',
`fb_session` varchar(200) NOT NULL DEFAULT '',
`fb_token` text,
`ips_mobile_token` varchar(64) DEFAULT NULL,
`donate_donations` smallint(5) NOT NULL DEFAULT '0',
`unacknowledged_warnings` tinyint(1) DEFAULT NULL,
`blogs_recache` tinyint(1) DEFAULT NULL,
`m_awards_display` varchar(255) NOT NULL DEFAULT '',
`m_awards` varchar(255) NOT NULL DEFAULT '',
`shoutbox_shouts` bigint(8) NOT NULL DEFAULT '0',
`chat_banned` tinyint(1) NOT NULL DEFAULT '0',
`sub_end` int(10) NOT NULL DEFAULT '0',
`subs_pkg_chosen` smallint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`member_id`),
KEY `members_l_display_name` (`members_l_display_name`),
KEY `members_l_username` (`members_l_username`),
KEY `bday_day` (`bday_day`),
KEY `bday_month` (`bday_month`),
KEY `member_banned` (`member_banned`),
KEY `members_bitoptions` (`members_bitoptions`),
KEY `ip_address` (`ip_address`),
KEY `failed_login_count` (`failed_login_count`),
KEY `joined` (`joined`),
KEY `fb_uid` (`fb_uid`),
KEY `twitter_id` (`twitter_id`),
KEY `email` (`email`),
KEY `mgroup` (`member_group_id`,`member_id`),
KEY `blogs_recache` (`blogs_recache`),
KEY `member_groups` (`member_group_id`,`mgroup_others`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=47580 ;
How should I go about changing them so that when I import, it will import correctly.