category exists, photos there, no photos...

climber · September 10th, 2006, 08:26 PM

everything has been working just fine on my site & my Phoro Pro installation for the past 2 years. I uploaded about 20 pictures this evening & went through the approval process, named them & made sure they had titles, etc. when I went to look at them in the category, it says "This category does not contain any images." I look in the database & it most certainly does have images. in fact on the home page under the Photos heading it says that there are 191 images, however under the Last Photo Upload heading it says "no photos". the pictures I uploaded & laboriously entered the data on are not in the database.

this is on http://www.neclimbs.com. any suggestions?

--climber

climber · September 11th, 2006, 07:53 AM

one other thing... the pictures I uploaded are not there. they aren't in the database or anywhere I can find. this is very disturbing. I most certainly do not want to go through the process of uploading & editing 200+ images again.

any ideas..Chuck, anyone???

climber · September 11th, 2006, 08:18 AM

just noticed one more thing... looking at the pp_photos table in the database there are 10 pages listed in phpmyadmin. however when I go to page 10, or try to look at 400 rows, there are less than 300 and it should just display what is available, phpmyadmin goes back to the structure display as if there is a problem. could there be a database corruption problem?

this is not good...

climber · September 11th, 2006, 08:38 AM

now, after looking at it many times, apparently it is working again. very strange... however it only displays 2 of the 20 images I uploaded last night. I'll try to re-add in some more & see what happens.

climber · September 11th, 2006, 09:10 AM

now all I am getting is the following error message:

There was an error uploading this photo. Please report to System Administrator.

HELP

Chuck S · September 11th, 2006, 09:14 AM

It seems to display fine here you can post a test login so we can try upload

climber · September 11th, 2006, 09:49 AM

Chuck,

sent you a private email..

Chuck S · September 11th, 2006, 10:21 AM

whatever repair you did may have fixed your corrupt rows but it did not correct your auto_increment field. You must use phpmyadmin and set in your structure the auto_increment field to the last insert number of that table. Definate mysql corruption as it is trying to insert a photo into a row that already exists.

Code:

Content visible to verified customers only.

climber · September 11th, 2006, 10:38 AM

I have phpmyadmin installed and am looking at the table. hmmm, starting id# is 10 and ending is 353! the error message says that there is a dupe on 354. hmmm!!!

that said, how do I set the starting auto_increment value for the pp_photos table.

Chuck S · September 11th, 2006, 10:53 AM

ALTER TABLE pp_photos auto_increment=SOMENUMBER;

You can not go by how many rows you have you need to view the last record and see the id and then set your auto_increment with the query above to that last records plus one.

climber · September 11th, 2006, 11:03 AM

OK... I also ran the phpmyadmin check on the table. it spit out 5 errors, the last is Corrupt. (see below) should back it up and I run the Repair Table function?

--------------------------

Table Op Msg_type Msg_text
climbs_neclimbs_com.pp_photos check warning 2 clients are using or haven't closed the table pr...
climbs_neclimbs_com.pp_photos check warning Size of indexfile is: 23552 Should be: 22528
climbs_neclimbs_com.pp_photos check warning Size of datafile is: 55552 Should be: 51948
climbs_neclimbs_com.pp_photos check error Found 302 keys of 283
climbs_neclimbs_com.pp_photos check error Corrupt

climber · September 11th, 2006, 11:14 AM

well it looks as if the act of looking at this has made the application go down. I am now getting an internal server error and on top of that phpmyadmin says it can't open the file! is there any way to recover from this??? the pp_photos MYI, MYD and frm files all still exist on my server.

Chuck, please contact me privately...

Chuck S · September 11th, 2006, 11:44 AM

You must do a repair the table or restore a backup of this table.

REPAIR TABLE pp_photos

You can contact your host with assistance on there server software if you are unable to successfully repair the table.

climber · September 11th, 2006, 12:50 PM

I see. I will look into restoring the table or database & then try to do a repair of the table prior to it getting so corrupted.

climber · September 11th, 2006, 02:57 PM

1) got the files restored
2) repaired the table, everything appeared to be OK
3) determined the id value + 1
4) applied the fix to the auto_increment field using phpmyadmin & it said OK
5) looked at the gallery & all looked well
6) uploaded a new file & approved it
7) it appeared but I could not select it by this query

SELECT * FROM `pp_photos` WHERE `cat`='501' ORDER BY `title` DESC LIMIT 1

title contains a numeric value equivalent to a date in reverse polish notation - 20060911 is today.

8) when I looked at the table in phpmyadmin, that image was not there, however it was shown in the gallery
9) when I looked in the gallery again, it went down due to corruption.

<sigh>

I am in the process of restoring the pp_photos files again. as you can well imagine this is getting old...

climber · September 11th, 2006, 05:21 PM

Chuck,

well things have gone steadily downhill, uphill & downhill...

I restored the corrupted files and finally the gallery did come back up. I immediately backed it up from phpmyadmin. I ran the Table Repair command from mySQL & all seemed to be good. then I ran the database scan utilities in PhotoPost. when they finished I checked out the gallery. it seemed to be OK. so I did another backup, with an incremental name. I checked out the gallery it seemed fine. I then went to phpmyadmin & ran a check on the problem table and there was a problem, which I then repaired. BANG of course after that it broke the gallery. I started getting the dreaded Internal Server error.

so I have 3 database backups, right? I loaded the most recent one. no go... I get this error:

Database not properly setup - unable to read pp_settings table. Contact administrator.

I load the middle one... same error! in terror I load the oldest one. WHEW it works. I check out the gallery & everything seems OK.

I am now very afraid to do anything. I'm afraid to run the table check in phpmyadmin. what can I do to get things back to functioning correctly & reliably? I am currently running 5.21, would upgrading to 5.31 be worth a try?

Chuck S · September 11th, 2006, 06:03 PM

You must correct your mysql table corruption before you can even thing about upgrading and since you closed your gallery I can not see it to give any advise

climber · September 13th, 2006, 09:13 AM

everything seems to be fine until I add another image & then the table gets corrupted. I'm not sure why that happens but I am looking into it.

Chuck S · September 13th, 2006, 10:41 AM

I was able to add 3 images in a row with no issues but yeah you should ask your host my your mysql keeps corrupting as this is not normal by any means.

http://www.neclimbs.com/PhotoPost/index.php