The table 'wcf1_session' is full

    The table 'wcf1_session' is full

    Mein Forum wurde gehackt.
    Kaum habe ich es neuinstalliert, in den ACP kann ich aber direkt ins Forum:

    Source Code

    1. Fatal error: Invalid SQL: INSERT INTO wcf1_session (sessionID, packageID, userID, ipAddress, userAgent, lastActivityTime, requestURI, requestMethod, username) VALUES ('f41b769a8e1c92d380573af2c6f172a0ed314eed', 48, 0, '95.91.141.186', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.56 Safari/537.17', 1359646950, '/index.php?page=Index', 'GET', '' )
    2. You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1114
    3. Information:
    4. error message: Invalid SQL: INSERT INTO wcf1_session (sessionID, packageID, userID, ipAddress, userAgent, lastActivityTime, requestURI, requestMethod, username) VALUES ('f41b769a8e1c92d380573af2c6f172a0ed314eed', 48, 0, '95.91.141.186', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.56 Safari/537.17', 1359646950, '/index.php?page=Index', 'GET', '' )
    5. error code: 1114
    6. sql type: MySQLDatabase
    7. sql error: The table 'wcf1_session' is full
    8. sql error number: 1114
    9. sql version:
    10. file: /var/www/wcf/lib/system/database/MySQLDatabase.class.php (118)
    11. php version: 5.3.3-7+squeeze14
    12. wcf version: 1.1.9 (Tempest)
    13. date: Thu, 31 Jan 2013 15:42:30 +0000
    14. request: /index.php?page=Index
    15. referer:
    16. Stacktrace:
    17. #0 /var/www/wcf/lib/system/session/CookieSessionFactory.class.php(78): MySQLDatabase->sendQuery('INSERT INTO ?wc...')
    18. #1 /var/www/wcf/lib/system/session/SessionFactory.class.php(73): CookieSessionFactory->create()
    19. #2 /var/www/lib/system/WBBCore.class.php(200): SessionFactory->get()
    20. #3 /var/www/wcf/lib/system/WCF.class.php(98): WBBCore->initSession()
    21. #4 /var/www/global.php(18): WCF->__construct()
    22. #5 /var/www/index.php(7): require_once('/var/www/global...')
    23. #6 {main}
    Inaktiv, falls Fragen: Forum
    Nun:

    Source Code

    1. Fatal error: Invalid SQL: SELECT application.* FROM wcf1_group_application application LEFT JOIN wcf1_group_application_notification notification ON (application.applicationID = notification.applicationID) AND notification.userID = 0 WHERE notification.applicationID IS NULL AND application.groupID IN ( SELECT leader.groupID FROM wcf1_group_leader leader WHERE leader.userID = 0 ) AND application.applicationStatus = 0
    2. You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1054
    3. Information:
    4. error message: Invalid SQL: SELECT application.* FROM wcf1_group_application application LEFT JOIN wcf1_group_application_notification notification ON (application.applicationID = notification.applicationID) AND notification.userID = 0 WHERE notification.applicationID IS NULL AND application.groupID IN ( SELECT leader.groupID FROM wcf1_group_leader leader WHERE leader.userID = 0 ) AND application.applicationStatus = 0
    5. error code: 1054
    6. sql type: MySQLDatabase
    7. sql error: Unknown column 'leader.userID' in 'where clause'
    8. sql error number: 1054
    9. sql version:
    10. file: /var/www/wcf/lib/system/database/MySQLDatabase.class.php (118)
    11. php version: 5.3.3-7+squeeze14
    12. wcf version: 1.1.9 (Tempest)
    13. date: Thu, 31 Jan 2013 16:55:41 +0000
    14. request: /index.php?page=Index
    15. referer: http://floinkboard.de/acp/index.php?form=PackageUpdateSearch&packageID=48&
    16. Stacktrace:
    17. #0 /var/www/wcf/lib/system/event/listener/ApplicationRegisterListener.class.php(36): MySQLDatabase->sendQuery('SELECT??applica...')
    18. #1 /var/www/wcf/lib/system/event/EventHandler.class.php(131): ApplicationRegisterListener->execute(Object(IndexPage), 'IndexPage', 'assignVariables')
    19. #2 /var/www/wcf/lib/system/event/EventHandler.class.php(156): EventHandler::executeInheritedActions(Object(IndexPage), 'assignVariables', 'IndexPage', 'assignVariables...')
    20. #3 /var/www/wcf/lib/page/AbstractPage.class.php(73): EventHandler::fireAction(Object(IndexPage), 'assignVariables')
    21. #4 /var/www/lib/page/IndexPage.class.php(26): AbstractPage->assignVariables()
    22. #5 /var/www/wcf/lib/page/AbstractPage.class.php(93): IndexPage->assignVariables()
    23. #6 /var/www/wcf/lib/page/AbstractPage.class.php(46): AbstractPage->show()
    24. #7 /var/www/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
    25. #8 /var/www/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('Index', Array, 'page')
    26. #9 /var/www/index.php(8): RequestHandler::handle(Array)
    27. #10 {main}
    Inaktiv, falls Fragen: Forum
    Nicht verlangsamen, sondern beschleunigen. Dürfte der "Hourly Cleanup" Cronjob sein. Wobei normalerweise die halbstündige Ausführung locker reicht. Du hast wohl bestimmt das Timeout für Sessions viel zu hoch eingestellt, sodass die Sessions kaum von dem Hourly Cleanup Cronjob geleert werden.
    98% aller PC Probleme sitzen direkt davor.

    Debian GNU/Linux 7 | nginx/1.2.1 | PHP 5.6.2-1~dotdeb.1 (fpm-fcgi) | MySQL 5.6.19

    SmashLabs - Das Forum rund um die Super Smash Bros. Videospielserie