I know, magento doesn’t support Windows at the moment (...), but we have to reference the problems encountered.
I’ve the same error by adding a category:
Exception while saving the object: Mysqli statement execute error : Field 'options' doesn't have a default value
My config is:
Windows XP SP2
Apache 2.0.61 x86
If someone succeed to point out the problem…