EE 1.3, when I add a photo to an exhibit, I see two of them.

[jscherer]

Ok,

I just did the upgrade to 1.3 which seems to have gone well. with one excption. When I goto http://my_server/gallery/my_install_dir and click on "pick a photo to edit, add a photo the chosen exhibit, the thing is adding two copies of the image, both with the same sql id. Very strange.

Any thoughs?

[Pekka]

Run "editor/utilities/Analyze and repair"

If that fixes it and you don't get the problem any more thet it was some oddity 1.22 left behind.

But if you still get the error can you please make a backup text dump of the database (utilities/backup) and mail it to me to pekka@photography-on-the.net for investigation.

[jscherer]

Thanks for the reply Pekka, and thanks for supporting all of us! This is a great program!


I ran the EE Analyze/repair tool and everything went ok I think. The output is below. I still have the problem however.


You might be able to get to it at http://scherers.no-ip.com Not sure though as I just set that up for a test.

If you click on an exhibit, say Family & Friends, You'll see duplicate entrys, but I only entered them once. They even have the same SQL ID.

That's not all. When you click on a photo from whithin the exhibit, if it's one with double photos, you will notice that both thubnails will be selected with a red square.. I guess that makes some sence if they both have the same sql id. Strange though

I'll email you the input directory name and a sql backup as well.



PHOTO TO WORKFLOW ID VALIDITY CHECK

ee_workflow.ee_workflow_id
...... ID 1 OK

ee_workflow.ee_workflow_id
...... ID 2 OK

ee_workflow.ee_workflow_id
...... ID 3 OK

PHOTO_TO_EXHIBITION ID VALIDITY CHECK

No orphans in ee_photo_to_exhibition.
No orphans in ee_photo.
All photos linked to valid exhibitions.
COUNTER ID VALIDITY CHECK

All photos have valid counters.
No orphan counters found.
No duplicate counters found.
DEFAULT ID VALIDITY CHECK

ee_camera.ee_camera_id
...... ID 1 OK

ee_category.ee_category_id
...... ID 1 OK

ee_country.ee_country_id
...... ID 191 OK

ee_defaults.ee_defaults_id
...... ID 1 OK

ee_lens.ee_lens_id
...... ID 1 OK

ee_light.ee_light_id
...... ID 1 OK

ee_location.ee_location_id
...... ID 1 OK

ee_microthumb_path.ee_microthumb_path_id
...... ID 1 OK

ee_owner.ee_owner_id
...... ID 1 OK

ee_thumb_path.ee_thumb_path_id
...... ID 1 OK

ee_size.ee_size_id
...... ID 1 OK

ee_thumbs.ee_thumbs_id
...... ID 1 OK

ee_workflow.ee_workflow_id
...... ID 3 OK

ee_style.ee_style_id
...... ID 1 OK


'ee_accessory' OPTIMIZED AND INDEXES REBUILT
'ee_backup_info' OPTIMIZED AND INDEXES REBUILT
'ee_camera' OPTIMIZED AND INDEXES REBUILT
'ee_camera_type' OPTIMIZED AND INDEXES REBUILT
'ee_category' OPTIMIZED AND INDEXES REBUILT
'ee_commerce_template' OPTIMIZED AND INDEXES REBUILT
'ee_counter' OPTIMIZED AND INDEXES REBUILT
'ee_country' OPTIMIZED AND INDEXES REBUILT
'ee_defaults' OPTIMIZED AND INDEXES REBUILT
'ee_exhibition' OPTIMIZED AND INDEXES REBUILT
'ee_exhibition_feedback' OPTIMIZED AND INDEXES REBUILT
'ee_lens' OPTIMIZED AND INDEXES REBUILT
'ee_light' OPTIMIZED AND INDEXES REBUILT
'ee_location' OPTIMIZED AND INDEXES REBUILT
'ee_message' OPTIMIZED AND INDEXES REBUILT
'ee_microthumb_path' OPTIMIZED AND INDEXES REBUILT
'ee_news' OPTIMIZED AND INDEXES REBUILT
'ee_order_to_exhibition' OPTIMIZED AND INDEXES REBUILT
'ee_order_to_indexpage' OPTIMIZED AND INDEXES REBUILT
'ee_owner' OPTIMIZED AND INDEXES REBUILT
'ee_performance' OPTIMIZED AND INDEXES REBUILT
'ee_photo' OPTIMIZED AND INDEXES REBUILT
'ee_photo_size' OPTIMIZED AND INDEXES REBUILT
'ee_photo_to_accessory' OPTIMIZED AND INDEXES REBUILT
'ee_photo_to_category' OPTIMIZED AND INDEXES REBUILT
'ee_photo_to_ee_commerce_template' OPTIMIZED AND INDEXES REBUILT
'ee_photo_to_exhibition' OPTIMIZED AND INDEXES REBUILT
'ee_settings' OPTIMIZED AND INDEXES REBUILT
'ee_size' OPTIMIZED AND INDEXES REBUILT
'ee_size_defaults' OPTIMIZED AND INDEXES REBUILT
'ee_style' OPTIMIZED AND INDEXES REBUILT
'ee_thumb_path' OPTIMIZED AND INDEXES REBUILT
'ee_thumbs' OPTIMIZED AND INDEXES REBUILT
'ee_workflow' OPTIMIZED AND INDEXES REBUILT