Ran into the same thing described in the 1st post. My fix was to turn STRICT_TRANS_TABLES off in mysql, then the defaukt datetime worked. Apparently this is ony an issue in mysql 5.7 because this flag is now on by default whereas it was by default off in mysql 5.6
This is solved: all related to issues with mysql and datetime values "0000-00-00 00:00:00' which by default cause an error in mysql 5.7. P.S.: the fix is to turn STRICT_TRANS_TABLE off in mysql 5.7
I saw an older post on revisions A,B,C,..., AA, AB,AC,.... and so on instead of using numbers. Does anybody know how this can be accomplished? Also, I have often used X1,X2,X3,... for prototype revisions and other letters (skipping X,O and I) for production release revisions. It would be nice if some support for this were included. I'd even be happy to manually set this.
+1 here, too
Turns out in MySQL 5.7, the STRICT_TRANS_TABLES is turned on which causes it to reject the zero date. If this option is turned off, it works. Maybe something to consider in future versions
Uwe, thanks for this clue. In my installation there is still a problem: when I imported the original data tables, my version of mysql did not like the default date of "0000-00-00 00:00:00", I had tochange that. Turns out, when I try to add a user with an empty password expiration, classDMS tries to use this date and the call to the database to insert fails which results in "Access Denied". I hacked it for now by making the password expiration sometime in the year 2300 if I want non-expiring passwords,...
after installing seedDMS 5.0.11 I cannot create a new user. I get "Access Denied" from $dms->addUser(......), it does not return a new user. Presumeably it's access to the db. I have checked the db username and password, can't figure it out
Last one is solved. I am creating a new post for the user creation problem