Error
insert into tr_list select 0, p.PlayerID, p.TeamID, inet_aton(@IP), unix_timestamp(), @MPrice, 0, 0, 0, 0, 0, 0, 0, 0, '', p.Name_rus, p.Position, p.Combination, p.Skl, p.Age, p.Talent, p.Tck, p.Mrk, p.Drb, p.Rcv, p.Edu, p.Pas, p.Shp, p.Sha, p.Price, p.Salary, (select (group_concat(concat(' ',bt.SmallName_rus,b.Level))) from ut_bonuses b join ut_bonus_types bt on b.BonusID=bt.bonusid where b.playerid=p.playerid) as Bonuses, p.CountryID, cp.Name_rus, t.Name_rus, t.CountryID, ct.name_rus,null from ut_players p join ut_countries cp on cp.countryid=p.countryid join ut_teams t on t.teamid=p.teamid left outer join ut_countries ct on t.countryid=ct.countryid where playerid='185464'
Duplicate entry '0' for key 1
Вон че пишет, когда я хочу его на транс отправить!
ПРОВЕРЯЙТЕ!
Добавлено в (5th February 2008 - 06:51 PM):Цитата(Амир @ Feb 5 2008, 06:47 PM)

Error
insert into tr_list select 0, p.PlayerID, p.TeamID, inet_aton(@IP), unix_timestamp(), @MPrice, 0, 0, 0, 0, 0, 0, 0, 0, '', p.Name_rus, p.Position, p.Combination, p.Skl, p.Age, p.Talent, p.Tck, p.Mrk, p.Drb, p.Rcv, p.Edu, p.Pas, p.Shp, p.Sha, p.Price, p.Salary, (select (group_concat(concat(' ',bt.SmallName_rus,b.Level))) from ut_bonuses b join ut_bonus_types bt on b.BonusID=bt.bonusid where b.playerid=p.playerid) as Bonuses, p.CountryID, cp.Name_rus, t.Name_rus, t.CountryID, ct.name_rus,null from ut_players p join ut_countries cp on cp.countryid=p.countryid join ut_teams t on t.teamid=p.teamid left outer join ut_countries ct on t.countryid=ct.countryid where playerid='185464'
Duplicate entry '0' for key 1
Вон че пишет, когда я хочу его на транс отправить!
ПРОВЕРЯЙТЕ!
то же самое(