beta 1.5 pack1 loosing country

[DirtyLittlePuppy]

I am finding the photo editor is replacing the country with N/A even though it is specified in the default photodata. The photo display page is also loosing the country on pages that had it before.

[Pekka]

DirtyLittlePuppy wrote:
I am finding the photo editor is replacing the country with N/A even though it is specified in the default photodata.

Let's clarify this report a bit.
Please do this procedure for me:

1. Go into photo editor.
2. Pick a photo where country has changed to "n/a"
3. change country to "Canada"
4. press "SAVE CHANGES TO THIS PHOTO".
Q: What do you see in country selection, is it "Canada"?

5. Now go to editor index page http://yoursite.com/gallery/input/index.php
Q: Do you see under exhibition breakdown box any lines containing: "photo id XX had rogue id...."?

6. Go into photo editor and pick the photo you just altered.
Q: What do you see in country selection, is it "Canada"?

The photo display page is also loosing the country on pages that had it before.

If country is "n/a" then it is not displayed at all on public area photo pages, and it is displayed as "---" in detail listings.

[DirtyLittlePuppy]

Pekka,

I can open up photo editor, change n/a to Canada, save the changes and Canada will still be there after the photo editor refreshes.

When I look at my editor index page I see this:

id name visibility all photos hidden photos
54 Around Here 2003 public 42 0
55 Up North 2003 hidden 1 0
56 Down South 2003 hidden 34 0
57 Our Menagerie 2003 hidden 45 0
59 Menagerie (film) public 17 0
60 Local Places & Things (film) public 42 0
61 South Places & Things (film) public 35 0
63 Laughter Friends hidden 23 0
64 Photoshop Creation public 14 0
65 Family Snapshots 2003 public 28 0
66 Family & Friends (film) public 13 0
67 Yukon (film) public 21 0

Total: 315 photos in 12 exhibitions


0 photo comments in total, latest was written on 29 Nov 2003 (Saturday)
photo id 2767 had rogue id 191 in row ee_country_id, reset to id 191
photo id 2769 had rogue id 191 in row ee_country_id, reset to id 191
photo id 2770 had rogue id 191 in row ee_country_id, reset to id 191
photo id 2774 had rogue id 191 in row ee_country_id, reset to id 191
photo id 2775 had rogue id 191 in row ee_country_id, reset to id 191
photo id 2776 had rogue id 191 in row ee_country_id, reset to id 191

(clipped here)

the list goes on and on, I think every picture in the gallery.

Also further down the list starts over with:

photo id 2767 had rogue id 1 in row ee_light_id, reset to id 1
photo id 2769 had rogue id 1 in row ee_light_id, reset to id 1
photo id 2770 had rogue id 1 in row ee_light_id, reset to id 1

I hadn't noticed, but it is resetting my selected lighting also for what apperes to be all photos.


Returning to photo editor the country is now back to n/a.


Also I noticed in the editor index page that it shows that I have 4 hidden exhibitions... only one of them is a true hidden exhibition. (see first clipping)

Thanks Pekka

[Pekka]

The problem you're having was fixed in "1.5 beta 5 fix pack 1". Perhaps fetchsettings.php was not replaced then.

You can fix this manually by replacing


function ee_fix_rogue_ids ($output) {

$tables_to_be_examined = array(
"lens" => array("table" => "ee_lens", "row" => "ee_lens_id", "id" => "1"),
"owner" => array("table" => "ee_owner", "row" => "ee_owner_id", "id" => "1"),
"country" => array("table" => "ee_country", "row" => "ee_country_id", "id" => "191"),
"camera" => array("table" => "ee_camera", "row" => "ee_camera_id", "id" => "1"),
"location" => array("table" => "ee_location", "row" => "ee_location_id", "id" => "1"),
"light" => array("table" => "ee_light", "row" => "ee_light_id", "id" => "1"),
"workflow" => array("table" => "ee_workflow", "row" => "ee_workflow_id", "id" => "1")
);

foreach ($tables_to_be_examined as $key => $k) {

$examine_table = $k["table"];
$examine_row = $k["row"];
$good_id = $k["id"];

ee_check_rogue_id($output,$examine_table,$examine_ row,$good_id);

}

}





with





function ee_fix_rogue_ids ($output) {

$tables_to_be_examined = array(
"lens" => array("table" => "ee_lens", "row" => "ee_lens_id", "id" => "1"),
"owner" => array("table" => "ee_owner", "row" => "ee_owner_id", "id" => "1"),
"country" => array("table" => "ee_country_eng", "row" => "ee_country_id", "id" => "191"),
"camera" => array("table" => "ee_camera", "row" => "ee_camera_id", "id" => "1"),
"location" => array("table" => "ee_location", "row" => "ee_location_id", "id" => "1"),
"light" => array("table" => "ee_light_eng", "row" => "ee_light_id", "id" => "1"),
"workflow" => array("table" => "ee_workflow", "row" => "ee_workflow_id", "id" => "1")
);

foreach ($tables_to_be_examined as $key => $k) {

$examine_table = $k["table"];
$examine_row = $k["row"];
$good_id = $k["id"];

ee_check_rogue_id($output,$examine_table,$examine_ row,$good_id);

}

}

Also I noticed in the editor index page that it shows that I have 4 hidden exhibitions... only one of them is a true hidden exhibition. (see first clipping)

I'll have to check that code.

[DirtyLittlePuppy]

Thanks Pekka,

I have my "rogue IDs" sorted out. I looked at the code until my eyes went buggy... b'darned if I could see the difference... then just pasted in your replacement code and its now okay.

To the best of my knowledge that file was updated with fix pack 1 so I'm still a little confused as to why.