Clicking object lot link results in "Something went wrong" broken link

monica

brucek it’s not for me to say. But you could at least put it up to be reviewed. Just make sure you explain the issue you are trying to solve.

darrigan

Hi Brucek,

brucek $tbl = ( $vs_linking_table != "ca_objects") ? "ca_objectsx" : "ca_objects"; //pelhamhs

Could you explain me why you write ca_objectsx here? 🤔

brucek

darrigan
If I dont make the substitution then I get an SQL error:

#1066 - Not unique table/alias: 'ca_objects'

i.e.:
SELECT DISTINCT ca_object_representations.media, ca_object_lots.lot_id
FROM ca_object_lots
INNER JOIN ca_objects ON ca_objects.lot_id = ca_object_lots.lot_id
INNER JOIN ca_objects ON ca_objects.object_id = ca_objects.object_id
INNER JOIN ca_objects_x_object_representations ON ca_objects_x_object_representations.object_id = ca_objects.object_id
INNER JOIN ca_object_representations ON ca_object_representations.representation_id = ca_objects_x_object_representations.representation_id
WHERE ca_objects_x_object_representations.is_primary = 1 AND ca_objects.access IN (1) AND ca_object_representations.access IN (1) AND ca_object_lots.lot_id IN (1083) LIMIT 0, 25

throws an error.

This is my hack:
SELECT DISTINCT ca_object_representations.media, ca_object_lots.lot_id
FROM ca_object_lots
INNER JOIN ca_objects ON ca_objects.lot_id = ca_object_lots.lot_id
INNER JOIN ca_objects as ca_objectsx ON ca_objectsx.object_id = ca_objects.object_id
INNER JOIN ca_objects_x_object_representations ON ca_objects_x_object_representations.object_id = ca_objects.object_id
INNER JOIN ca_object_representations ON ca_object_representations.representation_id = ca_objects_x_object_representations.representation_id
WHERE ca_objects_x_object_representations.is_primary = 1 AND ca_objectsx.access IN (1) AND ca_object_representations.access IN (1) AND ca_object_lots.lot_id IN (1083);

darrigan

@monica Do you know how is it possible, in thebrowse_results_list_html.php file, to get the primary image of the first object contained in a certain lot?
This could be a possible way to display a default image as a lot's representation. (Instead of assign images by hand for 600+ lots🙃)

Hal and I did a video call today to try to solve his image display problem for a lot. After trials and errors, we found that one action solved the problem: we need to click on "make primary" when linking a media to the lot. Without that, the image doesn't display...

darrigan

@hdace Hi, I've been thinking about your request to associate an image with each lot, using an image extracted from an object in the batch, without having to do it by hand.
I saw on your site that you started doing it "by hand" and the result is superb! https://rchsdigitalcollections.epistrophypictures.com/index.php/Browse/lots
If you spend 2-3 minutes manually assigning an image for 666 batches, you will spend about 30 hours of work 😅

You can do this in several ways, more or less conventional.

The most conventional method would be to import from an Excel file that associates a lot identifier with a media identifier, if you already have this easy-to-create relationship... But this requires first doing an exportation of the listing of images' identifiers of the objects contained in each lot and sorting them to keep only one by lot.

The other less conventional method would be to create a script that executes a SQL query to retrieve the identifier of the first public image (or "primary") of the first public object that is in a lot, and to create a new row in the ca_object_lots_x_object_representations table, without going through the providence official tools... There is always a risk in wanting to tamper with the database, unless you make a backup copy just before, in case it goes wrong... (it should demand less than 30h of work, except in case of crash 😁)

« Previous Page