You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1055
error message: Invalid SQL: SELECT (SELECT COUNT(*) FROM wcf1_user_whitelist WHERE userID = user.userID AND confirmed = 1) AS friends,wbb_user.posts,wbb_user.thanks_got,wbb_user.thanks_given,session.requestURI, session.requestMethod, session.ipAddress, session.userAgent,
rank.*, avatar.*,0 AS buddy, 0 AS ignoredUser, GROUP_CONCAT(DISTINCT groups.groupID ORDER BY groups.groupID ASC SEPARATOR ',') AS groupIDs,
GROUP_CONCAT(DISTINCT languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS languageIDs,user_option.*,
user.*
FROM wcf1_user user
LEFT JOIN wbb1_1_user wbb_user
ON (wbb_user.userID = user.userID) LEFT JOIN wcf1_avatar avatar ON (avatar.avatarID = user.avatarID) LEFT JOIN wcf1_session session ON (session.userID = user.userID AND session.packageID = 48 AND session.lastActivityTime > 1711712391) LEFT JOIN wcf1_user_rank rank ON (rank.rankID = user.rankID) LEFT JOIN wcf1_user_to_groups groups ON (groups.userID = user.userID)
LEFT JOIN wcf1_user_to_languages languages ON (languages.userID = user.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = user.userID)
WHERE user.userID = 1 GROUP BY user.userID LIMIT 1
error code: 1055
sql type: MySQLDatabase
sql error: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'chamaeleon.session.requestURI' 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: Fri, 29 Mar 2024 11:54:51 +0000
request: /index.php?page=User&userID=1&s=9aea137ddd0ff05e793d0b06f89285c78fd4f1a3
referer:
#0 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/system/database/Database.class.php(118): MySQLDatabase->sendQuery('SELECT ?(SELECT...', 1, 0) #1 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/data/user/User.class.php(63): Database->getFirstRow('SELECT ?(SELECT...') #2 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/system/session/UserSession.class.php(33): User->__construct(1, NULL, NULL, NULL) #3 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/data/user/UserProfile.class.php(63): UserSession->__construct(1, NULL, NULL, NULL) #4 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/data/user/UserProfileFrame.class.php(126): UserProfile->__construct(1, NULL, NULL, NULL, '(SELECT COUNT(*...', ' LEFT JOIN wbb1...') #5 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/data/user/UserProfileFrame.class.php(114): UserProfileFrame->init() #6 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/page/UserPage.class.php(69): UserProfileFrame->__construct(Object(UserPage)) #7 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/page/AbstractPage.class.php(45): UserPage->readParameters() #8 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct() #9 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('User', Array, 'page') #10 /var/www/vhosts/chamaeleons.com/httpdocs/index.php(8): RequestHandler::handle(Array) #11 {main}