[saltyzoo]

Ok, there are still syntax errors in the upgradegms.php script as follows:

Parse error: parse error, unexpected T_STRING in /home/thereeft/public_html/photopost/upgradegms.php on line 94

Line 93 has imbedded quotes.

After fixing that:

Parse error: parse error, unexpected ']', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/thereeft/public_html/photopost/upgradegms.php on line 104

Line 103 is missing the ;"; at the end

Then, when I run the script without the syntax errors this occurs:

Preparing to update GMS 3.X database... please wait...

Performing MySQL command: CREATE TABLE favorites (id int(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 int(4) NOT NULL default '0', userid int(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: ALTER TABLE categories ADD ugnoupload VARCHAR(255) NULL; ... Error: Duplicate column name 'ugnoupload'
Performing MySQL command: ALTER TABLE categories ADD ugnoanno VARCHAR(255) NULL; ... Error: Duplicate column name 'ugnoanno'
Performing MySQL command: ALTER TABLE categories ADD cattype varchar(4) NOT NULL default 'c'; ... Successful!
Performing MySQL command: INSERT INTO categories VALUES (500,'Member Galleries','Individual user galleries - any photo category',1,'yes',0,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,'c'); ... Error: Duplicate entry '500' for key 1
Performing MySQL command: ALTER TABLE comments ADD userid int(9) NOT NULL default '0'; ... Error: Duplicate column name 'userid'
Performing MySQL command: ALTER TABLE comments ADD comment text NOT NULL; ... Error: Duplicate column name 'comment'
Performing MySQL command: ALTER TABLE comments CHANGE rating rating FLOAT(12,2) DEFAULT NULL; ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (7,'URL to your forums main directory (optional)','vbulletin','This is the virtual path to your forum installation.','http://www.domain.com/forum',27,1); ... Error: Duplicate entry '7' for key 1
Performing MySQL command: INSERT INTO settings VALUES (13,'Default number of comments per page','defaultposts','','15',53,2); ... Error: Duplicate entry '13' for key 1
Performing MySQL command: INSERT INTO settings VALUES (22,'Uploaded photos require admin approval?','moderation','','yes',92,4); ... Error: Duplicate entry '22' for key 1
Performing MySQL command: REPLACE INTO settings VALUES (38,'Use email to notify users?','useemail','Users can be notified of photo approvals and deletions.','yes',301,5); ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (41,'User Registration System','vbversion','','photopost',304,1); ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (42,'Comments increment user post count?','cpostcount','','yes',93,5); ... Error: Duplicate entry '42' for key 1
Performing MySQL command: INSERT INTO settings VALUES (43,'Photo uploads increment user post count?','ppostcount','','yes',94,5); ... Error: Duplicate entry '43' for key 1
Performing MySQL command: INSERT INTO settings VALUES (44,'Save and display and images?','bigsave','','yes',95,3); ... Error: Duplicate entry '44' for key 1
Performing MySQL command: INSERT INTO settings VALUES (48,'Require users to be registered to send an e-Card?','cardreg','','yes',99,5); ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (51,'Allow users to be notified of new posts via email?','usenotify','','yes',305,5); ... Error: Duplicate entry '51' for key 1
Performing MySQL command: INSERT INTO settings VALUES (57,'Exclude admin uploads from photo approval process?','adminexclude','','yes',101,4); ... Error: Duplicate entry '57' for key 1
Performing MySQL command: INSERT INTO settings VALUES (61,'Use COPPA for registration?','coppa','','yes',350,5); ... Error: Duplicate entry '61' for key 1
Performing MySQL command: INSERT INTO settings VALUES (62,'Full Path to Registration Rules, or leave blank for default','rules','','',351,5); ... Error: Duplicate entry '62' for key 1
Performing MySQL command: INSERT INTO settings VALUES (63,'Require verification of email address upon registration?','emailverify','','yes',353,5); ... Error: Duplicate entry '63' for key 1
Performing MySQL command: INSERT INTO settings VALUES (64,'Your mailing address to receive COPPA permission forms?','address','','',354,5); ... Error: Duplicate entry '64' for key 1
Performing MySQL command: INSERT INTO settings VALUES (65,'Full path to COPPA rules file, or leave blank for default?','copparules','','',352,5); ... Error: Duplicate entry '65' for key 1
Performing MySQL command: INSERT INTO settings VALUES (66,'Allow new user registrations?','allowregs','','no',349,5); ... Error: Duplicate entry '66' for key 1
Performing MySQL command: INSERT INTO settings VALUES (67,'Allow users to upload photos?','allowup','','no',84,5); ... Error: Duplicate entry '67' for key 1
Performing MySQL command: INSERT INTO settings VALUES (68,'Allow users to post comments?','allowpost','','no',85,5); ... Error: Duplicate entry '68' for key 1
Performing MySQL command: INSERT INTO settings VALUES (70,'Your Commission Junction click-through URL','cjurl','','',5,1); ... Error: Duplicate entry '70' for key 1
Performing MySQL command: INSERT INTO settings VALUES (71,'Notify Admin of New Uploads?','uploadnotify','','yes',93,4); ... Error: Duplicate entry '71' for key 1
Performing MySQL command: INSERT INTO settings VALUES (72,'Show last photo thumbnail in member galleries listing?','membthumb','','yes',102,2); ... Error: Duplicate entry '72' for key 1
Performing MySQL command: INSERT INTO settings VALUES (76,'Require unique email addresses for user registration?','emailunique','','no',103,5); ... Error: Duplicate entry '76' for key 1
Performing MySQL command: INSERT INTO settings VALUES (80,'Do you want to allow ZIP uploads?','allowzip','','no',53,5); ... Error: Duplicate entry '80' for key 1
Performing MySQL command: INSERT INTO settings VALUES (83,'Forum database table prefix','dprefix','','',53,1); ... Error: Duplicate entry '83' for key 1
Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.5',53,0); ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (88,'Quality setting for resizing/thumbnails?','imgquality','','70',89,3); ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (91,'Allow users to move/delete their own images?','userdel','','no',58,5); ... Error: Duplicate entry '91' for key 1
Performing MySQL command: INSERT INTO settings VALUES (92,'Display Members Gallery on the main index page?','showmem','','no',55,2); ... Error: Duplicate entry '92' for key 1
Performing MySQL command: INSERT INTO settings VALUES (93,'Require users to be registered to view images?','reqregister','','no',56,2); ... Error: Duplicate entry '93' for key 1
Performing MySQL command: INSERT INTO settings VALUES (94,'Do you want Members Gallery to show all of a users photos?','memformat','','yes',57,2); ... Error: Duplicate entry '94' for key 1
Performing MySQL command: INSERT INTO settings VALUES (97,'Maximum multimedia upload size in Kb','mmuploadsize','','2000',88,3); ... Error: Duplicate entry '97' for key 1
Performing MySQL command: INSERT INTO settings VALUES (98,'Allow users to create Personal Albums?','allowpa','','no',53,5); ... Error: Duplicate entry '98' for key 1
Performing MySQL command: INSERT INTO settings VALUES (99,'Allow multimedia uploads?','allowmedia','','no',88,3); ... Error: Duplicate entry '99' for key 1
Performing MySQL command: INSERT INTO settings VALUES (101,'Display new comments/photos indicator on index?','displaynew','','no',58,2); ... Error: Duplicate entry '101' for key 1
Performing MySQL command: INSERT INTO settings VALUES (103,'Do you want to show the Members Gallery in List format?','memblist','','no',60,2); ... Error: Duplicate entry '103' for key 1
Performing MySQL command: INSERT INTO settings VALUES (104,'Do you want to prompt for optional info during registration?','getoptional','','no',355,5); ... Error: Duplicate entry '104' for key 1
Performing MySQL command: INSERT INTO settings VALUES (105,'Do you want to be notified of all new comments?','notifyadmin','','no',94,4); ... Error: Duplicate entry '105' for key 1
Performing MySQL command: INSERT INTO settings VALUES (120,'Display ratings that have no comments attached?','dispempty','','no',13,6); ... Error: Duplicate entry '120' for key 1
Performing MySQL command: INSERT INTO settings VALUES (122,'Display quickratings under photos?','dispquick','','no',15,6); ... Error: Duplicate entry '122' for key 1
Performing MySQL command: INSERT INTO settings VALUES (123,'Do you want to allow people to download their favorites?','allowfavzip','','no',58,2); ... Error: Duplicate entry '123' for key 1
Performing MySQL command: INSERT INTO settings VALUES (124,'Display # of comments indicator under thumbnails?','dispcoms','','yes',16,6); ... Error: Duplicate entry '124' for key 1
Performing MySQL command: INSERT INTO settings VALUES (125,'Display unapproved comments?','moderatecoms','','yes',17,4); ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (128,'Pixel size of borders for images/thumbnails','cellpadding','Thickness - set to 0 for no border','1',60,2); ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (129,'Color for image borders','framecolor','Color of the frame around images/thumbs','#000000',61,2); ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (130,'Select a theme for your website','theme','Choose from the available themes for your site layout','default',62,2); ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (131,'Show UBBCode on Photo page?','showubb','','no',16,6); ... Successful!
Performing MySQL command: CREATE TABLE sortmemb (sortid int(15) NOT NULL auto_increment,name varchar(35) NOT NULL default '',code varchar(75) NOT NULL default '',PRIMARY KEY (sortid)) TYPE=MyISAM; ... Error: Table 'sortmemb' already exists
Performing MySQL command: INSERT INTO sortmemb VALUES (2,'Date (newest first)','ORDER BY maxdate DESC'); ... Error: Duplicate entry '2' for key 1
Performing MySQL command: INSERT INTO sortmemb VALUES (3,'Views (high to low)','ORDER BY tviews DESC'); ... Error: Duplicate entry '3' for key 1
Performing MySQL command: INSERT INTO sortmemb VALUES (1,'Most Active','ORDER BY maxlast DESC'); ... Error: Duplicate entry '1' for key 1
Performing MySQL command: INSERT INTO sortmemb VALUES (4,'Alphabetical Order','ORDER BY user ASC'); ... Error: Duplicate entry '4' for key 1
Performing MySQL command: CREATE TABLE notify (id int(15) NOT NULL auto_increment,userid int(25) NOT NULL default '0',photo int(25) NOT NULL default '0',PRIMARY KEY (id),KEY photo(photo)) TYPE=MyISAM; ... Error: Table 'notify' already exists
Performing MySQL command: ALTER TABLE users ADD usergroupid int(5) NOT NULL default '0'; ... Error: Duplicate column name 'usergroupid'
Performing MySQL command: ALTER TABLE users ADD homepage varchar(100) default NULL; ... Error: Duplicate column name 'homepage'
Performing MySQL command: ALTER TABLE users ADD icq varchar(50) default NULL; ... Error: Duplicate column name 'icq'
Performing MySQL command: ALTER TABLE users ADD aim varchar(30) default NULL; ... Error: Duplicate column name 'aim'
Performing MySQL command: ALTER TABLE users ADD yahoo varchar(30) default NULL; ... Error: Duplicate column name 'yahoo'
Performing MySQL command: ALTER TABLE users ADD joindate int(25) NOT NULL default '0'; ... Error: Duplicate column name 'joindate'
Performing MySQL command: ALTER TABLE users ADD posts int(20) NOT NULL default '0'; ... Error: Duplicate column name 'posts'
Performing MySQL command: ALTER TABLE users ADD birthday date NOT NULL default '0000-00-00'; ... Error: Duplicate column name 'birthday'
Performing MySQL command: ALTER TABLE users ADD ipaddress varchar(18) default NULL; ... Error: Duplicate column name 'ipaddress'
Performing MySQL command: ALTER TABLE users ADD location varchar(100) default NULL; ... Error: Duplicate column name 'location'
Performing MySQL command: ALTER TABLE users ADD interests varchar(250) default NULL; ... Error: Duplicate column name 'interests'
Performing MySQL command: ALTER TABLE users ADD occupation varchar(250) default NULL; ... Error: Duplicate column name 'occupation'
Performing MySQL command: ALTER TABLE users ADD bio varchar(250) default NULL; ... Error: Duplicate column name 'bio'
Performing MySQL command: ALTER TABLE users ADD site VARCHAR(30) default NULL; ... Error: Duplicate column name 'site'
Performing MySQL command: ALTER TABLE users ADD offset INT(2) DEFAULT '0' NOT NULL; ... Error: Duplicate column name 'offset'
Performing MySQL command: ALTER TABLE users ADD views int(10) NOT NULL default '0'; ... Error: Duplicate column name 'views'
Performing MySQL command: ALTER TABLE iponline DROP PRIMARY KEY, ADD PRIMARY KEY (ipaddr); ... Error: Table 'thereeft_gallery.iponline' doesn't exist
Performing MySQL command: DROP TABLE usergroups; ... Successful!
Performing MySQL command: CREATE TABLE usergroups (groupid int(5) NOT NULL auto_increment, groupname varchar(50) NOT NULL default '', cpaccess int(3) NOT NULL default '0', modaccess int(3) NOT NULL default '0', uploads int(3) NOT NULL default '1', comments int(3) NOT NULL default '1', diskspace int(10) default NULL, uploadsize int(10) default NULL, editpho int(3) NOT NULL default '0', editposts int(3) NOT NULL default '0', PRIMARY KEY (groupid)) TYPE=MyISAM; ... Successful!
Performing MySQL command: INSERT INTO usergroups VALUES (5,'Administrator',1,1,1,1,'','',1,1); ... Successful!
Performing MySQL command: INSERT INTO usergroups VALUES (1,'Banned','','','','','','',0,0); ... Successful!
Performing MySQL command: INSERT INTO usergroups VALUES (3,'Unregistered','','','','','','',0,0); ... Successful!
Performing MySQL command: INSERT INTO usergroups VALUES (4,'Registered','','',1,1,'','',1,1); ... Successful!
Performing MySQL command: INSERT INTO usergroups VALUES (2,'COPPA','','','','','','',0,0); ... Successful!
Performing MySQL command: UPDATE photos SET approved='1'; ... Successful!
Performing MySQL command: DELETE FROM settings WHERE id=127; ... Successful!
Finished upgrade! You may now remove the upgrade scripts and upload the PhotoPost PRO scripts.