PhotoPost Community - TKO'd right in the middle of my upgrade....

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)

- - TKO'd right in the middle of my upgrade.... (http://www.photopost.com/forum/photopost-pro-installation-upgrades/131262-tkod-right-middle-my-upgrade.html)

TKO'd right in the middle of my upgrade....

Here's the error... what did i do/not do ?

Quote:

Preparing to update 4.0 database...
Performing MySQL command: DELETE FROM pp_settings WHERE id=16; ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: DELETE FROM pp_settings WHERE id=17; ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: DELETE FROM pp_settings WHERE id=55; ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: UPDATE pp_settings SET title='PATH to UPLOADS directory?' WHERE id=81; ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: UPDATE pp_settings SET title='URL to UPLOADS directory?' WHERE id=82; ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: REPLACE INTO pp_settings VALUES (84,'PhotoPost Version','pversion','','4.1',53,0); ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: REPLACE INTO pp_settings VALUES (128,'Pixel size of borders for images/thumbnails','cellpadding','Thickness - set to 0 for no border','2',60,2); ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: REPLACE INTO pp_settings VALUES (129,'Color for image borders','framecolor','Color of the frame around images/thumbs','#000000',61,2); ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: REPLACE INTO pp_settings VALUES (88,'Quality setting for image resizing/thumbnails?','imgquality','','70',89,3); ... Error: Table 'louisian_photopost.pp_settings' doesn't exist
Performing MySQL command: ALTER TABLE pp_iponline DROP PRIMARY KEY, ADD PRIMARY KEY (`ipaddr`); ... Error: Table 'louisian_photopost.pp_iponline' doesn't exist
Performing MySQL command: UPDATE pp_settings SET title='Do you want Members Gallery to show all of a users photos?' WHERE id=94; ... Error: Table 'louisian_photopost.pp_settings' doesn't exist

Next step gave me a simple message "Database not properly setup. Contact administrator"

Please adivse

Did you overwrite you config file? This seems logically what you did. If so edit the config file and place the proper info for your install in there

Quote:

Originally Posted by Chuck S (Post 1193489)

Did you overwrite you config file? This seems logically what you did. If so edit the config file and place the proper info for your install in there

I uploaded the newest config file after editing it with the correct paths, db name, password, etc....

How about the correct table prefix for the tables ;)

Quote:

Originally Posted by Chuck S (Post 1193494)

How about the correct table prefix for the tables ;)

hrrrmmm.... i left the default one... where would I find that info as my old config file did not have it.... i'm like 2 years behind on upgrading :)

You can try viewing your database and verify this info and double check the config. I can not tell your whats wrong only that it is not right by your error

Quote:

Originally Posted by Chuck S (Post 1193503)

You can try viewing your database and verify this info and double check the config. I can not tell your whats wrong only that it is not right by your error

I got it fixed Chuck... thanks...

Ill try to get this finished and report my next error as soon as I come across it :)

Well actually it seems like my system keeps timing out at 'upgrade=55&step=1'

It ran for like 2 hours and then timed out.... is that correct?

Chuck, here's what im left with:

I edited config-int.php manually through FTP.... got that working fine and my integration looks fine.... now when I click on admin i am unable to access my admin control panel...

Also, all images and thumbnails are there but i get the default thumbnail image and a red X when I try to view the actual image...

Any help man?

What do you mean you can not get into admin?

Yor paths in global and storage options are wrong if you can not see thumbs. You need to get into admin to fix that.

Let me know more info about your admin issue

Ok I was able to get into admin cp.... im going to work on the paths.... is it safe to say that url paths should have a trailing slash and server paths should not?

No

server path to your data directory is the only one that has a trailing slash nothing else should

Chuck, I give up... all my paths appear to be correct but I'm getting no images. Im assuming this has something to do with all my timeouts during the upgrade. The site also appears to take forever to load any pages in the gallery even though images aren't loading. I dont know what else to do except start all over

what is a url to an image? url to your gallery

http://www.louisianaclubscene.com/galleries

PS - Looks like all 69,000 images got deleted when attempting to rebuild thumnails and medium images :/

I still see them when I FTP in, but the gallery says 0 exist

Your path to the data directory is wrong it would appear then or severe permissions errors

Quote:

Originally Posted by Chuck S (Post 1193660)

Your path to the data directory is wrong it would appear then or severe permissions errors

Naaah, the path is correct and all the permissions are set correctly according to the manual. This happened once before to another site and you fixed it. I just can't remember what you did. :/

No doubt fixed the path issue ;) I replied to your other thread so lets keep the discussion there

Quote:

Originally Posted by Chuck S (Post 1193694)

No doubt fixed the path issue ;) I replied to your other thread so lets keep the discussion there

Ok thats fine, but keep in mind that both threads are not for the same site. I have 2 sites with 2 different (but somewhat similar) problems.