Fatal error: Invalid SQL: SELECT post.postID,
MATCH (post.subject, post.message) AGAINST ('Zecken...')
+ (5 / (1 + POW(LN(1 + (1369761586 - post.time) / 2592000), 2)))
+ IF(thread.boardID=114,2,0) AS relevance
FROM wbb4_1_post post
LEFT JOIN wbb4_1_thread thread USING (threadID)
WHERE MATCH (post.subject, post.message) AGAINST ('Zecken...' IN BOOLEAN MODE)
AND (post.threadID <> 3137)
GROUP BY post.postID
ORDER BY relevance DESC LIMIT 5
You get more information about the problem in our knowledge base: WoltLab® - Support - Documentations
Information:
error message: Invalid SQL: SELECT post.postID,
MATCH (post.subject, post.message) AGAINST ('Zecken...')
+ (5 / (1 + POW(LN(1 + (1369761586 - post.time) / 2592000), 2)))
+ IF(thread.boardID=114,2,0) AS relevance
FROM wbb4_1_post post
LEFT JOIN wbb4_1_thread thread USING (threadID)
WHERE MATCH (post.subject, post.message) AGAINST ('Zecken...' IN BOOLEAN MODE)
AND (post.threadID <> 3137)
GROUP BY post.postID
ORDER BY relevance DESC LIMIT 5
error code: 1191
sql type: MySQLDatabase
sql error: Can't find FULLTEXT index matching the column list
sql error number: 1191
sql version:
file: /var/www/web753/html/wbb3/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.3-7+squeeze15
wcf version: 1.1.9 (Tempest)
date: Tue, 28 May 2013 17:19:46 +0000
request: /index.php?form=ThreadAdd&boardID=114
referer: http://www.rund-um-hunde.de/index.php?form=ThreadAdd&boardID=114
Stacktrace:
#0 /var/www/web753/html/wbb3/lib/data/thread/ThreadEditor.class.php(563): MySQLDatabase->sendQuery('SELECT??post.po...', 5)
#1 /var/www/web753/html/wbb3/lib/data/thread/ThreadEditor.class.php(507): ThreadEditor::updateSimilarThreads(3137, 'Zecken...', '114')
#2 /var/www/web753/html/wbb3/lib/form/ThreadAddForm.class.php(305): ThreadEditor::create('114', 0, '', 'Zecken...', 'Sagt mal, haben...', '2', 'Steffi', 0, 0, 0, Array, 0, Object(MessageAttachmentListEditor), Object(PollEditor), 0)
#3 /var/www/web753/html/wbb3/lib/form/ThreadAddForm.class.php(178): ThreadAddForm->save()
#4 /var/www/web753/html/wbb3/wcf/lib/form/AbstractForm.class.php(90): ThreadAddForm->submit()
#5 /var/www/web753/html/wbb3/wcf/lib/form/CaptchaForm.class.php(104): AbstractForm->readData()
#6 /var/www/web753/html/wbb3/wcf/lib/form/MessageForm.class.php(193): CaptchaForm->readData()
#7 /var/www/web753/html/wbb3/lib/form/ThreadAddForm.class.php(369): MessageForm->readData()
#8 /var/www/web753/html/wbb3/wcf/lib/page/AbstractPage.class.php(90): ThreadAddForm->readData()
#9 /var/www/web753/html/wbb3/wcf/lib/form/MessageForm.class.php(237): AbstractPage->show()
#10 /var/www/web753/html/wbb3/lib/form/ThreadAddForm.class.php(434): MessageForm->show()
#11 /var/www/web753/html/wbb3/wcf/lib/page/AbstractPage.class.php(46): ThreadAddForm->show()
#12 /var/www/web753/html/wbb3/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#13 /var/www/web753/html/wbb3/wcf/lib/util/RequestHandler.class.php(95): RequestHandler->__construct('ThreadAdd', Array, 'form')
#14 /var/www/web753/html/wbb3/index.php(8): RequestHandler::handle(Array)
#15 {main}