- Betroffene 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}