USER ERROR
Message: SQLSTATE[42000]: Syntax error or access violation: 1064 Routing query to backend failed. See the error log for further details.
File: /includes/classes/Database.class.php
Line: 259
URL: xnova.nat.cu/2moons/admin.php?page=statsupdate
PHP-Version: 7.3.29
PHP-API: fpm-fcgi
2Moons Version: 2.0.git
Debug Backtrace:
#0 /includes/classes/Database.class.php(259): PDO->query('SELECT @i := 0;')
#1 /includes/classes/class.statbuilder.php(263): Database->nativeQuery('SELECT @i := 0;')
#2 /includes/classes/class.statbuilder.php(443): statbuilder->SetNewRanks()
#3 /includes/pages/adm/ShowStatUpdatePage.php(24): statbuilder->MakeStats()
#4 /admin.php(147): ShowStatUpdatePage()
#5 {main}
#0 /includes/classes/Database.class.php(259): PDO->query('SELECT @i := 0;')
252 {
253$this->lastInsertId = false;
254$this->rowCount = false;
255
256$qry = str_replace($this->dbTableNames['keys'], $this->dbTableNames['names'], $qry);
257
258/** @var $stmt PDOStatement */
259$stmt = $this->dbHandle->query($qry);
260
300$this->rowCount = $stmt->rowCount();
301
302$this->queryCounter++;
303return in_array($this->getQueryType($qry), array('select', 'show')) ? $stmt->fetchAll(PDO::FETCH_ASSOC) : true;
304 }
#1 /includes/classes/class.statbuilder.php(263): Database->nativeQuery('SELECT @i := 0;')
257 private function SetNewRanks()
258 {
259foreach($this->Unis as $uni)
230{
231foreach(array('tech', 'build', 'defs', 'fleet', 'total') as $type)
232{
234Database::get()->nativeQuery('SELECT @i := 0;');
235
236$sql = 'UPDATE %%STATPOINTS%% SET '.$type.'_rank = (SELECT @i := @i + 1)
237WHERE universe = :uni AND stat_type = :type
238ORDER BY '.$type.'_points DESC, id_owner ASC;';
239
240Database::get()->update($sql, array(
241':uni' => $uni,
242':type' => 1,
243));
244
245Database::get()->nativeQuery('SELECT @i := 0;');
246
247Database::get()->update($sql, array(
248':uni' => $uni,
249':type' => 2,
250));
251}
252}
253 }
#2 /includes/classes/class.statbuilder.php(443): statbuilder->SetNewRanks()
443 $this->SetNewRanks();
444
445$this->CheckUniverseAccounts($UniData);
446$this->writeRecordData();
447
448return $this->SomeStatsInfos();
#3 /includes/pages/adm/ShowStatUpdatePage.php(24): statbuilder->MakeStats()
24 $result= $stat->MakeStats();
#4 /admin.php(147): ShowStatUpdatePage()
145 case 'statsupdate':
146include_once('includes/pages/adm/ShowStatUpdatePage.php');
147ShowStatUpdatePage();
148 break;
Message: SQLSTATE[42000]: Syntax error or access violation: 1064 Routing query to backend failed. See the error log for further details.
File: /includes/classes/Database.class.php
Line: 259
URL: xnova.nat.cu/2moons/admin.php?page=statsupdate
PHP-Version: 7.3.29
PHP-API: fpm-fcgi
2Moons Version: 2.0.git
Debug Backtrace:
#0 /includes/classes/Database.class.php(259): PDO->query('SELECT @i := 0;')
#1 /includes/classes/class.statbuilder.php(263): Database->nativeQuery('SELECT @i := 0;')
#2 /includes/classes/class.statbuilder.php(443): statbuilder->SetNewRanks()
#3 /includes/pages/adm/ShowStatUpdatePage.php(24): statbuilder->MakeStats()
#4 /admin.php(147): ShowStatUpdatePage()
#5 {main}
#0 /includes/classes/Database.class.php(259): PDO->query('SELECT @i := 0;')
252 {
253$this->lastInsertId = false;
254$this->rowCount = false;
255
256$qry = str_replace($this->dbTableNames['keys'], $this->dbTableNames['names'], $qry);
257
258/** @var $stmt PDOStatement */
259$stmt = $this->dbHandle->query($qry);
260
300$this->rowCount = $stmt->rowCount();
301
302$this->queryCounter++;
303return in_array($this->getQueryType($qry), array('select', 'show')) ? $stmt->fetchAll(PDO::FETCH_ASSOC) : true;
304 }
#1 /includes/classes/class.statbuilder.php(263): Database->nativeQuery('SELECT @i := 0;')
257 private function SetNewRanks()
258 {
259foreach($this->Unis as $uni)
230{
231foreach(array('tech', 'build', 'defs', 'fleet', 'total') as $type)
232{
234Database::get()->nativeQuery('SELECT @i := 0;');
235
236$sql = 'UPDATE %%STATPOINTS%% SET '.$type.'_rank = (SELECT @i := @i + 1)
237WHERE universe = :uni AND stat_type = :type
238ORDER BY '.$type.'_points DESC, id_owner ASC;';
239
240Database::get()->update($sql, array(
241':uni' => $uni,
242':type' => 1,
243));
244
245Database::get()->nativeQuery('SELECT @i := 0;');
246
247Database::get()->update($sql, array(
248':uni' => $uni,
249':type' => 2,
250));
251}
252}
253 }
#2 /includes/classes/class.statbuilder.php(443): statbuilder->SetNewRanks()
443 $this->SetNewRanks();
444
445$this->CheckUniverseAccounts($UniData);
446$this->writeRecordData();
447
448return $this->SomeStatsInfos();
#3 /includes/pages/adm/ShowStatUpdatePage.php(24): statbuilder->MakeStats()
24 $result= $stat->MakeStats();
#4 /admin.php(147): ShowStatUpdatePage()
145 case 'statsupdate':
146include_once('includes/pages/adm/ShowStatUpdatePage.php');
147ShowStatUpdatePage();
148 break;