problem accessing categories

[Zach]

Hello,

I've been asked to try and figure out some problems a client is having with their photopost site. I was not the one that initially installed it so I have limited knowledge of what occured during that process.

When I try to edit categories in the admin panel, none of the categories show up. All I see is this:

Add Top Level Category

Member Galleries (Order: [Delete] [Add Subcat] [Edit] [Empty] [Moderators]

When I try adding a category, when I click the "add category" button, the screen goes blank. If I try clicking on the edit button for the member galleries line, I get this error:

Unable to find category: 500

I've tried the few basic things I've been able to find that might help. I've scanned the database, didn't help. I also dropped all the tables from MySQL and ran the install script again, and the same thing happened.

Can anybody suggest where to start?



zach

[Chuck S]

I would suggest you post a link to the server's PHPINFO first off and a url

[Zach]

http://www.scrapbookcorner.us/photopost/phpinfo.php

The photopost website is http://www.scrapbookcorner.us/photopost/index.php.

[Chuck S]

Looks to me like your categories have been deleted at first glance.

I would suggest you use phpmyadmin database viewer and run a repair on the photopost mysql database tables and see what entries are in the categories table.

Your members gallery does not even show up on the index and you cant delete the members gallery from admin so there is definately an issue with the categories table

[Zach]

What do you mean run a repair? If you're referring to scanning the database from inside the control panel, i've already done that. And when I erased the database and re-ran the install script, the same problem happened.

This is what's contained in the pp_categories table:

"500";"Member Galleries";"Individual user galleries - any photo category";"1";"yes";"0";NULL;NULL;NULL;"no";NULL;NULL;NULL;NULL;NULL;;"8";"103";"26";"2";NULL;"c";;NULL;;"1";NULL;NULL;NULL;NULL;NULL;NULL;"92";"0";"no";"0";"no";NULL;NULL;"6||Tracey Bish";"0";"0";"0";"0"
"529";"03-March Sketch Challenge";"Becky Higgins Sketch for September 2006";"9999";"yes";"22";NULL;NULL;NULL;"no";NULL;NULL;NULL;NULL;NULL;;"6";"107";"16";"4";;"a";;NULL;;"7";NULL;NULL;NULL;NULL;NULL;NULL;"92";"0";"no";"0";"no";NULL;NULL;NULL;"0";"0";"0";"0"
"522";"Class Examples";"Class Examples";"9999";"yes";"11";NULL;NULL;NULL;"no";NULL;NULL;NULL;NULL;NULL;;NULL;"58";"3";"0";;"a";;NULL;;"7";NULL;NULL;NULL;NULL;NULL;NULL;"58";"0";"no";"0";"no";NULL;NULL;NULL;"0";"0";"0";"0"
"531";"01-Designer Photos";"Group & Individual Photos";"1";"yes";"22";NULL;NULL;NULL;"no";NULL;NULL;NULL;NULL;NULL;;NULL;"100";"10";"0";;"a";;NULL;;"7";NULL;NULL;NULL;NULL;NULL;NULL;"66";"0";"no";"0";"no";NULL;NULL;NULL;"0";"0";"0";"0"
"530";"02-All About Me Layouts";"All About Me Layouts For 2006 Design Team";"9999";"yes";"22";NULL;NULL;NULL;"no";NULL;NULL;NULL;NULL;NULL;;"1";NULL;"8";"0";;"a";;NULL;;"6";NULL;NULL;NULL;NULL;NULL;NULL;"77";"0";"no";"0";"no";NULL;NULL;NULL;"0";"0";"0";"0"

[Chuck S]

You forgot to run an upgrade script

It should be fine. You have a members gallery and 4 personal albums it looks like.

[Zach]

I'm pretty sure I did run the upgrade script. I just ran it again and got these errors:

Error performing MySQL command: INSERT INTO pp_settings VALUES (213,'Show html code to display photos?','showhtml','Do you want to show the img src html tag for a photo?','no',6,5)
Error: Duplicate entry '213' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (214,'Show direct links to photos?','showdirect','Do you want to display the page link to a photo?','no',7,5)
Error: Duplicate entry '214' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (215,'Load limit for server?','loadlimit','If running *nix and you want to disable your forums when load goes over a certain limit; place the high limit here.','0',35,1)
Error: Duplicate entry '215' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (216,'Default number of thumbnail rows?','thumbrows','How many rows of thumbnails do you want to display by default on this page?','3',5,4)
Error: Duplicate entry '216' for key 1

Error performing MySQL command: ALTER TABLE pp_categories ADD thumbtype INT(2) UNSIGNED DEFAULT '0'
Error: Duplicate column name 'thumbtype'

Error performing MySQL command: INSERT INTO pp_settings VALUES (217,'Use category cache?','catcache','On some larger sites, using the category cache can actually reduce performance.','yes',36,1)
Error: Duplicate entry '217' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (218,'Display Featured Photos on this page?','features','On larger sites this option can slow down the showgallery page. Turn off to speed up this page.','yes',8,5)
Error: Duplicate entry '218' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (219,'Display Admin quick move/delete options under photo?','quickopts','On larger sites this option can slow down the showphoto page. Turn off to speed up this page.','yes',8,5)
Error: Duplicate entry '219' for key 1

Error performing MySQL command: ALTER TABLE pp_categories ADD subalbum INT(12) DEFAULT '0' NOT NULL AFTER albums
Error: Duplicate column name 'subalbum'

I still get a blank page when trying to add a category, after clicking the "add category" button regardless of what option i select (add, skip or skip). I can make changes to the member galleries category now, which I wasn't able to before, but I still can't add them.

[Chuck S]

Well I would suggest you redownload the distribution and upload the files maybe you have a bad file if you get a white page

[PRETTYBOI]

I'm seem to be having the same problem too

[Chuck S]

Do you have debugging on in admin global options?

Did you redownload the build and update your files to ensure you dont have a bad file. If you upgraded did you run every applicable upgrade?

[Zach]

I reuploaded files again and it might be working. I'll play around with it and email back if it is not.