You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1055
error message: Invalid SQL: SELECT *
FROM
(wcf1_rGallery_items as i
LEFT JOIN wcf1_rGallery_items_tag as it
ON i.itemID = it.itemID)
INNER JOIN wcf1_rGallery_items_cat as ic
on i.itemID = ic.itemID
WHERE 1=1
GROUP BY i.itemID
ORDER BY i.itemAddedDate DESC
LIMIT 0, 15
error code: 1055
sql type: MySQLDatabase
sql error: Expression #20 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'chamaeleon.it.tagID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
sql error number: 1055
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: Sat, 30 Mar 2024 06:12:19 +0000
request: /index.php?page=RGallery&rGalleryCat=none&reset_tag=1&s=946575be4141cb5f30faf6526b43235fc7ca1bd4
referer:
#0 /var/www/vhosts/chamaeleons.com/httpdocs/lib/system/RGallerySystem.class.php(510): MySQLDatabase->sendQuery('SELECT *?????FR...') #1 /var/www/vhosts/chamaeleons.com/httpdocs/lib/page/RGalleryPage.class.php(219): RGallerySystem->getItemsListing(1) #2 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/page/AbstractPage.class.php(46): RGalleryPage->show() #3 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct() #4 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('RGallery', Array, 'page') #5 /var/www/vhosts/chamaeleons.com/httpdocs/index.php(8): RequestHandler::handle(Array) #6 {main}