error after upgrading from 4.7

[lakauai]

oh man, I knew I would mess this up if I tried it by myself. Of course I don't know what went wrong - I didn't get any further than the first step after running the upgrade.php

This is what I did:
checked for changes that needed to be made to the config file, and did so in both config-inc.php and config-int.php These included the paths, database names, username and pw, etc. I did not see anything about the $cookie_domain as noted in the upgrade.txt file.

When I ran the upgrade.php file, I got the blue screen that said to choose which version I was upgrading from, I chose 4.7, clicked it and another blue screen came up which said

This install script will upgrade your 4.7 release. Only run this upgrade if you have the 4.7 version of the database in place (either by previous upgrades or if upgrading in order to the latest).

Proceed to Upgrade -->

I clicked the link and absolutely nothing happened.
I then unzipped the upgrade package again, uploaded it to my server again, and tried again, same result.

Also, I don't know if this is related or not, but when I went to the gallery page to first perform the upgrade.php I saw the following errors at the top of the page:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/scribbl/public_html/photpost/forums/vb3.php on line 365

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/scribbl/public_html/photpost/pp-inc.php on line 2932

any and all help will be much appreciated!
Here is a link:
http://www.scribblesonline.com/photpost

**edited to add**
Server Type - Linux
Web Server - Apache v1.3.33
PHP - 4.3.11
MySQL Version - 4.0.22-standard

semi-dedicated server through Hostrocket.com

[lakauai]

also I just realized that I no longer have the Admin option even though it shows I am logged in when I go to the gallery home page.
Maybe that will fix itself when the upgrade is fixed?

[Chuck S]

Hello try adding this in bold belowto your upgrade.php file and run any applicable upgrades only once. Let me know how that works out.

Content visible to verified customers only.

[lakauai]

yep, that worked like a charm Chuck. Thanks so much for your help! You helped me out last time I mucked up my gallery, and I really appreciate all you do!
The upgrade went smoothly after that, it seems. However, when I went to the gallery home page, it seems that many of the thumbnails are missing. I went to the Admin to check for and recreate them, I think it rebuilt a few of them, but this is the message I got:

Processing may take a while... please be patient and wait the for FINISHED message...

Checking photo #177: done.
Checking photo #178: done.
Checking photo #181: done.
Checking photo #182: done.
Checking photo #289: rebuilding /home/scribbl/public_html/photpost/data/500/thumbs/39brotherslo.jpg from /home/scribbl/public_html/photpost/data/500/39brotherslo.jpg ...
Warning: copy(/home/scribbl/public_html/photpost/data/500/thumbs/39brotherslo.jpg): failed to open stream: Permission denied in /home/scribbl/public_html/photpost/image-inc.php on line 260


Error creating thumbnail! Error code: 127

Command:

"/usr/bin/convert" +profile "*" -size 95x100 -quality 70 -geometry 95x100 -unsharp 10 '/home/scribbl/public_html/photpost/data/500/thumbs/39brotherslo.jpg'

I am thinking it has something to do with the path I put in, I wasn't positive what to put there - but I found that path in the admin CP of the 4.7 PP gallery - maybe that was not correct?

thanks again Chuck!

[Chuck S]

/usr/bin/convert

I would suggest you try this since we are looking for mogrify not convert

/usr/bin/mogrify

If you have anything else you need assistance with feel free to let me know

[lakauai]

ok, thanks for that - I changed it and went back into the Admin to check for and create missing thumbnails again, I got the same error message, with slightly different photo #'s and different filenames.

Processing may take a while... please be patient and wait the for FINISHED message...

Checking photo #177: done.
Checking photo #178: done.
Checking photo #181: done.
Checking photo #182: done.
Checking photo #292: image /home/scribbl/public_html/photpost/data/500/39small_boy_lo.jpg not found, removing from database... done.
Checking photo #510: rebuilding /home/scribbl/public_html/photpost/data/500/thumbs/39fingerprintslo1.jpg from /home/scribbl/public_html/photpost/data/500/39fingerprintslo1.jpg ...
Warning: copy(/home/scribbl/public_html/photpost/data/500/thumbs/39fingerprintslo1.jpg): failed to open stream: Permission denied in /home/scribbl/public_html/photpost/image-inc.php on line 260


Error creating thumbnail! Error code: 127

Command:

"/usr/bin/mogrify" +profile "*" -size 96x100 -quality 70 -geometry 96x100 -unsharp 10 '/home/scribbl/public_html/photpost/data/500/thumbs/39fingerprintslo1.jpg'

Should I keep trying that - or use the Rebuild all thumbnails feature?

[Chuck S]

I would suggest you PM me with server details to see what is going on before you continue.

I would not want you to delete all your photos in case something is wrong. We can pick up on this when I have a chance to look and see what the issue is. If your permissions where not correct on the data directory when you ran the upgrade this could cause some issues so let me check your install.

[lakauai]

uh-oh, ok thanks Chuck
sending PM now.

[Chuck S]

Okay your problem was that the thumbs medium and mini directories under category 500 which is the members gallery where not set to 777. Most likely because of the extreme amount of files in that directory there was trouble stating things.

I have fixed this for you and rebuild thumbs and mediums you should be all set.

[lakauai]

whew, I just finished rebuilding the thumbnails, that was a slow process, but thankfully - everything looks good again.

thanks for your help on this Chuck.