• 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://198.58.120.55/wbb4/index.php/ThreadAdd/9/User 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}

Participate now!

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