You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1055
error message: Invalid SQL: SELECT 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 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 > 1711713514) 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 #1 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 12:13:35 +0000
request: /index.php?form=Contact&s=060c724990b72605202d21afd713c66695b67d74
referer:
#0 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/system/database/Database.class.php(118): MySQLDatabase->sendQuery('SELECT ?session...', 1, 0) #1 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/data/user/User.class.php(63): Database->getFirstRow('SELECT ?session...') #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/form/ContactForm.class.php(78): UserProfile->__construct(1) #5 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/page/AbstractPage.class.php(45): ContactForm->readParameters() #6 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct() #7 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(95): RequestHandler->__construct('Contact', Array, 'form') #8 /var/www/vhosts/chamaeleons.com/httpdocs/index.php(8): RequestHandler::handle(Array) #9 {main}