MySQL search query failed

  • 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
    1. /www/htdocs/w00e34a8/community/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
    2. /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
    3. /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
    4. /www/htdocs/w00e34a8/community/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
    5. /www/htdocs/w00e34a8/community/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
    6. /www/htdocs/w00e34a8/community/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    7. /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
    8. /www/htdocs/w00e34a8/community/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
    9. /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
    10. /www/htdocs/w00e34a8/community/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
    11. /www/htdocs/w00e34a8/community/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    12. /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
    1. /www/htdocs/w00e34a8/community/lib/system/search/mysql/MysqlSearchEngine.class.php (122): wcf\system\database\statement\PreparedStatement->execute(…)
    2. /www/htdocs/w00e34a8/community/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
    3. /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
    4. /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
    5. /www/htdocs/w00e34a8/community/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
    6. /www/htdocs/w00e34a8/community/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
    7. /www/htdocs/w00e34a8/community/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    8. /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
    9. /www/htdocs/w00e34a8/community/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
    10. /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
    11. /www/htdocs/w00e34a8/community/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
    12. /www/htdocs/w00e34a8/community/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    13. /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
    1. /www/htdocs/w00e34a8/community/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
    2. /www/htdocs/w00e34a8/community/lib/system/search/mysql/MysqlSearchEngine.class.php (122): wcf\system\database\statement\PreparedStatement->execute(…)
    3. /www/htdocs/w00e34a8/community/lib/system/search/SearchEngine.class.php (115): wcf\system\search\mysql\MysqlSearchEngine->search(…)
    4. /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (312): wcf\system\search\SearchEngine->search(…)
    5. /www/htdocs/w00e34a8/community/lib/system/search/SearchHandler.class.php (89): wcf\system\search\SearchHandler->loadResults(…)
    6. /www/htdocs/w00e34a8/community/lib/data/search/SearchAction.class.php (105): wcf\system\search\SearchHandler->search(…)
    7. /www/htdocs/w00e34a8/community/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\search\SearchAction->search(…)
    8. /www/htdocs/w00e34a8/community/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    9. /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
    10. /www/htdocs/w00e34a8/community/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
    11. /www/htdocs/w00e34a8/community/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
    12. /www/htdocs/w00e34a8/community/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
    13. /www/htdocs/w00e34a8/community/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    14. /www/htdocs/w00e34a8/community/index.php (11): wcf\system\request\RequestHandler->handle(…)




  • Gruß norse

    Zugang zu meinen Arbeiten und dem dazugehörigen Support bekommt Ihr bei Interesse hier.

Participate now!

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