Photo Gallery module randomly disappears after 3.0.1 update

We use the CB Gallery module to show 1 random photo from a gallery. After 3.0.1 plugin update, the module shows a photo sometimes, other times it disappears. Previously we could refresh a page that contained the module and we would see a different photo each time. Now refreshing the page may show a different photo 2 or 3 times, then the module may disappear for the next couple of page refreshes, eventually returning and showing a photo.

Gallery plugin 3.0.1
Joomla 4.4.14
PHP 8.3.23
MySQL 8.4.3-3

If the media it chose failed access permission checks it's not going to show anything. For example if you're showing random profile photos and that profile is set to private. You can alleviate this somewhat by ensuring the gallery used for the module under its Integrations > CB Privacy tab is configured to query filter privacy.

With that said I recommend switching modules like that to the new Media gallery mode, which doesn't require a gallery and bypasses a lot of checks.

We do not have privacy settings enabled on our site, so it is not possible for a user to set their profile to "private". This module used to show a single random photo from the same gallery as is used for the photo gallery page that you recently fixed. Reloading the page or visiting another page that included the module would always show a single random photo from the specified gallery.

After 3.0.1 update, it may show an image or the module disappears. You can see this in action if you go to  www.wwoofjapan.com/home

There should be a single photo showing at the top right side of the page. If you see one, refresh the page. It should show a different photo. It may do that 1 or 2 times, then the module will disappear for 1 or more page refreshes. At some point after numerous page refreshes, a photo will be visible.

Trying to upload a screenshot of the module settings to this post, but keep getting an Upload failed error

I believe the issue may be that some of the photos in the gallery are associated with user subscriptions that have expired. Is there a way to filter out images that are on expired user profiles?

Expired subscription shouldn't matter unless their profile was disabled and made inaccessible, is that the case? If so all their media should've also been disabled, but that may not have been the case on CB Gallery 2.5, but absolutely is on CB Gallery 3.0. I can take a look with the credentials you've already provided for your other issue if you'd like.

Ok, have verified that's the issue. You've users with disabled accounts, but published media. You ideally need to unpublish their media. CB Gallery 3.0 does this automatically on disabling of a user, but CB Gallery 2.5 did not. What's happening is their media is being removed during server side aggregation because it's not accessible.

The below database query ran on your database should fix the mismatch published states for you.

Be sure to replace the "jos_" prefix with whatever your database table prefix is. You shouldn't need to do this ever again though since CB Gallery 3.0 will handle it automatically. I'll also add this to the migration code for future migrations for everyone else.