Hi, afetr having had the same problem today today and coming acroos this post i did some more looking and came up with a solution that worked for me.
info came from here
https://www.liquidweb.com/kb/how-to-disable-mysql-strict-m...
Step 1: shutdown opensim console
step 2: go to mysql folder C:\ProgramData\MySql\MySql server 5.7\My.ini
step3: under heading [mysqld] look for #set the sql mode to strict
step4: find sql-mode="no-engine-substition,strict-trans-tables"
step5:replace with sql-mode=""
step6:save file then RESTART PC
step7:run opensim
step8:rezzed animals out and set the names etc...
step9:restart console
and its now working fine for me
hope this helps..
regards
kawolf