Imported user field but users don't show up?

[sheitmar]

Okay, the title may sound confusing but here is what I've done.

I updated to the newest VB (from 3.0.1 I think?), 3.5.3, but I was having problems doing a simple conversion since I had done so many modifications to my previous database. So I backed up the database, wiped it out, and installed VB in a fresh DB.

All I really wanted to do was restore my users and their post counts (that's all they really cared about)..however, there were quite a few differences in the forum fields so I basically had to rewrite the user field so everything would fit in perfectly with the new database.

After about an hour of work (with only 33 users!) I managed to get that all done, imported into the DB, fine. My users were then able to log in and post.

However, it seems that VB is having difficulty aligning the users to their actual accounts. Users may post but it shows up as "Guest", yet their username shows up in the title, yet with no link to their profile (but they're still logged in?). I tried to check out their user profiles in the admincp, but it simply links to a "/admincp/user.php?do=edit&u=" and gives me nothing.

Here's a screenshot of what I'm getting:



Here is the format of my database (user field):

CREATE TABLE `user` (
  `userid` int(10) unsigned NOT NULL auto_increment,
  `usergroupid` smallint(5) unsigned NOT NULL default '0',
  `membergroupids` varchar(250) NOT NULL default '',
  `displaygroupid` smallint(5) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `passworddate` date NOT NULL default '0000-00-00',
  `email` varchar(100) NOT NULL default '',
  `styleid` smallint(5) unsigned NOT NULL default '0',
  `parentemail` varchar(50) NOT NULL default '',
  `homepage` varchar(100) NOT NULL default '',
  `icq` varchar(20) NOT NULL default '',
  `aim` varchar(20) NOT NULL default '',
  `yahoo` varchar(32) NOT NULL default '',
  `msn` varchar(100) NOT NULL default '',
  `skype` varchar(32) NOT NULL default '',
  `showvbcode` smallint(5) unsigned NOT NULL default '0',
  `showbirthday` smallint(5) unsigned NOT NULL default '2',
  `usertitle` varchar(250) NOT NULL default '',
  `customtitle` smallint(6) NOT NULL default '0',
  `joindate` int(10) unsigned NOT NULL default '0',
  `daysprune` smallint(6) NOT NULL default '0',
  `lastvisit` int(10) unsigned NOT NULL default '0',
  `lastactivity` int(10) unsigned NOT NULL default '0',
  `lastpost` int(10) unsigned NOT NULL default '0',
  `posts` int(10) unsigned NOT NULL default '0',
  `reputation` int(11) NOT NULL default '10',
  `reputationlevelid` int(10) unsigned NOT NULL default '1',
  `timezoneoffset` varchar(4) NOT NULL default '',
  `pmpopup` smallint(6) NOT NULL default '0',
  `avatarid` smallint(6) NOT NULL default '0',
  `avatarrevision` int(10) unsigned NOT NULL default '0',
  `profilepicrevision` int(10) unsigned NOT NULL default '0',
  `options` int(10) unsigned NOT NULL default '15',
  `birthday` varchar(10) NOT NULL default '',
  `birthday_search` date NOT NULL default '0000-00-00',
  `maxposts` smallint(6) NOT NULL default '-1',
  `startofweek` smallint(6) NOT NULL default '1',
  `ipaddress` varchar(15) NOT NULL default '',
  `referrerid` int(10) unsigned NOT NULL default '0',
  `languageid` smallint(5) unsigned NOT NULL default '0',
  `emailstamp` int(10) unsigned NOT NULL default '0',
  `threadedmode` smallint(5) unsigned NOT NULL default '0',
  `autosubscribe` smallint(6) NOT NULL default '-1',
  `pmtotal` smallint(5) unsigned NOT NULL default '0',
  `pmunread` smallint(5) unsigned NOT NULL default '0',
  `salt` char(3) NOT NULL default '',
  `wwu002activity` int(10) unsigned NOT NULL default '0',
  `wwu002activitydate` int(10) unsigned NOT NULL default '0',
  `wwu002memberlevel` tinyint(3) unsigned NOT NULL default '1',
  `wwu002fullmemberdate` int(10) unsigned NOT NULL default '0',
  `wwu002lastvisit` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`),
  KEY `usergroupid` (`usergroupid`),
  KEY `username` (`username`),
  KEY `birthday` (`birthday`,`showbirthday`),
  KEY `birthday_search` (`birthday_search`)
) TYPE=MyISAM AUTO_INCREMENT=39 ;

Here is a copy of a user within the field..maybe I did something wrong, or maybe i missed something.

INSERT INTO `user` VALUES (3, 2, '', 0, 'waterworks', '54adc66dc4deb4f375dbac22c9c8a6cd', '2005-09-15', 'daniriviere@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Senior Member', 0, 1126807200, -1, 1138335283, 1138367978, 1138329306, 597, 10, 5, '-6', 1, 0, 0, 0, 3415, '03-13-1982', '1982-03-13', 40, 1, '216.197.243.62', 0, 0, 0, 0, -1, 0, 0, '>QK', 414, 1138320000, 1, 0, 0);

In contrast, this user has absolutely NO problems, and can post with a link to their profile in the postbit.

INSERT INTO `user` VALUES (2, 2, '', 0, 'permahudef', 'a9c68d800cfceed6cedb13b85df2bba8', '2005-09-15', 'permahudef@yahoo.com', 0, '', 'http://homepage.usask.ca/~twb165/', '', '', '', '', '', 0, 0, 'Creepy Cowboy', 2, 1126807200, 0, 1138061701, 1138226677, 1138226255, 304, 10, 5, '-5', 1, 0, 0, 0, 3159, '12-12-1982', '1982-12-12', -1, 1, '130.15.195.205', 1, 0, 0, 0, -1, 6, 0, 'dU&', 270, 1138320000, 1, 0, 0);

Any ideas? Help would be greatly appreciated.

Actually I managed to fix it..I forgot to add fields to the "userfield" and "usertextfield" tables, thus creating my error.

[Marco van Herwaarden]

You should not have had any real problems when upgrading. What errors did you get when you tried an upgrade.

Also if your database is so much changed that an upgrade really (even with some manually help) don't work, you should try using ImpEx to import into a new clean database. Trying to do things manual is not the best way.

PS The reason that your users probably show up as guests, is that you didn't import all needed tables, more then only 'user' is needed.