Fehlermeldung in der Suche

Nico25

Ich kann keine Suche mehr ausführen. Ich erhalte folgenden Fehler.

Aufgerufene URL: POST /index.php?ajax-proxy/&t=9e7cc53b01c0d5a4fdceee1ea64f275718ead419619de41c33537ff534be04e2-6q6cZdMwk769xH6Mtw7pCw==

Referrer: https://www.meinedomain.de/index.php?search/&q=bild&sortField=time&sortOrder=DESC

WoltLab Suite: 6.0.16

PHP: 8.2.21

Fehlermeldung: MySQL search query failed.

Art: wcf\system\search\exception\SearchFailed

Datei (Zeile): /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/mysql/MysqlSearchEngine.class.php (129)

Stacktrace

/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchEngine.class.php (144): wcf\system\search\mysql\MysqlSearchEngine->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (341): wcf\system\search\SearchEngine->searchWithContext(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (93): wcf\system\search\SearchHandler->loadResults(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/data/search/SearchAction.class.php (99): wcf\system\search\SearchHandler->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (215): wcf\data\search\SearchAction->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (110): wcf\action\AJAXProxyAction->invoke(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AbstractAction.class.php (56): wcf\action\AJAXInvokeAction->execute(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (64): wcf\action\AbstractAction->__run(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/Request.class.php (57): wcf\action\AJAXInvokeAction->__run(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/http/middleware/HandleValinorMappingErrors.class.php (35): wcf\system\request\Request->handle(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/RequestHandler.class.php (147): wcf\http\Pipeline->process(…)
/var/www/vhosts/meinedomain.de/httpdocs/index.php (10): wcf\system\request\RequestHandler->handle(…)

Fehlermeldung: Could not prepare statement ' 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 easymedia1_video.videoID AS objectID, easymedia1_video.title AS subject, easymedia1_video.uploadTime AS time, easymedia1_video.username AS username, 'com.cls.easymedia.video' AS objectType FROM easymedia1_video INNER JOIN (SELECT objectID , '0' AS relevance FROM easymedia1_video_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON easymedia1_video.videoID = search_index.objectID WHERE easymedia1_video.videoID IN ( SELECT videoID FROM easymedia1_video_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) AND easymedia1_video.isDisabled = 0 AND easymedia1_video.isDeleted = 0 UNION ALL SELECT easymedia1_image.imageID AS objectID, easymedia1_image.title AS subject, easymedia1_image.uploadTime AS time, easymedia1_image.username AS username, 'com.cls.easymedia.image' AS objectType FROM easymedia1_image INNER JOIN (SELECT objectID , '0' AS relevance FROM easymedia1_image_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON easymedia1_image.imageID = search_index.objectID WHERE easymedia1_image.imageID IN ( SELECT imageID FROM easymedia1_image_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) AND easymedia1_image.isDisabled = 0 AND easymedia1_image.isDeleted = 0 UNION ALL SELECT wcf1_conversation_message.messageID AS objectID, conversation.subject AS subject, wcf1_conversation_message.time AS time, wcf1_conversation_message.username AS username, 'com.woltlab.wcf.conversation.message' AS objectType FROM wcf1_conversation_message INNER JOIN (SELECT objectID , '0' AS relevance FROM wcf1_conversation_message_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON wcf1_conversation_message.messageID = search_index.objectID JOIN wcf1_conversation_to_user conversation_to_user ON conversation_to_user.participantID = 1 AND conversation_to_user.conversationID = wcf1_conversation_message.conversationID LEFT JOIN wcf1_conversation conversation ON conversation.conversationID = wcf1_conversation_message.conversationID WHERE conversation_to_user.hideConversation IN (0,1) UNION ALL 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 LEFT JOIN wbb1_thread_user_status thread_user_status ON thread_user_status.threadID = wbb1_post.threadID AND thread_user_status.userID = 1 WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0 AND (thread_user_status.status <> ? OR thread_user_status.status IS NULL) UNION ALL SELECT shop1_product.productID AS objectID, shop1_product.title AS subject, 0 AS time, 'System' AS username, 'com.viecode.shop.product' AS objectType FROM shop1_product INNER JOIN (SELECT objectID , '0' AS relevance FROM shop1_product_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON shop1_product.productID = search_index.objectID WHERE (shop1_product.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR shop1_product.productID IN (SELECT productID FROM shop1_product_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))) AND shop1_product.isDisabled = 0 AND shop1_product.isDeleted = 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 IN (?, ?) OR (gallery1_image.accessLevel IN (?, ?) AND gallery1_image.userID = ?) OR gallery1_image.accessLevel = ?) UNION ALL SELECT lexicon1_entry.entryID AS objectID, lexicon1_entry.subject AS subject, lexicon1_entry.time AS time, lexicon1_entry.username AS username, 'com.viecode.lexicon.entry' AS objectType FROM lexicon1_entry INNER JOIN (SELECT objectID , '0' AS relevance FROM wcf1_search_index_ab405c95 WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON lexicon1_entry.entryID = search_index.objectID WHERE lexicon1_entry.entryID IN ( SELECT entryID FROM lexicon1_entry_to_category WHERE categoryID IN (?,?,?) ) AND lexicon1_entry.isDeleted = 0 AND lexicon1_entry.isDisabled = 0 UNION ALL SELECT news1_news.newsID AS objectID, IF(news1_news.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news.subject) AS subject, news1_news.time AS time, news1_news.username AS username, 'de.wbb-elite.news.search' AS objectType FROM news1_news INNER JOIN (SELECT objectID , '0' AS relevance FROM news1_news_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON news1_news.newsID = search_index.objectID LEFT JOIN news1_language_to_content newsLanguageContent ON(newsLanguageContent.newsID = news1_news.newsID) LEFT JOIN wcf1_language_item language_item ON(language_item.languageItemID = newsLanguageContent.languageItemID) WHERE news1_news.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news.isDisabled = 0 AND news1_news.isDeleted = 0 UNION ALL SELECT news1_news_update.updateID AS objectID, IF(news1_news_update.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news_update.subject) AS subject, news1_news_update.time AS time, news1_news_update.username AS username, 'de.wbb-elite.news.update.search' AS objectType FROM news1_news_update INNER JOIN (SELECT objectID , '0' AS relevance FROM news1_news_update_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) LIMIT 2500) search_index ON news1_news_update.updateID = search_index.objectID LEFT JOIN news1_update_language_to_content newsLanguageContent ON(newsLanguageContent.updateID = news1_news_update.updateID) LEFT JOIN wcf1_language_item language_item ON(language_item.languageItemID = newsLanguageContent.languageItemID) WHERE news1_news_update.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news_update.isDisabled = 0 AND news1_news_update.isDeleted = 0 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'

Art: wcf\system\database\exception\DatabaseQueryException

Datei (Zeile): /var/www/vhosts/meinedomain.de/httpdocs/lib/system/database/Database.class.php (332)

Stacktrace

/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/mysql/MysqlSearchEngine.class.php (120): wcf\system\database\Database->prepareStatement(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchEngine.class.php (144): wcf\system\search\mysql\MysqlSearchEngine->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (341): wcf\system\search\SearchEngine->searchWithContext(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (93): wcf\system\search\SearchHandler->loadResults(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/data/search/SearchAction.class.php (99): wcf\system\search\SearchHandler->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (215): wcf\data\search\SearchAction->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (110): wcf\action\AJAXProxyAction->invoke(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AbstractAction.class.php (56): wcf\action\AJAXInvokeAction->execute(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (64): wcf\action\AbstractAction->__run(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/Request.class.php (57): wcf\action\AJAXInvokeAction->__run(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/http/middleware/HandleValinorMappingErrors.class.php (35): wcf\system\request\Request->handle(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/RequestHandler.class.php (147): wcf\http\Pipeline->process(…)
/var/www/vhosts/meinedomain.de/httpdocs/index.php (10): wcf\system\request\RequestHandler->handle(…)

Fehlermeldung: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'easyrating1_article.title' in 'field list'

Art: PDOException

Datei (Zeile): /var/www/vhosts/meinedomain.de/httpdocs/lib/system/database/Database.class.php (326)

Stacktrace

/var/www/vhosts/meinedomain.de/httpdocs/lib/system/database/Database.class.php (326): PDO->prepare(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/mysql/MysqlSearchEngine.class.php (120): wcf\system\database\Database->prepareStatement(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchEngine.class.php (144): wcf\system\search\mysql\MysqlSearchEngine->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (341): wcf\system\search\SearchEngine->searchWithContext(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (93): wcf\system\search\SearchHandler->loadResults(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/data/search/SearchAction.class.php (99): wcf\system\search\SearchHandler->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (215): wcf\data\search\SearchAction->search(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (110): wcf\action\AJAXProxyAction->invoke(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AbstractAction.class.php (56): wcf\action\AJAXInvokeAction->execute(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (64): wcf\action\AbstractAction->__run(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/Request.class.php (57): wcf\action\AJAXInvokeAction->__run(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/http/middleware/HandleValinorMappingErrors.class.php (35): wcf\system\request\Request->handle(…)
/var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/RequestHandler.class.php (147): wcf\http\Pipeline->process(…)
/var/www/vhosts/meinedomain.de/httpdocs/index.php (10): wcf\system\request\RequestHandler->handle(…)

Tue, 09 Jul 2024 10:02:20 +0000
Message: MySQL search query failed.
PHP version: 8.2.21
WoltLab Suite version: 6.0.16
Request URI: POST /index.php?ajax-proxy/&t=9e7cc53b01c0d5a4fdceee1ea64f275718ead419619de41c33537ff534be04e2-6q6cZdMwk769xH6Mtw7pCw==
Referrer: https://www.meinedomain.de/index.php?search/&q=bild&sortField=time&sortOrder=DESC
User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:127.0) Gecko/20100101 Firefox/127.0
Peak Memory Usage: 6006640/4294967296
======
Error Class: wcf\system\search\exception\SearchFailed
Error Message: MySQL search query failed.
Error Code: 0
File: /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/mysql/MysqlSearchEngine.class.php (129)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchEngine.class.php","line":144,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["bild",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easymedia.video":"[redacted]","com.cls.easymedia.image":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.viecode.shop.product":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.viecode.lexicon.entry":"[redacted]","de.wbb-elite.news.search":"[redacted]","de.wbb-elite.news.update.search":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC",1000]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchHandler.class.php","line":341,"function":"searchWithContext","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["bild",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]","com.viecode.lexicon.entry":"[redacted]"},{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easymedia.video":"[redacted]","com.cls.easymedia.image":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.viecode.shop.product":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.viecode.lexicon.entry":"[redacted]","de.wbb-elite.news.search":"[redacted]","de.wbb-elite.news.update.search":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchHandler.class.php","line":93,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/data\/search\/SearchAction.class.php","line":99,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":110,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AbstractAction.class.php","line":56,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":64,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/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      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      easymedia1_video.videoID AS objectID,                                 easymedia1_video.title AS subject,                                 easymedia1_video.uploadTime AS time,                                 easymedia1_video.username AS username,                                 'com.cls.easymedia.video' AS objectType                                                      FROM        easymedia1_video                     INNER JOIN  (SELECT  objectID                         , '0' AS relevance                 FROM    easymedia1_video_search_index                 WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)                                                   LIMIT   2500) search_index                     ON          easymedia1_video.videoID = search_index.objectID                                          WHERE easymedia1_video.videoID IN (                     SELECT  videoID                     FROM    easymedia1_video_to_category                     WHERE   categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)             ) AND easymedia1_video.isDisabled = 0 AND easymedia1_video.isDeleted = 0 UNION ALL                      SELECT      easymedia1_image.imageID AS objectID,                                 easymedia1_image.title AS subject,                                 easymedia1_image.uploadTime AS time,                                 easymedia1_image.username AS username,                                 'com.cls.easymedia.image' AS objectType                                                      FROM        easymedia1_image                     INNER JOIN  (SELECT  objectID                         , '0' AS relevance                 FROM    easymedia1_image_search_index                 WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)                                                   LIMIT   2500) search_index                     ON          easymedia1_image.imageID = search_index.objectID                                          WHERE easymedia1_image.imageID IN (                     SELECT  imageID                     FROM    easymedia1_image_to_category                     WHERE   categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)             ) AND easymedia1_image.isDisabled = 0 AND easymedia1_image.isDeleted = 0 UNION ALL                      SELECT      wcf1_conversation_message.messageID AS objectID,                                 conversation.subject AS subject,                                 wcf1_conversation_message.time AS time,                                 wcf1_conversation_message.username AS username,                                 'com.woltlab.wcf.conversation.message' AS objectType                                                      FROM        wcf1_conversation_message                     INNER JOIN  (SELECT  objectID                         , '0' AS relevance                 FROM    wcf1_conversation_message_search_index                 WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)                                                   LIMIT   2500) search_index                     ON          wcf1_conversation_message.messageID = search_index.objectID                         JOIN        wcf1_conversation_to_user conversation_to_user                     ON          conversation_to_user.participantID = 1                             AND conversation_to_user.conversationID = wcf1_conversation_message.conversationID                     LEFT JOIN   wcf1_conversation conversation                     ON          conversation.conversationID = wcf1_conversation_message.conversationID                     WHERE conversation_to_user.hideConversation IN (0,1) UNION ALL                      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                 LEFT JOIN   wbb1_thread_user_status thread_user_status                 ON          thread_user_status.threadID = wbb1_post.threadID                             AND thread_user_status.userID = 1                     WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0 AND (thread_user_status.status <> ? OR thread_user_status.status IS NULL) UNION ALL                      SELECT      shop1_product.productID AS objectID,                                 shop1_product.title AS subject,                                 0 AS time,                                 'System' AS username,                                 'com.viecode.shop.product' AS objectType                                                      FROM        shop1_product                     INNER JOIN  (SELECT  objectID                         , '0' AS relevance                 FROM    shop1_product_search_index                 WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)                                                   LIMIT   2500) search_index                     ON          shop1_product.productID = search_index.objectID                                          WHERE (shop1_product.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR shop1_product.productID IN (SELECT productID FROM shop1_product_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))) AND shop1_product.isDisabled = 0 AND shop1_product.isDeleted = 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 IN (?, ?) OR (gallery1_image.accessLevel IN (?, ?) AND gallery1_image.userID = ?) OR gallery1_image.accessLevel = ?) UNION ALL                      SELECT      lexicon1_entry.entryID AS objectID,                                 lexicon1_entry.subject AS subject,                                 lexicon1_entry.time AS time,                                 lexicon1_entry.username AS username,                                 'com.viecode.lexicon.entry' AS objectType                                                      FROM        lexicon1_entry                     INNER JOIN  (SELECT  objectID                         , '0' AS relevance                 FROM    wcf1_search_index_ab405c95                 WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)                                                   LIMIT   2500) search_index                     ON          lexicon1_entry.entryID = search_index.objectID                                          WHERE lexicon1_entry.entryID IN ( 					SELECT entryID 					FROM lexicon1_entry_to_category 					WHERE categoryID IN (?,?,?) 				) AND lexicon1_entry.isDeleted = 0 AND lexicon1_entry.isDisabled = 0 UNION ALL                      SELECT      news1_news.newsID AS objectID,                                  IF(news1_news.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news.subject) AS subject,                                 news1_news.time AS time,                                 news1_news.username AS username,                                 'de.wbb-elite.news.search' AS objectType                                                      FROM        news1_news                     INNER JOIN  (SELECT  objectID                         , '0' AS relevance                 FROM    news1_news_search_index                 WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)                                                   LIMIT   2500) search_index                     ON          news1_news.newsID = search_index.objectID                      LEFT JOIN news1_language_to_content newsLanguageContent  		ON(newsLanguageContent.newsID = news1_news.newsID) 		  LEFT JOIN wcf1_language_item language_item  		  ON(language_item.languageItemID = newsLanguageContent.languageItemID)                     WHERE news1_news.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news.isDisabled = 0 AND news1_news.isDeleted = 0 UNION ALL                      SELECT      news1_news_update.updateID AS objectID,                                  IF(news1_news_update.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news_update.subject) AS subject,                                 news1_news_update.time AS time,                                 news1_news_update.username AS username,                                 'de.wbb-elite.news.update.search' AS objectType                                                      FROM        news1_news_update                     INNER JOIN  (SELECT  objectID                         , '0' AS relevance                 FROM    news1_news_update_search_index                 WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)                                                   LIMIT   2500) search_index                     ON          news1_news_update.updateID = search_index.objectID                      LEFT JOIN news1_update_language_to_content newsLanguageContent  		ON(newsLanguageContent.updateID = news1_news_update.updateID) 		  LEFT JOIN wcf1_language_item language_item  		  ON(language_item.languageItemID = newsLanguageContent.languageItemID)                     WHERE news1_news_update.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news_update.isDisabled = 0 AND news1_news_update.isDeleted = 0 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: /var/www/vhosts/meinedomain.de/httpdocs/lib/system/database/Database.class.php (332)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/mysql\/MysqlSearchEngine.class.php","line":120,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["\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      easymedia1_video.videoID AS objectID,\n                                easymedia1_video.title AS subject,\n                                easymedia1_video.uploadTime AS time,\n                                easymedia1_video.username AS username,\n                                'com.cls.easymedia.video' AS objectType\n                                \n                    FROM        easymedia1_video\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    easymedia1_video_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          easymedia1_video.videoID = search_index.objectID\n                    \n                    WHERE easymedia1_video.videoID IN (\n                    SELECT  videoID\n                    FROM    easymedia1_video_to_category\n                    WHERE   categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n            ) AND easymedia1_video.isDisabled = 0 AND easymedia1_video.isDeleted = 0\nUNION ALL\n\n                    SELECT      easymedia1_image.imageID AS objectID,\n                                easymedia1_image.title AS subject,\n                                easymedia1_image.uploadTime AS time,\n                                easymedia1_image.username AS username,\n                                'com.cls.easymedia.image' AS objectType\n                                \n                    FROM        easymedia1_image\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    easymedia1_image_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          easymedia1_image.imageID = search_index.objectID\n                    \n                    WHERE easymedia1_image.imageID IN (\n                    SELECT  imageID\n                    FROM    easymedia1_image_to_category\n                    WHERE   categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n            ) AND easymedia1_image.isDisabled = 0 AND easymedia1_image.isDeleted = 0\nUNION ALL\n\n                    SELECT      wcf1_conversation_message.messageID AS objectID,\n                                conversation.subject AS subject,\n                                wcf1_conversation_message.time AS time,\n                                wcf1_conversation_message.username AS username,\n                                'com.woltlab.wcf.conversation.message' AS objectType\n                                \n                    FROM        wcf1_conversation_message\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    wcf1_conversation_message_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          wcf1_conversation_message.messageID = search_index.objectID\n                        JOIN        wcf1_conversation_to_user conversation_to_user\n                    ON          conversation_to_user.participantID = 1\n                            AND conversation_to_user.conversationID = wcf1_conversation_message.conversationID\n                    LEFT JOIN   wcf1_conversation conversation\n                    ON          conversation.conversationID = wcf1_conversation_message.conversationID\n                    WHERE conversation_to_user.hideConversation IN (0,1)\nUNION ALL\n\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                LEFT JOIN   wbb1_thread_user_status thread_user_status\n                ON          thread_user_status.threadID = wbb1_post.threadID\n                            AND thread_user_status.userID = 1\n                    WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0 AND (thread_user_status.status <> ? OR thread_user_status.status IS NULL)\nUNION ALL\n\n                    SELECT      shop1_product.productID AS objectID,\n                                shop1_product.title AS subject,\n                                0 AS time,\n                                'System' AS username,\n                                'com.viecode.shop.product' AS objectType\n                                \n                    FROM        shop1_product\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    shop1_product_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          shop1_product.productID = search_index.objectID\n                    \n                    WHERE (shop1_product.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR shop1_product.productID IN (SELECT productID FROM shop1_product_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))) AND shop1_product.isDisabled = 0 AND shop1_product.isDeleted = 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 IN (?, ?) OR (gallery1_image.accessLevel IN (?, ?) AND gallery1_image.userID = ?) OR gallery1_image.accessLevel = ?)\nUNION ALL\n\n                    SELECT      lexicon1_entry.entryID AS objectID,\n                                lexicon1_entry.subject AS subject,\n                                lexicon1_entry.time AS time,\n                                lexicon1_entry.username AS username,\n                                'com.viecode.lexicon.entry' AS objectType\n                                \n                    FROM        lexicon1_entry\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    wcf1_search_index_ab405c95\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          lexicon1_entry.entryID = search_index.objectID\n                    \n                    WHERE lexicon1_entry.entryID IN (\n\t\t\t\t\tSELECT entryID\n\t\t\t\t\tFROM lexicon1_entry_to_category\n\t\t\t\t\tWHERE categoryID IN (?,?,?)\n\t\t\t\t) AND lexicon1_entry.isDeleted = 0 AND lexicon1_entry.isDisabled = 0\nUNION ALL\n\n                    SELECT      news1_news.newsID AS objectID,\n                                 IF(news1_news.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news.subject) AS subject,\n                                news1_news.time AS time,\n                                news1_news.username AS username,\n                                'de.wbb-elite.news.search' AS objectType\n                                \n                    FROM        news1_news\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    news1_news_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          news1_news.newsID = search_index.objectID\n                     LEFT JOIN news1_language_to_content newsLanguageContent \n\t\tON(newsLanguageContent.newsID = news1_news.newsID)\n\t\t  LEFT JOIN wcf1_language_item language_item \n\t\t  ON(language_item.languageItemID = newsLanguageContent.languageItemID)\n                    WHERE news1_news.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news.isDisabled = 0 AND news1_news.isDeleted = 0\nUNION ALL\n\n                    SELECT      news1_news_update.updateID AS objectID,\n                                 IF(news1_news_update.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news_update.subject) AS subject,\n                                news1_news_update.time AS time,\n                                news1_news_update.username AS username,\n                                'de.wbb-elite.news.update.search' AS objectType\n                                \n                    FROM        news1_news_update\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    news1_news_update_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          news1_news_update.updateID = search_index.objectID\n                     LEFT JOIN news1_update_language_to_content newsLanguageContent \n\t\tON(newsLanguageContent.updateID = news1_news_update.updateID)\n\t\t  LEFT JOIN wcf1_language_item language_item \n\t\t  ON(language_item.languageItemID = newsLanguageContent.languageItemID)\n                    WHERE news1_news_update.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news_update.isDisabled = 0 AND news1_news_update.isDeleted = 0\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":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchEngine.class.php","line":144,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["bild",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easymedia.video":"[redacted]","com.cls.easymedia.image":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.viecode.shop.product":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.viecode.lexicon.entry":"[redacted]","de.wbb-elite.news.search":"[redacted]","de.wbb-elite.news.update.search":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC",1000]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchHandler.class.php","line":341,"function":"searchWithContext","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["bild",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]","com.viecode.lexicon.entry":"[redacted]"},{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easymedia.video":"[redacted]","com.cls.easymedia.image":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.viecode.shop.product":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.viecode.lexicon.entry":"[redacted]","de.wbb-elite.news.search":"[redacted]","de.wbb-elite.news.update.search":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchHandler.class.php","line":93,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/data\/search\/SearchAction.class.php","line":99,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":110,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AbstractAction.class.php","line":56,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":64,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/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: /var/www/vhosts/meinedomain.de/httpdocs/lib/system/database/Database.class.php (326)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/database\/Database.class.php","line":326,"function":"prepare","class":"PDO","type":"->","args":["\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      easymedia1_video.videoID AS objectID,\n                                easymedia1_video.title AS subject,\n                                easymedia1_video.uploadTime AS time,\n                                easymedia1_video.username AS username,\n                                'com.cls.easymedia.video' AS objectType\n                                \n                    FROM        easymedia1_video\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    easymedia1_video_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          easymedia1_video.videoID = search_index.objectID\n                    \n                    WHERE easymedia1_video.videoID IN (\n                    SELECT  videoID\n                    FROM    easymedia1_video_to_category\n                    WHERE   categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n            ) AND easymedia1_video.isDisabled = 0 AND easymedia1_video.isDeleted = 0\nUNION ALL\n\n                    SELECT      easymedia1_image.imageID AS objectID,\n                                easymedia1_image.title AS subject,\n                                easymedia1_image.uploadTime AS time,\n                                easymedia1_image.username AS username,\n                                'com.cls.easymedia.image' AS objectType\n                                \n                    FROM        easymedia1_image\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    easymedia1_image_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          easymedia1_image.imageID = search_index.objectID\n                    \n                    WHERE easymedia1_image.imageID IN (\n                    SELECT  imageID\n                    FROM    easymedia1_image_to_category\n                    WHERE   categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n            ) AND easymedia1_image.isDisabled = 0 AND easymedia1_image.isDeleted = 0\nUNION ALL\n\n                    SELECT      wcf1_conversation_message.messageID AS objectID,\n                                conversation.subject AS subject,\n                                wcf1_conversation_message.time AS time,\n                                wcf1_conversation_message.username AS username,\n                                'com.woltlab.wcf.conversation.message' AS objectType\n                                \n                    FROM        wcf1_conversation_message\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    wcf1_conversation_message_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          wcf1_conversation_message.messageID = search_index.objectID\n                        JOIN        wcf1_conversation_to_user conversation_to_user\n                    ON          conversation_to_user.participantID = 1\n                            AND conversation_to_user.conversationID = wcf1_conversation_message.conversationID\n                    LEFT JOIN   wcf1_conversation conversation\n                    ON          conversation.conversationID = wcf1_conversation_message.conversationID\n                    WHERE conversation_to_user.hideConversation IN (0,1)\nUNION ALL\n\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                LEFT JOIN   wbb1_thread_user_status thread_user_status\n                ON          thread_user_status.threadID = wbb1_post.threadID\n                            AND thread_user_status.userID = 1\n                    WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0 AND (thread_user_status.status <> ? OR thread_user_status.status IS NULL)\nUNION ALL\n\n                    SELECT      shop1_product.productID AS objectID,\n                                shop1_product.title AS subject,\n                                0 AS time,\n                                'System' AS username,\n                                'com.viecode.shop.product' AS objectType\n                                \n                    FROM        shop1_product\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    shop1_product_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          shop1_product.productID = search_index.objectID\n                    \n                    WHERE (shop1_product.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR shop1_product.productID IN (SELECT productID FROM shop1_product_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))) AND shop1_product.isDisabled = 0 AND shop1_product.isDeleted = 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 IN (?, ?) OR (gallery1_image.accessLevel IN (?, ?) AND gallery1_image.userID = ?) OR gallery1_image.accessLevel = ?)\nUNION ALL\n\n                    SELECT      lexicon1_entry.entryID AS objectID,\n                                lexicon1_entry.subject AS subject,\n                                lexicon1_entry.time AS time,\n                                lexicon1_entry.username AS username,\n                                'com.viecode.lexicon.entry' AS objectType\n                                \n                    FROM        lexicon1_entry\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    wcf1_search_index_ab405c95\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          lexicon1_entry.entryID = search_index.objectID\n                    \n                    WHERE lexicon1_entry.entryID IN (\n\t\t\t\t\tSELECT entryID\n\t\t\t\t\tFROM lexicon1_entry_to_category\n\t\t\t\t\tWHERE categoryID IN (?,?,?)\n\t\t\t\t) AND lexicon1_entry.isDeleted = 0 AND lexicon1_entry.isDisabled = 0\nUNION ALL\n\n                    SELECT      news1_news.newsID AS objectID,\n                                 IF(news1_news.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news.subject) AS subject,\n                                news1_news.time AS time,\n                                news1_news.username AS username,\n                                'de.wbb-elite.news.search' AS objectType\n                                \n                    FROM        news1_news\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    news1_news_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          news1_news.newsID = search_index.objectID\n                     LEFT JOIN news1_language_to_content newsLanguageContent \n\t\tON(newsLanguageContent.newsID = news1_news.newsID)\n\t\t  LEFT JOIN wcf1_language_item language_item \n\t\t  ON(language_item.languageItemID = newsLanguageContent.languageItemID)\n                    WHERE news1_news.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news.isDisabled = 0 AND news1_news.isDeleted = 0\nUNION ALL\n\n                    SELECT      news1_news_update.updateID AS objectID,\n                                 IF(news1_news_update.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news_update.subject) AS subject,\n                                news1_news_update.time AS time,\n                                news1_news_update.username AS username,\n                                'de.wbb-elite.news.update.search' AS objectType\n                                \n                    FROM        news1_news_update\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    news1_news_update_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          news1_news_update.updateID = search_index.objectID\n                     LEFT JOIN news1_update_language_to_content newsLanguageContent \n\t\tON(newsLanguageContent.updateID = news1_news_update.updateID)\n\t\t  LEFT JOIN wcf1_language_item language_item \n\t\t  ON(language_item.languageItemID = newsLanguageContent.languageItemID)\n                    WHERE news1_news_update.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news_update.isDisabled = 0 AND news1_news_update.isDeleted = 0\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"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/mysql\/MysqlSearchEngine.class.php","line":120,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["\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      easymedia1_video.videoID AS objectID,\n                                easymedia1_video.title AS subject,\n                                easymedia1_video.uploadTime AS time,\n                                easymedia1_video.username AS username,\n                                'com.cls.easymedia.video' AS objectType\n                                \n                    FROM        easymedia1_video\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    easymedia1_video_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          easymedia1_video.videoID = search_index.objectID\n                    \n                    WHERE easymedia1_video.videoID IN (\n                    SELECT  videoID\n                    FROM    easymedia1_video_to_category\n                    WHERE   categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n            ) AND easymedia1_video.isDisabled = 0 AND easymedia1_video.isDeleted = 0\nUNION ALL\n\n                    SELECT      easymedia1_image.imageID AS objectID,\n                                easymedia1_image.title AS subject,\n                                easymedia1_image.uploadTime AS time,\n                                easymedia1_image.username AS username,\n                                'com.cls.easymedia.image' AS objectType\n                                \n                    FROM        easymedia1_image\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    easymedia1_image_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          easymedia1_image.imageID = search_index.objectID\n                    \n                    WHERE easymedia1_image.imageID IN (\n                    SELECT  imageID\n                    FROM    easymedia1_image_to_category\n                    WHERE   categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n            ) AND easymedia1_image.isDisabled = 0 AND easymedia1_image.isDeleted = 0\nUNION ALL\n\n                    SELECT      wcf1_conversation_message.messageID AS objectID,\n                                conversation.subject AS subject,\n                                wcf1_conversation_message.time AS time,\n                                wcf1_conversation_message.username AS username,\n                                'com.woltlab.wcf.conversation.message' AS objectType\n                                \n                    FROM        wcf1_conversation_message\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    wcf1_conversation_message_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          wcf1_conversation_message.messageID = search_index.objectID\n                        JOIN        wcf1_conversation_to_user conversation_to_user\n                    ON          conversation_to_user.participantID = 1\n                            AND conversation_to_user.conversationID = wcf1_conversation_message.conversationID\n                    LEFT JOIN   wcf1_conversation conversation\n                    ON          conversation.conversationID = wcf1_conversation_message.conversationID\n                    WHERE conversation_to_user.hideConversation IN (0,1)\nUNION ALL\n\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                LEFT JOIN   wbb1_thread_user_status thread_user_status\n                ON          thread_user_status.threadID = wbb1_post.threadID\n                            AND thread_user_status.userID = 1\n                    WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND wbb1_post.isDeleted = 0 AND wbb1_post.isDisabled = 0 AND (thread_user_status.status <> ? OR thread_user_status.status IS NULL)\nUNION ALL\n\n                    SELECT      shop1_product.productID AS objectID,\n                                shop1_product.title AS subject,\n                                0 AS time,\n                                'System' AS username,\n                                'com.viecode.shop.product' AS objectType\n                                \n                    FROM        shop1_product\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    shop1_product_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          shop1_product.productID = search_index.objectID\n                    \n                    WHERE (shop1_product.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR shop1_product.productID IN (SELECT productID FROM shop1_product_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))) AND shop1_product.isDisabled = 0 AND shop1_product.isDeleted = 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 IN (?, ?) OR (gallery1_image.accessLevel IN (?, ?) AND gallery1_image.userID = ?) OR gallery1_image.accessLevel = ?)\nUNION ALL\n\n                    SELECT      lexicon1_entry.entryID AS objectID,\n                                lexicon1_entry.subject AS subject,\n                                lexicon1_entry.time AS time,\n                                lexicon1_entry.username AS username,\n                                'com.viecode.lexicon.entry' AS objectType\n                                \n                    FROM        lexicon1_entry\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    wcf1_search_index_ab405c95\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          lexicon1_entry.entryID = search_index.objectID\n                    \n                    WHERE lexicon1_entry.entryID IN (\n\t\t\t\t\tSELECT entryID\n\t\t\t\t\tFROM lexicon1_entry_to_category\n\t\t\t\t\tWHERE categoryID IN (?,?,?)\n\t\t\t\t) AND lexicon1_entry.isDeleted = 0 AND lexicon1_entry.isDisabled = 0\nUNION ALL\n\n                    SELECT      news1_news.newsID AS objectID,\n                                 IF(news1_news.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news.subject) AS subject,\n                                news1_news.time AS time,\n                                news1_news.username AS username,\n                                'de.wbb-elite.news.search' AS objectType\n                                \n                    FROM        news1_news\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    news1_news_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          news1_news.newsID = search_index.objectID\n                     LEFT JOIN news1_language_to_content newsLanguageContent \n\t\tON(newsLanguageContent.newsID = news1_news.newsID)\n\t\t  LEFT JOIN wcf1_language_item language_item \n\t\t  ON(language_item.languageItemID = newsLanguageContent.languageItemID)\n                    WHERE news1_news.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news.isDisabled = 0 AND news1_news.isDeleted = 0\nUNION ALL\n\n                    SELECT      news1_news_update.updateID AS objectID,\n                                 IF(news1_news_update.isMultilingual AND language_item.languageItemValue IS NOT NULL, language_item.languageItemValue, news1_news_update.subject) AS subject,\n                                news1_news_update.time AS time,\n                                news1_news_update.username AS username,\n                                'de.wbb-elite.news.update.search' AS objectType\n                                \n                    FROM        news1_news_update\n                    INNER JOIN  (SELECT  objectID\n                        , '0' AS relevance\n                FROM    news1_news_update_search_index\n                WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)\n                \n                \n                LIMIT   2500) search_index\n                    ON          news1_news_update.updateID = search_index.objectID\n                     LEFT JOIN news1_update_language_to_content newsLanguageContent \n\t\tON(newsLanguageContent.updateID = news1_news_update.updateID)\n\t\t  LEFT JOIN wcf1_language_item language_item \n\t\t  ON(language_item.languageItemID = newsLanguageContent.languageItemID)\n                    WHERE news1_news_update.newsID IN (SELECT newsID FROM news1_news_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?)) AND news1_news_update.isDisabled = 0 AND news1_news_update.isDeleted = 0\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":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchEngine.class.php","line":144,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["bild",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easymedia.video":"[redacted]","com.cls.easymedia.image":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.viecode.shop.product":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.viecode.lexicon.entry":"[redacted]","de.wbb-elite.news.search":"[redacted]","de.wbb-elite.news.update.search":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC",1000]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchHandler.class.php","line":341,"function":"searchWithContext","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["bild",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.wbb.post":"[redacted]","com.viecode.lexicon.entry":"[redacted]"},{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.cls.easymedia.video":"[redacted]","com.cls.easymedia.image":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.viecode.shop.product":"[redacted]","com.woltlab.gallery.image":"[redacted]","com.viecode.lexicon.entry":"[redacted]","de.wbb-elite.news.search":"[redacted]","de.wbb-elite.news.update.search":"[redacted]","com.cls.easyrating.article":"[redacted]"},"time DESC"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/search\/SearchHandler.class.php","line":93,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/data\/search\/SearchAction.class.php","line":99,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":110,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AbstractAction.class.php","line":56,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":64,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/var\/www\/vhosts\/meinedomain.de\/httpdocs\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

SoftCreatR

Der Fehler wird vom easyrating Plugin verursacht

Olaf Braun

Cyperghost

Nico25 der Fehler ist bekannt und wird mit der nächsten Version behoben sein.

Nico25

Danke, hatte versucht das passende Plugin selber rauszulesen aber habe ich nicht geschafft.

SoftCreatR

Zitat von Nico25

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'easyrating1_article.title' in 'field list'

Fehlermeldung in der Suche

Olaf Braun 9. Juli 2024 um 14:15

Jetzt mitmachen!

Ähnliche Themen

Verlinkung der "Tag-Suche" im Suchfenster-Dropdown

Eine Französische Text-Variable von drei Sprachen fehlt in der Datenbank

Fehlerhaftes Ergebnis bei Suche hier auf der Seite in einem bestimmten Zeitraum

Benutzer online in diesem Thema