[Help] [MySql] Cant figure whats wrong with my code.

[Thesnowman]

Man it is 2 am, and i have been trying to figure out what happened to my code for the last 10 mins. I need another person lol because apparently my brain cant spot the problem.

Code:

INSERT INTO `spawns_monster` VALUES ('14978','21','10','0','0','1','6869.762207','100','3254.184326','0')
INSERT INTO `spawns_monster` VALUES ('14979','21','10','0','0','1','6866.338379','100','3249.192627','0')
INSERT INTO `spawns_monster` VALUES ('14980','22','10','0','0','1','6865.231445','100','3254.184326','0')
INSERT INTO `spawns_monster` VALUES ('14981','21','10','0','0','1','6869.762207','100','3237.349854','0')
INSERT INTO `spawns_monster` VALUES ('14982','21','10','0','0','1','6858.945801','100','3234.806396','0')
INSERT INTO `spawns_monster` VALUES ('14983','23','10','0','0','1','6853.384766','100','3236.025146','0')
INSERT INTO `spawns_monster` VALUES ('14984','21','10','0','0','1','6851.157227','100','3240.010010','0')
INSERT INTO `spawns_monster` VALUES ('14985','21','10','0','0','1','6851.973633','100','3245.625977','0')
INSERT INTO `spawns_monster` VALUES ('14986','22','10','0','0','1','6854.530273','100','3245.448730','0')
INSERT INTO `spawns_monster` VALUES ('14987','21','10','0','0','1','6855.030273','100','3240.855957','0')
INSERT INTO `spawns_monster` VALUES ('14988','21','10','0','0','1','6857.198242','100','3236.812988','0')
INSERT INTO `spawns_monster` VALUES ('14989','22','10','0','0','1','6858.084961','100','3232.843262','0')
INSERT INTO `spawns_monster` VALUES ('14990','21','10','0','0','1','6858.382324','100','3224.207275','0')
INSERT INTO `spawns_monster` VALUES ('14991','23','10','0','0','1','6862.466797','100','3254.184326','0')
INSERT INTO `spawns_monster` VALUES ('14992','21','10','0','0','1','6866.570801','100','3225.517090','0')
INSERT INTO `spawns_monster` VALUES ('14993','21','10','0','0','1','6868.207031','100','3230.241943','0')
INSERT INTO `spawns_monster` VALUES ('14994','97','10','0','0','1','7026.371094','100','3528.260498','0')
INSERT INTO `spawns_monster` VALUES ('14995','97','10','0','0','1','7024.630859','100','3537.393066','0')
INSERT INTO `spawns_monster` VALUES ('14996','97','10','0','0','1','7016.085938','100','3539.381348','0')
INSERT INTO `spawns_monster` VALUES ('14997','98','10','0','0','1','7011.758301','100','3552.139160','0')
INSERT INTO `spawns_monster` VALUES ('14998','97','10','0','0','1','7019.435547','100','3552.655029','0')
INSERT INTO `spawns_monster` VALUES ('14999','97','10','0','0','1','7026.847656','100','3550.917236','0')
INSERT INTO `spawns_monster` VALUES ('15000','97','10','0','0','1','7035.654297','100','3553.241455','0')
INSERT INTO `spawns_monster` VALUES ('15001','99','10','0','0','1','7031.339355','100','3559.363525','0')
INSERT INTO `spawns_monster` VALUES ('15002','97','10','0','0','1','7029.703613','100','3574.028809','0')
INSERT INTO `spawns_monster` VALUES ('15003','97','10','0','0','1','7041.129395','100','3571.523926','0')
INSERT INTO `spawns_monster` VALUES ('15004','98','10','0','0','1','7053.043457','100','3574.055664','0')
INSERT INTO `spawns_monster` VALUES ('15005','97','10','0','0','1','3574.055664','100','3575.656250','0')

Error:

[Err] 1064 - 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 'INSERT INTO `spawns_monster` VALUES ('14979','21','10','0','0','1','6866.338379'' at line 2
[Msg] Finished - Unsuccessfully

And if your asking how are my positions so big? well in game i push 9 and then open Position.txt and they are exactly like that.

But please help because im striking a blank.

 

[Thesnowman]

Re: [MySql] Cant figure whats wrong with my code.

But it accepted Lightnings Monster spawns perfectly.

here let me give u a example of his spawns.

INSERT INTO `spawns_monster` VALUES ('1', '20', '10', '10', '0', '0', '1', '7025.95', '100', '3399.46', '0');
INSERT INTO `spawns_monster` VALUES ('2', '20', '10', '10', '0', '0', '1', '7019.67', '100', '3411.92', '0');
INSERT INTO `spawns_monster` VALUES ('3', '20', '10', '10', '0', '0', '1', '7016.01', '100', '3402.98', '0');

Now i noticed that my code doesnt have the Semi colons at the end. I added them. Now when i execute i get a new problem.

Error:

[Err] 1136 - Column count doesn't match value count at row 1
[Msg] Finished - Unsuccessfully

Fixed

[Msg] Finished - 29 queries executed successfully

All i had to do is add a '10', after the '10',

Thanks.

 

[GlaphanKing]

Re: [MySql] Cant figure whats wrong with my code.

there are not the same number of columns for your table. check your table against your sql. that is the answer.

 

[Thesnowman]

Re: [MySql] Cant figure whats wrong with my code.

haha yeah noticed before u posted. Thanks tho galphan. haha edited the post above urs before u replied.