- Affected Version
- WoltLab Suite 5.5
- Affected App
- WoltLab Suite Forum
Hallo zusammen,
ich habe folgenden Fehler im Forum und weiss nicht wo ich anfangen muss zu suchen an was es liegen kann.
Für jede Hilfe bin ich dankbar.
- Requested URL
- POST /index.php?ajax-proxy/&t=2de5aab5faeb44f29d243d1de8449eceab25251bce2889c6ce76e83e146f3280-lNc9hNTx0VQTNccQQ4alyg==
- Referrer
- https://wasserlasser.com/index.php?search/&q=arena&type=com.woltlab.filebase.file&sortField=time&sortOrder=DESC
- Error Message
- MySQL search query failed.
- Type
- wcf\system\search\exception\SearchFailed
- File (Line)
- /www/htdocs/w00e34a8/community/lib/system/search/mysql/MysqlSearchEngine.class.php (130)
- Stacktrace
-
- /www/htdocs/w00e34a8/community/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
- /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
- /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
- /www/htdocs/w00e34a8/community/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
- /www/htdocs/w00e34a8/community/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
- /www/htdocs/w00e34a8/community/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
- /www/htdocs/w00e34a8/community/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
- /www/htdocs/w00e34a8/community/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
- /www/htdocs/w00e34a8/community/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 = 2) ) 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) 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)
- /www/htdocs/w00e34a8/community/lib/system/database/statement/PreparedStatement.class.php (144)
- Query Parameter 1
- '+arena*'
- Query Parameter 2
- 4
- Query Parameter 3
- 260
- Query Parameter 4
- 5
- Query Parameter 5
- 266
- Query Parameter 6
- 11
- Query Parameter 7
- 270
- Query Parameter 8
- 276
- Query Parameter 9
- 37
- Query Parameter 10
- 40
- Query Parameter 11
- 389
- Query Parameter 12
- 138
- Query Parameter 13
- 213
- Query Parameter 14
- 216
- Query Parameter 15
- 234
- Query Parameter 16
- 255
- Query Parameter 17
- 6
- Query Parameter 18
- 9
- Query Parameter 19
- 268
- Query Parameter 20
- 269
- Query Parameter 21
- 277
- Query Parameter 22
- 36
- Query Parameter 23
- 38
- Query Parameter 24
- 39
- Query Parameter 25
- 41
- Query Parameter 26
- 43
- Query Parameter 27
- 46
- Query Parameter 28
- 388
- Query Parameter 29
- 212
- Query Parameter 30
- 265
- Query Parameter 31
- 10
- Query Parameter 32
- 271
- Query Parameter 33
- 42
- Query Parameter 34
- 44
- Query Parameter 35
- 45
- Query Parameter 36
- 47
- Query Parameter 37
- 49
- Query Parameter 38
- 52
- Query Parameter 39
- 387
- Query Parameter 40
- 390
- Query Parameter 41
- 214
- Query Parameter 42
- 12
- Query Parameter 43
- 272
- Query Parameter 44
- 18
- Query Parameter 45
- 275
- Query Parameter 46
- 48
- Query Parameter 47
- 50
- Query Parameter 48
- 51
- Query Parameter 49
- 53
- Query Parameter 50
- 55
- Query Parameter 51
- 58
- Query Parameter 52
- 391
- Query Parameter 53
- 13
- Query Parameter 54
- 273
- Query Parameter 55
- 278
- Query Parameter 56
- 25
- Query Parameter 57
- 54
- Query Parameter 58
- 56
- Query Parameter 59
- 57
- Query Parameter 60
- 59
- Query Parameter 61
- 64
- Query Parameter 62
- 136
- Query Parameter 63
- 392
- Query Parameter 64
- 14
- Query Parameter 65
- 279
- Query Parameter 66
- 26
- Query Parameter 67
- 60
- Query Parameter 68
- 61
- Query Parameter 69
- 70
- Query Parameter 70
- 338
- Query Parameter 71
- 339
- Query Parameter 72
- 341
- Query Parameter 73
- 15
- Query Parameter 74
- 19
- Query Parameter 75
- 281
- Query Parameter 76
- 63
- Query Parameter 77
- 65
- Query Parameter 78
- 66
- Query Parameter 79
- 67
- Query Parameter 80
- 76
- Query Parameter 81
- 335
- Query Parameter 82
- 16
- Query Parameter 83
- 20
- Query Parameter 84
- 62
- Query Parameter 85
- 69
- Query Parameter 86
- 71
- Query Parameter 87
- 72
- Query Parameter 88
- 73
- Query Parameter 89
- 82
- Query Parameter 90
- 211
- Query Parameter 91
- 27
- Query Parameter 92
- 68
- Query Parameter 93
- 75
- Query Parameter 94
- 77
- Query Parameter 95
- 78
- Query Parameter 96
- 79
- Query Parameter 97
- 215
- Query Parameter 98
- 24
- Query Parameter 99
- 74
- Query Parameter 100
- 81
- Query Parameter 101
- 83
- Query Parameter 102
- 217
- Query Parameter 103
- 264
- Query Parameter 104
- 21
- Query Parameter 105
- 282
- Query Parameter 106
- 80
- Query Parameter 107
- 340
- Query Parameter 108
- 22
- Query Parameter 109
- 336
- Query Parameter 110
- 23
- Query Parameter 111
- 337
- Query Parameter 112
- 288
- Query Parameter 113
- 289
- Query Parameter 114
- 375
- Stacktrace
-
- /www/htdocs/w00e34a8/community/lib/system/search/mysql/MysqlSearchEngine.class.php (122): wcf\system\database\statement\PreparedStatement->execute(…)
- /www/htdocs/w00e34a8/community/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
- /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
- /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
- /www/htdocs/w00e34a8/community/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
- /www/htdocs/w00e34a8/community/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
- /www/htdocs/w00e34a8/community/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
- /www/htdocs/w00e34a8/community/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
- /www/htdocs/w00e34a8/community/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
- /www/htdocs/w00e34a8/community/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)
- /www/htdocs/w00e34a8/community/lib/system/database/statement/PreparedStatement.class.php (126)
- Stacktrace
-
- /www/htdocs/w00e34a8/community/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
- /www/htdocs/w00e34a8/community/lib/system/search/mysql/MysqlSearchEngine.class.php (122): wcf\system\database\statement\PreparedStatement->execute(…)
- /www/htdocs/w00e34a8/community/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
- /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
- /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
- /www/htdocs/w00e34a8/community/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
- /www/htdocs/w00e34a8/community/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
- /www/htdocs/w00e34a8/community/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
- /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
- /www/htdocs/w00e34a8/community/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
- /www/htdocs/w00e34a8/community/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
- /www/htdocs/w00e34a8/community/index.php (11): wcf\system\request\RequestHandler->handle(…)