You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1194
error message: Invalid SQL: SELECT user.userID
FROM wcf2_user user
WHERE BINARY UPPER(SUBSTRING(username,1,1)) = 'J'
ORDER BY user.username DESC LIMIT 22320, 30
error code: 1194
sql type: MySQLDatabase
sql error: Table 'wcf2_user' is marked as crashed and should be repaired
sql error number: 1194
sql version:
file: /srv/vhosts/world-of-paranoid.com/htdocs/forum/wcf/lib/system/database/MySQLDatabase.class.php (116)
php version: 5.6.17-0+deb8u1
wcf version: 1.0.10 (Horizon)
date: Fri, 12 Jul 2024 09:58:43 +0000
request: /forum/index.php?letter=J&page=MembersList&pageNo=745&s=fbbe502e23ec53b08e299b701a52546d6801728c&searchID=0&sortField=username&sortOrder=DESC
referer:
#0 /srv/vhosts/world-of-paranoid.com/htdocs/forum/wcf/lib/page/MembersListPage.class.php(355): MySQLDatabase->sendQuery('SELECT\t\tuser.us...', 30, 22320) #1 /srv/vhosts/world-of-paranoid.com/htdocs/forum/wcf/lib/page/MembersListPage.class.php(168): MembersListPage->readMembers() #2 /srv/vhosts/world-of-paranoid.com/htdocs/forum/wcf/lib/page/AbstractPage.class.php(74): MembersListPage->readData() #3 /srv/vhosts/world-of-paranoid.com/htdocs/forum/wcf/lib/page/MembersListPage.class.php(200): AbstractPage->show() #4 /srv/vhosts/world-of-paranoid.com/htdocs/forum/wcf/lib/page/AbstractPage.class.php(36): MembersListPage->show() #5 /srv/vhosts/world-of-paranoid.com/htdocs/forum/wcf/lib/util/RequestHandler.class.php(63): AbstractPage->__construct() #6 /srv/vhosts/world-of-paranoid.com/htdocs/forum/wcf/lib/util/RequestHandler.class.php(91): RequestHandler->__construct('MembersList', Array, 'page') #7 /srv/vhosts/world-of-paranoid.com/htdocs/forum/global.php(20): RequestHandler::handle(Array) #8 /srv/vhosts/world-of-paranoid.com/htdocs/forum/index.php(1333): require_once('/srv/vhosts/wor...') #9 {main}