You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=3065
error message: Invalid SQL: SELECT distinct(wcfu.userID) as userID
FROM wcf1_rGallery_items_owner as io,
wcf1_user as wcfu
WHERE
io.ownerID = wcfu.userID
ORDER BY wcfu.username DESC
error code: 3065
sql type: MySQLDatabase
sql error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'chamaeleon.wcfu.username' which is not in SELECT list; this is incompatible with DISTINCT
sql error number: 3065
sql version:
file: /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.29
wcf version: 1.1.10 (Tempest)
date: Thu, 28 Mar 2024 11:14:26 +0000
request: /index.php?page=RGallery&subpage=users&s=7c4ecc707f7f8822c26a009898b077a2eae459b6
referer:
#0 /var/www/vhosts/chamaeleons.com/httpdocs/lib/page/RGalleryPage.class.php(63): MySQLDatabase->sendQuery('SELECT distinct...') #1 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/page/AbstractPage.class.php(46): RGalleryPage->show() #2 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct() #3 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('RGallery', Array, 'page') #4 /var/www/vhosts/chamaeleons.com/httpdocs/index.php(8): RequestHandler::handle(Array) #5 {main}