Have 1 problem stats keep adding 1 bot to rankings always any idea's why?
I've also tried using both v1.4B117 & github v1.4B120
Also getting loads of errors:
L 06/30/2013 - 10:17:27: SourceMod error session started
L 06/30/2013 - 10:17:27: Info (map "c1m1_hotel") (file "errors_20130630.log")
L 06/30/2013 - 10:17:27: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players S' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 5 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 5 WHERE steamid = 'e + playtime_versus + playtime_realism ")
L 06/30/2013 - 10:17
9: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e + playtime_versus + playtim'' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 6 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 6 WHERE steamid = 'e + playtime_versus + playtim'")
L 06/30/2013 - 10:17:49: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_scavenge_survivors + points_scavenge_infected + points_realism_survivors + points_realism_infected + points_mutations FROM players")
L 06/30/2013 - 10:18:25: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 20 WHERE steamid = '= ''' ")
L 06/30/2013 - 10:18:25: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 20 WHERE steamid = '= ''' ")
L 06/30/2013 - 10:18:25: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 20 WHERE steamid = '= ''' ")
L 06/30/2013 - 10:18:25: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 20 WHERE steamid = '= ''' ")
L 06/30/2013 - 10:18:52: [l4d_stats.smx] GetClientRankMute failed! Reason: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
L 06/30/2013 - 10:19:10: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE players SET points_mutations = points_mutations + 12 WHERE steamid = 'rs ' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 12 WHERE steamid = 'rs SET infected_spawn_2 = infected_spawn_2 + 1 WHERE steamid = 'UPDATE players SET points_mutations = points_mutations + 12 WHERE steamid = 'rs SET infected_spawn_2 = in'")
L 06/30/2013 - 10:19:22: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players S' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 2 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 2 WHERE steamid = 'e + playtime_versus + playtime_realism ")
L 06/30/2013 - 10:21:55: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players S' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 8 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 8 WHERE steamid = 'e + playtime_versus + playtime_realism ")
L 06/30/2013 - 10:23
2: Error log file session closed.
L 06/30/2013 - 10:24:40: SourceMod error session started
L 06/30/2013 - 10:24:40: Info (map "c1m2_streets") (file "errors_20130630.log")
L 06/30/2013 - 10:24:40: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE players SET points_mutations = points_mutations + 3 WHERE steamid = 'rs S' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 3 WHERE steamid = 'rs SET infected_spawn_3 = infected_spawn_3 + 1 WHERE steamid = 'UPDATE players SET points_mutations = points_mutations + 3 WHERE steamid = 'rs SET infected_sp'")
L 06/30/2013 - 10:26
8: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e + playtime_versus + playtim'' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 1 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 1 WHERE steamid = 'e + playtime_versus + playtim'")
L 06/30/2013 - 10:27
1: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 0, award_charger = award_charger + 1 WHERE steamid = 'points + 5, award_protect = award_protect + 1 WHERE steamid = '''")
L 06/30/2013 - 10:27
1: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 1 WHERE steamid = '= '''")
L 06/30/2013 - 10:29:24: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 23 WHERE steamid = '= '''")
L 06/30/2013 - 10
0:25: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 3 WHERE steamid = '= '''")
L 06/30/2013 - 10
0:25: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 17 WHERE steamid = '= '''")
L 06/30/2013 - 10
0:44: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'time_versus + playtime_realism + playtime_survival + playtime_scU'' at line 1 (Query: "UPDATE players SET infected_boomer_vomits = infected_boomer_vomits + 1 WHERE steamid = 'time_versus + playtime_realism + playtime_survival + playtime_scUPDATE players SET infected_boomer_vomits = infected_boomer_vomits + 1 WHERE steamid = 'time_versus + p")
L 06/30/2013 - 10
1:04: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'oints_infected + points_realism + points_survival + points_scavenge_survivors + ' at line 1 (Query: "UPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_scaveUPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_")
L 06/30/2013 - 10
1:06: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'oints_infected + points_realism + points_survival + points_scaveUPDATE players S' at line 1 (Query: "UPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_scaveUPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_")
L 06/30/2013 - 10
1:14: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 14 WHERE steamid = '= ''' ")
L 06/30/2013 - 10
1:14: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 14 WHERE steamid = '= ''' ")
L 06/30/2013 - 10
1:14: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 14 WHERE steamid = '= ''' ")
L 06/30/2013 - 10
1:15: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 14 WHERE steamid = '= ''' ")
L 06/30/2013 - 10
3
7: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 (Query: "UPDATE players SET points = points + 0, award_charger = award_charger + 1 WHERE steamid = 'points + 4, award_protect = award_protect + 1 WHERE steamid = '''")