Thread: StatsLab12
View Single Post
Old 08-13-2011, 08:19 PM   #64
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,927
I tried loading the new files I uploaded, like half of them work fine but some of them have an error, I reuploaded the games.mysql.sql file but it still shows the error when I try to load it:

Loading games.mysql.sql
... 1000 queries executed
... 2000 queries executed
... 3000 queries executed
... 4000 queries executed
... 5000 queries executed
... 6000 queries executed
... 7000 queries executed
... 8000 queries executed
... 9000 queries executed
... 10000 queries executed
... 11000 queries executed
... 12000 queries executed
... 13000 queries executed
insert into `games` VALUES (1, 103, 191, 198, 5685, "2011-3-31", 1800, 0, 1, 0, 9, 4, 1, 9, 3, 2, 0, 31905, 24215, 32250, 31905, 24215); -> Duplicate entry '1' for key 'PRIMARY'
insert into `games` VALUES (2, 103, 196, 194, 5413, "2011-3-31", 1835, 0, 1, 0, 9, 1, 3, 7, 8, 0, 0, 30308, 31031, 33580, 31031, 30308); -> Duplicate entry '2' for key 'PRIMARY'
insert into `games` VALUES (3, 103, 189, 192, 5710, "2011-3-31", 1835, 0, 1, 0, 9, 0, 3, 1, 5, 0, 1, 32720, 30551, 26035, 30551, 32720); -> Duplicate entry '3' for key 'PRIMARY'
insert into `games` VALUES (4, 103, 197, 195, 5576, "2011-3-31", 1900, 0, 1, 0, 9, 3, 4, 8, 9, 1, 1, 31185, 25992, 18853, 25992, 31185); -> Duplicate entry '4' for key 'PRIMARY'
insert into `games` VALUES (5, 103, 193, 187, 6160, "2011-3-31", 1905, 0, 1, 0, 9, 11, 2, 15, 7, 0, 1, 35120, 27006, 0, 35120, 27006); -> Duplicate entry '5' for key 'PRIMARY'
insert into `games` VALUES (6, 103, 190, 188, 5587, "2011-3-31", 1905, 0, 1, 0, 9, 1, 5, 9, 6, 0, 0, 31680, 27181, 0, 27181, 31680); -> Duplicate entry '6' for key 'PRIMARY'
insert into `games` VALUES (7, 103, 191, 198, 1954, "2011-4-1", 1800, 0, 1, 0, 9, 5, 2, 6, 4, 0, 1, 19207, 19553, 32250, 33208, 19553); -> Duplicate entry '7' for key 'PRIMARY'
insert into `games` VALUES (8, 103, 196, 194, 3014, "2011-4-1", 1835, 0, 1, 0, 10, 5, 6, 12, 12, 0, 1, 35148, 25903, 0, 30769, 31399); -> Duplicate entry '8' for key 'PRIMARY'
insert into `games` VALUES (9, 103, 190, 188, 2925, "2011-4-1", 1835, 0, 1, 0, 10, 1, 2, 6, 6, 0, 1, 33296, 30840, 0, 27612, 33568); -> Duplicate entry '9' for key 'PRIMARY'
insert into `games` VALUES (10, 103, 189, 192, 3115, "2011-4-1", 1835, 0, 1, 0, 9, 3, 10, 7, 9, 2, 2, 30194, 23193, 0, 23193, 30194); -> Duplicate entry '10' for key 'PRIMARY'
insert into `games` VALUES (11, 103, 197, 195, 3065, "2011-4-1", 1900, 0, 1, 0, 11, 5, 6, 11, 12, 0, 1, 31310, 26544, 0, 32636, 27497); -> Duplicate entry '11' for key 'PRIMARY'
insert into `games` VALUES (12, 103, 193, 187, 3073, "2011-4-1", 1905, 0, 1, 0, 9, 2, 10, 5, 10, 0, 0, 27636, 30478, 0, 30478, 27636); -> Duplicate entry '12' for key 'PRIMARY'
insert into `games` VALUES (13, 103, 191, 198, 3195, "2011-4-2", 1300, 0, 1, 0, 9, 5, 3, 12, 8, 2, 0, 19207, 23145, 32250, 31908, 23145); -> Duplicate entry '13' for key 'PRIMARY'
insert into `games` VALUES (14, 103, 196, 194, 3212, "2011-4-2", 1305, 0, 1, 0, 9, 5, 3, 9, 5, 1, 0, 25022, 27861, 25903, 30778, 32695); -> Duplicate entry '14' for key 'PRIMARY'
insert into `games` VALUES (15, 103, 193, 187, 3409, "2011-4-2", 1305, 0, 1, 0, 9, 7, 3, 14, 8, 0, 1, 32098, 22880, 0, 32098, 23276); -> Duplicate entry '15' for key 'PRIMARY'
insert into `games` VALUES (16, 103, 189, 192, 3441, "2011-4-2", 1335, 0, 1, 0, 9, 18, 6, 18, 9, 0, 3, 24427, 26037, 0, 24427, 26037); -> Duplicate entry '16' for key 'PRIMARY'
insert into `games` VALUES (17, 103, 190, 188, 3315, "2011-4-2", 1835, 0, 1, 0, 9, 1, 9, 4, 10, 1, 1, 26863, 26173, 0, 26173, 26863); -> Duplicate entry '17' for key 'PRIMARY'
insert into `games` VALUES (18, 103, 197, 195, 3319, "2011-4-2", 1900, 0, 1, 0, 9, 2, 4, 6, 9, 1, 1, 25073, 32637, 31310, 23548, 31233); -> Duplicate entry '18' for key 'PRIMARY'
insert into `games` VALUES (19, 103, 191, 198, 3230, "2011-4-3", 1300, 0, 1, 0, 9, 2, 4, 4, 10, 0, 0, 32261, 19377, 28569, 23272, 32261); -> Duplicate entry '19' for key 'PRIMARY'
insert into `games` VALUES (20, 103, 196, 194, 2982, "2011-4-3", 1305, 0, 1, 0, 9, 7, 1, 12, 7, 0, 0, 24700, 26128, 0, 24700, 26128); -> Duplicate entry '20' for key 'PRIMARY'
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote