SiNeD21 Posted May 31, 2018 Report Share Posted May 31, 2018 (edited) Mi-am pus turfs in SF si LV dar imi da eroarea : column count doesn't match value count at row 1 INSERT INTO `turfs` (`ID`, `Owned`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES (1, 0, 12, 0, 0, '114.21', '-1364.93', '506.54', '-912.91'), (2, 0, 12, 0, 0, '506.54', '-1364.93', '899.25', '-912.91'), (3, 0, 12, 0, 0, '899.25', '-1313.70', '1313.58', '-912.91'), (4, 0, 12, 0, 0, '1313.58', '-1364.93', '1727.49', '-912.91'), (5, 0, 12, 0, 0, '1727.49', '-1364.93', '2108.13', '-912.91'), (6, 0, 12, 0, 0, '2108.13', '-1364.93', '2499.38', '-912.91'), (7, 0, 12, 0, 0, '2499.38', '-1313.70', '2916.17', '-912.91'), (8, 0, 12, 0, 0, '114.21', '-1821.03', '506.54', '-1364.93'), (9, 0, 12, 0, 0, '506.54', '-1821.03', '899.25', '-1364.93'), (10, 0, 12, 0, 0, '899.25', '-1721.90', '1313.58', '-1313.70'), (11, 0, 12, 0, 0, '1313.58', '-1821.03', '1727.49', '-1364.93'), (12, 0, 12, 0, 0, '1727.49', '-1821.03', '2108.13', '-1364.93'), (13, 0, 12, 0, 0, '2108.13', '-1821.03', '2499.38', '-1364.93'), (14, 0, 12, 0, 0, '2499.38', '-1737.65', '2916.17', '-1313.70'), (15, 0, 12, 0, 0, '899.25', '-2131.32', '1313.58', '-1721.90'), (16, 0, 12, 0, 0, '899.25', '-2489.99', '1313.58', '-2131.32'), (17, 0, 12, 0, 0, '1313.58', '-2250.92', '1727.49', '-1821.03'), (18, 0, 12, 0, 0, '1727.49', '-2250.92', '2108.13', '-1821.03'), (19, 0, 12, 0, 0, '2108.13', '-2250.92', '2499.38', '-1821.03'), (20, 0, 12, 0, 0, '2499.38', '-2172.41', '2916.17', '-1737.65'), (21, 0, 12, 0, 0, '1313.58', '-2690.47', '1727.49', '-2250.92'), (22, 0, 12, 0, 0, '1727.49', '-2690.47', '2108.13', '-2250.92'), (23, 0, 12, 0, 0, '2108.13', '-2690.47', '2499.38', '-2250.92'), (24, 0, 12, 0, 0, '2499.38', '-2567.91', '2916.17', '-2172.41'), (25, 0, 12, 0, 0, '1114.47', '2444.49', '1478.16', '2901.03'), (26, 0, 12, 0, 0, '1478.16', '2444.49', '1828.16', '2901.03'), (27, 0, 12, 0, 0, '1828.16', '2444.49', '2150.16', '2901.03'), (28, 0, 12, 0, 0, '2150.16', '2444.49', '2528.16', '2901.03'), (29, 0, 12, 0, 0, '2528.16', '2444.49', '2878.16', '2901.03'), (30, 0, 12, 0, 0, '901.16', '1980.34', '1307.16', '2444.49'), (31, 0, 12, 0, 0, '1307.16', '1980.34', '1677.16', '2444.49'), (32, 0, 12, 0, 0, '1677.16', '1980.34', '2076.16', '2444.49'), (33, 0, 12, 0, 0, '2076.16', '1980.34', '2482.00', '2444.49'), (34, 0, 12, 0, 0, '2482.00', '1980.34', '2878.16', '2444.49'), (35, 0, 12, 0, 0, '901.16', '1528.09', '1307.16', '1980.34'), (36, 0, 12, 0, 0, '1307.16', '1528.09', '1677.16', '1980.34'), (37, 0, 12, 0, 0, '1677.16', '1528.09', '2076.16', '1980.34'), (38, 0, 12, 0, 0, '2076.16', '1528.09', '2482.00', '1980.34'), (39, 0, 12, 0, 0, '2482.00', '1528.09', '2878.16', '1980.34'), (40, 0, 12, 0, 0, '901.16', '1074.90', '1307.16', '1528.09'), (41, 0, 12, 0, 0, '1307.16', '1074.90', '1677.16', '1528.09'), (42, 0, 12, 0, 0, '1677.16', '1074.90', '2076.16', '1528.09'), (43, 0, 12, 0, 0, '2076.16', '1074.90', '2482.00', '1528.09'), (44, 0, 12, 0, 0, '2482.00', '1074.90', '2878.16', '1528.09'), (45, 0, 12, 0, 0, '1307.16', '663.83', '1677.16', '1074.90'), (46, 0, 12, 0, 0, '1677.16', '663.83', '2076.16', '1074.90'), (47, 0, 12, 0, 0, '2076.16', '663.83', '2482.00', '1074.90'), (48, 0, 12, 0, 0, '2482.00', '663.83', '2878.16', '1074.90'); Edited May 31, 2018 by SiNeD21 Quote Link to comment Share on other sites More sharing options...
0 AlwaysGoLl Posted June 1, 2018 Report Share Posted June 1, 2018 Pai mai ai turfuri care au valoarea 1 adica (1, 0, 12, 0, 0, '114.21', '-1364.93', '506.54', '-912.91'), prima litera din paranteza a mai fost folosita odata... Quote Link to comment Share on other sites More sharing options...
0 SiNeD21 Posted June 15, 2018 Author Report Share Posted June 15, 2018 @AlwaysGoLl Adica? Quote Link to comment Share on other sites More sharing options...
Question
SiNeD21
Mi-am pus turfs in SF si LV dar imi da eroarea : column count doesn't match value count at row 1
INSERT INTO `turfs` (`ID`, `Owned`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
Edited by SiNeD21(1, 0, 12, 0, 0, '114.21', '-1364.93', '506.54', '-912.91'),
(2, 0, 12, 0, 0, '506.54', '-1364.93', '899.25', '-912.91'),
(3, 0, 12, 0, 0, '899.25', '-1313.70', '1313.58', '-912.91'),
(4, 0, 12, 0, 0, '1313.58', '-1364.93', '1727.49', '-912.91'),
(5, 0, 12, 0, 0, '1727.49', '-1364.93', '2108.13', '-912.91'),
(6, 0, 12, 0, 0, '2108.13', '-1364.93', '2499.38', '-912.91'),
(7, 0, 12, 0, 0, '2499.38', '-1313.70', '2916.17', '-912.91'),
(8, 0, 12, 0, 0, '114.21', '-1821.03', '506.54', '-1364.93'),
(9, 0, 12, 0, 0, '506.54', '-1821.03', '899.25', '-1364.93'),
(10, 0, 12, 0, 0, '899.25', '-1721.90', '1313.58', '-1313.70'),
(11, 0, 12, 0, 0, '1313.58', '-1821.03', '1727.49', '-1364.93'),
(12, 0, 12, 0, 0, '1727.49', '-1821.03', '2108.13', '-1364.93'),
(13, 0, 12, 0, 0, '2108.13', '-1821.03', '2499.38', '-1364.93'),
(14, 0, 12, 0, 0, '2499.38', '-1737.65', '2916.17', '-1313.70'),
(15, 0, 12, 0, 0, '899.25', '-2131.32', '1313.58', '-1721.90'),
(16, 0, 12, 0, 0, '899.25', '-2489.99', '1313.58', '-2131.32'),
(17, 0, 12, 0, 0, '1313.58', '-2250.92', '1727.49', '-1821.03'),
(18, 0, 12, 0, 0, '1727.49', '-2250.92', '2108.13', '-1821.03'),
(19, 0, 12, 0, 0, '2108.13', '-2250.92', '2499.38', '-1821.03'),
(20, 0, 12, 0, 0, '2499.38', '-2172.41', '2916.17', '-1737.65'),
(21, 0, 12, 0, 0, '1313.58', '-2690.47', '1727.49', '-2250.92'),
(22, 0, 12, 0, 0, '1727.49', '-2690.47', '2108.13', '-2250.92'),
(23, 0, 12, 0, 0, '2108.13', '-2690.47', '2499.38', '-2250.92'),
(24, 0, 12, 0, 0, '2499.38', '-2567.91', '2916.17', '-2172.41'),
(25, 0, 12, 0, 0, '1114.47', '2444.49', '1478.16', '2901.03'),
(26, 0, 12, 0, 0, '1478.16', '2444.49', '1828.16', '2901.03'),
(27, 0, 12, 0, 0, '1828.16', '2444.49', '2150.16', '2901.03'),
(28, 0, 12, 0, 0, '2150.16', '2444.49', '2528.16', '2901.03'),
(29, 0, 12, 0, 0, '2528.16', '2444.49', '2878.16', '2901.03'),
(30, 0, 12, 0, 0, '901.16', '1980.34', '1307.16', '2444.49'),
(31, 0, 12, 0, 0, '1307.16', '1980.34', '1677.16', '2444.49'),
(32, 0, 12, 0, 0, '1677.16', '1980.34', '2076.16', '2444.49'),
(33, 0, 12, 0, 0, '2076.16', '1980.34', '2482.00', '2444.49'),
(34, 0, 12, 0, 0, '2482.00', '1980.34', '2878.16', '2444.49'),
(35, 0, 12, 0, 0, '901.16', '1528.09', '1307.16', '1980.34'),
(36, 0, 12, 0, 0, '1307.16', '1528.09', '1677.16', '1980.34'),
(37, 0, 12, 0, 0, '1677.16', '1528.09', '2076.16', '1980.34'),
(38, 0, 12, 0, 0, '2076.16', '1528.09', '2482.00', '1980.34'),
(39, 0, 12, 0, 0, '2482.00', '1528.09', '2878.16', '1980.34'),
(40, 0, 12, 0, 0, '901.16', '1074.90', '1307.16', '1528.09'),
(41, 0, 12, 0, 0, '1307.16', '1074.90', '1677.16', '1528.09'),
(42, 0, 12, 0, 0, '1677.16', '1074.90', '2076.16', '1528.09'),
(43, 0, 12, 0, 0, '2076.16', '1074.90', '2482.00', '1528.09'),
(44, 0, 12, 0, 0, '2482.00', '1074.90', '2878.16', '1528.09'),
(45, 0, 12, 0, 0, '1307.16', '663.83', '1677.16', '1074.90'),
(46, 0, 12, 0, 0, '1677.16', '663.83', '2076.16', '1074.90'),
(47, 0, 12, 0, 0, '2076.16', '663.83', '2482.00', '1074.90'),
(48, 0, 12, 0, 0, '2482.00', '663.83', '2878.16', '1074.90');
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.