• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

  • 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

class.listing.php

Status
Not open for further replies.
G

gasdigitalltd

Chevereto Member
many users are getting internal server error after update to latest version

apache log error
exception 'CHV\\ListingException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'chv_images.image_nsfw' in 'where clause'' in /xxx/c/app/lib/classes/class.listing.php:349\

seems to be a problem with hardcoded db table name at class.listing.php line 237

$this->where .= '(' . $nsfw_off_clause . ' OR (chv_images.image_nsfw = 1 AND chv_images.image_user_id = ' . $this->requester['id'] . ')) AND ';

should be

$this->where .= '(' . $nsfw_off_clause . ' OR ('.$tables['images'].'.image_nsfw = 1 AND '.$tables['images'].'.image_user_id = ' . $this->requester['id'] . ')) AND ';
 
giphy.gif


You are right. The patch will be included in v3.10.3.

Thank you for let me know about this.
 
Status
Not open for further replies.
Back
Top