Another upgrade gone wrong

webicity · November 5th, 2008, 10:11 AM

I uploaded the update files but I didn't run "install" because it is not a "fresh install".

What is the next step?

Main Index - Digital Design Den - Gallery (missing gallery display but galleries do appear in PP admin).

webicity · November 5th, 2008, 10:35 AM

I went ahead and ran the Install (it should say install or upgrade), I followed all the directions - Now admin login and the Gallery all come up as blank pages.

NOW I FOUND upgrade.php which WAS NEVER MENTIONED AT ALL in the instructions.

Now I'm really in trouble. I really need help now.

kernel-panic · November 5th, 2008, 10:35 AM

You need to run upgrade.php

webicity · November 5th, 2008, 10:46 AM

It would be really helpful if the Install file and the whatever that page was that told me to install had something in it to remind me about the upgrade.php file. I have a backup database for vB made prior to the disaster.

webicity · November 5th, 2008, 10:48 AM

Now I have a screen full of MySQL errors:
Error performing MySQL command: CREATE TABLE pp_messages ( msgid int( 12 ) NOT NULL AUTO_INCREMENT , userid int( 12 ) NOT NULL default '0', datestamp int( 15 ) NOT NULL default '0', message mediumtext, status smallint( 1 ) NOT NULL default '0', type enum( 'c', 'f', 'i', 'm', 'r' ) default NULL , photo int( 12 ) NOT NULL default '0', PRIMARY KEY ( msgid ) ) TYPE=MYISAM
Error: Table 'pp_messages' already exists

Error performing MySQL command: CREATE TABLE pp_captcha ( id int( 12 ) NOT NULL auto_increment , code varchar( 12 ) default NULL , PRIMARY KEY ( id ) ) TYPE=MyISAM
Error: Table 'pp_captcha' already exists

Error performing MySQL command: CREATE TABLE pp_buddies ( id int( 12 ) NOT NULL auto_increment , userid int( 12 ) NOT NULL default '0', buddy int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , KEY userid ( userid ) ) TYPE=MyISAM
Error: Table 'pp_buddies' already exists

Error performing MySQL command: CREATE TABLE pp_board ( msgid int(12) NOT NULL auto_increment, replyto int(12) NOT NULL default '0', userid int(12) NOT NULL default '0', category int(4) NOT NULL default '0', date int(15) NOT NULL default '0', subject varchar(250) default NULL, message mediumtext, replies int(6) NOT NULL default '0', views int(7) NOT NULL default '0', lastmsg int(12) NOT NULL default '0', lastdate int(15) NOT NULL default '0', lastuser int(12) NOT NULL default '0', lastusername varchar(32) default NULL, ipaddr varchar(15) default NULL, updated int(16) NOT NULL default '0', updateuser int(12) NOT NULL default '0', PRIMARY KEY (msgid), KEY date (date) ) TYPE=MyISAM
Error: Table 'pp_board' already exists

Error performing MySQL command: CREATE TABLE pp_invites ( id int( 12 ) NOT NULL AUTO_INCREMENT , code varchar( 32 ) default NULL , email varchar( 32 ) default NULL , name varchar( 64 ) default NULL , message mediumtext, datestamp int( 16 ) NOT NULL default '0', referer int( 10 ) NOT NULL default '0', status smallint( 1 ) NOT NULL default '0', uid int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , UNIQUE KEY code ( code ) ) TYPE=MYISAM
Error: Table 'pp_invites' already exists

Error performing MySQL command: ALTER TABLE pp_users ADD realname varchar(80) default NULL, ADD title varchar(30) default NULL, ADD signature varchar(250) default NULL, ADD avatar varchar(120) default NULL, ADD mature tinyint(1) NOT NULL default '1', ADD invites int(6) NOT NULL default '0', ADD accepts int(6) NOT NULL default '0', ADD laston int(15) NOT NULL default '0'
Error: Duplicate column name 'realname'

Error performing MySQL command: ALTER TABLE pp_photos ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE pp_comments ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: INSERT INTO pp_settings VALUES (226,'Use lightbox integration?','lightbox','','no',32,5)
Error: Duplicate entry '226' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (227,'Width to trigger lightbox integration (if enabled)?','lbwidth','','900',33,5)
Error: Duplicate entry '227' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (228,'Height to trigger lightbox integration (if enabled)?','lbheight','','600',34,5)
Error: Duplicate entry '228' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (229,'Use mature content filter?','mature','Prevents photos marked from mature being shown without user electing to view them.','no',18,2)
Error: Duplicate entry '229' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (230,'Use uniform thumbnail feature?','uniform','','no',26,6)
Error: Duplicate entry '230' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (231,'Uniform thumbnail height?','uniheight','Can only be used when using IM for imaging.','78',27,6)
Error: Duplicate entry '231' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (232,'Uniform thumbnail width','uniwidth','Can only be used when using IM for imaging.','120',28,6)
Error: Duplicate entry '232' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (233,'Use Messaging System for PhotoPost alerts/notices?','usemsg','','yes',38,1)
Error: Duplicate entry '233' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (234,'Use CAPTCHA images when verifying registration?','usecaptcha','Requires GD2 support!','no',4,8)
Error: Duplicate entry '234' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (235,'Enable PhotoPost Message Board?','usebb','Used only for internal PhotoPost systems.','no',5,13)
Error: Duplicate entry '235' for key 1

updating photo tags...done.
scanning for exifs... done.
updating users table...done.
updating votes...
Upgrade complete! You should continue to next step

Do I continue to the next step or not? This is extremely stressful at this point with users constantly emailing complaints every 3 seconds.

webicity · November 5th, 2008, 10:50 AM

Can I call you about this?

webicity · November 5th, 2008, 10:52 AM

The Gallery and PhotoPost admin are still totally blank pages. Not even an error message. Nothing. White. Blank.

webicity · November 5th, 2008, 10:55 AM

OK, no answer, so I went ahead to the next screen -- more errors:

Preparing to update database...

Error performing MySQL command: INSERT INTO pp_settings VALUES (236,'Enable Email a Friend feature?','findfriend','','yes',7,4)
Error: Duplicate entry '236' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (238,'Use images for user menu options on showphoto?','imgmenu','','yes',35,5)
Error: Duplicate entry '238' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (239,'Enable zoom javascript?','zoom','Enable the TJP zoom javascript feature on showphoto?','no',36,5)
Error: Duplicate entry '239' for key 1

Error performing MySQL command: ALTER TABLE pp_messages ADD fromuserid INT( 12 ) DEFAULT '0' NOT NULL AFTER userid
Error: Duplicate column name 'fromuserid'

Now what?

webicity · November 5th, 2008, 11:27 AM

It would be very helpful if "Upgrade" could be included in this page: http://www.photopost.com/manual/index.html That's where I went wrong.

I have asked the datacenter to restore the PP database from yesterday, I will then run the upgrade script again and see if that solves all the problems. Thanks for the suggestions and help.

webicity · November 5th, 2008, 12:45 PM

Datacenter restored the database, I ran the upgrade, same errors, same result except the Admin now works, but the Photopost is still a blank page.

This all started, apparently, when we ran the vBulletin update.

I need some help here, if possible.

webicity · November 5th, 2008, 07:16 PM

Is anybody there?

Chuck S · November 5th, 2008, 09:53 PM

The upgrade instructions are located in the documentations folder and clearly state to upload the files except config files or install file and run upgrade.php and select the upgrades you need.

I would suspect your install messed things up or if you moved your vb folder you might want to edit your photopost config-int.php file and place the proper server path to vb in there and see if photopost comes up.

webicity · November 5th, 2008, 10:30 PM

Thank you for your reply. I was about to lose hope.

I have not moved any folders. I have copied the original config-int and config-inc files. I have verified the server paths and I can't find any errors. File permissions for both config files are full rwx. I got in trouble with vBulletin when I didn't copy in ascii mode so I made sure that I copied the update files to the server in ascii mode - perhaps that was not correct?

webicity · November 5th, 2008, 10:32 PM

What would account for all the MySQL errors in the update running from a fresh MySQL restore from yesterday before all the problems? (see above)

webicity · November 5th, 2008, 10:33 PM

I must have fixed something (recopied the original config files from a backup), but we're still not there. Please view this page and advise:

Main Index - Digital Design Den - Gallery

webicity · November 5th, 2008, 10:35 PM

Is the blue page what is supposed to be there? It doesn't look right.

Category Photos Comments Last Comment Last Photo Upload

Layouts of fireworks, parades and family picnics

lite & fit, sugar free desserts, canning & freezing recipes

Hot August Recipes

using word art

Chuck S · November 6th, 2008, 05:20 AM

Duplicate errors just mean you have already run that upgrade or where already on that version.

IN admin global settings turn off the category cache and see how things view for you.

webicity · November 6th, 2008, 06:17 AM

Thank you, thank you, thank you! What a great way to start a day. I was surprised about the database error thing when it happened because that was on a fresh restore file that I had the datacenter do, and I wasn't expecting it, but apparently no harm was done.

Chuck S · November 6th, 2008, 04:22 PM

Not an issue have a good day.