[GeorgeS]

I am still trying to fix the issue.

Regarding error "Old Edit gives 'Run time error '9' Subscript out of range' for any item."

This was fixed today. Field# exceeded variable declaration.

Now regarding the other more serious error. So we know that 'new edit' copy works fine, but fails if you save the copied item ~ around where it updates the "range" field.

Can you verify this assumption below?
if you save an original (not copied) item in new edit with no changes -- it works ok? but fails when saving the copied one?

BTW - I loaded in the latest schema and could not reproduce the error. Could be my version of mysql (mysql-5.0.77) that may be causing this, but still there has to be a reason why a simple query like UPDATE items SET range="0" WHERE id='1079' (it fails here everytime?)
fails???

This is weird and a real brain twister..
I'm on it and I'll let you know when I'm done

GeorgeS