You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=2013
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,(SELECT COUNT(*) FROM wcf1_user_achievement WHERE userID = user.userID) AS achievementsCount,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 = 27 AND session.lastActivityTime > 1711631478) 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 = 59 GROUP BY user.userID LIMIT 1
error code: 2013
sql type: MySQLDatabase
sql error: Lost connection to server during query
sql error number: 2013
sql version:
file: /home/stubenkr/public_html/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.6.40
wcf version: 1.1.10 pl 1 (Tempest)
date: Thu, 28 Mar 2024 13:26:27 +0000
request: /index.php?page=User&userID=59&s=534a0ba58a38425642dd871583343c65d0676234
referer:
#0 /home/stubenkr/public_html/wcf/lib/system/database/Database.class.php(118): MySQLDatabase->sendQuery('SELECT \t(SELECT...', 1, 0) #1 /home/stubenkr/public_html/wcf/lib/data/user/User.class.php(63): Database->getFirstRow('SELECT \t(SELECT...') #2 /home/stubenkr/public_html/wcf/lib/system/session/UserSession.class.php(33): User->__construct(59, NULL, NULL, NULL) #3 /home/stubenkr/public_html/wcf/lib/data/user/UserProfile.class.php(63): UserSession->__construct(59, NULL, NULL, NULL) #4 /home/stubenkr/public_html/wcf/lib/data/user/UserProfileFrame.class.php(126): UserProfile->__construct(59, NULL, NULL, NULL, '(SELECT COUNT(*...', ' LEFT JOIN wbb1...') #5 /home/stubenkr/public_html/wcf/lib/data/user/UserProfileFrame.class.php(114): UserProfileFrame->init() #6 /home/stubenkr/public_html/wcf/lib/page/UserPage.class.php(69): UserProfileFrame->__construct(Object(UserPage)) #7 /home/stubenkr/public_html/wcf/lib/page/AbstractPage.class.php(45): UserPage->readParameters() #8 /home/stubenkr/public_html/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct() #9 /home/stubenkr/public_html/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('User', Array, 'page') #10 /home/stubenkr/public_html/index.php(8): RequestHandler::handle(Array) #11 {main}