• Affected App
    WoltLab Suite Forum

    Hi friends...

    Im getting this error message when making a new thread in my wbb forum. ( i Have installed a fresh wbb4 and imported a wbb 3.1.8 database ) The thread is added when using the back button in browser after this error... ::

    Could not execute prepared statement: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokensTimeDec 18th 2013, 11:06pmFile (Line)/var/www/wbb4/wcf/lib/system/database/statement/PreparedStatement.class.php (100)Requested URL/wbb4/index.php/ThreadAdd/9/Referrerhttp:// AgentMozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36Additional informationsql type: wcf\system\database\MySQLDatabase
    sql error:
    sql error number: HY093
    sql version: 5.5.34-0ubuntu0.13.10.1
    sql query: SELECT post.threadID, search_index.relevance + IF(thread.boardID=9,2,0) AS relevance FROM wbb1_post post INNER JOIN ( SELECT objectID, MATCH (subject, message, metaData) AGAINST ('Test igen') + (5 / (1 + POW(LN(1 + (1387404416 - time) / 2592000), 2))) AS relevance FROM wcf1_search_index WHERE MATCH (subject, message, metaData) AGAINST ('Test igen' IN BOOLEAN MODE) AND objectTypeID = 88 AND time > 1355868416 ORDER BY relevance DESC LIMIT 1000 ) search_index ON (post.postID = search_index.objectID) LEFT JOIN wbb1_thread thread ON (thread.threadID = post.threadID) WHERE post.isDisabled = 0 AND post.isDeleted = 0 AND post.threadID <> ? AND thread.boardID IN (?) ORDER BY relevance DESC LIMIT 6
    sql query parameter 0:36793
    Stacktrace#0 /var/www/wbb4/lib/data/thread/Thread.class.php(353): wcf\system\database\statement\PreparedStatement->execute(Array)
    #1 /var/www/wbb4/lib/data/thread/ThreadAction.class.php(1608): wbb\data\thread\Thread::getSimilarThreads('Test igen', Array, 6, '9', '36793', NULL)
    #2 [internal function]: wbb\data\thread\ThreadAction->updateSimilarThreads()
    #3 /var/www/wbb4/wcf/lib/data/AbstractDatabaseObjectAction.class.php(182): call_user_func(Array)
    #4 /var/www/wbb4/lib/data/thread/ThreadAction.class.php(147): wcf\data\AbstractDatabaseObjectAction->executeAction()
    #5 [internal function]: wbb\data\thread\ThreadAction->create()
    #6 /var/www/wbb4/wcf/lib/data/AbstractDatabaseObjectAction.class.php(182): call_user_func(Array)
    #7 /var/www/wbb4/lib/form/ThreadAddForm.class.php(364): wcf\data\AbstractDatabaseObjectAction->executeAction()
    #8 /var/www/wbb4/wcf/lib/form/AbstractForm.class.php(63): wbb\form\ThreadAddForm->save()
    #9 /var/www/wbb4/wcf/lib/form/AbstractForm.class.php(114): wcf\form\AbstractForm->submit()
    #10 /var/www/wbb4/wcf/lib/form/MessageForm.class.php(334): wcf\form\AbstractForm->readData()
    #11 /var/www/wbb4/lib/form/ThreadAddForm.class.php(416): wcf\form\MessageForm->readData()
    #12 /var/www/wbb4/wcf/lib/page/AbstractPage.class.php(179): wbb\form\ThreadAddForm->readData()
    #13 /var/www/wbb4/wcf/lib/page/AbstractPage.class.php(86): wcf\page\AbstractPage->show()
    #14 /var/www/wbb4/wcf/lib/system/request/Request.class.php(58): wcf\page\AbstractPage->__run()
    #15 /var/www/wbb4/wcf/lib/system/request/RequestHandler.class.php(106): wcf\system\request\Request->execute()
    #16 /var/www/wbb4/index.php(10): wcf\system\request\RequestHandler->handle('wbb')
    #17 {main}

  • I see :) When i reply an excisting thread there's no problem . Only if I create a new thread , then this issue will appear

    • Official Post

    Looks like I found the issue: Could it be that every other forum (expect the one where you've created the thread) has the Posts are used to calculate similar threads option? You can review the settings through: Community > Forums > List Forums > Edit > Tab "General" > Section "Settings"

  • Thank you so much - It works :) Its a big job, to change that settings for each forum.
    Thanks again for your great support...

    Regards from noerbom

Participate now!

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