Fehler bei der Box "Letzte Kommentare"

    • Fixed

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Fehler bei der Box "Letzte Kommentare"

      Habe auch folgende Fehlermeldung wenn man auf das Dashboard möchte

      Source Code

      1. <<<<<<<<8765babdf31445c48760c2af208823ff5e1b5308<<<<
      2. Sun, 12 May 2019 10:21:38 +0000
      3. Message: Could not prepare statement 'SELECT
      4. comment.*
      5. FROM wcf1_comment comment
      6. WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1
      7. ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      8. PHP version: 7.0.32-nmm1
      9. WoltLab Suite version: 3.1.9 pl 2
      10. Request URI: /
      11. User Agent: Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)
      12. Peak Memory Usage: 18059720/268435456
      13. ======
      14. Error Class: wcf\system\database\exception\DatabaseQueryException
      15. Error Message: Could not prepare statement 'SELECT
      16. comment.*
      17. FROM wcf1_comment comment
      18. WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1
      19. ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      20. Error Code: 42
      21. File: /www/htdocs/w017c61c/lib/system/database/Database.class.php (248)
      22. Extra Information: -
      23. Stack Trace: [{"file":"\/www\/htdocs\/w017c61c\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf1_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5","5",0]},{"file":"\/www\/htdocs\/w017c61c\/lib\/data\/comment\/ViewableCommentList.class.php","line":28,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":255,"function":"readObjects","class":"wcf\\data\\comment\\ViewableCommentList","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/data\/box\/Box.class.php","line":263,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/templates\/compiled\/28_wcf_1_cms.php","line":4189,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/www\/htdocs\/w017c61c\/templates\/compiled\/28_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/www\/htdocs\/w017c61c\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/www\/htdocs\/w017c61c\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
      24. ======
      25. Error Class: PDOException
      26. Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comments' in 'order clause'
      27. Error Code: 42
      28. File: /www/htdocs/w017c61c/lib/system/database/Database.class.php (243)
      29. Extra Information: -
      30. Stack Trace: [{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/database\/Database.class.php","line":243,"function":"prepare","class":"PDO","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf1_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5"]},{"file":"\/www\/htdocs\/w017c61c\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf1_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5","5",0]},{"file":"\/www\/htdocs\/w017c61c\/lib\/data\/comment\/ViewableCommentList.class.php","line":28,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":255,"function":"readObjects","class":"wcf\\data\\comment\\ViewableCommentList","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/data\/box\/Box.class.php","line":263,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/templates\/compiled\/28_wcf_1_cms.php","line":4189,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/www\/htdocs\/w017c61c\/templates\/compiled\/28_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/www\/htdocs\/w017c61c\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/www\/htdocs\/w017c61c\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w017c61c\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
      31. <<<<
      Display All
    • Gleiches Problem.
      Als Angemeldeter siehe ich den fehler nicht aber als Gast (Logout) tritt der fehler auf.

      Source Code

      1. Could not prepare statement 'SELECT comment.* FROM wcf2018_comment comment WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1 ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      2. Datum
      3. 14. Mai 2019, 20:49
      4. Aufgerufene URL
      5. /
      6. Referrer
      7. https://www.cafe-anime.de/
      8. Browser
      9. Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36
      10. Arbeitsspeicher
      11. 11,3 MiB / 256 MiB
      12. Fehlermeldung
      13. Could not prepare statement 'SELECT comment.* FROM wcf2018_comment comment WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1 ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      14. Art
      15. wcf\system\database\exception\DatabaseQueryException
      16. Datei (Zeile)
      17. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (248)
      18. Stacktrace
      19. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/DatabaseObjectList.class.php (194): wcf\system\database\Database->prepareStatement(…)
      20. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/comment/ViewableCommentList.class.php (28): wcf\data\DatabaseObjectList->readObjects(…)
      21. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (255): wcf\data\comment\ViewableCommentList->readObjects(…)
      22. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (231): wcf\system\box\AbstractDatabaseObjectListBoxController->readObjects(…)
      23. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (202): wcf\system\box\AbstractDatabaseObjectListBoxController->loadContent(…)
      24. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/box/Box.class.php (278): wcf\system\box\AbstractDatabaseObjectListBoxController->hasContent(…)
      25. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/box/Box.class.php (263): wcf\data\box\Box->hasContent(…)
      26. /var/www/vhosts/cafe-anime.de/httpdocs/templates/compiled/2_wcf_1_cms.php (2591): wcf\data\box\Box->render(…)
      27. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/template/TemplateEngine.class.php (321): include(…)
      28. /var/www/vhosts/cafe-anime.de/httpdocs/lib/page/AbstractPage.class.php (323): wcf\system\template\TemplateEngine->display(…)
      29. /var/www/vhosts/cafe-anime.de/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
      30. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
      31. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
      32. /var/www/vhosts/cafe-anime.de/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)
      33. Fehlermeldung
      34. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comments' in 'order clause'
      35. Art
      36. PDOException
      37. Datei (Zeile)
      38. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (243)
      39. Stacktrace
      40. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (243): PDO->prepare(…)
      41. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/DatabaseObjectList.class.php (194): wcf\system\database\Database->prepareStatement(…)
      42. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/comment/ViewableCommentList.class.php (28): wcf\data\DatabaseObjectList->readObjects(…)
      43. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (255): wcf\data\comment\ViewableCommentList->readObjects(…)
      44. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (231): wcf\system\box\AbstractDatabaseObjectListBoxController->readObjects(…)
      45. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (202): wcf\system\box\AbstractDatabaseObjectListBoxController->loadContent(…)
      46. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/box/Box.class.php (278): wcf\system\box\AbstractDatabaseObjectListBoxController->hasContent(…)
      47. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/box/Box.class.php (263): wcf\data\box\Box->hasContent(…)
      48. /var/www/vhosts/cafe-anime.de/httpdocs/templates/compiled/2_wcf_1_cms.php (2591): wcf\data\box\Box->render(…)
      49. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/template/TemplateEngine.class.php (321): include(…)
      50. /var/www/vhosts/cafe-anime.de/httpdocs/lib/page/AbstractPage.class.php (323): wcf\system\template\TemplateEngine->display(…)
      51. /var/www/vhosts/cafe-anime.de/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
      52. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
      53. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
      54. /var/www/vhosts/cafe-anime.de/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)
      Display All

      Source Code

      1. Tue, 14 May 2019 18:49:34 +0000
      2. Message: Could not prepare statement 'SELECT
      3. comment.*
      4. FROM wcf2018_comment comment
      5. WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1
      6. ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      7. PHP version: 7.1.29
      8. WoltLab Suite version: 3.1.9 pl 2
      9. Request URI: /
      10. Referrer: https://www.cafe-anime.de/
      11. User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36
      12. Peak Memory Usage: 11848016/268435456
      13. ======
      14. Error Class: wcf\system\database\exception\DatabaseQueryException
      15. Error Message: Could not prepare statement 'SELECT
      16. comment.*
      17. FROM wcf2018_comment comment
      18. WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1
      19. ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      20. Error Code: 42
      21. File: /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (248)
      22. Extra Information: -
      23. Stack Trace: [{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf2018_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5","5",0]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/comment\/ViewableCommentList.class.php","line":28,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":255,"function":"readObjects","class":"wcf\\data\\comment\\ViewableCommentList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":263,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/templates\/compiled\/2_wcf_1_cms.php","line":2591,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/templates\/compiled\/2_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
      24. ======
      25. Error Class: PDOException
      26. Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comments' in 'order clause'
      27. Error Code: 42
      28. File: /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (243)
      29. Extra Information: -
      30. Stack Trace: [{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/database\/Database.class.php","line":243,"function":"prepare","class":"PDO","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf2018_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5"]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf2018_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5","5",0]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/comment\/ViewableCommentList.class.php","line":28,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":255,"function":"readObjects","class":"wcf\\data\\comment\\ViewableCommentList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":263,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/templates\/compiled\/2_wcf_1_cms.php","line":2591,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/templates\/compiled\/2_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
      Display All

      Edit generell wird die box auch im eingeloggten Zustand nicht angezeigt.

      The post was edited 1 time, last by Cafe-Anime ().

    • Cafe-Anime wrote:

      Gleiches Problem.
      Als Angemeldeter siehe ich den fehler nicht aber als Gast (Logout) tritt der fehler auf.

      Source Code

      1. Could not prepare statement 'SELECT comment.* FROM wcf2018_comment comment WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1 ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      2. Datum
      3. 14. Mai 2019, 20:49
      4. Aufgerufene URL
      5. /
      6. Referrer
      7. https://www.cafe-anime.de/
      8. Browser
      9. Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36
      10. Arbeitsspeicher
      11. 11,3 MiB / 256 MiB
      12. Fehlermeldung
      13. Could not prepare statement 'SELECT comment.* FROM wcf2018_comment comment WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1 ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      14. Art
      15. wcf\system\database\exception\DatabaseQueryException
      16. Datei (Zeile)
      17. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (248)
      18. Stacktrace
      19. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/DatabaseObjectList.class.php (194): wcf\system\database\Database->prepareStatement(…)
      20. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/comment/ViewableCommentList.class.php (28): wcf\data\DatabaseObjectList->readObjects(…)
      21. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (255): wcf\data\comment\ViewableCommentList->readObjects(…)
      22. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (231): wcf\system\box\AbstractDatabaseObjectListBoxController->readObjects(…)
      23. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (202): wcf\system\box\AbstractDatabaseObjectListBoxController->loadContent(…)
      24. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/box/Box.class.php (278): wcf\system\box\AbstractDatabaseObjectListBoxController->hasContent(…)
      25. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/box/Box.class.php (263): wcf\data\box\Box->hasContent(…)
      26. /var/www/vhosts/cafe-anime.de/httpdocs/templates/compiled/2_wcf_1_cms.php (2591): wcf\data\box\Box->render(…)
      27. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/template/TemplateEngine.class.php (321): include(…)
      28. /var/www/vhosts/cafe-anime.de/httpdocs/lib/page/AbstractPage.class.php (323): wcf\system\template\TemplateEngine->display(…)
      29. /var/www/vhosts/cafe-anime.de/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
      30. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
      31. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
      32. /var/www/vhosts/cafe-anime.de/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)
      33. Fehlermeldung
      34. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comments' in 'order clause'
      35. Art
      36. PDOException
      37. Datei (Zeile)
      38. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (243)
      39. Stacktrace
      40. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (243): PDO->prepare(…)
      41. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/DatabaseObjectList.class.php (194): wcf\system\database\Database->prepareStatement(…)
      42. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/comment/ViewableCommentList.class.php (28): wcf\data\DatabaseObjectList->readObjects(…)
      43. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (255): wcf\data\comment\ViewableCommentList->readObjects(…)
      44. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (231): wcf\system\box\AbstractDatabaseObjectListBoxController->readObjects(…)
      45. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (202): wcf\system\box\AbstractDatabaseObjectListBoxController->loadContent(…)
      46. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/box/Box.class.php (278): wcf\system\box\AbstractDatabaseObjectListBoxController->hasContent(…)
      47. /var/www/vhosts/cafe-anime.de/httpdocs/lib/data/box/Box.class.php (263): wcf\data\box\Box->hasContent(…)
      48. /var/www/vhosts/cafe-anime.de/httpdocs/templates/compiled/2_wcf_1_cms.php (2591): wcf\data\box\Box->render(…)
      49. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/template/TemplateEngine.class.php (321): include(…)
      50. /var/www/vhosts/cafe-anime.de/httpdocs/lib/page/AbstractPage.class.php (323): wcf\system\template\TemplateEngine->display(…)
      51. /var/www/vhosts/cafe-anime.de/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
      52. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
      53. /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
      54. /var/www/vhosts/cafe-anime.de/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)
      Display All

      Source Code

      1. Tue, 14 May 2019 18:49:34 +0000
      2. Message: Could not prepare statement 'SELECT
      3. comment.*
      4. FROM wcf2018_comment comment
      5. WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1
      6. ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      7. PHP version: 7.1.29
      8. WoltLab Suite version: 3.1.9 pl 2
      9. Request URI: /
      10. Referrer: https://www.cafe-anime.de/
      11. User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36
      12. Peak Memory Usage: 11848016/268435456
      13. ======
      14. Error Class: wcf\system\database\exception\DatabaseQueryException
      15. Error Message: Could not prepare statement 'SELECT
      16. comment.*
      17. FROM wcf2018_comment comment
      18. WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1
      19. ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      20. Error Code: 42
      21. File: /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (248)
      22. Extra Information: -
      23. Stack Trace: [{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf2018_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5","5",0]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/comment\/ViewableCommentList.class.php","line":28,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":255,"function":"readObjects","class":"wcf\\data\\comment\\ViewableCommentList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":263,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/templates\/compiled\/2_wcf_1_cms.php","line":2591,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/templates\/compiled\/2_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
      24. ======
      25. Error Class: PDOException
      26. Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comments' in 'order clause'
      27. Error Code: 42
      28. File: /var/www/vhosts/cafe-anime.de/httpdocs/lib/system/database/Database.class.php (243)
      29. Extra Information: -
      30. Stack Trace: [{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/database\/Database.class.php","line":243,"function":"prepare","class":"PDO","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf2018_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5"]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf2018_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5","5",0]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/comment\/ViewableCommentList.class.php","line":28,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":255,"function":"readObjects","class":"wcf\\data\\comment\\ViewableCommentList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":263,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/templates\/compiled\/2_wcf_1_cms.php","line":2591,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/templates\/compiled\/2_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/cafe-anime.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
      Display All
      Edit generell wird die box auch im eingeloggten Zustand nicht angezeigt.

      Wenn ich raten müsste liegt es an der Box.xml und zwar am

      <sortField>comments</sortField> zeile 163
      dies gibt es so gar nicht als Sortier Funktion Standard sind dort immer wie ich sehe

      <sortField>time</sortField>

      Denn es soll ja nach Zeit und nicht nach anzahl von Kommentaren sortiert werden (denn diese werden garnicht geprüft)
    • @Cafe-Anime
      Könntest du bitte die im Anhang befindete Datei einmal testen? Diese gehört in den Ordner clan\lib\system\box
      Damit ist es definitiv behoben, das die Box generell nicht mehr angezeigt wird. Interessant wäre, ob deine zwei besagten Fehlermeldungen damit auch verschwinden, die bekomm ich nämlich in keinster weise (Weder im angemeldeten, noch im unangemeldeten Zustand). Über eine kurze Rückmeldung würde ich mich freuen.

      Gruß und Danke,
      Marcel

      Edit: Datei entfernt