Hallo,
ich bekomme bei mir im System regelmäßig folgende Fehlermeldung:
Code
Mon, 08 Jul 2024 21:28:58 +0000
Message: MySQL search query failed.
PHP version: 8.3.8
WoltLab Suite version: 6.0.16
Request URI: POST /index.php?ajax-proxy/&t=0f32f4acb7443bd50fd715615da0aa23187463fdfb6cbeabe01e91bbe8dbdd8c-rsRc4AQlNgK1M49Ss8kNbQ==
Referrer: https://www.anime-community.de/search/?q=Spice+and+wolf&sortField=time&sortOrder=DESC
User Agent: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36
Peak Memory Usage: 5427744/134217728
======
Error Class: wcf\system\search\exception\SearchFailed
Error Message: MySQL search query failed.
Error Code: 0
File: /../community/lib/system/search/mysql/MysqlSearchEngine.class.php (129)
Extra Information: -
Stack Trace: [{"file":"\/..\/lib\/system\/search\/SearchEngine.class.php","line":144,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["Spice and wolf",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC",1000]},{"file":"\/..\/lib\/system\/search\/SearchHandler.class.php","line":341,"function":"searchWithContext","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["Spice and wolf",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]"},{"com.woltlab.wbb.post":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC"]},{"file":"\/..\/lib\/system\/search\/SearchHandler.class.php","line":93,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/..\/lib\/data\/search\/SearchAction.class.php","line":99,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/..\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXInvokeAction.class.php","line":110,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AbstractAction.class.php","line":56,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXInvokeAction.class.php","line":64,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/..\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/..\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/..\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/..\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement ' SELECT wbb1_post.postID AS objectID, wbb1_post.subject AS subject, wbb1_post.time AS time, wbb1_post.username AS username, 'com.woltlab.wbb.post' AS objectType FROM wbb1_post INNER JOIN (SELECT objectID , '0' AS relevance FROM wbb1_post_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON wbb1_post.postID = search_index.objectID LEFT JOIN wbb1_thread thread ON thread.threadID = wbb1_post.threadID WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0 UNION ALL SELECT gallery1_image.imageID AS objectID, gallery1_image.title AS subject, gallery1_image.uploadTime AS time, gallery1_image.username AS username, 'com.woltlab.gallery.image' AS objectType FROM gallery1_image INNER JOIN (SELECT objectID , '0' AS relevance FROM gallery1_image_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON gallery1_image.imageID = search_index.objectID WHERE gallery1_image.imageID IN ( SELECT imageID FROM gallery1_image_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) AND gallery1_image.isDisabled = 0 AND gallery1_image.isDeleted = 0 AND gallery1_image.accessLevel = ? UNION ALL SELECT wcf1_article_content.articleContentID AS objectID, wcf1_article_content.title AS subject, wcf1_article.time AS time, wcf1_article.username AS username, 'com.woltlab.wcf.article' AS objectType FROM wcf1_article_content INNER JOIN (SELECT objectID , '0' AS relevance FROM wcf1_article_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON wcf1_article_content.articleContentID = search_index.objectID INNER JOIN wcf1_article ON wcf1_article.articleID = wcf1_article_content.articleID WHERE wcf1_article.categoryID IN (?,?,?,?,?,?,?) AND wcf1_article.publicationStatus = ? UNION ALL SELECT wcf1_page_content.pageContentID AS objectID, wcf1_page_content.title AS subject, wcf1_page_content.pageContentID AS time, '' AS username, 'com.woltlab.wcf.page' AS objectType FROM wcf1_page_content INNER JOIN (SELECT objectID , '0' AS relevance FROM wcf1_page_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON wcf1_page_content.pageContentID = search_index.objectID INNER JOIN wcf1_page ON wcf1_page.pageID = wcf1_page_content.pageID WHERE wcf1_page.pageType IN (?,?) AND wcf1_page.isDisabled = ? AND (wcf1_page_content.languageID IS NULL OR wcf1_page_content.languageID IN (?)) AND ( wcf1_page_content.pageID NOT IN ( SELECT objectID FROM wcf1_acl_simple_to_group WHERE objectTypeID = ? UNION SELECT objectID FROM wcf1_acl_simple_to_user WHERE objectTypeID = ? ) OR wcf1_page_content.pageID IN ( SELECT objectID FROM wcf1_acl_simple_to_group WHERE objectTypeID = ? AND groupID IN (?,?) UNION SELECT objectID FROM wcf1_acl_simple_to_user WHERE objectTypeID = ? AND userID = ? ) ) UNION ALL SELECT easyrating1_article.articleID AS objectID, easyrating1_article.title AS subject, easyrating1_article.time AS time, easyrating1_article.username AS username, 'com.cls.easyrating.article' AS objectType FROM easyrating1_article INNER JOIN (SELECT objectID , '0' AS relevance FROM easyrating1_article_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON easyrating1_article.articleID = search_index.objectID WHERE easyrating1_article.articleID IN ( SELECT articleID FROM easyrating1_article_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) AND easyrating1_article.isDisabled = 0 AND easyrating1_article.isDeleted = 0 ORDER BY time DESC LIMIT 1000'
Error Code: 42S22
File: /../community/lib/system/database/Database.class.php (332)
Extra Information: -
Stack Trace: [{"file":"\/..\/lib\/system\/search\/mysql\/MysqlSearchEngine.class.php","line":120,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["\n SELECT wbb1_post.postID AS objectID,\n wbb1_post.subject AS subject,\n wbb1_post.time AS time,\n wbb1_post.username AS username,\n 'com.woltlab.wbb.post' AS objectType\n \n FROM wbb1_post\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wbb1_post_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wbb1_post.postID = search_index.objectID\n \n LEFT JOIN wbb1_thread thread\n ON thread.threadID = wbb1_post.threadID\n WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0\nUNION ALL\n\n SELECT gallery1_image.imageID AS objectID,\n gallery1_image.title AS subject,\n gallery1_image.uploadTime AS time,\n gallery1_image.username AS username,\n 'com.woltlab.gallery.image' AS objectType\n \n FROM gallery1_image\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM gallery1_image_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON gallery1_image.imageID = search_index.objectID\n \n WHERE gallery1_image.imageID IN (\n SELECT imageID\n FROM gallery1_image_to_category\n WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ) AND gallery1_image.isDisabled = 0 AND gallery1_image.isDeleted = 0 AND gallery1_image.accessLevel = ?\nUNION ALL\n\n SELECT wcf1_article_content.articleContentID AS objectID,\n wcf1_article_content.title AS subject,\n wcf1_article.time AS time,\n wcf1_article.username AS username,\n 'com.woltlab.wcf.article' AS objectType\n \n FROM wcf1_article_content\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wcf1_article_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wcf1_article_content.articleContentID = search_index.objectID\n \n INNER JOIN wcf1_article\n ON wcf1_article.articleID = wcf1_article_content.articleID\n WHERE wcf1_article.categoryID IN (?,?,?,?,?,?,?) AND wcf1_article.publicationStatus = ?\nUNION ALL\n\n SELECT wcf1_page_content.pageContentID AS objectID,\n wcf1_page_content.title AS subject,\n wcf1_page_content.pageContentID AS time,\n '' AS username,\n 'com.woltlab.wcf.page' AS objectType\n \n FROM wcf1_page_content\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wcf1_page_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wcf1_page_content.pageContentID = search_index.objectID\n \n INNER JOIN wcf1_page\n ON wcf1_page.pageID = wcf1_page_content.pageID\n WHERE wcf1_page.pageType IN (?,?) AND wcf1_page.isDisabled = ? AND (wcf1_page_content.languageID IS NULL OR wcf1_page_content.languageID IN (?)) AND (\n wcf1_page_content.pageID NOT IN (\n SELECT objectID\n FROM wcf1_acl_simple_to_group\n WHERE objectTypeID = ?\n UNION\n SELECT objectID\n FROM wcf1_acl_simple_to_user\n WHERE objectTypeID = ?\n )\n OR\n wcf1_page_content.pageID IN (\n SELECT objectID\n FROM wcf1_acl_simple_to_group\n WHERE objectTypeID = ?\n AND groupID IN (?,?)\n UNION\n SELECT objectID\n FROM wcf1_acl_simple_to_user\n WHERE objectTypeID = ?\n AND userID = ?\n )\n )\nUNION ALL\n\n SELECT easyrating1_article.articleID AS objectID,\n easyrating1_article.title AS subject,\n easyrating1_article.time AS time,\n easyrating1_article.username AS username,\n 'com.cls.easyrating.article' AS objectType\n \n FROM easyrating1_article\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM easyrating1_article_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON easyrating1_article.articleID = search_index.objectID\n \n WHERE easyrating1_article.articleID IN (\n SELECT articleID\n FROM easyrating1_article_to_category\n WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ) AND easyrating1_article.isDisabled = 0 AND easyrating1_article.isDeleted = 0 ORDER BY time DESC LIMIT 1000",1000]},{"file":"\/..\/lib\/system\/search\/SearchEngine.class.php","line":144,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["Spice and wolf",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC",1000]},{"file":"\/..\/lib\/system\/search\/SearchHandler.class.php","line":341,"function":"searchWithContext","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["Spice and wolf",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]"},{"com.woltlab.wbb.post":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC"]},{"file":"\/..\/lib\/system\/search\/SearchHandler.class.php","line":93,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/..\/lib\/data\/search\/SearchAction.class.php","line":99,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/..\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXInvokeAction.class.php","line":110,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AbstractAction.class.php","line":56,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXInvokeAction.class.php","line":64,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/..\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/..\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/..\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/..\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'easyrating1_article.title' in 'field list'
Error Code: 42S22
File: /../community/lib/system/database/Database.class.php (326)
Extra Information: -
Stack Trace: [{"file":"\/..\/lib\/system\/database\/Database.class.php","line":326,"function":"prepare","class":"PDO","type":"->","args":["\n SELECT wbb1_post.postID AS objectID,\n wbb1_post.subject AS subject,\n wbb1_post.time AS time,\n wbb1_post.username AS username,\n 'com.woltlab.wbb.post' AS objectType\n \n FROM wbb1_post\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wbb1_post_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wbb1_post.postID = search_index.objectID\n \n LEFT JOIN wbb1_thread thread\n ON thread.threadID = wbb1_post.threadID\n WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0\nUNION ALL\n\n SELECT gallery1_image.imageID AS objectID,\n gallery1_image.title AS subject,\n gallery1_image.uploadTime AS time,\n gallery1_image.username AS username,\n 'com.woltlab.gallery.image' AS objectType\n \n FROM gallery1_image\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM gallery1_image_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON gallery1_image.imageID = search_index.objectID\n \n WHERE gallery1_image.imageID IN (\n SELECT imageID\n FROM gallery1_image_to_category\n WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ) AND gallery1_image.isDisabled = 0 AND gallery1_image.isDeleted = 0 AND gallery1_image.accessLevel = ?\nUNION ALL\n\n SELECT wcf1_article_content.articleContentID AS objectID,\n wcf1_article_content.title AS subject,\n wcf1_article.time AS time,\n wcf1_article.username AS username,\n 'com.woltlab.wcf.article' AS objectType\n \n FROM wcf1_article_content\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wcf1_article_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wcf1_article_content.articleContentID = search_index.objectID\n \n INNER JOIN wcf1_article\n ON wcf1_article.articleID = wcf1_article_content.articleID\n WHERE wcf1_article.categoryID IN (?,?,?,?,?,?,?) AND wcf1_article.publicationStatus = ?\nUNION ALL\n\n SELECT wcf1_page_content.pageContentID AS objectID,\n wcf1_page_content.title AS subject,\n wcf1_page_content.pageContentID AS time,\n '' AS username,\n 'com.woltlab.wcf.page' AS objectType\n \n FROM wcf1_page_content\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wcf1_page_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wcf1_page_content.pageContentID = search_index.objectID\n \n INNER JOIN wcf1_page\n ON wcf1_page.pageID = wcf1_page_content.pageID\n WHERE wcf1_page.pageType IN (?,?) AND wcf1_page.isDisabled = ? AND (wcf1_page_content.languageID IS NULL OR wcf1_page_content.languageID IN (?)) AND (\n wcf1_page_content.pageID NOT IN (\n SELECT objectID\n FROM wcf1_acl_simple_to_group\n WHERE objectTypeID = ?\n UNION\n SELECT objectID\n FROM wcf1_acl_simple_to_user\n WHERE objectTypeID = ?\n )\n OR\n wcf1_page_content.pageID IN (\n SELECT objectID\n FROM wcf1_acl_simple_to_group\n WHERE objectTypeID = ?\n AND groupID IN (?,?)\n UNION\n SELECT objectID\n FROM wcf1_acl_simple_to_user\n WHERE objectTypeID = ?\n AND userID = ?\n )\n )\nUNION ALL\n\n SELECT easyrating1_article.articleID AS objectID,\n easyrating1_article.title AS subject,\n easyrating1_article.time AS time,\n easyrating1_article.username AS username,\n 'com.cls.easyrating.article' AS objectType\n \n FROM easyrating1_article\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM easyrating1_article_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON easyrating1_article.articleID = search_index.objectID\n \n WHERE easyrating1_article.articleID IN (\n SELECT articleID\n FROM easyrating1_article_to_category\n WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ) AND easyrating1_article.isDisabled = 0 AND easyrating1_article.isDeleted = 0 ORDER BY time DESC LIMIT 1000 -- '\/index.php?ajax-proxy\/&t=0f32f4acb7443bd50fd715615da0aa23187463fdfb6cbeabe01e91bbe8dbdd8c- (wcf\\\\data\\\\search\\\\SearchAction:search)'"]},{"file":"\/..\/lib\/system\/search\/mysql\/MysqlSearchEngine.class.php","line":120,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["\n SELECT wbb1_post.postID AS objectID,\n wbb1_post.subject AS subject,\n wbb1_post.time AS time,\n wbb1_post.username AS username,\n 'com.woltlab.wbb.post' AS objectType\n \n FROM wbb1_post\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wbb1_post_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wbb1_post.postID = search_index.objectID\n \n LEFT JOIN wbb1_thread thread\n ON thread.threadID = wbb1_post.threadID\n WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0\nUNION ALL\n\n SELECT gallery1_image.imageID AS objectID,\n gallery1_image.title AS subject,\n gallery1_image.uploadTime AS time,\n gallery1_image.username AS username,\n 'com.woltlab.gallery.image' AS objectType\n \n FROM gallery1_image\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM gallery1_image_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON gallery1_image.imageID = search_index.objectID\n \n WHERE gallery1_image.imageID IN (\n SELECT imageID\n FROM gallery1_image_to_category\n WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ) AND gallery1_image.isDisabled = 0 AND gallery1_image.isDeleted = 0 AND gallery1_image.accessLevel = ?\nUNION ALL\n\n SELECT wcf1_article_content.articleContentID AS objectID,\n wcf1_article_content.title AS subject,\n wcf1_article.time AS time,\n wcf1_article.username AS username,\n 'com.woltlab.wcf.article' AS objectType\n \n FROM wcf1_article_content\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wcf1_article_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wcf1_article_content.articleContentID = search_index.objectID\n \n INNER JOIN wcf1_article\n ON wcf1_article.articleID = wcf1_article_content.articleID\n WHERE wcf1_article.categoryID IN (?,?,?,?,?,?,?) AND wcf1_article.publicationStatus = ?\nUNION ALL\n\n SELECT wcf1_page_content.pageContentID AS objectID,\n wcf1_page_content.title AS subject,\n wcf1_page_content.pageContentID AS time,\n '' AS username,\n 'com.woltlab.wcf.page' AS objectType\n \n FROM wcf1_page_content\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM wcf1_page_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON wcf1_page_content.pageContentID = search_index.objectID\n \n INNER JOIN wcf1_page\n ON wcf1_page.pageID = wcf1_page_content.pageID\n WHERE wcf1_page.pageType IN (?,?) AND wcf1_page.isDisabled = ? AND (wcf1_page_content.languageID IS NULL OR wcf1_page_content.languageID IN (?)) AND (\n wcf1_page_content.pageID NOT IN (\n SELECT objectID\n FROM wcf1_acl_simple_to_group\n WHERE objectTypeID = ?\n UNION\n SELECT objectID\n FROM wcf1_acl_simple_to_user\n WHERE objectTypeID = ?\n )\n OR\n wcf1_page_content.pageID IN (\n SELECT objectID\n FROM wcf1_acl_simple_to_group\n WHERE objectTypeID = ?\n AND groupID IN (?,?)\n UNION\n SELECT objectID\n FROM wcf1_acl_simple_to_user\n WHERE objectTypeID = ?\n AND userID = ?\n )\n )\nUNION ALL\n\n SELECT easyrating1_article.articleID AS objectID,\n easyrating1_article.title AS subject,\n easyrating1_article.time AS time,\n easyrating1_article.username AS username,\n 'com.cls.easyrating.article' AS objectType\n \n FROM easyrating1_article\n INNER JOIN (SELECT objectID\n , '0' AS relevance\n FROM easyrating1_article_search_index\n WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n \n \n LIMIT 2500) search_index\n ON easyrating1_article.articleID = search_index.objectID\n \n WHERE easyrating1_article.articleID IN (\n SELECT articleID\n FROM easyrating1_article_to_category\n WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ) AND easyrating1_article.isDisabled = 0 AND easyrating1_article.isDeleted = 0 ORDER BY time DESC LIMIT 1000",1000]},{"file":"\/..\/lib\/system\/search\/SearchEngine.class.php","line":144,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["Spice and wolf",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC",1000]},{"file":"\/..\/lib\/system\/search\/SearchHandler.class.php","line":341,"function":"searchWithContext","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["Spice and wolf",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]"},{"com.woltlab.wbb.post":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC"]},{"file":"\/..\/lib\/system\/search\/SearchHandler.class.php","line":93,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/..\/lib\/data\/search\/SearchAction.class.php","line":99,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/..\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXInvokeAction.class.php","line":110,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AbstractAction.class.php","line":56,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/..\/lib\/action\/AJAXInvokeAction.class.php","line":64,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/..\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/..\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/..\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/..\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
