Problems with upgrade from GMS to 4.8

[saltyzoo]

I had a great deal of trouble with the upgrade process. I thought I got through it but now I'm getting segmentation faults from apache.

What's the best way to proceed at this point since I've gone through the upgrade process already (perhaps incorrectly)?

[Michael P]

Segmentation faults? That's an apache error, not a PHP error. I'm not sure how PP should have possibly effected your Apache server.

GMS to 4.8 would require running all of the upgrade scripts, including upgradegms.php; did you follow all the upgrades?

[saltyzoo]

Sorry, left some stuff out. The seg faults are only occuring on photopost pages. I get a white page and a seg fault in the apache log....

[saltyzoo]

vbulletin 3, other apps, and the GMS version of pp run fine on this apache/ php combo.

[Chuck S]

Have you followed the correct upgrade instructions like Michael asked?

Ran the proper upgrades?

[saltyzoo]

Sorry, I swear those questions weren't there first time. I think he added them.

Yes, I did follow all the upgrades beginning with the gms upgrade, although I had a lot of problems with the gms upgrade in particular. For example, it had multiple php syntax errors in it that I had to fix manually. Missing double quotes, etc....

To the best of my knowledge I performed all of the upgrades, but as I said, I'm not confident that they were completed properly.

That is what leads me to my current question. What is the best way for me to proceed at this point?

[Chuck S]

You did not keep track of errors. HMM

I will have to also check what version of photopost gms upgrades to. I beleive you may need to also run some of the regular upgrade scripts as well

EDIT: Looks to me like it upgrades to a 4.5 database type

YOU NEED RUN THE FOLLOWING PHOTOPOST UPGRADES ALSO

upgrade45.php
upgrade46.php
upgrade467.php
upgrade47.php

[saltyzoo]

I don't have my notes with me here, but I do remember fixing at least two syntax errors. After that I checked the version that the gms upgrade brought me up to and ran all scripts from that point on. Sorry, I don't remember the version either. I did not run the scripts prior to that version.

I do have the ability to restore everything back to pre-upgrade and start over if that's the best course of action. However, the gms version was not working properly when I started as I had upgraded my integrated vb to vb3 which broke it. Is there any way to get gms to work with vb3? That would allow me to slow down and work on getting the new version running with less emergency.

[Chuck S]

recheck my post above. You need to also run the following photopost database upgrades since it brings you to a 4.5 database and we are now on 4.8

[saltyzoo]

After that I checked the version that the gms upgrade brought me up to and ran all scripts from that point on.

I ran all the scripts that appear on the list provided by the upgrade.php that comes with 4.8. I don't have that available, but I'm assuming that the list matches what you posted.

Is there any way to get gms to work with vb3?

[Chuck S]

Originally Posted by saltyzoo

I ran all the scripts that appear on the list provided by the upgrade.php that comes with 4.8. I don't have that available, but I'm assuming that the list matches what you posted.

well I read the upgrade gms doc and it made no meantion of what scripts to run after. It upgrades you to a 4.5 database so you need to run the ones I meantioned.

Now Michael has upgraded the upgrade script so when you run upgradegms.php it should link to the next upgrade you need and so forth

Go ahead redownload the build and start completely over with a fresh GMS database.


As far as linking to VB once you finish yes you can change your integration type but please note unless you have done an import of users in order from GMS to VB3 with the same userid as your old database none of the Photos will align with the proper user.

Now you can change the owner of an image to another user in 4.8 but if you have alot of photos thats alot of work.

[saltyzoo]

Go ahead redownload the build and start completely over with a fresh GMS database.

just to be sure I'm on the same page. Which build are you referring to? The 4.8 build? Just as an FYI, the 4.8 build I downloaded yesterday did not have an upgrade path from gms. I had to download a seperate upgrade to get to 4.5

[Chuck S]

I just talked with Michael this morning. No one has upgraded from GMS in a long time. If you redownload the build when you run upgradegms.php the script will link upgrade45.php and so on so all the proper scripts are ran.

[saltyzoo]

I will try again this evening with a redownloaded build. You are referring to the 4.8 build, right?

[Chuck S]

Yes of course that is the only build linked in the members area since we have no beta's running anywhere

[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.

[saltyzoo]

Just for more info, before running the script the PhotoPost Version in my database was 3.1.0

[saltyzoo]

Hello?

[Chuck S]

Duplicates I would not worry about.

What do you mean the version was 3.1.0? Where you running Photopost or GMS

Did you run all the upgrades. Did you follow the steps in the upgrade doc.

Url to install

[saltyzoo]

Ok, I think you just struck on the problem. I thought I was running photopost all along, but the customer service guy said I wasn't, so I assumed GMS must be the name of an earlier version of photopost. I believe I've been running photopost since day 1.

That would certainly explain my difficulties.