I get the following error when I try to update my CP.lua. It worked perfectly before the 1.8 -> 2.0 changes. However I think it may be the incredibly long decimal after 'stat_dodge_c' that's messing it up.

1265: Data truncated for column 'stat_dodge_c' at row 1

SQL:
INSERT INTO `roster_players` SET `name` = 'Mizak', `guild_id` = '1', `server` = 'Khadgar', `region` = 'US', `level` = '66', `sessionHK` = '0', `sessionCP` = '0', `yesterdayHK` = '0', `yesterdayContribution` = '0', `lifetimeHK` = '9314', `lifetimeHighestRank` = '6', `lifetimeRankname` = 'Knight', `honorpoints` = '9476', `arenapoints` = '0', `crit` = '10.77', `stat_int` = '76', `stat_int_c` = '154', `stat_int_b` = '78', `stat_int_d` = '0', `stat_agl` = '147', `stat_agl_c` = '351', `stat_agl_b` = '204', `stat_agl_d` = '0', `stat_sta` = '99', `stat_sta_c` = '307', `stat_sta_b` = '208', `stat_sta_d` = '0', `stat_str` = '57', `stat_str_c` = '70', `stat_str_b` = '13', `stat_str_d` = '0', `stat_spr` = '77', `stat_spr_c` = '77', `stat_spr_b` = '0', `stat_spr_d` = '0', `dodge` = '20.00', `parry` = '9.76', `block` = '0.00', `mitigation` = '29.28', `stat_armor` = '3567', `stat_armor_c` = '3597', `stat_armor_b` = '30', `stat_armor_d` = '0', `stat_def` = '324', `stat_def_c` = '324', `stat_def_b` = '0', `stat_def_d` = '0', `stat_block` = '0', `stat_block_c` = '0', `stat_block_b` = '0', `stat_block_d` = '0', `stat_parry` = '0', `stat_parry_c` = '0', `stat_parry_b` = '0', `stat_parry_d` = '0', `stat_defr` = '0', `stat_defr_c` = '0', `stat_defr_b` = '0', `stat_defr_d` = '0', `stat_dodge` = '24', `stat_dodge_c` = '25.5609755516', `stat_dodge_b` = '1.5609755516052', `stat_dodge_d` = '0', `stat_res_ranged` = '0', `stat_res_spell` = '0', `stat_res_melee` = '0', `res_holy` = '0', `res_holy_c` = '0', `res_holy_b` = '0', `res_holy_d` = '0', `res_frost` = '0', `res_frost_c` = '20', `res_frost_b` = '20', `res_frost_d` = '0', `res_arcane` = '0', `res_arcane_c` = '0', `res_arcane_b` = '0', `res_arcane_d` = '0', `res_fire` = '0', `res_fire_c` = '0', `res_fire_b` = '0', `res_fire_d` = '0', `res_shadow` = '0', `res_shadow_c` = '0', `res_shadow_b` = '0', `res_shadow_d` = '0', `res_nature` = '10', `res_nature_c` = '10', `res_nature_b` = '0', `res_nature_d` = '0', `melee_power` = '533', `melee_power_c` = '880', `melee_power_b` = '347', `melee_power_d` = '0', `melee_hit` = '0', `melee_hit_c` = '0', `melee_hit_b` = '0', `melee_hit_d` = '0', `melee_crit` = '55', `melee_crit_c` = '58.0662021637', `melee_crit_b` = '3.0662021636963', `melee_crit_d` = '0', `melee_haste` = '0', `melee_haste_c` = '0', `melee_haste_b` = '0', `melee_haste_d` = '0', `melee_crit_chance` = '10.77', `melee_power_dps` = '62.9', `melee_mhand_speed` = '3.50', `melee_mhand_dps` = '132.9', `melee_mhand_skill` = '324', `melee_mhand_mindam` = '416', `melee_mhand_maxdam` = '514', `melee_mhand_rating` = '324', `melee_mhand_rating_c` = '324', `melee_mhand_rating_b` = '0', `melee_mhand_rating_d` = '0', `melee_ohand_speed` = '0', `melee_ohand_dps` = '0', `melee_ohand_skill` = '0', `melee_ohand_mindam` = '0', `melee_ohand_maxdam` = '0', `melee_ohand_rating` = '0', `melee_ohand_rating_c` = '0', `melee_ohand_rating_b` = '0', `melee_ohand_rating_d` = '0', `melee_range_tooltip` = 'Main Hand\nAttack Speed (seconds): 3.50\nDamage: 416 - 514\nDamage per Second: 132.9', `melee_power_tooltip` = 'Increases damage with melee weapons by 62.9 damage per second.', `ranged_power` = '575', `ranged_power_c` = '943', `ranged_power_b` = '368', `ranged_power_d` = '0', `ranged_hit` = '0', `ranged_hit_c` = '0', `ranged_hit_b` = '0', `ranged_hit_d` = '0', `ranged_crit` = '55', `ranged_crit_c` = '58.0662021637', `ranged_crit_b` = '3.0662021636963', `ranged_crit_d` = '0', `ranged_haste` = '0', `ranged_haste_c` = '0', `ranged_haste_b` = '0', `ranged_haste_d` = '0', `ranged_crit_chance` = '15.81', `ranged_power_dps` = '41.1', `ranged_speed` = '2.04', `ranged_dps` = '164.8', `ranged_skill` = '325', `ranged_mindam` = '307', `ranged_maxdam` = '364', `ranged_rating` = '325', `ranged_rating_c` = '325', `ranged_rating_b` = '0', `ranged_rating_d` = '0', `ranged_range_tooltip` = 'Ranged\nAttack Speed (seconds): 2.04\nDamage: 307 - 364\nDamage per Second: 164.8', `ranged_power_tooltip` = 'Increases damage with ranged weapons by 41.1 damage per second.', `spell_hit` = '0', `spell_hit_c` = '0', `spell_hit_b` = '0', `spell_hit_d` = '0', `spell_crit` = '0', `spell_crit_c` = '0', `spell_crit_b` = '0', `spell_crit_d` = '0', `spell_haste` = '0', `spell_haste_c` = '0', `spell_haste_b` = '0', `spell_haste_d` = '0', `spell_crit_chance` = '5.71', `mana_regen` = '86', `mana_regen_cast` = '10', `spell_penetration` = '0', `spell_damage` = '0', `spell_healing` = '0', `spell_crit_chance_holy` = '5.71', `spell_crit_chance_frost` = '5.71', `spell_crit_chance_arcane` = '5.71', `spell_crit_chance_fire` = '5.71', `spell_crit_chance_shadow` = '5.71', `spell_crit_chance_nature` = '5.71', `spell_damage_holy` = '0', `spell_damage_frost` = '0', `spell_damage_arcane` = '0', `spell_damage_fire` = '0', `spell_damage_shadow` = '0', `spell_damage_nature` = '0', `talent_points` = '0', `money_c` = '41', `money_s` = '93', `money_g` = '438', `exp` = '1095:734100:1101150', `race` = 'Night Elf', `raceid` = '4', `raceEn` = 'NightElf', `class` = 'Hunter', `classid` = '3', `classEn` = 'HUNTER', `health` = '5954', `mana` = '4748', `power` = 'Mana', `sex` = 'Male', `sexid` = '0', `hearth` = 'Shattrath City', `dateupdatedutc` = '2007-07-28 03:06:20', `DBversion` = '2.0.0', `CPversion` = '2.1.1', `timeplayed` = '3051910', `timelevelplayed` = '3040', `maildateutc` = '2007-07-01 15:04:57', `clientLocale` = 'enUS', `member_id` = '279'

File: lib\dbal\mysql.php

Line: 202

I'm running Apache 2.2.4 with PHP 5.2.3 and MySQL 5.027. Let me know if you need more info.

*Note: Guild updates with password but character update fails.

SVN: 1223

That fixed it! Thanks Zeryl!