Pictures only show up on first page

[pehansen]

I just installed 1.5b4 from scratch, and so far all installation setup went without errors.

When I now upload pictures I can see that the microthumb, thumb and the full sized pictures gets created.

And on the first page of EE it shows the thumbs of the 5 newest pictures.

BUT when I go to the exhibition it is empty... and picture editor / browser says "no pictures"...

If I check the folders, it's all there, and the path check shows all OK for all sizes..

Do I miss something here... it looks like path problems, but all checks looks OK..

[pehansen]

I just tried to run the pathanalyze, and it also gives an OK... shows the thumbs, and says filecheck OK, and if I copy the path to a picture into the browser it comes up fine...

But as soon as I access the exhibition it is empty, and both photobrowser and photoeditor says "no pictures"

Are there any restrictions on picture filenames.. special characters, max. number of chars etc....???

[Pekka]

pehansen wrote:
I just installed 1.5b4 from scratch, and so far all installation setup went without errors.

When I now upload pictures I can see that the microthumb, thumb and the full sized pictures gets created.

And on the first page of EE it shows the thumbs of the 5 newest pictures.

BUT when I go to the exhibition it is empty... and picture editor / browser says "no pictures"...

If I check the folders, it's all there, and the path check shows all OK for all sizes..

Do I miss something here... it looks like path problems, but all checks looks OK..

Strange problem you have, that should not even technically be possible at all (either photos show in all places or if they are hidden they do not show at all).

I just did a clean installation on another server and it all worked just fine there.

To solve your problem very quickly please make EE Backup's text dump or PhpMyAdmin's text dump of whole database and mail it to me at pekka AT photography-on-the.net . No images or ftp passwords needed (you can do an EE Backup dump without "ee_ftp" table).

I'll check it out in the evening and see what's going on.

[Rich A]

I am having a very similar issue.

Rich

[Pekka]

If you have the same problem: pehansen's problem was that table ee_photo had some unexisting photo_id's. The cause of these is yet unknown - I'm working on trying to find a procedure that will make those happen.

To check and fix that problem you'd need PhpMyAdmin or some other tool which lets you see MySQL database. In "ee_owner" table each "ee_owner_id" holds an id number. Mark those id's down. Then see that each photo in table "ee_photo" has one of those "ee_owner_id" numbers. If they do not, edit them so that they have.

If you'd send me a dump of your database I can do above for you and mail the dump back.

I can make a simple hack to fix this situation, but rather I'd like to find how it happens. So, I'm very interested in actions you did before the problem happened, especially:

- did you edit users before or after uploading?
- did you delete unused users? If you did, was it before or after uploading?
- did you check "guess owner" on upload page?

[pehansen]

Pekka wrote:

- did you edit users before or after uploading?
- did you delete unused users? If you did, was it before or after uploading?
- did you check "guess owner" on upload page?


One thing I noticed, I did not have "guess owner" checked.... not quite sure what it means.... and what the difference is if it's on or not?

[Pekka]

pehansen wrote:
Pekka wrote:

- did you edit users before or after uploading?
- did you delete unused users? If you did, was it before or after uploading?
- did you check "guess owner" on upload page?


One thing I noticed, I did not have "guess owner" checked.... not quite sure what it means.... and what the difference is if it's on or not?

Guess owner uses IPTC and EXIF to find out photographer name.

I'm just trying to find a way to reproduce the bug (i.e. all settings and commands that change owner data).

[pehansen]

I just tried to create a new exhibition, and copied all pictures from the existing to the new exhibition, and all worked just fine.

The I tried to upload two more pictures.... and the problem was back!.... everything looks OK, but the pictures just dont show.... the picture count is even updated by 2, but not visible.

Now that I know what the problem is, I corrected the photo owner ID table and it worked again.... but it really is strange that just these two pictures get an owner ID that is not existing..

[Pekka]

pehansen wrote:
I just tried to create a new exhibition, and copied all pictures from the existing to the new exhibition, and all worked just fine.

The I tried to upload two more pictures.... and the problem was back!.... everything looks OK, but the pictures just dont show.... the picture count is even updated by 2, but not visible.

Now that I know what the problem is, I corrected the photo owner ID table and it worked again.... but it really is strange that just these two pictures get an owner ID that is not existing..



Ok, I can fix this very fast if you can
a) write down all steps you did after clean install up to the point the bug appeared.
b) mail me those photos you uploaded for testing.

[Ewan]

Hi all.

I've just installed 1.5b4 with fix pack 2 and am having this problem. I've tried the suggestions given with no luck. Is there a solution yet?

[Pekka]

Ewan wrote:
Hi all.

I've just installed 1.5b4 with fix pack 2 and am having this problem. I've tried the suggestions given with no luck. Is there a solution yet?

Download http://www.photography-on-the.net/ee/beta/photofixer.zip

Open zip, upload photofixer.php to your EE's input folder and run it (by http://www.yoursite.com/gallery/input/photofixer.php)

Please copy and paste all the output you see on the page after it has run and post that here.

What it does: photofixer.php scans all photos for rogue id's in lenses, owners, cameras, locations, countries, cameras and lights. If it founds a rogue id it resets that id to default and reports it. I'd really like to see all reports containing those ids.

[Ewan]

thanks. here it is...

EE rogue id fixer A (ee_photo)


photo id 13 had rogue id 191 in row ee_country_id, reset to id 191
photo id 14 had rogue id 191 in row ee_country_id, reset to id 191
photo id 13 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 14 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 13 had rogue id 1 in row ee_light_id, reset to id 1
photo id 14 had rogue id 1 in row ee_light_id, reset to id 1

DONE.

[Ewan]

here's another set of data after creating a new exhibition - I only had a couple of pics in last night.

EE rogue id fixer A (ee_photo)


photo id 23 had rogue id 191 in row ee_country_id, reset to id 191
photo id 22 had rogue id 191 in row ee_country_id, reset to id 191
photo id 21 had rogue id 191 in row ee_country_id, reset to id 191
photo id 20 had rogue id 191 in row ee_country_id, reset to id 191
photo id 19 had rogue id 191 in row ee_country_id, reset to id 191
photo id 18 had rogue id 191 in row ee_country_id, reset to id 191
photo id 17 had rogue id 191 in row ee_country_id, reset to id 191
photo id 16 had rogue id 191 in row ee_country_id, reset to id 191
photo id 13 had rogue id 191 in row ee_country_id, reset to id 191
photo id 14 had rogue id 191 in row ee_country_id, reset to id 191
photo id 15 had rogue id 191 in row ee_country_id, reset to id 191
photo id 24 had rogue id 191 in row ee_country_id, reset to id 191
photo id 25 had rogue id 191 in row ee_country_id, reset to id 191
photo id 26 had rogue id 191 in row ee_country_id, reset to id 191
photo id 23 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 22 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 24 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 25 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 26 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 23 had rogue id 1 in row ee_light_id, reset to id 1
photo id 22 had rogue id 1 in row ee_light_id, reset to id 1
photo id 21 had rogue id 1 in row ee_light_id, reset to id 1
photo id 20 had rogue id 1 in row ee_light_id, reset to id 1
photo id 19 had rogue id 1 in row ee_light_id, reset to id 1
photo id 18 had rogue id 1 in row ee_light_id, reset to id 1
photo id 17 had rogue id 1 in row ee_light_id, reset to id 1
photo id 16 had rogue id 1 in row ee_light_id, reset to id 1
photo id 13 had rogue id 1 in row ee_light_id, reset to id 1
photo id 14 had rogue id 1 in row ee_light_id, reset to id 1
photo id 15 had rogue id 1 in row ee_light_id, reset to id 1
photo id 24 had rogue id 1 in row ee_light_id, reset to id 1
photo id 25 had rogue id 1 in row ee_light_id, reset to id 1
photo id 26 had rogue id 1 in row ee_light_id, reset to id 1

DONE.

[Pekka]

Ewan wrote:
thanks. here it is...

EE rogue id fixer A (ee_photo)


photo id 13 had rogue id 191 in row ee_country_id, reset to id 191
photo id 14 had rogue id 191 in row ee_country_id, reset to id 191
photo id 13 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 14 had rogue id 2 in row ee_camera_id, reset to id 1
photo id 13 had rogue id 1 in row ee_light_id, reset to id 1
photo id 14 had rogue id 1 in row ee_light_id, reset to id 1

DONE.


Sounds like your country list is not as installed by EE installer (country "n/a" missing), same with light table, default light is missing. Did you do a full 1.5 beta install and added fix packs or did you update existing EE?

Pretty strange, as e.g. lights can not be deleted at all using EE editors, there is simply no code there for it.

Have you edited the database with any other tool than EE editor?

I can correct those problems easily if you'd mail me an EE Backup dump of your database to pekka AT photography-on-the.net

[Ewan]

pekka wrote:
Ewan wrote:
DONE.


Sounds like your country list is not as installed by EE installer (country "n/a" missing), same with light table, default light is missing. Did you do a full 1.5 beta install and added fix packs or did you update existing EE?

-- Full 1.5b install followed by fix pack 2 prior to doing anything else.


Have you edited the database with any other tool than EE editor?

-- only recommended changes as mentioned earlier in the thread, using myphpadmin

I can correct those problems easily if you'd mail me an EE Backup dump of your database to pekka AT photography-on-the.net

Thanks - will do.

[Ewan]

I've emailed my db backup but I think I may have worked around it by reassigning already uploaded pics to the exhibition.

Let me know if you want a new db backup from a non-working exhibition.