Код:
Context info for the following error/warning:
Error: 256, Read query failed:
SELECT r.name AS racename, UNIX_TIMESTAMP(u.registered) AS registered, UNIX_TIMESTAMP(u.lastlogin) AS lastlogin, ur.realname, ur.realsex, ur.country, ur.city, ur.icq, ur.homepage, u.slogan, u.about, u.image, cr.rank_name AS clantitle, up.val AS verdict, FIND_IN_SET('redirectinfo', u.flags) AS redirectinfo, FIND_IN_SET('blocked', u.flags) AS blocked, (FIND_IN_SET('htmlinabout', u.flags) OR FIND_IN_SET('htmlinabout', clan.flags)) AS htmlinabout, (FIND_IN_SET('htmlinslogan', u.flags) OR FIND_IN_SET('htmlinslogan', clan.flags)) AS htmlinslogan, (FIND_IN_SET('htmlinrealname', u.flags) OR FIND_IN_SET('htmlinrealname', clan.flags)) AS htmlinrealname, (FIND_IN_SET('htmlincountry', u.flags) OR FIND_IN_SET('htmlincountry', clan.flags)) AS htmlincountry, (FIND_IN_SET('htmlincity', u.flags) OR FIND_IN_SET('htmlincity', clan.flags)) AS htmlincity, IFNULL(session.roomid, b.roomid) AS online, IFNULL(u.lastroomid, b.roomid) AS roomid, IFNULL(u.wins, npc.wins) AS wins, IFNULL(u.loses, npc.loses) AS loses, IFNULL(u.draws, npc.draws) AS draws, IFNULL(u.deaths, npc.deaths) AS deaths, bm.state AS battlestate, UNIX_TIMESTAMP(b.timestart) AS battlestart, b.round AS battleround, b.weapon AS battleweapon, bm.userid, bm.memberid, bm.battleid, bm.color, bm.state, 0 as bstamp, bm.killedpc, bm.killednpc, bm.hitpc, bm.hitnpc, bm.num, bm.expa, bm.hp AS bmhp, bm.hpc AS bmhpc, bm.mpc AS bmmpc, bm.bfc AS bmbfc, CONCAT(IFNULL(u.username, npc.name), IF(num > 0, num + 1, '')) AS username, IFNULL(u.race, npc.race) AS race, IFNULL(u.sex, npc.sex) AS sex, u.clan, u.teacher, npc.bonus AS x_bonus, npc.req AS x_req, npc.brcache AS x_brcache, IF(bm.level<>0,bm.level,IFNULL(u.`level`, npc.`level`)) AS level, IFNULL(u.lastroomid,0) as roomid, IFNULL(u.image, npc.image) AS image, IF(session.userid IS NOT NULL OR bm.userid < 0, 1, 0) AS online, IFNULL(u.`aligEG`, npc.`aligEG`) AS `aligEG`, IFNULL(u.`aligCL`, npc.`aligCL`) AS `aligCL`, IFNULL(u.`str`, npc.`str`) AS `str`, IFNULL(u.`dex`, npc.`dex`) AS `dex`, IFNULL(u.`rag`, npc.`rag`) AS `rag`, IFNULL(u.`int`, npc.`int`) AS `int`, IFNULL(u.`wis`, npc.`wis`) AS `wis`, IFNULL(u.`inu`, npc.`inu`) AS `inu`, IFNULL(u.`con`, npc.`con`) AS `con`, IFNULL(u.`eng`, npc.`eng`) AS `eng`, IFNULL(u.`exp`, npc.`exp`) AS `exp`, IFNULL(u.hpc, bm.hpc) AS hpc, IFNULL(u.mpc, bm.mpc) AS mpc, u.hpt AS hpt, u.mpt AS mpt, u.bft AS bft, IFNULL(u.bf, 100) as bf, IFNULL(u.bfc, 100) as bfc, u.add, u.cash, u.icon, u.`maginq`, u.`mstadd`, u.`profession`, u.`prof_exp`, u.`pair`, u.`usercontext`, u.battleid AS battleid_bound, IFNULL(u.`mstp`, npc.`mstp`) AS `mstp`, IFNULL(u.`msts`, npc.`msts`) AS `msts`, IFNULL(u.`mstc`, npc.`mstc`) AS `mstc`, IFNULL(u.`mstb`, npc.`mstb`) AS `mstb`, IFNULL(u.`mst2`, npc.`mst2`) AS `mst2`, IFNULL(u.`mst1`, npc.`mst1`) AS `mst1`, IFNULL(u.`mst11`, npc.`mst11`) AS `mst11`, IFNULL(u.`mstd`, npc.`mstd`) AS `mstd`, IFNULL(u.`msth`, npc.`msth`) AS `msth`, IFNULL(u.`magfire`, npc.`magfire`) AS `magfire`, IFNULL(u.`magair`, npc.`magair`) AS `magair`, IFNULL(u.`magwater`, npc.`magwater`) AS `magwater`, IFNULL(u.`magearth`, npc.`magearth`) AS `magearth`, IFNULL(u.`magblack`, npc.`magblack`) AS `magblack`, IFNULL(u.`magwhite`, npc.`magwhite`) AS `magwhite`, IFNULL(u.`maggray`, npc.`maggray`) AS `maggray`, IFNULL(u.`magshaman`, npc.`magshaman`) AS `magshaman`, IFNULL(u.effects, bm.effects) AS effects, bm.wearro, u.slots, u.petid, u.partyid, u.partystamp,u.karma,u.class, /*IFNULL(u.wear, npc.wear) AS wear,*/ IFNULL(u.w_ring1, npc.w_ring1) AS w_ring1, IFNULL(u.w_ring2, npc.w_ring2) AS w_ring2, IFNULL(u.w_ring3, npc.w_ring3) AS w_ring3, IFNULL(u.w_earing, npc.w_earing) AS w_earing, IFNULL(u.w_amulet, npc.w_amulet) AS w_amulet, IFNULL(u.w_necklace, npc.w_necklace) AS w_necklace, IFNULL(u.w_weapon1, npc.w_weapon1) AS w_weapon1, IFNULL(u.w_weapon2, npc.w_weapon2) AS w_weapon2, IFNULL(u.w_armor, npc.w_armor) AS w_armor, IFNULL(u.w_helmet, npc.w_helmet) AS w_helmet, IFNULL(u.w_bracers, npc.w_bracers) AS w_bracers, IFNULL(u.w_gloves, npc.w_gloves) AS w_gloves, IFNULL(u.w_belt, npc.w_belt) AS w_belt, IFNULL(u.w_pants, npc.w_pants) AS w_pants, IFNULL(u.w_boots, npc.w_boots) AS w_boots, IFNULL(u.w_underhelmet, npc.w_underhelmet) AS w_underhelmet, IFNULL(u.w_underarmor, npc.w_underarmor) AS w_underarmor, IFNULL(u.w_underpants, npc.w_underpants) AS w_underpants, IFNULL(u.w_underboots, npc.w_underboots) AS w_underboots, IFNULL(u.w_overhelmet, npc.w_overhelmet) AS w_overhelmet, IFNULL(u.w_overarmor, npc.w_overarmor) AS w_overarmor, IFNULL(u.w_overpants, npc.w_overpants) AS w_overpants, IFNULL(u.w_overboots, npc.w_overboots) AS w_overboots FROM `haddanarc`.battlemember AS bm LEFT JOIN session ON (bm.userid > 0 AND bm.userid=session.userid) LEFT JOIN user AS u ON (bm.userid > 0 AND bm.userid=u.userid) LEFT JOIN npc ON (bm.userid < 0 AND bm.userid=npc.npcid) LEFT JOIN race r ON r.raceid=u.race OR r.raceid=npc.race LEFT JOIN user_prop_str up ON up.userid=u.userid AND up.name='verdict' LEFT JOIN clan_ranks cr ON u.clantitle=cr.uid LEFT JOIN clan ON u.clan=clan.clanid LEFT JOIN `haddanarc`.battle b ON b.battleid=bm.battleid LEFT JOIN userreal ur ON u.ruid = ur.ruid WHERE bm.memberid='484467585'
With result:
Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'ifnull'
in /var/www/haddan/core/library/db_fns.php, 332
Backtrace: {
file: /var/www/haddan/core/library/db_fns.php, 332
call: trigger_error("Read query failed:
SELECT r.name AS racename,
UNIX_TIMESTAMP(u.registered) AS registered,
UNIX_TIMESTAMP(u.lastlogin) AS l...", 256)
file: /var/www/haddan/core/library/db_fns.php, 201
call: db_trigger_error("Read query failed:
SELECT r.name AS racename,
UNIX_TIMESTAMP(u.registered) AS registered,
UNIX_TIMESTAMP(u.lastlogin) AS l...", "Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'ifnull'", 256)
file: /var/www/htdocs/user.php, 136
call: db_query_read("SELECT r.name AS racename,
UNIX_TIMESTAMP(u.registered) AS registered,
UNIX_TIMESTAMP(u.lastlogin) AS lastlogin,
ur.realname,...")
}
Locals:
Array
(
[querytext] => Read query failed:
SELECT r.name AS racename,
UNIX_TIMESTAMP(u.registered) AS registered,
UNIX_TIMESTAMP(u.lastlogin) AS lastlogin,
ur.realname, ur.realsex, ur.country, ur.city, ur.icq, ur.homepage,
u.slogan, u.about, u.image,
cr.rank_name AS clantitle,
up.val AS verdict,
FIND_IN_SET('redirectinfo', u.flags) AS redirectinfo,
FIND_IN_SET('blocked', u.flags) AS blocked,
(FIND_IN_SET('htmlinabout', u.flags) OR FIND_IN_SET('htmlinabout', clan.flags)) AS htmlinabout,
(FIND_IN_SET('htmlinslogan', u.flags) OR FIND_IN_SET('htmlinslogan', clan.flags)) AS htmlinslogan,
(FIND_IN_SET('htmlinrealname', u.flags) OR FIND_IN_SET('htmlinrealname', clan.flags)) AS htmlinrealname,
(FIND_IN_SET('htmlincountry', u.flags) OR FIND_IN_SET('htmlincountry', clan.flags)) AS htmlincountry,
(FIND_IN_SET('htmlincity', u.flags) OR FIND_IN_SET('htmlincity', clan.flags)) AS htmlincity,
IFNULL(session.roomid, b.roomid) AS online,
IFNULL(u.lastroomid, b.roomid) AS roomid,
IFNULL(u.wins, npc.wins) AS wins,
IFNULL(u.loses, npc.loses) AS loses,
IFNULL(u.draws, npc.draws) AS draws,
IFNULL(u.deaths, npc.deaths) AS deaths,
bm.state AS battlestate,
UNIX_TIMESTAMP(b.timestart) AS battlestart,
b.round AS battleround,
b.weapon AS battleweapon,
bm.userid, bm.memberid, bm.battleid, bm.color, bm.state, 0 as bstamp,
bm.killedpc, bm.killednpc, bm.hitpc, bm.hitnpc, bm.num, bm.expa,
bm.hp AS bmhp, bm.hpc AS bmhpc, bm.mpc AS bmmpc, bm.bfc AS bmbfc,
CONCAT(IFNULL(u.username, npc.name), IF(num > 0, num + 1, '')) AS username,
IFNULL(u.race, npc.race) AS race,
IFNULL(u.sex, npc.sex) AS sex,
u.clan, u.teacher,
npc.bonus AS x_bonus, npc.req AS x_req, npc.brcache AS x_brcache,
IF(bm.level<>0,bm.level,IFNULL(u.`level`, npc.`level`)) AS level,
IFNULL(u.lastroomid,0) as roomid,
IFNULL(u.image, npc.image) AS image,
IF(session.userid IS NOT NULL OR bm.userid < 0, 1, 0) AS online,
IFNULL(u.`aligEG`, npc.`aligEG`) AS `aligEG`,
IFNULL(u.`aligCL`, npc.`aligCL`) AS `aligCL`,
IFNULL(u.`str`, npc.`str`) AS `str`,
IFNULL(u.`dex`, npc.`dex`) AS `dex`,
IFNULL(u.`rag`, npc.`rag`) AS `rag`,
IFNULL(u.`int`, npc.`int`) AS `int`,
IFNULL(u.`wis`, npc.`wis`) AS `wis`,
IFNULL(u.`inu`, npc.`inu`) AS `inu`,
IFNULL(u.`con`, npc.`con`) AS `con`,
IFNULL(u.`eng`, npc.`eng`) AS `eng`,
IFNULL(u.`exp`, npc.`exp`) AS `exp`,
IFNULL(u.hpc, bm.hpc) AS hpc,
IFNULL(u.mpc, bm.mpc) AS mpc,
u.hpt AS hpt,
u.mpt AS mpt,
u.bft AS bft,
IFNULL(u.bf, 100) as bf,
IFNULL(u.bfc, 100) as bfc,
u.add, u.cash, u.icon,
u.`maginq`, u.`mstadd`,
u.`profession`, u.`prof_exp`,
u.`pair`, u.`usercontext`,
u.battleid AS battleid_bound,
IFNULL(u.`mstp`, npc.`mstp`) AS `mstp`,
IFNULL(u.`msts`, npc.`msts`) AS `msts`,
IFNULL(u.`mstc`, npc.`mstc`) AS `mstc`,
IFNULL(u.`mstb`, npc.`mstb`) AS `mstb`,
IFNULL(u.`mst2`, npc.`mst2`) AS `mst2`,
IFNULL(u.`mst1`, npc.`mst1`) AS `mst1`,
IFNULL(u.`mst11`, npc.`mst11`) AS `mst11`,
IFNULL(u.`mstd`, npc.`mstd`) AS `mstd`,
IFNULL(u.`msth`, npc.`msth`) AS `msth`,
IFNULL(u.`magfire`, npc.`magfire`) AS `magfire`,
IFNULL(u.`magair`, npc.`magair`) AS `magair`,
IFNULL(u.`magwater`, npc.`magwater`) AS `magwater`,
IFNULL(u.`magearth`, npc.`magearth`) AS `magearth`,
IFNULL(u.`magblack`, npc.`magblack`) AS `magblack`,
IFNULL(u.`magwhite`, npc.`magwhite`) AS `magwhite`,
IFNULL(u.`maggray`, npc.`maggray`) AS `maggray`,
IFNULL(u.`magshaman`, npc.`magshaman`) AS `magshaman`,
IFNULL(u.effects, bm.effects) AS effects,
bm.wearro,
u.slots, u.petid,
u.partyid, u.partystamp,u.karma,u.class,
/*IFNULL(u.wear, npc.wear) AS wear,*/
IFNULL(u.w_ring1, npc.w_ring1) AS w_ring1,
IFNULL(u.w_ring2, npc.w_ring2) AS w_ring2,
IFNULL(u.w_ring3, npc.w_ring3) AS w_ring3,
IFNULL(u.w_earing, npc.w_earing) AS w_earing,
IFNULL(u.w_amulet, npc.w_amulet) AS w_amulet,
IFNULL(u.w_necklace, npc.w_necklace) AS w_necklace,
IFNULL(u.w_weapon1, npc.w_weapon1) AS w_weapon1,
IFNULL(u.w_weapon2, npc.w_weapon2) AS w_weapon2,
IFNULL(u.w_armor, npc.w_armor) AS w_armor,
IFNULL(u.w_helmet, npc.w_helmet) AS w_helmet,
IFNULL(u.w_bracers, npc.w_bracers) AS w_bracers,
IFNULL(u.w_gloves, npc.w_gloves) AS w_gloves,
IFNULL(u.w_belt, npc.w_belt) AS w_belt,
IFNULL(u.w_pants, npc.w_pants) AS w_pants,
IFNULL(u.w_boots, npc.w_boots) AS w_boots,
IFNULL(u.w_underhelmet, npc.w_underhelmet) AS w_underhelmet,
IFNULL(u.w_underarmor, npc.w_underarmor) AS w_underarmor,
IFNULL(u.w_underpants, npc.w_underpants) AS w_underpants,
IFNULL(u.w_underboots, npc.w_underboots) AS w_underboots,
IFNULL(u.w_overhelmet, npc.w_overhelmet) AS w_overhelmet,
IFNULL(u.w_overarmor, npc.w_overarmor) AS w_overarmor,
IFNULL(u.w_overpants, npc.w_overpants) AS w_overpants,
IFNULL(u.w_overboots, npc.w_overboots) AS w_overboots
FROM `haddanarc`.battlemember AS bm
LEFT JOIN session ON (bm.userid > 0 AND bm.userid=session.userid)
LEFT JOIN user AS u ON (bm.userid > 0 AND bm.userid=u.userid)
LEFT JOIN npc ON (bm.userid < 0 AND bm.userid=npc.npcid)
LEFT JOIN race r ON r.raceid=u.race OR r.raceid=npc.race
LEFT JOIN user_prop_str up ON up.userid=u.userid AND up.name='verdict'
LEFT JOIN clan_ranks cr ON u.clantitle=cr.uid
LEFT JOIN clan ON u.clan=clan.clanid
LEFT JOIN `haddanarc`.battle b ON b.battleid=bm.battleid
LEFT JOIN userreal ur ON u.ruid = ur.ruid
WHERE bm.memberid='484467585'
[error] => Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'ifnull'
[type] => 256
)