How i can fix this?

MySQL Query Error 'Out of range value adjusted for column 'remainingTime' at row 1' for query 'INSERT INTO buffs (charid,skillid,skilllvl,abilityType1,ability1,abilityType2,ability2,abilityType3,ability3,remainingTime) VALUES (664,8,20,34,****0,0,0,0,-40000)'


i need to fix xDD

plz:P:

Quote:

---

Originally Posted by Johnatan28

MySQL Query Error 'Out of range value adjusted for column 'remainingTime' at row 1' for query 'INSERT INTO buffs (charid,skillid,skilllvl,abilityType1,ability1,abilityType2,ability2,abilityType3,ability3,remainingTime) VALUES (664,8,20,34,****0,0,0,0,-40000)'


i need to fix xDD

plz:P:

---

not an expert at flyff stuff but it seems thats Negative 40000 and it should be positive how the rules are setup in the sql it wont take that so try to remove the - from infront of it

MySQL Query Error 'Out of range value adjusted for column 'remainingTime' at row 1' for query 'INSERT INTO buffs (charid,skillid,skilllvl,abilityType1,ability1,abi lityType2,ability2,abilityType3,ability3,remaining Time) VALUES (664,8,20,34,****0,0,0,0,-40000)'

-40000 (NEGATIVE)

Change it into

40000 (POSITIVE)