Fatal error: Invalid SQL: SELECT s.*, b.stamp AS banStamp FROM ad1_1_settlement s LEFT JOIN ad1_1_settlement_ban b ON (s.settlementID = b.settlementID AND b.characterID = '205') WHERE s.worldID = '10' AND s.status IN ('active','init') AND s.triviaID > 0 ORDER BY s.settlementname
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1054
Information:
error message: Invalid SQL: SELECT s.*, b.stamp AS banStamp FROM ad1_1_settlement s LEFT JOIN ad1_1_settlement_ban b ON (s.settlementID = b.settlementID AND b.characterID = '205') WHERE s.worldID = '10' AND s.status IN ('active','init') AND s.triviaID > 0 ORDER BY s.settlementname
error code: 1054
sql type: MySQLDatabase
sql error: Unknown column 'b.characterID' in 'on clause'
sql error number: 1054
sql version:
file: C:\inetpub\htdocs\betasinweb\wcf\lib\system\database\MySQLDatabase.class.php (118)
php version: 5.6.34
wcf version: 1.1.10 pl 1 (Tempest)
date: Thu, 07 Jun 2018 11:53:22 +0000
request: /index.php?form=Immigrate&characterID=205
referer: https://adler.betasin.adersin.de/index.php?page=Whitelist
Stacktrace:
#0 C:\inetpub\htdocs\betasinweb\adler\lib\form\ImmigrateForm.class.php(280): MySQLDatabase->sendQuery('SELECT s.*, b.stamp AS banStamp FROM ad1_1_settlem ...')
#1 C:\inetpub\htdocs\betasinweb\adler\lib\form\ImmigrateForm.class.php(119): ImmigrateForm->loadSettlements()
#2 C:\inetpub\htdocs\betasinweb\wcf\lib\page\AbstractPage.class.php(90): ImmigrateForm->readData()
#3 C:\inetpub\htdocs\betasinweb\adler\lib\form\ImmigrateForm.class.php(266): AbstractPage->show()
#4 C:\inetpub\htdocs\betasinweb\wcf\lib\page\AbstractPage.class.php(46): ImmigrateForm->show()
#5 C:\inetpub\htdocs\betasinweb\wcf\lib\util\RequestHandler.class.php(68): AbstractPage->__construct()
#6 C:\inetpub\htdocs\betasinweb\wcf\lib\util\RequestHandler.class.php(100): RequestHandler->__construct('Immigrate', Array, 'form')
#7 C:\inetpub\htdocs\betasinweb\adler\index.php(3): RequestHandler::handle(Array)
Alcadeias
Gerade gesehen, dass mein Spot in Betasin auf Zwangspause geschalten wurde. Hängt das damit zusammen?