sheitmar
01-27-2006, 04:12 PM
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:
http://www.thehappyfriends.net/problem.jpg
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.
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:
http://www.thehappyfriends.net/problem.jpg
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.