Just searched around and it appears your MYSQL is set to strict mode. See this thread here:
http://www.zen-cart.com/forum/showthread.php?t=63993
Turn strict mode off by editing your my.ini file like the poster in this thread did. That should fix the problem.
Bookmarks