Fehler bei BetterFeed 1.0.0 RC 1

  • Hallo,


    ohne das Plugin funktionieren die Feeds im System überall. Mit dem installierten Plugin gehen die Feeds bei Artikeln oder auch im Lexikon ohne Probleme, aber im Forum (wo das Plugin ja "aktiv" wird), erhalte ich folgenden Fehler:


    Teil 1:

    Fehlermeldung schrieb:

    System Information

    Final Error

    • Error Type: wcf\system\database\exception\DatabaseQueryException
    • Error Message: Could not prepare statement 'SELECT DISTINCT post.userID AS ownPosts,tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID,last_post.message, last_post.enableSmilies, last_post.enableHtml, last_post.enableBBCodes, thread.* FROM wbb1_thread thread LEFT JOIN wbb1_post post ON (post.threadID = thread.threadID AND post.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 1) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 1 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) LEFT JOIN wbb1_post last_post ON (last_post.postID = thread.lastPostID) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY thread.lastPostTime DESC'
    • Error Code: 42
    • File: */lib/system/database/Database.class.php (240)
    • Stack Trace:

      • #0 */lib/data/DatabaseObjectList.class.php (183):
      • wcf\system\database\Database->prepareStatement('SELECT DISTINCT post.userID AS ownPosts,tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID,last_post.message, last_post.enableSmilies, last_post.enableHtml, last_post.enableBBCodes, thread.* FROM wbb1_thread thread LEFT JOIN wbb1_post post ON (post.threadID = thread.threadID AND post.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 1) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 1 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) LEFT JOIN wbb1_post last_post ON (last_post.postID = thread.lastPostID) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY thread.lastPostTime DESC')
      • #1 */forum/lib/data/thread/ViewableThreadList.class.php (94):
      • wcf\data\DatabaseObjectList->readObjects()
      • #2 */forum/lib/system/event/listener/BetterBoardFeedListener.class.php (34):
      • wbb\data\thread\ViewableThreadList->readObjects()
      • #3 */lib/system/event/EventHandler.class.php (221):
      • wbb\system\event\listener\BetterBoardFeedListener->execute(wbb\page\BoardFeedPage, 'wbb\\page\\BoardFeedPage', 'assignVariables', [ ])
      • #4 */lib/page/AbstractPage.class.php (130):
      • wcf\system\event\EventHandler->fireAction(wbb\page\BoardFeedPage, 'assignVariables')
      • #5 */lib/page/AbstractFeedPage.class.php (53):
      • wcf\page\AbstractPage->assignVariables()
      • #6 */lib/page/AbstractPage.class.php (277):
      • wcf\page\AbstractFeedPage->assignVariables()
      • #7 */lib/page/AbstractFeedPage.class.php (84):
      • wcf\page\AbstractPage->show()
      • #8 */lib/page/AbstractPage.class.php (103):
      • wcf\page\AbstractFeedPage->show()
      • #9 */lib/system/request/Request.class.php (83):
      • wcf\page\AbstractPage->__run()
      • #10 */lib/system/request/RequestHandler.class.php (94):
      • wcf\system\request\Request->execute()
      • #11 */forum/index.php (9):
      • wcf\system\request\RequestHandler->handle('wbb')
  • Teil 2:


    Fehlermeldung schrieb:

    Original Error


    • Error Type: PDOException
    • Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_post.enableSmilies' in 'field list'
    • Error Code: 42
    • File: */lib/system/database/Database.class.php (235)
    • Stack Trace:

      • #0 */lib/system/database/Database.class.php (235):
      • PDO->prepare('SELECT DISTINCT post.userID AS ownPosts,tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID,last_post.message, last_post.enableSmilies, last_post.enableHtml, last_post.enableBBCodes, thread.* FROM wbb1_thread thread LEFT JOIN wbb1_post post ON (post.threadID = thread.threadID AND post.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 1) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 1 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) LEFT JOIN wbb1_post last_post ON (last_post.postID = thread.lastPostID) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY thread.lastPostTime DESC')
      • #1 */lib/data/DatabaseObjectList.class.php (183):
      • wcf\system\database\Database->prepareStatement('SELECT DISTINCT post.userID AS ownPosts,tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID,last_post.message, last_post.enableSmilies, last_post.enableHtml, last_post.enableBBCodes, thread.* FROM wbb1_thread thread LEFT JOIN wbb1_post post ON (post.threadID = thread.threadID AND post.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 1) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 1 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) LEFT JOIN wbb1_post last_post ON (last_post.postID = thread.lastPostID) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY thread.lastPostTime DESC')
      • #2 */forum/lib/data/thread/ViewableThreadList.class.php (94):
      • wcf\data\DatabaseObjectList->readObjects()
      • #3 */forum/lib/system/event/listener/BetterBoardFeedListener.class.php (34):
      • wbb\data\thread\ViewableThreadList->readObjects()
      • #4 */lib/system/event/EventHandler.class.php (221):
      • wbb\system\event\listener\BetterBoardFeedListener->execute(wbb\page\BoardFeedPage, 'wbb\\page\\BoardFeedPage', 'assignVariables', [ ])
      • #5 */lib/page/AbstractPage.class.php (130):
      • wcf\system\event\EventHandler->fireAction(wbb\page\BoardFeedPage, 'assignVariables')
      • #6 */lib/page/AbstractFeedPage.class.php (53):
      • wcf\page\AbstractPage->assignVariables()
      • #7 */lib/page/AbstractPage.class.php (277):
      • wcf\page\AbstractFeedPage->assignVariables()
      • #8 */lib/page/AbstractFeedPage.class.php (84):
      • wcf\page\AbstractPage->show()
      • #9 */lib/page/AbstractPage.class.php (103):
      • wcf\page\AbstractFeedPage->show()
      • #10 */lib/system/request/Request.class.php (83):
      • wcf\page\AbstractPage->__run()
      • #11 */lib/system/request/RequestHandler.class.php (94):
      • wcf\system\request\Request->execute()
      • #12 */forum/index.php (9):
      • wcf\system\request\RequestHandler->handle('wbb')


    [/quote]

  • @SoftCreatR: Die Datenbank-Struktur hat sich geändert sodass nun enableBBcode und enableSmiley nicht mehr länger existieren.
    Ich glaub da sind btw noch weitere Anpassungen nötig, ich schau später mal wenn du magst ;)

  • Ist mit Version 1.0.0 behoben.

    Ist bei diesen BBCode das Forum zwingend. Ich habe zur Zeit nur das WCS 3.0.1 pl1 installiert.
    Ich frage deswegwegen weil bei der installation kommt der gleiche Fehler wie schon weiter oben beschrieben.

    bx19 ;)

  • Bei mir ist zur Zeit nur die WoltLab Suit Core ohne Forensoftware installiert.
    Beim Versuch den BBCode zu installieren erhalte ich eine Fehlermeldung daher geh ich davon aus das die Forensoftware WBB 5.x notwendig ist.
    Wenn dem so ist sollte ein starten der installation nicht möglich gemacht werden.

    bx19 ;)

  • Du kannst dann aber eigentlich nicht den o.g. Fehler erhalten.


    Grundsätzlich hast du natürlich Recht, dass ich da eine Kleinigkeit vergessen habe, ändere das sofort, lade es aber mit derselben Versionsnummer neu hoch.


    EDIT:


    Done.