Hi all, I just wanted to let you know that I had the same problem (TVs not being saved) and disabling MySQL strict Mode solved it.
My environment is:
- IIS6 (Windows 2003)
- PHP 5.2.5
- MySQL 5.0.45
- MODx 0.9.6.1 new install
- No autocomplete
- No WYSIWYG editors
I experimented with the SQL Mode configuration. I noticed that if the TV had a value (saved when not in MySQL strict mode) and then set the strict mode I could still change the value of the TV given that I didn’t leave it blank. As soon as I clear the value of the TV and save it I can not set any other value for it until I disable the strict mode.
I hope this helps the developers and if you need more information about this issue i’d be glad to help.
