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/