4.86 step 2 upgrade error

marit · March 11th, 2006, 07:06 AM

I started my 4.86 upgrade (I finally got this far, thanks to Chuck!!) and made it through step 1 without too much problems (only got a duplicate error on some tables, but I read here that it was nothing to worry about). So I made it to step 2, but there are quite a few files I just can't move, no matter how many times I hit refresh. I looked at the files, and I can't manage to chmod them to 777. They're set at 644 and it tells me it can't change the files because of "Bad file descriptor". Can I still proceed to step 3 without moving these files? Or what do I need to do to get them changed to 777? My host said all files were 777 in the data/500 folder, but they were obviously wrong?

I also noticed that in the data/500 folder, there is no thumbs, mini and medium folders. I just tried to upload them without luck, and then tried to create them, but they aren't showing up at all. But if I type in the path in my ftp program data/500/thumbs/ the index file there shows up. Any idea what's going on and how I can fix it?

Thanks!

Chuck S · March 11th, 2006, 07:10 AM

Have your host look into this issue with your data directory before continuing. If the files can not be moved the directories are not 777 and must be.

Your host could be able to issue a recursive chmod like so on your data directory and fix any issue with bad file descriptor

Tell them about this bad file descriptor error on certain directories

CHMOD -R 777 data

marit · March 11th, 2006, 07:19 AM

Thanks, Chuck! I just sent them an e-mail now

marit · March 11th, 2006, 03:55 PM

Doesn't look like I'll be getting any help from my host until after the weekend, so I've tried a couple of things. The first thing I did was create a new /500/ folder under /web/ and uploaded all the pics from the /data/500/ folder on my computer to that. Then I tried to replace the old /500/ folder, but all the permissions was reset as soon as I placed it under /data/. And then I discovered that if I deleted one of the files in the /data/500/ folder, it still said I had 1999 pics in that folder, which really got me wondering what was going on. I then discovered that it says on my FTP "Output truncated to 2000 matches", so I didn't even have all the pics in the folder, anyway. But now I have been looking at the pics I can't change the permissions of, and I'm wondering if I can move the files manually? I see that the change that is made is that the files are moved to the /500/thumbs/ folder, and that "thumb" is removed from the filename... all the files it can't move either has thumb or medium in the name.

For instance for (part of the error code in step 2)

Code:

Content visible to verified customers only.

I could manually move the 378ppgutt-thumb.jpg file from /500/ to /500/thumbs/ and rename it 378ppgutt.jpg

Would that work? At least it would get me started...

Chuck S · March 11th, 2006, 06:10 PM

I think alot of the issue you have is the permissions issues on the various folders.

See if we can not set permissions on the 500 thumbs directory because you can not stat the directory and the bad file directory the script can not move and rename the file.

Your best bet is to wait till your host really looks into exactly what is going on in there. It is clear there is something wrong.

marit · March 12th, 2006, 05:36 AM

I found a way to change the permission of the thumbs, mini and medium folders to 777, so now I made it to 5.0 step 1 (I created a subfolder and moved enough of the files there for the 3 folders to appear, and then I could change the permissions)

5.0 step 1 seems to have stopped in the middle of the page, so I'm wondering if I can refresh the page? This is all I got

Quote:

Preparing to update database...
Error performing MySQL command: ALTER TABLE pp_categories ADD ismember SMALLINT(1) default '0' NOT NULL
Error: Duplicate column name 'ismember'

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

Error performing MySQL command: INSERT INTO pp_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.scrapbookexpress.no/galleri/data',34,1)
Error: Duplicate entry '207' for key 1

Error performing MySQL command: INSERT INTO pp_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','/data/www/vsite303/web/galleri/data/',35,1)
Error: Duplicate entry '208' for key 1

Error performing MySQL command: INSERT INTO pp_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

There's no place to move on to the next step...

Chuck S · March 12th, 2006, 06:34 AM

Did you ever complete 4.86 upgrade? 5.0 forward will complete just give it time.

marit · March 12th, 2006, 10:19 AM

Quote:

Originally Posted by Chuck S

Did you ever complete 4.86 upgrade? 5.0 forward will complete just give it time.

Yes, the 4.86 upgrade went fine, after I got the thumbs folder set to 777, and I clicked on the 5.0 upgrade link from there. The upgrade.php?upgrade=50&step=1page still says the same thing as before, so can I hit refresh, or should I just hit upgrade.php again and chose 5.0 from there?

And when I just looked in my admin panel, it says I have version 5.3 in place... any idea how that happened? In the DB it says I have version 5. How should I proceed now?

Chuck S · March 12th, 2006, 12:15 PM

Duplicate inserts etc you don't worry about but what I am saying is you need to let it finish. 5.0 is also another big step that can take a while on larger systems cause it is checking the photo and comments titles description and stripping any slashes in them so they display right with our new typecast sanitizer forward.

marit · March 12th, 2006, 12:21 PM

So it can take this many hrs for the page to finish? Or is it a time-out problem? The page isn't loading anymore, it just says "Finished" at the bottom of my browser window.

marit · March 12th, 2006, 04:57 PM

Still nothing has changed, and it's been sitting here for almost 12 hrs now, so there must be something wrong. How can I get the process to move further?

marit · March 12th, 2006, 05:16 PM

I found the fix in another post here!

Quote:

In your upgrade.php add this at top and run any missing upgrades

define( 'THIS_SCRIPT', "upgrade" );
$skip_exheader = "yes";

That's all I needed!

Now I need to test to see if it's working properly, but at least the upgrade is done LOL

Chuck S · March 12th, 2006, 05:32 PM

You sure your using the latest code as thats an old post and our upgrade file right in 5.0 upgrade has this

Code:

Content visible to verified customers only.