Help identify error

  • Affected Version
    WoltLab Suite 3.1

    I'm getting this error occasionally just going to my forum home page. It started a couple months ago and is now happening more often. What is causing it?




    An error has occured

    Internal error code: 1092ac0441330d05884caf2eedc7ee627e5c0564


    What happened?

    An error has occured while trying to handle your request and execution has been terminated. Please forward the above error code to the site administrator.


    The error code can be used by an administrator to lookup the full error message in the Administration Control Panel via “Logs » Errors”. In addition the error has been written to the log file located at */log/2019-07-15.txt and can be accessed with a FTP program or similar.


    Notice: The error code was randomly generated and has no use beyond looking up the full message.


    System Information

    • PHP Version:

      7.2.20

    • WoltLab Suite Core:

      3.0.21 pl 1

    • Peak Memory Usage:

      20.267/256 MiB

    • Request URI:

      /

    • Referrer:

    • User Agent:

      Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0


    Final Error

    • Error Type:

      wcf\system\database\exception\DatabaseQueryExecutionException

    • Error Message:

      Could not execute 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, 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 = 210 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 1) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 209 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 = 235 AND user_object_watch.userID = 1 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 211 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 233 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC,thread.time DESC'

    • Error Code:

      0

    • File:

      */lib/system/database/statement/PreparedStatement.class.php (105)

    • Query Parameter 1:

      7743

    • Query Parameter 2:

      7739

    • Query Parameter 3:

      7738

    • Query Parameter 4:

      386

    • Query Parameter 5:

      7735

    • Query Parameter 6:

      7709

    • Stack Trace:

      • #0 */lib/data/DatabaseObjectList.class.php (184):
      • wcf\system\database\statement\PreparedStatement->execute([ 6 items ])
      • #1 */../lib/data/thread/ViewableThreadList.class.php (94):
      • wcf\data\DatabaseObjectList->readObjects()
      • #2 */lib/system/box/AbstractDatabaseObjectListBoxController.class.php (255):
      • wbb\data\thread\ViewableThreadList->readObjects()
      • #3 */../lib/system/box/ThreadListBoxController.class.php (134):
      • wcf\system\box\AbstractDatabaseObjectListBoxController->readObjects()
      • #4 */lib/system/box/AbstractDatabaseObjectListBoxController.class.php (231):
      • wbb\system\box\ThreadListBoxController->readObjects()
      • #5 */lib/system/box/AbstractDatabaseObjectListBoxController.class.php (202):
      • wcf\system\box\AbstractDatabaseObjectListBoxController->loadContent()
      • #6 */lib/data/box/Box.class.php (271):
      • wcf\system\box\AbstractDatabaseObjectListBoxController->hasContent()
      • #7 */lib/data/box/Box.class.php (256):
      • wcf\data\box\Box->hasContent()
      • #8 */templates/compiled/3_wbb_1_boardList.php (2735):
      • wcf\data\box\Box->render()
      • #9 */lib/system/template/TemplateEngine.class.php (320):
      • include('*/templates/compiled/3_wbb_1_boardList.php')
      • #10 */lib/page/AbstractPage.class.php (308):
      • wcf\system\template\TemplateEngine->display('boardList', 'wbb')
      • #11 */lib/page/AbstractPage.class.php (103):
      • wcf\page\AbstractPage->show()
      • #12 */lib/system/request/Request.class.php (83):
      • wcf\page\AbstractPage->__run()
      • #13 */lib/system/request/RequestHandler.class.php (94):
      • wcf\system\request\Request->execute()
      • #14 */../index.php (9):
      • wcf\system\request\RequestHandler->handle('wbb')


    Original Error

    • Error Type:

      PDOException

    • Error Message:

      SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared

    • Error Code:

      0

    • File:

      */lib/system/database/statement/PreparedStatement.class.php (93)

    • Stack Trace:

      • #0 */lib/system/database/statement/PreparedStatement.class.php (93):
      • PDOStatement->execute([ 6 items ])
      • #1 */lib/data/DatabaseObjectList.class.php (184):
      • wcf\system\database\statement\PreparedStatement->execute([ 6 items ])
      • #2 */../lib/data/thread/ViewableThreadList.class.php (94):
      • wcf\data\DatabaseObjectList->readObjects()
      • #3 */lib/system/box/AbstractDatabaseObjectListBoxController.class.php (255):
      • wbb\data\thread\ViewableThreadList->readObjects()
      • #4 */../lib/system/box/ThreadListBoxController.class.php (134):
      • wcf\system\box\AbstractDatabaseObjectListBoxController->readObjects()
      • #5 */lib/system/box/AbstractDatabaseObjectListBoxController.class.php (231):
      • wbb\system\box\ThreadListBoxController->readObjects()
      • #6 */lib/system/box/AbstractDatabaseObjectListBoxController.class.php (202):
      • wcf\system\box\AbstractDatabaseObjectListBoxController->loadContent()
      • #7 */lib/data/box/Box.class.php (271):
      • wcf\system\box\AbstractDatabaseObjectListBoxController->hasContent()
      • #8 */lib/data/box/Box.class.php (256):
      • wcf\data\box\Box->hasContent()
      • #9 */templates/compiled/3_wbb_1_boardList.php (2735):
      • wcf\data\box\Box->render()
      • #10 */lib/system/template/TemplateEngine.class.php (320):
      • include('*/templates/compiled/3_wbb_1_boardList.php')
      • #11 */lib/page/AbstractPage.class.php (308):
      • wcf\system\template\TemplateEngine->display('boardList', 'wbb')
      • #12 */lib/page/AbstractPage.class.php (103):
      • wcf\page\AbstractPage->show()
      • #13 */lib/system/request/Request.class.php (83):
      • wcf\page\AbstractPage->__run()
      • #14 */lib/system/request/RequestHandler.class.php (94):
      • wcf\system\request\Request->execute()
      • #15 */../index.php (9):
      • wcf\system\request\RequestHandler->handle('wbb')
    • Official Post

    SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared

    This is commonly caused by an insufficient table_definition_cache in MySQL, often caused by heavy load on the database server.

    Alexander Ebert
    Senior Developer WoltLab® GmbH

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!