Fehlermeldung in der Suche

  • Affected Version
    WoltLab Suite 6.0

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

    Requested 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
    Error Message
    MySQL search query failed.
    Type
    wcf\system\search\exception\SearchFailed
    File (Line)
    /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/mysql/MysqlSearchEngine.class.php (129)
    Stacktrace
    1. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchEngine.class.php (144): wcf\system\search\mysql\MysqlSearchEngine->search(…)
    2. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (341): wcf\system\search\SearchEngine->searchWithContext(…)
    3. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (93): wcf\system\search\SearchHandler->loadResults(…)
    4. /var/www/vhosts/meinedomain.de/httpdocs/lib/data/search/SearchAction.class.php (99): wcf\system\search\SearchHandler->search(…)
    5. /var/www/vhosts/meinedomain.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (215): wcf\data\search\SearchAction->search(…)
    6. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    7. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (110): wcf\action\AJAXProxyAction->invoke(…)
    8. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AbstractAction.class.php (56): wcf\action\AJAXInvokeAction->execute(…)
    9. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (64): wcf\action\AbstractAction->__run(…)
    10. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/Request.class.php (57): wcf\action\AJAXInvokeAction->__run(…)
    11. /var/www/vhosts/meinedomain.de/httpdocs/lib/http/middleware/HandleValinorMappingErrors.class.php (35): wcf\system\request\Request->handle(…)
    12. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/RequestHandler.class.php (147): wcf\http\Pipeline->process(…)
    13. /var/www/vhosts/meinedomain.de/httpdocs/index.php (10): wcf\system\request\RequestHandler->handle(…)
    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'
    Type
    wcf\system\database\exception\DatabaseQueryException
    File (Line)
    /var/www/vhosts/meinedomain.de/httpdocs/lib/system/database/Database.class.php (332)
    Stacktrace
    1. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/mysql/MysqlSearchEngine.class.php (120): wcf\system\database\Database->prepareStatement(…)
    2. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchEngine.class.php (144): wcf\system\search\mysql\MysqlSearchEngine->search(…)
    3. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (341): wcf\system\search\SearchEngine->searchWithContext(…)
    4. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (93): wcf\system\search\SearchHandler->loadResults(…)
    5. /var/www/vhosts/meinedomain.de/httpdocs/lib/data/search/SearchAction.class.php (99): wcf\system\search\SearchHandler->search(…)
    6. /var/www/vhosts/meinedomain.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (215): wcf\data\search\SearchAction->search(…)
    7. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    8. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (110): wcf\action\AJAXProxyAction->invoke(…)
    9. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AbstractAction.class.php (56): wcf\action\AJAXInvokeAction->execute(…)
    10. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (64): wcf\action\AbstractAction->__run(…)
    11. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/Request.class.php (57): wcf\action\AJAXInvokeAction->__run(…)
    12. /var/www/vhosts/meinedomain.de/httpdocs/lib/http/middleware/HandleValinorMappingErrors.class.php (35): wcf\system\request\Request->handle(…)
    13. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/RequestHandler.class.php (147): wcf\http\Pipeline->process(…)
    14. /var/www/vhosts/meinedomain.de/httpdocs/index.php (10): wcf\system\request\RequestHandler->handle(…)
    Error Message
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'easyrating1_article.title' in 'field list'
    Type
    PDOException
    File (Line)
    /var/www/vhosts/meinedomain.de/httpdocs/lib/system/database/Database.class.php (326)
    Stacktrace
    1. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/database/Database.class.php (326): PDO->prepare(…)
    2. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/mysql/MysqlSearchEngine.class.php (120): wcf\system\database\Database->prepareStatement(…)
    3. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchEngine.class.php (144): wcf\system\search\mysql\MysqlSearchEngine->search(…)
    4. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (341): wcf\system\search\SearchEngine->searchWithContext(…)
    5. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/search/SearchHandler.class.php (93): wcf\system\search\SearchHandler->loadResults(…)
    6. /var/www/vhosts/meinedomain.de/httpdocs/lib/data/search/SearchAction.class.php (99): wcf\system\search\SearchHandler->search(…)
    7. /var/www/vhosts/meinedomain.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (215): wcf\data\search\SearchAction->search(…)
    8. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    9. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (110): wcf\action\AJAXProxyAction->invoke(…)
    10. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AbstractAction.class.php (56): wcf\action\AJAXInvokeAction->execute(…)
    11. /var/www/vhosts/meinedomain.de/httpdocs/lib/action/AJAXInvokeAction.class.php (64): wcf\action\AbstractAction->__run(…)
    12. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/Request.class.php (57): wcf\action\AJAXInvokeAction->__run(…)
    13. /var/www/vhosts/meinedomain.de/httpdocs/lib/http/middleware/HandleValinorMappingErrors.class.php (35): wcf\system\request\Request->handle(…)
    14. /var/www/vhosts/meinedomain.de/httpdocs/lib/system/request/RequestHandler.class.php (147): wcf\http\Pipeline->process(…)
    15. /var/www/vhosts/meinedomain.de/httpdocs/index.php (10): wcf\system\request\RequestHandler->handle(…)
  • Olaf Braun July 9, 2024 at 2:15 PM

    Added the Label Not a bug

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!