Error: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
Query: SELECT `f`.`id`, `f`.`info_hash`, `f`.`filename`, `f`.`size`, UNIX_TIMESTAMP(`f`.`data`) `added`, `f`.`seeds`+ifnull(`x`.`seeders`,0) `seeds`, `f`.`leechers`+ifnull(`x`.`leechers`,0) `leechers`, `f`.`category` FROM `files` `f` LEFT JOIN `xbt_files` `x` ON `x`.`info_hash`=`f`.`bin_hash` WHERE `f`.`filename` LIKE '%创造%' AND `f`.`seeds`+ifnull(`x`.`seeders`,0) > '0' AND `f`.`info_hash` <> '2c4677f1e8183c0d3310f56952c6e8d6a281369a' OR `f`.`filename` LIKE '%创造%' AND `f`.`seeds`+ifnull(`x`.`seeders`,0) > '0' AND `f`.`info_hash` <> '2c4677f1e8183c0d3310f56952c6e8d6a281369a' ORDER BY `f`.`seeds`+ifnull(`x`.`seeders`,0) DESC LIMIT 10
|