From c72b4ce64ce4975f995bd964a8ca3224e5c68697 Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Wed, 28 Aug 2013 23:45:48 +0200 Subject: [PATCH] Fixed search engine issue --- wcfsetup/install/files/lib/form/SearchForm.class.php | 2 +- wcfsetup/setup/db/install.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/wcfsetup/install/files/lib/form/SearchForm.class.php b/wcfsetup/install/files/lib/form/SearchForm.class.php index df8814a155..fb4f4bde09 100644 --- a/wcfsetup/install/files/lib/form/SearchForm.class.php +++ b/wcfsetup/install/files/lib/form/SearchForm.class.php @@ -409,7 +409,7 @@ class SearchForm extends RecaptchaForm { // language if (!empty($this->query) && LanguageFactory::getInstance()->multilingualismEnabled() && count(WCF::getUser()->getLanguageIDs())) { - $this->searchIndexCondition->add('(languageID IN (?) OR languageID IS NULL)', array(WCF::getUser()->getLanguageIDs())); + $this->searchIndexCondition->add('(languageID IN (?) OR languageID = 0)', array(WCF::getUser()->getLanguageIDs())); } foreach ($this->selectedObjectTypes as $key => $objectTypeName) { diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 712a40fae1..cbf40abb97 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -767,7 +767,7 @@ CREATE TABLE wcf1_search_index ( time INT(10) NOT NULL DEFAULT 0, userID INT(10), username VARCHAR(255) NOT NULL DEFAULT '', - languageID INT(10), + languageID INT(10) NOT NULL DEFAULT 0, UNIQUE KEY (objectTypeID, objectID, languageID), FULLTEXT INDEX fulltextIndex (subject, message, metaData), FULLTEXT INDEX fulltextIndexSubjectOnly (subject), -- 2.20.1