Ug.. i hate asking for support but im lost

Fred · June 13th, 2006, 07:38 PM

stuck at the first step upgrade with 5.0 to 5.1

i get this

Quote:

Preparing to update database...

Error performing MySQL command: ALTER TABLE categories ADD ismember SMALLINT(1) default '0' NOT NULL
Error: Duplicate column name 'ismember'

Error performing MySQL command: ALTER TABLE categories ADD albums TEXT AFTER children
Error: Duplicate column name 'albums'

Error performing MySQL command: INSERT INTO settings VALUES (207,'Original Image storage directory URL','origdir','Typically this path matches your DATA directory URL, unless you want to store your original images seperatly from your thumbnail/medium images','http://www.sportbikes.net/photos/data',34,1)
Error: Duplicate entry '207' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (208,'Orignial Image storage directory server path','origfull','Typically this path matches your DATA directory server path, unless you want to store your original images seperatly from your thumbnail/medium images','/home/fred/www/photos/data/',35,1)
Error: Duplicate entry '208' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (209,'When using on-the-fly image generation, do you want to overlay the watermark image?','overwater','You can use this feature for on-the-fly watermarks in combination with the on-the-fly image generation.','no',30,5)
Error: Duplicate entry '209' for key 1

Warning: unlink(/home/fred/www/photos/adm-userg.php): No such file or directory in /home/fred/public_html/photos/upgrade.php on line 2100

Warning: unlink(/home/fred/www/photos/adm-approve.php): No such file or directory in /home/fred/public_html/photos/upgrade.php on line 2101

Warning: unlink(/home/fred/www/photos/adm-db.php): No such file or directory in /home/fred/public_html/photos/upgrade.php on line 2102

Warning: unlink(/home/fred/www/photos/adm-menu.php): No such file or directory in /home/fred/public_html/photos/upgrade.php on line 2103
Home · Search · Register

Sportbikes.net Photo Gallery Message
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Config is ok.. paths look to be ok. i can see the photos.. however thumbnails and images are not showing

Fred · June 13th, 2006, 08:15 PM

Looks like all the paths might be incorrect for each image? When I right click the image it shows the images not there. However I can see them. Its just different file names now?

Fred · June 13th, 2006, 08:18 PM

yup.. all images are new file names. I am guessing this is something to do with the upgrade. However each step moved ok from anything below 5.0

any ideas?

Chuck S · June 14th, 2006, 10:06 AM

That just means you have ran the 5.0-5.1 upgrade before just proceed one to the others.

Fred · June 14th, 2006, 11:08 AM

Ok Chuck. I ran all the upgrades. Still missing the files though. No thumbnails are showing and also no images.

Chuck S · June 14th, 2006, 11:09 AM

Well if no thumbnails are showing my not post a link here so I can see. You could have possibley ran the 4.86 upgrade when you should not have.

Fred · June 14th, 2006, 11:26 AM

Ohh boy.. im going to need a spanking.. i did run the 4.86.. i thought you needed to go step by step..

man i always have bad luck upgrading photopost.. i have yet had a good experience in upgrading.. hehehe why i always wait untill i have to upgrade..

http://www.sportbikes.net/photos/

so anyways.. yes i did run all the upgrades on the list.. is there a way i can undo that without having to go to backup? 6 years running this program you would think i would have it down pat by now.. heck when i move servers i still change my settings using phpmyadmin becuase its so much easier.. course i guess thats what you get used too running these things.

let me know what i need to do. Hopefully there is a easy way to back out of this but still ave it updated to the latest and greatest..

Fred · June 15th, 2006, 02:58 PM

any answer on this?

Chuck S · June 15th, 2006, 06:51 PM

basically the way out of this would be to restore the photos table from a backup prior to the upgrade which you should have made anyway since the upgrade instructions state to take one before starting. Restore that backup and you can safely run 5.0-5.3 thats it just to make sure you got everything

You where running a 5.0 series before not 4.8 series so you should not have ran that one again it changes the filenames

Fred · June 16th, 2006, 11:49 AM

kind of figured that was going to be the only way. Alright. I will have to do a restore..

BTW.. i was running 4.7 before all this. Basically what i did was upgraded to 4.8 and down the line. Figured you would have to do it in order. no instructions told me to skip any steps.. i am guessing i should have gone right to 5.0?

Chuck S · June 16th, 2006, 02:41 PM

Do a restore and go right down the line running each upgrade ONLY ONCE.

Fred · June 18th, 2006, 12:55 PM

Chuck,

I am still getting this error when i get to the 5.0 part

Quote:

Preparing to update database...

Warning: unlink(/home/fred/www/photos/adm-userg.php): No such file or directory in /home/fred/public_html/photos/upgrade.php on line 2100

Warning: unlink(/home/fred/www/photos/adm-approve.php): No such file or directory in /home/fred/public_html/photos/upgrade.php on line 2101

Warning: unlink(/home/fred/www/photos/adm-db.php): No such file or directory in /home/fred/public_html/photos/upgrade.php on line 2102

Warning: unlink(/home/fred/www/photos/adm-menu.php): No such file or directory in /home/fred/public_html/photos/upgrade.php on line 2103
Home · Search · Register

Sportbikes.net Photo Gallery Message
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Chuck S · June 18th, 2006, 02:55 PM

Just move on to the next upgrade

Fred · June 19th, 2006, 09:16 AM

Quote:

Originally Posted by Chuck S

Just move on to the next upgrade

Ok. Tried that out. Still missing thumbnails and images

Chuck S · June 19th, 2006, 10:46 AM

You need to open the gallery so we can see what you did.

Fred · June 19th, 2006, 01:37 PM

Its open now.

I basically took the old database.. (backed up one) did the upgrade.. everything goes fine all the way to 5.

However after that it doesnt work.. no thumbnails no images..

Chuck S · June 19th, 2006, 03:09 PM

Looks to me like your running the 4.85 upgrade when you dont have tp cause look here

http://www.sportbikes.net/photos/dat...14IMG_3085.JPG

however the image exists here

http://www.sportbikes.net/photos/dat...s/IMG_3085.JPG

Fred · June 21st, 2006, 09:30 AM

Chuck,

I have tried to do this upgrade about a dozen times now.

i keep dropping and readding the database.. however the upgrade never gets completed correctly.

This just doesnt make any sence

Fred · June 21st, 2006, 09:35 AM

Well even if i go back to 4.7 it still isnt showing the images.. path issue all the sudden?

Chuck S · June 21st, 2006, 02:21 PM

Your site is closed so I can not respond further on any issues other than what I have responded on. I would need to be able to see your site to comment.