Hola amigos, estoy presentando este problema a la hora de tratar de incluir jugadores en las alianzas, Alguna idea?:
USER ERROR Message: SQLSTATE[42000]: Syntax error or access violation: 1064 Routing query to backend failed. See the error log for further details.
Query-Code:SELECT r.`applyID`, r.`time`, r.`userID`, r.`text`, u.`username`, u.`customNick`, u.`register_time`, u.`onlinetime`, u.`galaxy`, u.`system`, u.`planet`, CONCAT_WS(':', u.`galaxy`, u.`system`, u.`planet`) AS `coordinates`, @total_fights := u.`wons` + u.`loos` + u.`draws`, @total_fights_percentage := @total_fights / 100, @total_fights AS `total_fights`, u.`wons`, ROUND(u.`wons` / @total_fights_percentage, 2) AS `wons_percentage`, u.`loos`, ROUND(u.`loos` / @total_fights_percentage, 2) AS `loos_percentage`, u.`draws`, ROUND(u.`draws` / @total_fights_percentage, 2) AS `draws_percentage`, u.`kbmetal`, u.`kbcrystal`, u.`lostunits`, u.`desunits`, stat.`tech_rank`, stat.`tech_points`, stat.`build_rank`, stat.`build_points`, stat.`defs_rank`, stat.`defs_points`, stat.`fleet_rank`, stat.`fleet_points`, stat.`total_rank`, stat.`total_points`, p.`name` FROM uni1_alliance_request AS r LEFT JOIN uni1_users AS u ON r.userId = u.id INNER JOIN uni1_statpoints AS stat LEFT JOIN uni1_planets AS p ON p.id = u.id_planet WHERE applyID = 298;
File: /includes/classes/Database.class.php
Line: 109
URL: https://www.xnova.na...ailApply&id=298
PHP-Version: 7.3.20
PHP-API: fpm-fcgi
MySQL-Cleint-Version: mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
2Moons Version: 2.2.git
Debug Backtrace:
#0 /includes/classes/Database.class.php(185): Database->_query('SELECT/n/t/t/tr.`ap...', Array, 'select')
#1 /includes/pages/game/ShowAlliancePage.class.php(2496): Database->selectSingle('SELECT/n/t/t/tr.`ap...', Array)
#2 /includes/pages/game/ShowAlliancePage.class.php(2067): ShowAlliancePage->adminDetailApply()
#3 /game.php(89): ShowAlliancePage->admin()
#4 {main}