MySQL Error
Doslo je do greske prilikom izvrsavanja sledeceg upita:
SELECT
`server`.*,
`c_owner`.`clientid` as `ownerid`,
`c_owner`.`username` as `ownerusername`,
`c_owner`.`firstname` as `ownerfirstname`,
`c_owner`.`lastname` as `ownerlastname`,
`c_adder`.`clientid` as `adderid`,
`c_adder`.`username` as `adderusername`,
`country`.`short_name` as `countryname`,
`country`.`iso2` as `iso2`,
`country`.`balcan` as `balcan`,
`game`.`name` as `gamename`,
`game`.`short` as `gameshort`,
`mods`.`name` as `modname`,
`mods`.`short` as `modshort`
FROM `server`
LEFT JOIN `client` `c_owner`
ON `server`.`ownedby` = `c_owner`.`clientid`
LEFT JOIN `client` `c_adder`
ON `server`.`addedby` = `c_adder`.`clientid`
LEFT JOIN `country`
ON `server`.`country_id` = `country`.`country_id`
LEFT JOIN `game`
ON `server`.`game_id` = `game`.`game_id`
LEFT JOIN `mods`
ON `server`.`mod_id` = `mods`.`mod_id` AND `server`.`game_id` = `mods`.`game_id`
WHERE
`ip`='151.80....25C2�' AND `q_port`=''
Greska glasi:
Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='