Beiträge von Dragosius

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"]}]