trickerytrickery Posted August 5, 2018 Share Posted August 5, 2018 (edited) I can Import the table without problem, however it seems it cant fit key´s in right. (thus i cant really edit it afterwards) '\xEA\xB2\x8C\xED\x8E\x 9C...' for column 'INFO' at row 1 ERROR 1366 (HY000): Incorrect integer value Worked like a charm 2 Years Ago (Last Server), what happened here? #Edit 1 Found out that the Korean Names of the Geffen Magic Tournament Mobs seem to caused atleast one of this Errors However "Still no „unique“) column" #Edit 2 Ive just added the unique key ALTER TABLE `mob_skill_db_re` ADD UNIQUE (`MOB_ID`) To Test it, breaks it ofc since the unique is MOB_ID and it cant use more then one per mob, but now it works so its def. the unique key Soo, i guess i have to create another column just for a unique key ? Why guys, why ? Edited August 5, 2018 by trickerytrickery Quote Link to comment Share on other sites More sharing options...
I can Import the table without problem, however it seems it cant fit key´s in right. (thus i cant really edit it afterwards)
'\xEA\xB2\x8C\xED\x8E\x 9C...' for column 'INFO' at row 1
ERROR 1366 (HY000): Incorrect integer value
Worked like a charm 2 Years Ago (Last Server), what happened here?
#Edit 1
Found out that the Korean Names of the Geffen Magic Tournament Mobs seem to caused atleast one of this Errors
However "Still no „unique“) column"
#Edit 2
Ive just added the unique key
ALTER TABLE `mob_skill_db_re` ADD UNIQUE (`MOB_ID`)
To Test it, breaks it ofc since the unique is MOB_ID and it cant use more then one per mob, but now it works
so its def. the unique key
Soo, i guess i have to create another column just for a unique key ?
Why guys, why ?
Edited by trickerytrickeryLink to comment
Share on other sites