• Remember to address to the Bug Tracking guidelines and to follow the instructions in the post ticket template.
  • Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

4.5.8: "Liked" listing broken for non-admins

Version
4.5.8
PHP version
8.2.35
Database driver
MySQL
Database version
8.0.46
Web browser
Chrome

mikaa

Chevereto Member
Pro
Reproduction steps
1. Fresh install of 4.5.8 Pro, create two users: alice and bob.
2. alice uploads an image, bob likes it.
3. As a guest (or as alice), open /bob/liked.
4. As any user except admin (bob included), trigger the Liked listing via /json: POST /json action=list&list=images&like_user_id=bob's user id

Unexpected result

Step 3: the page loads but the list is empty.
Step 4: HTTP 500 "Something went wrong".
Admins are not affected and see the liked images.

Error log message

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'album_id' in field list is ambiguous
(Listing.php:1092 <- json.php:643)
 

Chevereto Cloud

Back
Top