Çözüldü Rehber Serisi Sql 1265 Error

McDynamic · 25 Temmuz 2020

skill_proto da takılıyor içi tamamen boş hata şu şekilde;

Kod:

[SQL] Query player start
[ERR] 1265 - Data truncated for column 'setAffectFlag' at row 1
[ERR]
INSERT INTO `refine_proto` VALUES ('337', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('338', '30052', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '75');
INSERT INTO `refine_proto` VALUES ('339', '30046', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('340', '30056', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '65');
INSERT INTO `refine_proto` VALUES ('341', '30025', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('342', '30058', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '55');
INSERT INTO `refine_proto` VALUES ('343', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7500', '0', '0', '100');
INSERT INTO `refine_proto` VALUES ('344', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25000', '0', '0', '85');
INSERT INTO `refine_proto` VALUES ('346', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('347', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '65000', '0', '0', '75');
INSERT INTO `refine_proto` VALUES ('348', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('349', '30061', '2', '30193', '2', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '65');
INSERT INTO `refine_proto` VALUES ('350', '30088', '2', '30193', '4', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('351', '30019', '2', '30193', '8', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '55');
INSERT INTO `refine_proto` VALUES ('352', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3000', '0', '0', '100');
INSERT INTO `refine_proto` VALUES ('353', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('354', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('355', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('357', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60000', '0', '0', '55');
INSERT INTO `refine_proto` VALUES ('358', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('359', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '55');
INSERT INTO `refine_proto` VALUES ('360', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '55');
INSERT INTO `refine_proto` VALUES ('400', '30194', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '49');
INSERT INTO `refine_proto` VALUES ('401', '30192', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '38');
INSERT INTO `refine_proto` VALUES ('501', '70253', '2', '70254', '2', '0', '0', '0', '0', '0', '0', '50000000', '0', '0', '100');
INSERT INTO `refine_proto` VALUES ('502', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '100');
INSERT INTO `refine_proto` VALUES ('503', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '140000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('504', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '170000', '0', '0', '85');
INSERT INTO `refine_proto` VALUES ('505', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('506', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '240000', '0', '0', '75');
INSERT INTO `refine_proto` VALUES ('507', '30050', '2', '0', '0', '0', '0', '0', '0', '0', '0', '290000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('508', '30083', '2', '27992
[ERR] 1265 - Data truncated for column 'setAffectFlag' at row 1
[ERR]
INSERT INTO `skill_proto` VALUES ('108', 0xC6F8B7DAB0DD, '4', '1', '1', '0', 'HP', '-(50 + 5*lv + (12*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '40+180*k', '', '', '10', '-(50 + 5*lv + (12*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '', 'ATTACK', '', 'NONE', '', '', '', '', '', '', '40+180*k', '0', '0', 'MAGIC', '7', '0.8', '2500', '0');
INSERT INTO `skill_proto` VALUES ('109', 0xC1A4BEF7C0CE, '4', '1', '1', '0', 'HP', '200+4*lv+(10*iq+6*mwep+number(600,800))*k', '40+200*k', '', '', '10', '200+4*lv+(10*iq+6*mwep+number(600,800))*k', '', 'REMOVE_BAD_AFFECT,PARTY', '', 'NONE', '20+80*k', '0', '', '', '', '', '40+200*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('110', 0xC4E8BCD3, '4', '1', '1', '0', 'MOV_SPEED', '5 + 35*k', '60+120*k', '60+100*k', '', '10', '5 + 35*k', '', 'PARTY', 'KWAESOK', 'CASTING_SPEED', '3+33*k', '60+100*k', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('111', 0xC1F5B7C2BCFA, '4', '1', '1', '0', 'ATT_GRADE', '5+(iq*0.2 +15)*k', '60+120*k', '60+100*k', '', '10', '5+(iq*0.2 +15)*k', '', 'PARTY', 'JEUNGRYEOK', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('121', 0xC5EBBCD6B7C2, '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('122', 0xBFACB0E8B1E2, '0', '1', '2', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('124', 0xC3A4B1A4BCFA, '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('125', 0xBAAFBDC5, '0', '1', '40', '0', 'NONE', '', '', '10+1000*k', '', '', '', '', 'DISABLE_BY_POINT_UP', 'YMIR', 'NONE', '', '', 'YMIR', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('126', 0xBDC5BCF6BEEE, '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('127', 0xC3B5C1B6BEEE, '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('128', 0xC1F8B3EBBEEE, '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('129', 0xB5D0B0A9BCFA, '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', 'NONE', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('130', 0xBDC2B8B6, '0', '1', '1', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('131', 0xB8BBBCD2C8AF, '0', '1', '10', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('137', 0xB3ADB9AB, '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '5-(4*k)', '', '', 'ATTACK,USE_MELEE_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '10', '1', '300', '0');
INSERT INTO `skill_proto` VALUES ('138', 0xB5B9B0DD, '5', '1', '1', '52', 'HP', '-(2.4*(200+1.5*lv)+(3*200*k))', '60+120*k', '', '', '15', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH_LONG', '', 'MOV_SPEED', '50', '5', '', '', '', '', '', '0', '0', 'MELEE', '6', '1', '400', '100');
INSERT INTO `skill_proto` VALUES ('139', 0xC5BBC3E2, '5', '1', '1', '55', 'HP', '-(2*(200+1.5*lv)+
[SQL] Finished with error

McDynamic · 25 Temmuz 2020

Konu kilitlenebilir. sorunun çözümünü bilmiyorum açıkçası .tgz olarak direk aktardım sorun çıkmadı sadece sürükleyince bu sorun çıkıyor.

Ara

Çözüldü Rehber Serisi Sql 1265 Error

McDynamic

MT Üye

McDynamic

MT Üye

Benzer konular