Page 1 of 1

SQL Server Files - Fixed animation type for WS-type JAs Git

Posted: Mon Jan 04, 2016 4:30 pm
by xelloss
This file was changed a few days ago so not sure if this is only affecting me or if it's a general problem. I can't update the server SQL since 30 Dec 2015 because of abilities.sql file changes.

Navicat says die:

[Err] 1264 - Out of range value for column 'range' at row 1
[Err] INSERT INTO `abilities` VALUES ('98', 'corsairs_roll', '17', '5', '1', '60', '193', '420', '0', '114', '2000', '6', '8.0', '1', '1', '80', '0', '8','TOAU');
INSERT INTO `abilities` VALUES ('99', 'puppet_roll', '17', '52', '1', '60', '193', '420', '0', '115', '2000', '6', '8.0', '1', '1', '80', '0', '8','TOAU');
INSERT INTO `abilities` VALUES ('100', 'dancers_roll', '17', '61', '1', '60', '193', '420', '0', '167', '2000', '6', '8.0', '1', '1', '80', '0', '8','WOTG');
INSERT INTO `abilities` VALUES ('101', 'scholars_roll', '17', '64', '1', '60', '193', '420', '0', '168', '2000', '6', '8.0', '1', '1', '80', '0', '8','WOTG');
INSERT INTO `abilities` VALUES ('107', 'double-up', '17', '5', '1', '8', '194', '424', '0', '116', '2000', '6', '8.0', '0', '1', '80', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('108', 'quick_draw', '17', '40', '1', '199', '0', '0', '0', '0', '2000', '6', '18.0', '0', '0', '0', '1410', '0','TOAU');
INSERT INTO `abilities` VALUES ('109', 'fire_shot', '17', '40', '4', '60', '195', '110', '0', '125', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('110', 'ice_shot', '17', '40', '4', '60', '195', '110', '0', '126', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('111', 'wind_shot', '17', '40', '4', '60', '195', '110', '0', '127', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('112', 'earth_shot', '17', '40', '4', '60', '195', '110', '0', '128', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('113', 'thunder_shot', '17', '40', '4', '60', '195', '110', '0', '129', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('114', 'water_shot', '17', '40', '4', '60', '195', '110', '0', '130', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('115', 'light_shot', '17', '40', '4', '60', '195', '0', '0', '123', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('116', 'dark_shot', '17', '40', '4', '60', '195', '0', '0', '124', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('117', 'random_deal', '17', '50', '1', '1200', '196', '0', '0', '131', '2000', '6', '20.0', '1', '1', '300', '1414', '0','TOAU');
INSERT INTO `abilities` VALUES ('119', 'overdrive', '18', '0', '1', '3600', '0', '0', '0', '143', '2000', '6', '20.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('120', 'activate', '18', '1', '1', '1200', '205', '0', '0', '83', '2000', '6', '20.0', '0', '1', '80', '1478', '0','TOAU');
INSERT INTO `abilities` VALUES ('121', 'repair', '18', '15', '1', '180', '206', '0', '0', '83', '2000', '6', '18.0', '0', '0', '0', '1480', '0','TOAU');
INSERT INTO `abilities` VALUES ('122', 'deploy', '18', '1', '4', '10', '207', '0', '0', '83', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('123', 'deactivate', '18', '1', '1', '60', '208', '0', '0', '83', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('124', 'retrieve', '18', '10', '1', '10', '209', '0', '0', '83', '2000', '6', '18.0', '0', '0', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('125', 'fire_maneuver', '18', '1', '1', '10', '210', '0', '0', '333', '2000', '6', '18.0', '0', '1', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('126', 'ice_maneuver', '18', '1', '1', '10', '210', '0', '0', '333', '2000', '6', '18.0', '0', '1', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('127', 'wind_maneuver', '18', '1', '1', '10', '210', '0', '0', '333', '2000', '6', '18.0', '0', '1', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('128', 'earth_maneuver', '18', '1', '1', '10', '210', '0', '0', '333', '2000', '6', '18.0', '0', '1', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUES ('129', 'thunder_maneuver', '18', '1', '1', '10', '210', '0', '0', '333', '2000', '6', '18.0', '0', '1', '0', '0', '0','TOAU');
INSERT INTO `abilities` VALUE
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Re: SQL Server Files - Fixed animation type for WS-type JAs

Posted: Mon Jan 04, 2016 7:27 pm
by whasf
Pull from master again, I fixed it.

Thank you for the report!

Re: SQL Server Files - Fixed animation type for WS-type JAs

Posted: Mon Jan 04, 2016 8:21 pm
by xelloss
Thanks. Wasn't sure since it had been a few days so posted here instead of on git. Figured if someone else was having a build issue it would've already been reported. Must just be the holiday slumps.

Re: SQL Server Files - Fixed animation type for WS-type JAs

Posted: Mon Jan 04, 2016 8:23 pm
by kjLotus
it actually runs fine through mysql on its own, its just navicat that complained (which is why I didn't catch it, I don't use a sql workbench )