Duplicate entry swift error [Gaby]

[123456qwerty]

Hi guys

i am using akiix swift edit, But 1 have 1 problem, My database told me that i have a duplicate entry 65536


i did a little research and its not because there is already a id with same number, its because i am using small int in y items_base table but i cant set it 2 medium int my emulator will not startup then...

Anybody got a fix?

Gaby fixed it on retronet by some1 if u read this can u please tell me how

 

[Jaden]

Wrong Section. >_> run this query then restart ur emulator

SET @@global.sql_mode= '';

 

[Sledmore]

65536 is the maximum value of a small int, you need to increase the length (or change the type) of the `id` column in your `items` table. You will also need to change how the value is parsed in the emulator (if this is only `items_base` related, then find where the items load and use Convert.ToInt32()).