Fehler bei einigen Suchen in der Filebase

orkenspalter · Jan 22nd 2023

Hi zusammen,

bei mir im Forum fällt mir seit kurzem auf, dass im Fehlerprotokoll einige MySQL-Fehler geloggt werden. Einige Suchbegriffe (nicht alle), die über die Filebase laufen, lösen einen Fehler aus. Beschränkt man die Suche auf den Betreff (nicht nur Betreff + Nachricht) wird der Fehler nicht geworfen.

Beispiel:

https://www.orkenspalter.de/filebase/ => Suche nach Bornland

Konkret wird ausgelöst:

Code

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 objectID , '0' AS relevance FROM filebase1_file_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) AND (languageID IN (?,?,?,?,?,?) OR languageID = 0) LIMIT 2500) 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'

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

Art
PDOException

Datei (Zeile)
/home/www/orkenspalter.de/wcf/lib/system/database/statement/PreparedStatement.class.php (126)

Display More

Habt ihr eine Idee, woran das liegen könnte?

Vollständiges Fehlerprotokoll:

Display Spoiler

Requested URL: POST /wcf/index.php?ajax-proxy/&t=95055ecea7c2078435fde5b82399c2034f40910234c932ff1c24db5c138fafa2-SzHJ72KGNKem/judnG6ZGQ==

Referrer: https://www.orkenspalter.de/wcf/index.php?search/&q=DSA&type=com.woltlab.filebase.file&sortField=time&sortOrder=DESC

Error Message: MySQL search query failed.

Type: wcf\system\search\exception\SearchFailed

File (Line): /home/www/orkenspalter.de/wcf/lib/system/search/mysql/MysqlSearchEngine.class.php (130)

Stacktrace

/home/www/orkenspalter.de/wcf/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
/home/www/orkenspalter.de/wcf/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
/home/www/orkenspalter.de/wcf/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
/home/www/orkenspalter.de/wcf/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
/home/www/orkenspalter.de/wcf/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/home/www/orkenspalter.de/wcf/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/home/www/orkenspalter.de/wcf/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/home/www/orkenspalter.de/wcf/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/home/www/orkenspalter.de/wcf/index.php (11): wcf\system\request\RequestHandler->handle(…)

Error Message: 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 objectID , '0' AS relevance FROM filebase1_file_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) AND (languageID IN (?,?,?,?,?,?) OR languageID = 0) LIMIT 2500) 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'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /home/www/orkenspalter.de/wcf/lib/system/database/statement/PreparedStatement.class.php (144)

Query Parameter 1: '+DSA*'

Query Parameter 2: 1

Query Parameter 3: 2

Query Parameter 4: 5

Query Parameter 5: 3

Query Parameter 6: 6

Query Parameter 7: 4

Query Parameter 8: 4

Query Parameter 9: 6

Query Parameter 10: 9

Query Parameter 11: 22

Query Parameter 12: 23

Query Parameter 13: 25

Query Parameter 14: 26

Query Parameter 15: 28

Query Parameter 16: 29

Query Parameter 17: 30

Query Parameter 18: 31

Query Parameter 19: 34

Query Parameter 20: 40

Query Parameter 21: 101

Query Parameter 22: 107

Query Parameter 23: 5

Query Parameter 24: 7

Query Parameter 25: 10

Query Parameter 26: 24

Query Parameter 27: 27

Query Parameter 28: 32

Query Parameter 29: 41

Query Parameter 30: 8

Query Parameter 31: 11

Query Parameter 32: 33

Query Parameter 33: 42

Query Parameter 34: 12

Query Parameter 35: 39

Query Parameter 36: 44

Query Parameter 37: 13

Query Parameter 38: 45

Query Parameter 39: 14

Query Parameter 40: 46

Query Parameter 41: 15

Query Parameter 42: 47

Query Parameter 43: 16

Query Parameter 44: 48

Query Parameter 45: 194

Query Parameter 46: 17

Query Parameter 47: 49

Query Parameter 48: 111

Query Parameter 49: 18

Query Parameter 50: 50

Stacktrace

/home/www/orkenspalter.de/wcf/lib/system/search/mysql/MysqlSearchEngine.class.php (122): wcf\system\database\statement\PreparedStatement->execute(…)
/home/www/orkenspalter.de/wcf/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
/home/www/orkenspalter.de/wcf/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
/home/www/orkenspalter.de/wcf/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
/home/www/orkenspalter.de/wcf/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
/home/www/orkenspalter.de/wcf/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/home/www/orkenspalter.de/wcf/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/home/www/orkenspalter.de/wcf/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/home/www/orkenspalter.de/wcf/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/home/www/orkenspalter.de/wcf/index.php (11): wcf\system\request\RequestHandler->handle(…)

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

Type: PDOException

File (Line): /home/www/orkenspalter.de/wcf/lib/system/database/statement/PreparedStatement.class.php (126)

Stacktrace

/home/www/orkenspalter.de/wcf/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
/home/www/orkenspalter.de/wcf/lib/system/search/mysql/MysqlSearchEngine.class.php (122): wcf\system\database\statement\PreparedStatement->execute(…)
/home/www/orkenspalter.de/wcf/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
/home/www/orkenspalter.de/wcf/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
/home/www/orkenspalter.de/wcf/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
/home/www/orkenspalter.de/wcf/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
/home/www/orkenspalter.de/wcf/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/home/www/orkenspalter.de/wcf/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
/home/www/orkenspalter.de/wcf/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/home/www/orkenspalter.de/wcf/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/home/www/orkenspalter.de/wcf/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/home/www/orkenspalter.de/wcf/index.php (11): wcf\system\request\RequestHandler->handle(…)

Sat, 14 Jan 2023 21:56:33 +0000
Message: MySQL search query failed.
PHP version: 8.0.25
WoltLab Suite version: 5.5.7
Request URI: POST /wcf/index.php?ajax-proxy/&t=95055ecea7c2078435fde5b82399c2034f40910234c932ff1c24db5c138fafa2-SzHJ72KGNKem/judnG6ZGQ==
Referrer: https://www.orkenspalter.de/wcf/index.php?search/&q=DSA&type=com.woltlab.filebase.file&sortField=time&sortOrder=DESC
User Agent: ...
Peak Memory Usage: 7638208/1073741824
======
Error Class: wcf\system\search\exception\SearchFailed
Error Message: MySQL search query failed.
Error Code: 0
File: /home/www/orkenspalter.de/wcf/lib/system/search/mysql/MysqlSearchEngine.class.php (130)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchEngine.class.php","line":115,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["DSA",["[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.filebase.file":"[redacted]"},"time DESC",1000]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchHandler.class.php","line":312,"function":"search","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["DSA",["[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.filebase.file":"[redacted]"},"time DESC"]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchHandler.class.php","line":89,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/data\/search\/SearchAction.class.php","line":105,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: 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  objectID                         , '0' AS relevance                 FROM    filebase1_file_search_index                 WHERE   MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE)                 AND (languageID IN (?,?,?,?,?,?) OR languageID = 0)                                  LIMIT   2500) 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'
Error Code: 21000
File: /home/www/orkenspalter.de/wcf/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTo1MDp7aTowO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAxIjtpOjE7czo3OiInK0RTQSonIjt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aToxO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjI7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO2k6NTt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7aTozO31pOjU7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDYiO2k6MTtpOjY7fWk6NjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNyI7aToxO2k6NDt9aTo3O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA4IjtpOjE7aTo0O31pOjg7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDkiO2k6MTtpOjY7fWk6OTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTAiO2k6MTtpOjk7fWk6MTA7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDExIjtpOjE7aToyMjt9aToxMTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTIiO2k6MTtpOjIzO31pOjEyO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxMyI7aToxO2k6MjU7fWk6MTM7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDE0IjtpOjE7aToyNjt9aToxNDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTUiO2k6MTtpOjI4O31pOjE1O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxNiI7aToxO2k6Mjk7fWk6MTY7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDE3IjtpOjE7aTozMDt9aToxNzthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTgiO2k6MTtpOjMxO31pOjE4O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxOSI7aToxO2k6MzQ7fWk6MTk7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDIwIjtpOjE7aTo0MDt9aToyMDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMjEiO2k6MTtpOjEwMTt9aToyMTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMjIiO2k6MTtpOjEwNzt9aToyMjthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMjMiO2k6MTtpOjU7fWk6MjM7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDI0IjtpOjE7aTo3O31pOjI0O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAyNSI7aToxO2k6MTA7fWk6MjU7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDI2IjtpOjE7aToyNDt9aToyNjthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMjciO2k6MTtpOjI3O31pOjI3O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAyOCI7aToxO2k6MzI7fWk6Mjg7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDI5IjtpOjE7aTo0MTt9aToyOTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMzAiO2k6MTtpOjg7fWk6MzA7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDMxIjtpOjE7aToxMTt9aTozMTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMzIiO2k6MTtpOjMzO31pOjMyO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAzMyI7aToxO2k6NDI7fWk6MzM7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDM0IjtpOjE7aToxMjt9aTozNDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMzUiO2k6MTtpOjM5O31pOjM1O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAzNiI7aToxO2k6NDQ7fWk6MzY7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDM3IjtpOjE7aToxMzt9aTozNzthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMzgiO2k6MTtpOjQ1O31pOjM4O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAzOSI7aToxO2k6MTQ7fWk6Mzk7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDQwIjtpOjE7aTo0Njt9aTo0MDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgNDEiO2k6MTtpOjE1O31pOjQxO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciA0MiI7aToxO2k6NDc7fWk6NDI7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDQzIjtpOjE7aToxNjt9aTo0MzthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgNDQiO2k6MTtpOjQ4O31pOjQ0O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciA0NSI7aToxO2k6MTk0O31pOjQ1O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciA0NiI7aToxO2k6MTc7fWk6NDY7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDQ3IjtpOjE7aTo0OTt9aTo0NzthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgNDgiO2k6MTtpOjExMTt9aTo0ODthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgNDkiO2k6MTtpOjE4O31pOjQ5O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciA1MCI7aToxO2k6NTA7fX0=
Stack Trace: [{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/mysql\/MysqlSearchEngine.class.php","line":122,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchEngine.class.php","line":115,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["DSA",["[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.filebase.file":"[redacted]"},"time DESC",1000]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchHandler.class.php","line":312,"function":"search","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["DSA",["[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.filebase.file":"[redacted]"},"time DESC"]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchHandler.class.php","line":89,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/data\/search\/SearchAction.class.php","line":105,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
Error Code: 21000
File: /home/www/orkenspalter.de/wcf/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/mysql\/MysqlSearchEngine.class.php","line":122,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchEngine.class.php","line":115,"function":"search","class":"wcf\\system\\search\\mysql\\MysqlSearchEngine","type":"->","args":["DSA",["[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.filebase.file":"[redacted]"},"time DESC",1000]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchHandler.class.php","line":312,"function":"search","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["DSA",["[redacted]"],false,"wcf\\system\\database\\util\\PreparedStatementConditionBuilder",{"com.woltlab.filebase.file":"[redacted]"},"time DESC"]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/search\/SearchHandler.class.php","line":89,"function":"loadResults","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/data\/search\/SearchAction.class.php","line":105,"function":"search","class":"wcf\\system\\search\\SearchHandler","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"search","class":"wcf\\data\\search\\SearchAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/orkenspalter.de\/wcf\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Darklord · Jan 22nd 2023

Das liegt wohl an der Mehrsprachigkeit, dürfte das selbe Problem wie hier sein.

Post

Fehler in der elastic Search Erweiterung

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....

(Hidden Content)

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

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!

Stephan_70

Aug 15th 2022

Quote from Alexander Ebert

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?

orkenspalter · Jan 23rd 2023

Danke. Werde ich prüfen.

orkenspalter · Jan 23rd 2023

Ich habe in der Datenbank geschaut, ob es Einträge im Umfeld der filebase gibt, die mit languageID ausgestattet sind. Da waren noch 2, die habe ich umgebogen. Sind jetzt alle mit NULL gesetzt.

Also:

filebase1_file_content: alle languageID auf NULL
filebase1_file_search_index: alle languageID auf 0
filebase1_file_version_content: alle languageID auf NULL

Leider taucht der Fehler noch immer auf. Da es jedoch nur bezogen auf einige Schlagworte auftaucht (also z.B. Bornand, aber nicht ornland) vermute ich, dass es noch anderswo im Index eine Referenz gibt, die ich korrigieren könnte.

Habt ihr dazu einen Tipp?

**Alexander Ebert** · Jan 31st 2023

Hallo orkenspalter,

bitte wende dich per Ticket an uns, damit wir der Ursache gezielt auf den Grund gehen können.

Fehler bei einigen Suchen in der Filebase

Alexander Ebert Jan 31st 2023

Marcel Werk Feb 2nd 2023

Marcel Werk Feb 2nd 2023

Alexander Ebert Mar 13th 2023

Participate now!

Share

Similar Threads

SQL Fehler bei Upload von großen Dateien

Fehler nach DB Versionsupdate

Reiter "Top bewertet" falsch / irreführend beschriftet

Fehler bei update Filebase und Gallery 5.5.3 → 5.5.4 - dann doch ok

Inkonsistente Zähler bei ungelesenen Beiträgen und der Forenübersicht

Users Viewing This Thread