April 25th, 2007, 04:14 PM
I'm trying to upgrade from 5.31 to 5.62. Looking at the upgrade.php script (after getting a ton of errors), I see it's trying to ALTER the users table. I seem to have a user table instead. Was this changed at some point and I'm just behind the times or do have a larger issue? This user table seems to have the correct fields in it, so I'm not sure why the name isn't right.
I'm integrated with phpbb2.
April 25th, 2007, 05:40 PM
Photopost should have always had a user table
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 '',
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), PRIMARY KEY (userid)) TYPE=MyISAM;
April 25th, 2007, 06:16 PM
The difference I have is that my table is called user not users. Note the lack of s.
Would it be possible to remove my table, create the new table using your script above, and resync the users from phpBB?
April 25th, 2007, 06:31 PM
Dont do anything but create the table I noted our table will be empty and when you run the scan database rebuild last photo insert it will place inserts in there
No need to do anything with the phpbb user table since that is part of phpbb
You just look like you are missing our users table for one reason or another
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.