Fehler in der elastic Search Erweiterung

Stephan_70 · Aug 15th 2022

Hallo WoltLab Team

Seit ich gestern das Update gefahren habe, bekomme ich viele Fehler in der Suche.

Die Fehlerbeschreibung verweist auf mysql...das dürfte so aber nicht sein, da elastic Search vorgeschalten ist.

Ich bin hier ein wenig ratlos....

Kompletter Fehler

Fetching search results from MySQL failed.

Datum
15. August 2022, 13:54

Aufgerufene URL
POST /index.php?ajax-proxy/&t=9de2bceb630bfec98a5ef522a4ef2db2a6f4be0f68de7d974e3814de1a984c47-1BvxSmacCmo4WqWtpirBWw==

Referrer
https://forbidden-mods.de/sear…SC&filebaseCategoryID=268

Browser
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36

Arbeitsspeicher
8,56 MiB / 1 GiB

Fehlermeldung
Fetching search results from MySQL failed.

Art
wcf\system\search\exception\SearchFailed

Datei (Zeile)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (145)

Stacktrace

/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchEngine.class.php (115): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchHandler.class.php (306): wcf\system\search\SearchEngine->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchHandler.class.php (83): wcf\system\search\SearchHandler->loadResults(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/data/search/SearchAction.class.php (104): wcf\system\search\SearchHandler->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/index.php (11): wcf\system\request\RequestHandler->handle(…)

Fehlermeldung
Could not execute statement 'SELECT filebase1_file.fileID AS objectID, time, username, 'com.woltlab.filebase.file' AS objectType, ( SELECT subject FROM filebase1_file_content WHERE fileID = filebase1_file.fileID AND (languageID IS NULL OR languageID = 1) ) AS subject FROM filebase1_file INNER JOIN ( SELECT DISTINCT file_content.fileID FROM filebase1_file_content file_content INNER JOIN (SELECT '35771' AS objectID, '138' AS relevance UNION ALL SELECT '35422' AS objectID, '137' AS relevance UNION ALL SELECT '33652' AS objectID, '136' AS relevance UNION ALL SELECT '33639' AS objectID, '135' AS relevance UNION ALL SELECT '33239' AS objectID, '134' AS relevance UNION ALL SELECT '32919' AS objectID, '133' AS relevance UNION ALL SELECT '32737' AS objectID, '132' AS relevance UNION ALL SELECT '32610' AS objectID, '131' AS relevance UNION ALL SELECT '32438' AS objectID, '130' AS relevance UNION ALL SELECT '31878' AS objectID, '129' AS relevance UNION ALL SELECT '31777' AS objectID, '128' AS relevance UNION ALL SELECT '31482' AS objectID, '127' AS relevance UNION ALL SELECT '31217' AS objectID, '126' AS relevance UNION ALL SELECT '31000' AS objectID, '125' AS relevance UNION ALL SELECT '30781' AS objectID, '124' AS relevance UNION ALL SELECT '30091' AS objectID, '123' AS relevance UNION ALL SELECT '30003' AS objectID, '122' AS relevance UNION ALL SELECT '29936' AS objectID, '121' AS relevance UNION ALL SELECT '29906' AS objectID, '120' AS relevance UNION ALL SELECT '29831' AS objectID, '119' AS relevance UNION ALL SELECT '29763' AS objectID, '118' AS relevance UNION ALL SELECT '29165' AS objectID, '117' AS relevance UNION ALL SELECT '28791' AS objectID, '116' AS relevance UNION ALL SELECT '28790' AS objectID, '115' AS relevance UNION ALL SELECT '28191' AS objectID, '114' AS relevance UNION ALL SELECT '27869' AS objectID, '113' AS relevance UNION ALL SELECT '27000' AS objectID, '112' AS relevance UNION ALL SELECT '26997' AS objectID, '111' AS relevance UNION ALL SELECT '26765' AS objectID, '110' AS relevance UNION ALL SELECT '26669' AS objectID, '109' AS relevance UNION ALL SELECT '26625' AS objectID, '108' AS relevance UNION ALL SELECT '26594' AS objectID, '107' AS relevance UNION ALL SELECT '26340' AS objectID, '106' AS relevance UNION ALL SELECT '26314' AS objectID, '105' AS relevance UNION ALL SELECT '25916' AS objectID, '104' AS relevance UNION ALL SELECT '25685' AS objectID, '103' AS relevance UNION ALL SELECT '24776' AS objectID, '102' AS relevance UNION ALL SELECT '24662' AS objectID, '101' AS relevance UNION ALL SELECT '24492' AS objectID, '100' AS relevance UNION ALL SELECT '24420' AS objectID, '99' AS relevance UNION ALL SELECT '24370' AS objectID, '98' AS relevance UNION ALL SELECT '24137' AS objectID, '97' AS relevance UNION ALL SELECT '23867' AS objectID, '96' AS relevance UNION ALL SELECT '23775' AS objectID, '95' AS relevance UNION ALL SELECT '23462' AS objectID, '94' AS relevance UNION ALL SELECT '22907' AS objectID, '93' AS relevance UNION ALL SELECT '22570' AS objectID, '92' AS relevance UNION ALL SELECT '22539' AS objectID, '91' AS relevance UNION ALL SELECT '22473' AS objectID, '90' AS relevance UNION ALL SELECT '22411' AS objectID, '89' AS relevance UNION ALL SELECT '21865' AS objectID, '88' AS relevance UNION ALL SELECT '21563' AS objectID, '87' AS relevance UNION ALL SELECT '21360' AS objectID, '86' AS relevance UNION ALL SELECT '21351' AS objectID, '85' AS relevance UNION ALL SELECT '21298' AS objectID, '84' AS relevance UNION ALL SELECT '21297' AS objectID, '83' AS relevance UNION ALL SELECT '21211' AS objectID, '82' AS relevance UNION ALL SELECT '20774' AS objectID, '81' AS relevance UNION ALL SELECT '20642' AS objectID, '80' AS relevance UNION ALL SELECT '20428' AS objectID, '79' AS relevance UNION ALL SELECT '19970' AS objectID, '78' AS relevance UNION ALL SELECT '19099' AS objectID, '77' AS relevance UNION ALL SELECT '19038' AS objectID, '76' AS relevance UNION ALL SELECT '18690' AS objectID, '75' AS relevance UNION ALL SELECT '18681' AS objectID, '74' AS relevance UNION ALL SELECT '18411' AS objectID, '73' AS relevance UNION ALL SELECT '18242' AS objectID, '72' AS relevance UNION ALL SELECT '18218' AS objectID, '71' AS relevance UNION ALL SELECT '18134' AS objectID, '70' AS relevance UNION ALL SELECT '17959' AS objectID, '69' AS relevance UNION ALL SELECT '17937' AS objectID, '68' AS relevance UNION ALL SELECT '17737' AS objectID, '67' AS relevance UNION ALL SELECT '16753' AS objectID, '66' AS relevance UNION ALL SELECT '16239' AS objectID, '65' AS relevance UNION ALL SELECT '15501' AS objectID, '64' AS relevance UNION ALL SELECT '15422' AS objectID, '63' AS relevance UNION ALL SELECT '15053' AS objectID, '62' AS relevance UNION ALL SELECT '15046' AS objectID, '61' AS relevance UNION ALL SELECT '14417' AS objectID, '60' AS relevance UNION ALL SELECT '14307' AS objectID, '59' AS relevance UNION ALL SELECT '14279' AS objectID, '58' AS relevance UNION ALL SELECT '14040' AS objectID, '57' AS relevance UNION ALL SELECT '13344' AS objectID, '56' AS relevance UNION ALL SELECT '12926' AS objectID, '55' AS relevance UNION ALL SELECT '12073' AS objectID, '54' AS relevance UNION ALL SELECT '11421' AS objectID, '53' AS relevance UNION ALL SELECT '11398' AS objectID, '52' AS relevance UNION ALL SELECT '11345' AS objectID, '51' AS relevance UNION ALL SELECT '11303' AS objectID, '50' AS relevance UNION ALL SELECT '11089' AS objectID, '49' AS relevance UNION ALL SELECT '10872' AS objectID, '48' AS relevance UNION ALL SELECT '19703' AS objectID, '47' AS relevance UNION ALL SELECT '10757' AS objectID, '46' AS relevance UNION ALL SELECT '10254' AS objectID, '45' AS relevance UNION ALL SELECT '9552' AS objectID, '44' AS relevance UNION ALL SELECT '9539' AS objectID, '43' AS relevance UNION ALL SELECT '9472' AS objectID, '42' AS relevance UNION ALL SELECT '9189' AS objectID, '41' AS relevance UNION ALL SELECT '8973' AS objectID, '40' AS relevance UNION ALL SELECT '8280' AS objectID, '39' AS relevance UNION ALL SELECT '8191' AS objectID, '38' AS relevance UNION ALL SELECT '8147' AS objectID, '37' AS relevance UNION ALL SELECT '8146' AS objectID, '36' AS relevance UNION ALL SELECT '8125' AS objectID, '35' AS relevance UNION ALL SELECT '8106' AS objectID, '34' AS relevance UNION ALL SELECT '7881' AS objectID, '33' AS relevance UNION ALL SELECT '7830' AS objectID, '32' AS relevance UNION ALL SELECT '7435' AS objectID, '31' AS relevance UNION ALL SELECT '7375' AS objectID, '30' AS relevance UNION ALL SELECT '7373' AS objectID, '29' AS relevance UNION ALL SELECT '7133' AS objectID, '28' AS relevance UNION ALL SELECT '5885' AS objectID, '27' AS relevance UNION ALL SELECT '5867' AS objectID, '26' AS relevance UNION ALL SELECT '5736' AS objectID, '25' AS relevance UNION ALL SELECT '5363' AS objectID, '24' AS relevance UNION ALL SELECT '5358' AS objectID, '23' AS relevance UNION ALL SELECT '5120' AS objectID, '22' AS relevance UNION ALL SELECT '4464' AS objectID, '21' AS relevance UNION ALL SELECT '4399' AS objectID, '20' AS relevance UNION ALL SELECT '4119' AS objectID, '19' AS relevance UNION ALL SELECT '4054' AS objectID, '18' AS relevance UNION ALL SELECT '3723' AS objectID, '17' AS relevance UNION ALL SELECT '3619' AS objectID, '16' AS relevance UNION ALL SELECT '3156' AS objectID, '15' AS relevance UNION ALL SELECT '2732' AS objectID, '14' AS relevance UNION ALL SELECT '1301' AS objectID, '13' AS relevance UNION ALL SELECT '859' AS objectID, '12' AS relevance UNION ALL SELECT '485' AS objectID, '11' AS relevance UNION ALL SELECT '484' AS objectID, '10' AS relevance UNION ALL SELECT '483' AS objectID, '9' AS relevance UNION ALL SELECT '482' AS objectID, '8' AS relevance UNION ALL SELECT '480' AS objectID, '7' AS relevance UNION ALL SELECT '478' AS objectID, '6' AS relevance UNION ALL SELECT '476' AS objectID, '5' AS relevance UNION ALL SELECT '474' AS objectID, '4' AS relevance UNION ALL SELECT '236' AS objectID, '3' AS relevance UNION ALL SELECT '29' AS objectID, '2' AS relevance UNION ALL SELECT '16' AS objectID, '1' AS relevance) search_index ON file_content.fileContentID = search_index.objectID ) AS subselect ON filebase1_file.fileID = subselect.fileID WHERE filebase1_file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND filebase1_file.isDisabled = 0 AND filebase1_file.isDeleted = 0 ORDER BY time DESC LIMIT 1000'

Art
wcf\system\database\exception\DatabaseQueryExecutionException

Datei (Zeile)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/database/statement/PreparedStatement.class.php (144)
Query Parameter 1
268
Query Parameter 2
380
Query Parameter 3
270
Query Parameter 4
292
Query Parameter 5
308
Query Parameter 6
325
Query Parameter 7
351
Query Parameter 8
127
Query Parameter 9
132
Query Parameter 10
364
Query Parameter 11
134
Query Parameter 12
362
Query Parameter 13
271
Query Parameter 14
272
Query Parameter 15
273
Query Parameter 16
274
Query Parameter 17
275
Query Parameter 18
282
Query Parameter 19
366
Query Parameter 20
365
Query Parameter 21
277
Query Parameter 22
276
Query Parameter 23
290
Query Parameter 24
284
Query Parameter 25
291
Query Parameter 26
278
Query Parameter 27
280
Query Parameter 28
279
Query Parameter 29
367
Query Parameter 30
283
Query Parameter 31
281
Query Parameter 32
285
Query Parameter 33
286
Query Parameter 34
368
Query Parameter 35
287
Query Parameter 36
288
Query Parameter 37
289
Query Parameter 38
293
Query Parameter 39
294
Query Parameter 40
300
Query Parameter 41
295
Query Parameter 42
296
Query Parameter 43
297
Query Parameter 44
301
Query Parameter 45
302
Query Parameter 46
304
Query Parameter 47
373
Query Parameter 48
303
Query Parameter 49
305
Query Parameter 50
348
Query Parameter 51
306
Query Parameter 52
349
Query Parameter 53
374
Query Parameter 54
307
Query Parameter 55
309
Query Parameter 56
310
Query Parameter 57
177
Query Parameter 58
178
Query Parameter 59
313
Query Parameter 60
179
Query Parameter 61
375
Query Parameter 62
181
Query Parameter 63
183
Query Parameter 64
182
Query Parameter 65
188
Query Parameter 66
185
Query Parameter 67
326
Query Parameter 68
184
Query Parameter 69
231
Query Parameter 70
232
Query Parameter 71
186
Query Parameter 72
191
Query Parameter 73
328
Query Parameter 74
330
Query Parameter 75
331
Query Parameter 76
329
Query Parameter 77
336
Query Parameter 78
337
Query Parameter 79
197
Query Parameter 80
339
Query Parameter 81
199
Query Parameter 82
344
Query Parameter 83
200
Query Parameter 84
377
Query Parameter 85
203
Query Parameter 86
370
Query Parameter 87
371
Query Parameter 88
334
Query Parameter 89
378
Query Parameter 90
202
Query Parameter 91
332
Query Parameter 92
204
Query Parameter 93
352
Query Parameter 94
353
Query Parameter 95
356
Query Parameter 96
355
Query Parameter 97
379
Query Parameter 98
354
Query Parameter 99
359
Query Parameter 100
357
Query Parameter 101
358
Query Parameter 102
369
Stacktrace

/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (137): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchEngine.class.php (115): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchHandler.class.php (306): wcf\system\search\SearchEngine->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchHandler.class.php (83): wcf\system\search\SearchHandler->loadResults(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/data/search/SearchAction.class.php (104): wcf\system\search\SearchHandler->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/index.php (11): wcf\system\request\RequestHandler->handle(…)

Fehlermeldung
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row

Art
PDOException

Datei (Zeile)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/database/statement/PreparedStatement.class.php (126)

Stacktrace

/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (137): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchEngine.class.php (115): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchHandler.class.php (306): wcf\system\search\SearchEngine->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/search/SearchHandler.class.php (83): wcf\system\search\SearchHandler->loadResults(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/data/search/SearchAction.class.php (104): wcf\system\search\SearchHandler->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/index.php (11): wcf\system\request\RequestHandler->handle(…)

Zudem kommt dieser Fehler seit gestern den ich mir ehrlich gesagt auch nicht erklären kann:

Display Spoiler

Datum
15. August 2022, 13:19

Aufgerufene URL
GET /manage-reactions/?pageNo=11393&sortField=user&sortOrder=DESC
Referrer
https://forbidden-mods.de/mana…Field=user&sortOrder=DESC
Browser
Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)
Arbeitsspeicher
9,37 MiB / 1 GiB
Fehlermeldung
Undefined array key ""
Art
wcf\system\exception\ErrorException
Datei (Zeile)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/WCF.class.php (341)
Stacktrace

/var/www/vhosts/forbidden-mods.de/httpdocs/filebase/lib/system/comment/manager/FileCommentManager.class.php (226): wcf\system\WCF::handleError(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/data/comment/response/LikeableCommentResponseProvider.class.php (101): filebase\system\comment\manager\FileCommentManager->prepare(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/data/like/ManageLikeList.class.php (86): wcf\data\comment\response\LikeableCommentResponseProvider->prepare(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/page/MultipleLinkPage.class.php (172): wcf\data\like\ManageLikeList->readObjects(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/page/MultipleLinkPage.class.php (137): wcf\page\MultipleLinkPage->readObjects(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/page/SortablePage.class.php (61): wcf\page\MultipleLinkPage->readData(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/page/AbstractPage.class.php (353): wcf\page\SortablePage->readData(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/page/AbstractPage.class.php (135): wcf\page\AbstractPage->show(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/request/Request.class.php (90): wcf\page\AbstractPage->__run(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/vhosts/forbidden-mods.de/httpdocs/index.php (11): wcf\system\request\RequestHandler->handle(…)

Ich denke, der Fehler sitzt 50cm vor dem Bildschirm, trotzdem wäre ich über eine Rückmeldung doch sehr froh.

Danke schon mal im voraus!

**Alexander Ebert** · Aug 15th 2022

Hallo,

die Fehlerbeschreibung stimmt so, denn über Elasticsearch werden intern die relevanten Einträge erfasst und dann mit den Datenbeständen in der Datenbank korreliert.

Die Meldung lässt mich vermuten, dass die Mehrsprachigkeit in der Filebase nachträglich aktiviert wurde und einige Einträge sowohl einen sprachbezogenen als auch einen sprachneutralen Datensatz aufweisen, kann dies zutreffen?

Stephan_70 · Aug 16th 2022

Das ist eigentlich nicht der Fall, denn die Mehrsprachigkeit war deaktiviert.

Der Fehler trat auch erst nach dem Update auf, vorher war er nie in der Log.

Ich habe allerdings zusätzlich zur elastic Search noch die "Erweiterte Suche" installiert.

Kann es sein, dass diese mit verantwortlich ist?

Was mir nämlich auffällt ist, dass die SuFu seitdem die Hauptkategorien der Filebase nicht mehr erfasst

und es bei Eingabe zu einer Fehlermeldung kommt.

Einzelne Einträge in der Filebase werden aber treffsicher erkannt und ausgegeben.

Die nächste Frage wäre....wie kann ich das korrigieren?

Muss ich nur die Mehrsprachigkeit (Deutsch/Englisch) aktivieren um den Fehler wegzubekommen?

Oder gibt es da eine andere Lösung?

Ich bedanke mich schon mal vorab für ihre Mühen.

Mit freundlichem Gruß,

Csonka Stephan

SoftCreatR · Aug 16th 2022

Die erweiterte Suche ist nur bedingt mit elasticsearch kompatibel.

Darklord · Aug 16th 2022

Quote from Stephan_70

Ich habe allerdings zusätzlich zur elastic Search noch die "Erweiterte Suche" installiert.
Kann es sein, dass diese mit verantwortlich ist?

Nein, da der Fehler schon davor auftrat.

Darklord · Aug 17th 2022

Quote from Alexander Ebert

Hallo,

die Fehlerbeschreibung stimmt so, denn über Elasticsearch werden intern die relevanten Einträge erfasst und dann mit den Datenbeständen in der Datenbank korreliert.

Die Meldung lässt mich vermuten, dass die Mehrsprachigkeit in der Filebase nachträglich aktiviert wurde und einige Einträge sowohl einen sprachbezogenen als auch einen sprachneutralen Datensatz aufweisen, kann dies zutreffen?

Wie lässt sich dies beheben?

Es gibt massen Sprachneutrale und Englisch zugeordnete Einträge, sowol im Forum als auch in der Filebase, wäre das ganze per SQL machbar, das man allen Einträgen die 1 als LanguageID zuweist?

**Alexander Ebert** · Aug 17th 2022

Ja, das ist prinzipiell so machbar, vorausgesetzt natürlich, es gibt keine Kollisionen.

Wasserlasser · Jan 1st 2023

Da ich diesen Fehler auch habe die Frage, wie ich die SQL Query machen muss um alles auf 1 zu stellen?

Danke

Fehler in der elastic Search Erweiterung

Fetching search results from MySQL failed.

Alexander Ebert Sep 8th 2022

Marcel Werk Sep 14th 2022

Participate now!

Share

Similar Threads

Bug: Suchen mit Anführungszeichen führt zum Fehler

Fehler in der Suche mit Zahlen

Users Viewing This Thread