Help with 5.1 to 5.21 please!

[caliman]

Ah man I screwed up..

I missed the 5.1 to 5.11 option in the upgrade and went right to 5.1x to 5.2..

I got this:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in

/photos/pp-inc.php on line 2872

i noticed i uploaded inc-features and inc-photopost which the instructions said not to, so I restored them and reran upgrade and got this:

Preparing to update database...

Error performing MySQL command: CREATE TABLE pp_cache (id tinyint(1) NOT NULL

default '1', timestamp int(15) NOT NULL default '0', statscache mediumtext, recentcache

mediumtext, popularcache mediumtext, randomcache mediumtext, calcache mediumtext,

catcache mediumtext, catprops mediumtext, PRIMARY KEY (id), KEY id (id))

TYPE=MyISAM
Error: Table 'pp_cache' already exists

Error performing MySQL command: INSERT INTO pp_cache VALUES

(1,0,null,null,null,null,null,null,null)
Error: Duplicate entry '1' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (211,'Minutes to

cache index page data for featured photos, statistics and PALs?','cachetimeout','Number of

minutes to cache information. Default is 10 minutes, 0 means no caching.','10',36,1)
Error: Duplicate entry '211' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (212,'Show

Calendar PAL?','calpal','Do you want to display the calendar pal, yes or no.','yes',16,11)
Error: Duplicate entry '212' for key 1


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in

/photos/pp-inc.php on line 2872

Upgrade complete! You may now remove the upgrade.php script.

---------

THEN I SAW that I missed the 5.1 to 5.11 and ran that.

That upgraded without errors, but when I reran the 5.1x to 5.2 I still got errors similar to the first time..

UGH.. when I look at the photopost on my site it looks fine except at the header I have this:

Warning: Invalid argument supplied for foreach() in /photos/pp-inc.php on line 2889

Warning: Invalid argument supplied for foreach() in /photos/pp-inc.php on line 2889

Warning: Invalid argument supplied for foreach() in /photos/pp-inc.php on line 2889

Can someone please help me fix this mess.. I feel like an idiot!

[caliman]

After restoring database to prior to install I got this after upgrading correctly...

5.0 to 5.1 went fine, then 5.1 to 5.2 go this:

Preparing to update database...

Error performing MySQL command: CREATE TABLE pp_cache (id tinyint(1) NOT NULL default '1', timestamp int(15) NOT NULL default '0', statscache mediumtext, recentcache mediumtext, popularcache mediumtext, randomcache mediumtext, calcache mediumtext, catcache mediumtext, catprops mediumtext, PRIMARY KEY (id), KEY id (id)) TYPE=MyISAM
Error: Table 'pp_cache' already exists

Error performing MySQL command: INSERT INTO pp_cache VALUES (1,0,null,null,null,null,null,null,null)
Error: Duplicate entry '1' for key 1


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /pp-inc.php on line 2872

Upgrade complete! You may now remove the upgrade.php script.



-----

Again I am getting the pp-inc error in the header and when I click on some images they come up broken.

[Chuck S]

You missing a step somewhere or you think your running a version your not. In your old pp-inc.php file should be the version number you can find

Your board is closed so I cant see exactly what your missing but you can edit the new pp-inc.php and do this

// Set this to 1 if you want to see debug information (only prints for admins)
// Set this to 2 is you want to print out queries and timing info
$showsqldebug = 2;

it will show you what your missing so I can tell you what upgrades your missing

[caliman]

This is f'ing weird.

I changed the debug from 0 to 1 per your request and the thing is behaving now and appears to be working. What the heck is going on?

EDIT1- Ok, when I click profile and manage photos it says I don't have any photos in the member gallery category, but when I go directly there I see them.

EDIT2 I have to scroll to see the calendar.. Some table issue here.

EDIT3- Rate this photo is not showing numbers above the radio buttons anymore, is this on purpose?

EDIT4 - not all cats are showing up..1st 3 are, last 3 are not.

FYI - SITE IS LIVE, check it out.

[Chuck S]

Well showsqldebug I said set to 2 and it will show you what your missing

Site looks fine looks like you finally ran all the upgrades

[caliman]

Sorry, I set it to 2 initially and didn't see anything.. but that was because the text was white on white... you can check it out now... lots of code there, I don't see any errors though.. do you?

[Chuck S]

Your page looks fine as stated and its only set to 1 right now


Page generated in 0.37263 seconds with 9 queries

[caliman]

I think you might have it backwards Chuck.. looking at pp-inc:

// Set this to 1 if you want to see debug information (only prints for admins)
// Set this to 2 is you want to print out queries and timing info
$showsqldebug = 1;

So I just set it to 1!


Any idea why some of my cats aren't showing up though? When I go to edit cats, it lists them, but they are not hyperlinked like the others.

Also, how do I fix the index page so the table doesn't blow out like it does now? I couldn't find that in the templates..

THANKS FOR YOUR HELP BY THE WAY!

[Chuck S]

In my post I state to set that to 2 not 1 so I dont think I have it backwards

Your cats show up fine for me when I look at your install

As far as a page with 2 sidebars and trying to get it to show without scrolling you can try this

1. set your index options not to show the last comments column and or last photos column in admin

if your still scrolling

2. set in layout options your columns to 3 and thumbnails to show to 6 instead of 4 and 8

[caliman]

Originally Posted by Chuck S

In my post I state to set that to 2 not 1 so I dont think I have it backwards

I'm confused! hahah..

Originally Posted by Chuck S

Your cats show up fine for me when I look at your install

See attachment... after messing with it, I can see them on index now, but they aren't hyperlinked in 'edit categories.'

Originally Posted by Chuck S

As far as a page with 2 sidebars and trying to get it to show without scrolling you can try this

1. set your index options not to show the last comments column and or last photos column in admin

This seemed to do it! Thanks for that Chuck.

[caliman]

Here is the attachment.

Ohhh I figured it out... they don't have subcats...

Never mind on this part.

Thanks again Chuck. heh.. this stuff makes me nervous.. PM me with rates on upgrading stuff - seriously!

[Chuck S]

Yep only cats with subcats have hyperlinks in edit cats