December 31st, 2008, 12:16 PM
I've just upgraded from 5.1 to 6.2 (I just took over this pos).
The upgrade seems to think thee is a pp_users table, but there isn't. Never has been. We are using vbulletin 3x which is where the users table is.
I haven't seen anything regarding this. I've been searching all morning. I'm getting errors on anything that has to do with members as a result.
Photo Gallery - Member Galleries (http://www.army.com/photos/showmembers.php/cat/500)
I've run EVERY upgrade from 5.1 to 6.2 - got plenty of errors along the way regarding pp_users.
Anyone know how to fix this? Where did I go wrong?
December 31st, 2008, 01:21 PM
well in any photopost install there is ALWAYS a pp_users table that is created.
It really does not matter that we dont authenticate the user there but the table holds other specific user information
You would actually need to create that missing table that should be there
CREATE TABLE IF NOT EXISTS pp_users (userid int(25) NOT NULL auto_increment,
usergroupid int(5) NOT NULL default '0',
username varchar(30) NOT NULL default '',
realname varchar(80) default NULL,
password varchar(50) NOT NULL default '',
email varchar(75) NOT NULL default '',
homepage varchar(100) default NULL,
icq varchar(50) default NULL,
aim varchar(30) default NULL,
yahoo varchar(30) default NULL,
joindate int(25) NOT NULL default '0',
posts int(20) NOT NULL default '0',
birthday date NOT NULL default '0000-00-00',
ipaddress varchar(18) default NULL,
location varchar(100) default NULL,
interests MEDIUMTEXT NULL DEFAULT NULL,
occupation varchar(250) default NULL,
bio MEDIUMTEXT NULL DEFAULT NULL,
site VARCHAR(30) default NULL,
offset SMALLINT(2) DEFAULT '0' NOT NULL,
lastphoto INT( 12 ) NOT NULL DEFAULT '0',
lastdate INT( 15 ) NOT NULL DEFAULT '0',
views int(10) NOT NULL default '0',
cellphone VARCHAR(255) DEFAULT NULL,
title varchar(30) default NULL,
signature varchar(250) default NULL,
avatar varchar(120) default NULL,
mature tinyint(1) NOT NULL default '1',
invites int(6) NOT NULL default '0',
accepts int(6) NOT NULL default '0',
laston int(15) NOT NULL default '0',
paypal VARCHAR(75) NOT NULL DEFAULT '',
PRIMARY KEY (userid)) TYPE=MyISAM;
December 31st, 2008, 01:45 PM
Very strange, because I'm 20000% positive we've never had that table. I just checked my backups for the last year and I don't see that table ever being in there, but adding it seems to have fixed my issue.
Thanks for the quick reply and solution. Worked great!
January 1st, 2009, 01:52 AM
well I can only assume that whomever ran the site deleted it because on a normal photopost install it most definately is installed.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.