Failed Upgrade to 5.5

Tracker · October 10th, 2006, 04:28 PM

Just tried to upgrade from 5.3 to 5.5 and got the following when running the upgrade.php file. I now get a blank page when trying to login to photopost. Any ideas before I make things any worse.

Preparing to update database...
Error performing MySQL command: INSERT INTO pp_settings VALUES (213,'Show html code to display photos?','showhtml','Do you want to show the img src html tag for a photo?','no',6,5)
Error: Duplicate entry '213' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (214,'Show direct links to photos?','showdirect','Do you want to display the page link to a photo?','no',7,5)
Error: Duplicate entry '214' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (215,'Load limit for server?','loadlimit','If running *nix and you want to disable your forums when load goes over a certain limit; place the high limit here.','0',35,1)
Error: Duplicate entry '215' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (216,'Default number of thumbnail rows?','thumbrows','How many rows of thumbnails do you want to display by default on this page?','3',5,4)
Error: Duplicate entry '216' for key 1

Error performing MySQL command: ALTER TABLE pp_categories ADD thumbtype INT(2) UNSIGNED DEFAULT '0'
Error: Duplicate column name 'thumbtype'

Error performing MySQL command: INSERT INTO pp_settings VALUES (217,'Use category cache?','catcache','On some larger sites, using the category cache can actually reduce performance.','yes',36,1)
Error: Duplicate entry '217' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (218,'Display Featured Photos on this page?','features','On larger sites this option can slow down the showgallery page. Turn off to speed up this page.','yes',8,5)
Error: Duplicate entry '218' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (219,'Display Admin quick move/delete options under photo?','quickopts','On larger sites this option can slow down the showphoto page. Turn off to speed up this page.','yes',8,5)
Error: Duplicate entry '219' for key 1

Error performing MySQL command: ALTER TABLE pp_categories ADD subalbum INT(12) DEFAULT '0' NOT NULL AFTER albums
Error: Duplicate column name 'subalbum'

Upgrade complete! You may now remove the upgrade.php script.

Chuck S · October 10th, 2006, 04:41 PM

duplicate entry just means you ran the upgrade more than once.

some more info here would assist us like url to your install integration type etc. You did not replace your config files right? If your integrating with vb3 make sure your $vbpath is correct. This will cause a white page.

Tracker · October 11th, 2006, 06:32 AM

Sorry Chuck it was late when I first posted.

More info then:-
I copied all the 5.5 update files to the correct folders on my 5.3 installation. I then ran the upgrade.php file and received the message in my above post(this was on the first run of upgrade.php). I then tried to access my site and received a white but blank screen. On reading some posts on this forum I though maybe I should copy my original config files back, but this did not help, I ran the upgrade.php again with my original config files, no different.
If I add the index.php to the end of the url I receive the following message,
Fatal error: Call to undefined function: update_whoonline() in /homepages/5/d161531532/htdocs/photopost/pp-inc.php on line 484

My installation is at http://www.trackaction-online.co.uk/photopost/

PS: My forum is phpbb and uses the same mysql database, I didn't close the forum before upgrade but I did close photopost.

Chuck S · October 11th, 2006, 09:02 AM

You need to make sure you have uploaded all the new files. The error your posting tells me you have not uploaded all the files.

Tracker · October 11th, 2006, 11:40 AM

Phew..Thanks I've uploaded all the files again and I can now gain access, do I need to run the update.php again? The site does look different so I'm assuming the update is now applied.

Chuck S · October 11th, 2006, 12:13 PM

You should be fine you already upgraded the database

Tracker · October 11th, 2006, 12:20 PM

I've Just noticed that when I try to access any images I get the following error message.
Is this because I have the board set to closed or is this some other type of problem?

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,user,userid,cat,storecat,storeid,date,title,description,keywords,bigimage,width,
height,filesize,views,medwidth,medheight,medsize,approved,rating,extra1,extra2,extra3,extra4,
extra5,extra6,disporder,ipaddress,allowprint,allowrate,allowcoms FROM pp_photos WHERE id=92

Result: Unknown column 'allowrate' in 'field list'

Database handle: Resource id #6

Chuck S · October 11th, 2006, 12:33 PM

Your missing a column rerun the 5.3-5.5 upgrade

Tracker · October 11th, 2006, 12:47 PM

Yep, that works fine, your a genius mate, thanks very much.

Just one last little question, I now need to add "\index.php" to the end of my URL, previously I didn't need to do this, any idea?

Chuck S · October 11th, 2006, 12:55 PM

Depends on your site do you have an htaccess on your main web root with something like this in it?

Directory Index index.php

Tracker · October 11th, 2006, 02:15 PM

Quote:

Originally Posted by Chuck S

Depends on your site do you have an htaccess on your main web root with something like this in it?

Directory Index index.php

I can't find one, but that file name does ring a bell with me. No big issue though I can work around it.

Thanks again for all your help.

Chuck S · October 11th, 2006, 06:37 PM

You need to create a file named .htaccess and put it in your web root with the line I noted above being the contents of that said file.