Fatal error: Invalid SQL: SELECT wbb_user.posts,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 = 38 AND session.lastActivityTime > 1591496101) 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 = 29031 GROUP BY user.userID LIMIT 1

You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1055

Information:

error message: Invalid SQL: SELECT wbb_user.posts,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 = 38 AND session.lastActivityTime > 1591496101) 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 = 29031 GROUP BY user.userID LIMIT 1
error code: 1055
sql type: MySQLDatabase
sql error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bk-christen_db.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/bekennende-christen.de/httpdocs/wcf/lib/system/database/MySQLDatabase.class.php (116)
php version: 5.3.29
wcf version: 1.0.11 pl 4 (Horizon)
date: Sun, 07 Jun 2020 02:30:01 +0000
request: /index.php?page=User&userID=29031&s=a3010e0e8daf0ad4160aabfc4f165df486eda7a6
referer:

Stacktrace:

#0 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/system/database/Database.class.php(116): MySQLDatabase->sendQuery('SELECT ?wbb_use...', 1, 0)
#1 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/data/user/User.class.php(61): Database->getFirstRow('SELECT ?wbb_use...')
#2 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/system/session/UserSession.class.php(31): User->__construct(29031, NULL, NULL, NULL)
#3 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/data/user/UserProfile.class.php(41): UserSession->__construct(29031, NULL, NULL, NULL)
#4 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/page/UserPage.class.php(48): UserProfile->__construct(29031, NULL, NULL, NULL, 'wbb_user.posts,', ' LEFT JOIN wbb1...')
#5 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/page/AbstractPage.class.php(35): UserPage->readParameters()
#6 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/page/UserPage.class.php(37): AbstractPage->__construct()
#7 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/util/RequestHandler.class.php(63): UserPage->__construct()
#8 /var/www/vhosts/bekennende-christen.de/httpdocs/wcf/lib/util/RequestHandler.class.php(91): RequestHandler->__construct('User', Array, 'page')
#9 /var/www/vhosts/bekennende-christen.de/httpdocs/index.php(8): RequestHandler::handle(Array)
#10 {main}