Could not execute statement

  • Affected Version
    WoltLab Suite 5.2

    Hi.


    Ich bekomme täglich folgende Fehlermeldung seit dem Update auf 5.2. An was kann es liegen? Sucht da jemand im Forum diese komische URL??


    Sun, 12 Apr 2020 19:08:54 +0000

    Message: Could not execute statement 'INSERT INTO wcf2_search_keyword

    (keyword,searches,lastSearchTime)

    VALUES (?,?,?)'

    PHP version: 7.1.33

    WoltLab Suite version: 5.2.5

    Request URI: /search/?q=www.yumiaoyc.cn

    Referrer:

    User Agent: mozilla/5.0 (iphone; cpu iphone os 11_0 like mac os x) applewebkit/604.1.38 (khtml, like gecko) version/11.0 mobile/15a372 safari/604.1

    Peak Memory Usage: 4393696/536870912

    ======

    Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message: Could not execute statement 'INSERT INTO wcf2_search_keyword

    (keyword,searches,lastSearchTime)

    VALUES (?,?,?)'

    Error Code: 23000

    File: /usr/www/users/bayernho/community/lib/system/database/statement/PreparedStatement.class.php (105)

    Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtzOjE3OiInd3d3Lnl1bWlhb3ljLmNuJyI7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6MTt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aToxNTg2NzE4NTM0O319

    Stack Trace: [{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/data\/DatabaseObjectEditor.class.php","line":37,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"keyword":"[redacted]","searches":"[redacted]","lastSearchTime":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":337,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"keyword":"[redacted]","searches":"[redacted]","lastSearchTime":"[redacted]"}],"class":"","type":""},{"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/system\/search\/SearchKeywordManager.class.php","line":44,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/form\/SearchForm.class.php","line":373,"function":"add","class":"wcf\\system\\search\\SearchKeywordManager","type":"->","args":["www.yumiaoyc.cn"]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/form\/SearchForm.class.php","line":313,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/form\/SearchForm.class.php","line":415,"function":"submit","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

    ======

    Error Class: PDOException

    Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'www.yumiaoyc.cn' for key 'keyword'

    Error Code: 23000

    File: /usr/www/users/bayernho/community/lib/system/database/statement/PreparedStatement.class.php (93)

    Extra Information: -

    Stack Trace: [{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/data\/DatabaseObjectEditor.class.php","line":37,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"keyword":"[redacted]","searches":"[redacted]","lastSearchTime":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":337,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"keyword":"[redacted]","searches":"[redacted]","lastSearchTime":"[redacted]"}],"class":"","type":""},{"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/system\/search\/SearchKeywordManager.class.php","line":44,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/form\/SearchForm.class.php","line":373,"function":"add","class":"wcf\\system\\search\\SearchKeywordManager","type":"->","args":["www.yumiaoyc.cn"]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/form\/SearchForm.class.php","line":313,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/form\/SearchForm.class.php","line":415,"function":"submit","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/usr\/www\/users\/bayernho\/community\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Participate now!

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