| Junior Member Verified Customer
Join Date: Mar 2006
Posts: 28
| upgrade errors
i just upgraded my vbulletin to version 3.5.5 and afterwards, my photopost was just blank, so I just purchased and uploaded the latest version of photopost and while upgrading... i get this error right off the bat...
Performing MySQL command: REPLACE INTO settings VALUES (94,'Use traditional Members Gallery configuration?','memformat','','yes',57,2); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (95,'Display headers during SlideShows?','slidehead','','yes',58,2); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (97,'Maximum multimedia upload size in kB','mmuploadsize','','2000',88,3); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (98,'Allow users to create Personal Albums?','allowpa','','yes',53,5); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (99,'Allow multimedia uploads?','allowmedia','','no',88,3); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (100,'Allow members to rate photos?','allowrate','','yes',54,5); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (101,'Display new comments/photos indicator on index?','displaynew','','no',58,2); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: ALTER TABLE users ADD site VARCHAR(30) default NULL; ... Error: Table 'oldmetalme.users' doesn't exist
Performing MySQL command: ALTER TABLE users ADD views int(10) NOT NULL default '0'; ... Error: Table 'oldmetalme.users' doesn't exist
Performing MySQL command: ALTER TABLE useralbums ADD isprivate varchar(4) NOT NULL default 'no'; ... Error: Table 'oldmetalme.useralbums' doesn't exist
Performing MySQL command: ALTER TABLE useralbums ADD password VARCHAR(16) NOT NULL; ... Error: Table 'oldmetalme.useralbums' doesn't exist
Performing MySQL command: ALTER TABLE users ADD offset INT(2) UNSIGNED DEFAULT '0' NOT NULL; ... Error: Table 'oldmetalme.users' doesn't exist
Performing MySQL command: ALTER TABLE photos ADD watermarked varchar(5) NOT NULL default 'no'; ... Error: Table 'oldmetalme.photos' doesn't exist
Performing MySQL command: CREATE TABLE favorites (id smallint(4) NOT NULL auto_increment, userid int(8) NOT NULL default '0', photo int(11) NOT NULL default '0', PRIMARY KEY (id), KEY parent (photo)) TYPE=MyISAM; ... Error: Table 'favorites' already exists
Performing MySQL command: CREATE TABLE laston (cat smallint(4) NOT NULL default '0', userid mediumint(9) NOT NULL default '0', laston int(11) unsigned default NULL, PRIMARY KEY (cat,userid)) TYPE=MyISAM; ... Error: Table 'laston' already exists
Performing MySQL command: CREATE TABLE ipcache (id int(10) NOT NULL auto_increment,userid INT(25) NOT NULL, ipaddr VARCHAR(75) NOT NULL, date INT(11) UNSIGNED, type VARCHAR(4) NOT NULL, photo INT(10) NOT NULL, PRIMARY KEY (id)) TYPE=MyISAM; ... Error: Table 'ipcache' already exists
Performing MySQL command: REPLACE INTO sort VALUES (6, 'Random', 'ORDER BY RAND()'); ... Error: Table 'oldmetalme.sort' doesn't exist
Performing MySQL command: REPLACE INTO sort VALUES (5, 'Least Popular', 'ORDER BY rating, views'); ... Error: Table 'oldmetalme.sort' doesn't exist
Performing MySQL command: REPLACE INTO sort VALUES (4, 'Most Popular', 'ORDER BY rating DESC, views DESC'); ... Error: Table 'oldmetalme.sort' doesn't exist
Performing MySQL command: REPLACE INTO sort VALUES (7, 'Alphabetical', 'ORDER BY bigimage'); ... Error: Table 'oldmetalme.sort' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=73; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=74; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=88; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=39; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=40; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=96; ... Error: Table 'oldmetalme.settings' doesn't exist
Fixing database: changing mediumint(9) to int(10) for photos.filesize...Starting to find image files and update file sizes in database...
Fatal error: Call to undefined function: ppmysql_query() in /home/webadmin/metalmeet.com/html/photopost/upgrade.php on line 488
all variables in the config files are the same as the previous... im kinda stuck here....any ideas??
thanks!
jack
|