Front Page Slide Show in default theme.

[Monica-Wood]

This is a logged issue based off the forum post at https://support.collectiveaccess.org/d/302219-dev20-default-theme-front-carousel-intermittently-failing/2

I believe one of the following 3 query additions added to

pawtucket2/app/lib/BaseModel.php

Line 12063 in 495cc2e

public function getRandomItems($pn_limit=10, $pa_options=null) {

will ensure this is less likely to happen

Solution 1: Add an extra 'WHERE` clause to LN 12101

ca_objects_x_object_representations.is_primary = 1

Solution 2: Add DISTINCT to entire query on LN 12108

SELECT DISTINCT ca_objects.* FROM ca_object

Solution 3: Add a GROUP BY class on entire query on LN 12113

GROUP BY ca_objects.object_id

Solution 1 is being tested currently by 0nobody0 as per the forum post.

@collectiveaccess: Which solution would be your preference?