ok so it looks like what appears to be simple sql fails. Can you try and see which of these work?
Code:
UPDATE items SET range="0" WHERE id='1079'
UPDATE items SET range='0' WHERE id='1079'
One thing I can tell is that by the time range fails, many other fields using this query work, so it could boil down to the field struct - or something similar
Later
GeorgeS