Mehrere Ranggrafiken - Nginx Problem

Bitte in den Beiträgen keine externe Bilder einbinden, sondern nur die Dateianhänge verwenden.
Vielen dank.
  • Hallo,

    ich habe mir im Woltlab Store das plugin "mehrere Ranggrafiken" geholt. Meine Seite nutzt SEO in zusammenarbeit mit nginx.
    Beim Aufruf des Froums erscheint diese Fehlermeldung:

    Spoiler anzeigen


    Wed, 24 May 2017 13:26:28 +0000
    Message: Could not prepare statement 'SELECT userID, userOption as optionValue FROM wcf1_user_option_value WHERE userID IN(?)'
    PHP version: 7.1.5
    WoltLab Suite version: 3.0.5
    Request URI: /forum/index.php?ajax-proxy/&
    Referrer: http://www.die-legionaere.games-mmo.de/forum/
    User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0
    Peak Memory Usage: 3012656/134217728
    ======
    Error Class: wcf\system\database\exception\DatabaseQueryException
    Error Message: Could not prepare statement 'SELECT userID, userOption as optionValue FROM wcf1_user_option_value WHERE userID IN(?)'
    Error Code: 42
    File: /var/www/vhosts/games-mmo.de/die-legionaere.games-mmo.de/de/lib/system/database/Database.class.php (240)
    Extra Information: -
    Stack Trace: [{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/data\/multirank\/MultirankAction.class.php","line":141,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT userID, userOption as optionValue FROM wcf1_user_option_value WHERE userID IN(?)"]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/data\/multirank\/MultirankAction.class.php","line":89,"function":"getUserOptions","class":"wcf\\data\\multirank\\MultirankAction","type":"->","args":[["[redacted]"]]},{"function":"getMultirank","class":"wcf\\data\\multirank\\MultirankAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/action\/AJAXProxyAction.class.php","line":74,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/system\/request\/RequestHandler.class.php","line":94,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]
    ======
    Error Class: PDOException
    Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'userOption' in 'field list'
    Error Code: 42
    File: /var/www/vhosts/games-mmo.de/die-legionaere.games-mmo.de/de/lib/system/database/Database.class.php (235)
    Extra Information: -
    Stack Trace: [{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/system\/database\/Database.class.php","line":235,"function":"prepare","class":"PDO","type":"->","args":["SELECT userID, userOption as optionValue FROM wcf1_user_option_value WHERE userID IN(?)"]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/data\/multirank\/MultirankAction.class.php","line":141,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT userID, userOption as optionValue FROM wcf1_user_option_value WHERE userID IN(?)"]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/data\/multirank\/MultirankAction.class.php","line":89,"function":"getUserOptions","class":"wcf\\data\\multirank\\MultirankAction","type":"->","args":[["[redacted]"]]},{"function":"getMultirank","class":"wcf\\data\\multirank\\MultirankAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/action\/AJAXProxyAction.class.php","line":74,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/lib\/system\/request\/RequestHandler.class.php","line":94,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/games-mmo.de\/die-legionaere.games-mmo.de\/de\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]

    Die nginx Einstellungen sehen so aus:

    Spoiler anzeigen


    location /var/www/vhosts/games-mmo.de/die-legionaere.games-mmo.de/de {
    index index.php;


    try_files $uri $uri/var/www/vhosts/games-mmo.de/die-legionaere.games-mmo.de/de @rewrite;
    }
    location @rewrite {
    rewrite ^/(forum/|cms/|wcf/|calendar/|filebase/|blog/|gallery/|easymedia/)?([^.]+)$ /$1index.php?$2 last;
    }

    Die Seite ist aktuell nur ein Testsystem.

    Hat jemand ne Idee wie ich den Fehler abgestellt bekomme?

    URL zur Testseite: http://www.die-legionaere.games-mmo.de/forum/

  • Cyperghost 27. Mai 2018 um 12:40

    Hat das Thema geschlossen.
  • Cyperghost 15. August 2019 um 22:08

    Hat das Thema geschlossen.
  • Dragosius 31. Oktober 2022 um 00:56

    Hat das Label von Mehrere Ranggrafiken 3 auf Mehrere Ranggrafiken geändert.