You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1054
error message: Invalid SQL: SELECT
user_option.userOption15, session.userID, session.username as guestname, session.ipAddress,
session.userAgent, session.lastActivityTime, session.requestURI, session.sessionID,
session.requestMethod, session.spiderID, groups.userOnlineMarking, user.username
FROM wcf1_session session
LEFT JOIN wcf1_user user
ON (user.userID = session.userID)
LEFT JOIN wcf1_user_option_value user_option
ON (user_option.userID = session.userID)
LEFT JOIN wcf1_group groups
ON (groups.groupID = user.userOnlineGroupID)
WHERE session.packageID = 48
AND session.lastActivityTime > 1711710892
AND session.spiderID = 0
AND session.sessionID <> '35727f99ccebabd1ef8dd4005b9992b78a1e4f95'
AND session.boardID = 1
ORDER BY session.username
error code: 1054
sql type: MySQLDatabase
sql error: Unknown column 'session.boardID' in 'where clause'
sql error number: 1054
sql version:
file: /usr/www/users/otaaaa/trainzer/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.6.40
wcf version: 1.1.10 pl 2 (Tempest)
date: Fri, 29 Mar 2024 11:29:52 +0000
request: /index.php?page=Board&boardID=1&pageNo=1&sortField=views&sortOrder=DESC&daysPrune=1000&status=&prefix=&languageID=0&tagID=0&s=98f7690098ab296121fd0df4ab037c3f0e1e7578
referer:
#0 /usr/www/users/otaaaa/trainzer/wcf/lib/data/user/usersOnline/UsersOnline.class.php(45): MySQLDatabase->sendQuery('SELECT \t\t\n\t\t\t\t\t...') #1 /usr/www/users/otaaaa/trainzer/wcf/lib/data/user/usersOnline/UsersOnlineList.class.php(69): UsersOnline->getUsersOnline() #2 /usr/www/users/otaaaa/trainzer/lib/page/BoardPage.class.php(279): UsersOnlineList->renderOnlineList() #3 /usr/www/users/otaaaa/trainzer/lib/page/BoardPage.class.php(168): BoardPage->renderOnlineList() #4 /usr/www/users/otaaaa/trainzer/wcf/lib/page/AbstractPage.class.php(90): BoardPage->readData() #5 /usr/www/users/otaaaa/trainzer/wcf/lib/page/AbstractPage.class.php(46): AbstractPage->show() #6 /usr/www/users/otaaaa/trainzer/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct() #7 /usr/www/users/otaaaa/trainzer/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('Board', Array, 'page') #8 /usr/www/users/otaaaa/trainzer/index.php(8): RequestHandler::handle(Array) #9 {main}