Çözüldü Rehber Serisi Sql 1265 Error

Bu konu çözüme ulaştırılmıştır. Çözüm için konuya yazılan tüm yorumları okumayı unutmayın. Eğer konudaki yorumlar sorununuzu çözmediyse yeni bir konu açabilirsiniz.
Durum
İçerik kilitlendiği için mesaj gönderimine kapatıldı.

McDynamic

MT Üye
MT Üye
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
 
Durum
İçerik kilitlendiği için mesaj gönderimine kapatıldı.
Geri