error on upgrade from 3.1.1

[ncangler]

I just started the upgrade process to go from 3.1.1 to 3.3.1 and had errors on step 2 of the upgrade to 3.2. The errors looked like this:

Preparing to move files...

Warning: fopen(/home/******/public_html/reviewpost/data/1/thumbs/index.htm) [function.fopen]: failed to open stream: Permission denied in /home/******/public_html/reviewpost/pp-inc.php on line 2849

Warning: fclose(): supplied argument is not a valid stream resource in /home/******/public_html/reviewpost/pp-inc.php on line 2850

Warning: fopen(/home/******/public_html/reviewpost/data/1/large/index.htm) [function.fopen]: failed to open stream: Permission denied in /home/******/public_html/reviewpost/pp-inc.php on line 2855

Warning: fclose(): supplied argument is not a valid stream resource in /home/******/public_html/reviewpost/pp-inc.php on line 2856

Warning: fopen(/home/******/public_html/reviewpost/data/2/thumbs/index.htm) [function.fopen]: failed to open stream: Permission denied in /home/******/public_html/reviewpost/pp-inc.php on line 2849

Warning: fclose(): supplied argument is not a valid stream resource in /home/******/public_html/reviewpost/pp-inc.php on line 2850

Warning: fopen(/home/******/public_html/reviewpost/data/2/large/index.htm) [function.fopen]: failed to open stream: Permission denied in /home/******/public_html/reviewpost/pp-inc.php on line 2855

Warning: fclose(): supplied argument is not a valid stream resource in /home/******/public_html/reviewpost/pp-inc.php on line 2856

Warning: copy(/home/******/public_html/reviewpost/data/2/large/1TG-30-II_large.gif) [function.copy]: failed to open stream: Permission denied in /home/******/public_html/reviewpost/upgrade.php on line 1125
Copy photo 1: of /home/******/public_html/reviewpost/data/2/1TG-30-II_large-large.gif to /home/******/public_html/reviewpost/data/2/large/1TG-30-II_large.gif failed!

Warning: copy(/home/******/public_html/reviewpost/data/2/thumbs/1TG-30-II_large.gif) [function.copy]: failed to open stream: Permission denied in /home/******/public_html/reviewpost/upgrade.php on line 1134
Copy of photo 1: /home/******/public_html/reviewpost/data/2/1TG-30-II_large-thumb.gif to /home/******/public_html/reviewpost/data/2/thumbs/1TG-30-II_large.gif failed!

etc. Any idea what could be causing this?

[ncangler]

BTW I checked the permissions for data and upload directories and all subdirectories under them. All were 777. The good news I guess is that I only had 45 products in the database for review. If this had happened with Photopost I'd be in big trouble. I haven't proceeded to the next step though awaiting a possible solution. Thanks for any help!

[ncangler]

Okay I may have really screwed up here. I had in my forum notes that the last upgrade I did was to 3.1.1 but I just went into the Reviewpost Admin and it says 3.3.1. I must have already upgraded and forgot to change it in my notes! So now I've run steps 1 and tried to run step 2 of the 3.1.1 upgrade and now my photos aren't showing up. Is there a fix for this stupidity?

Note to self...always check the version number in the Admin before starting an upgrade. Duh!

[ncangler]

Now I'm getting this error in Admin:

Warning: fopen(config-intr.php) [function.fopen]: failed to open stream: Permission denied in /home/ncangler/public_html/reviewpost/adm-misc.php on line 1538

Warning: fwrite(): supplied argument is not a valid stream resource in /home/*******/public_html/reviewpost/adm-misc.php on line 1539

Warning: fclose(): supplied argument is not a valid stream resource in /home/******/public_html/reviewpost/adm-misc.php on line 1540

[ncangler]

And this error when I select one of the products:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/*******/public_html/reviewpost/showproduct.php on line 137

[ncangler]

Another note to self....don't do upgrades when you haven't had much sleep. It occurred to me that that since I had uploaded edited config-inc.php and config-intr.php files that the Reviewpost version number (3.3.1) would be changed in the Admin. So perhaps I hadn't run the upgrade script after all. So I uploaded a new upgrade.php file and went through all the steps . I still had the same errors as in the initial post in 3.1.1 upgrade step 2. All other steps completed without errors. The above posted errors in Admin now seem to have disappeared.

All the thumbs on the Reviewpost home page are not showing up, but over half of the photos for the actual product reviews do show up. I tried to run rebuild thumbs, etc. in Admin but got errors. I'm not sure how to get the thumbs back for the main page.

Is this thoroughly confusing now or do you have any suggestions.

[ncangler]

Just tried to upload a replacement photo for one of the products and received this error:

Error creating thumbnail! Error code: 1

Command: "/usr/bin/mogrify" -size 97x100 -quality 70 -geometry 97x100 /home/******/public_html/reviewpost/data/2/thumbs/1OkumaIntegrity5_6.jpg

At the top of the page above my header was this error:

Warning: copy(/home/*****/public_html/reviewpost/data/2/thumbs/1OkumaIntegrity5_6.jpg) [function.copy]: failed to open stream: Permission denied in /home/*****/public_html/reviewpost/image-inc.php on line 455

Warning: unlink(/home/******/public_html/reviewpost/data/2/thumbs/1OkumaIntegrity5_6.jpg) [function.unlink]: No such file or directory in /home/******/public_html/reviewpost/image-inc.php on line 487

All of this certainly seems to be permissions related, but I have checked and rechecked all the data and uploads folders and subfolders and all are 777.

[ncangler]

Sorry for the blog here, but I fixed it! It was permissions. For some reason the 'large' and 'thumbs' subfolders of folder '2' were not being set to '777'. I thought I checked it last night but apparently skipped over that one.

[Chuck S]

Yep you got it

You can restore a copy of the products table and rerun the upgrade to get products back as well