I must say, not that VuFind needs by no means to have its honor defended -- it's on it way to be a perfect solution -- like, mentioned with Demian, this “bug” was one of those not relevant at all as that date wasn’t used elsewhere (sorting) than now with Public List browse (VUFIND-443
Also, like mentioned with Demian, if that helps others that need the solution right away, when found that bug last night tried to solve it (and did... but not in the conventional way):
$this->created = date('Y-m-d H:i:s');
but it did not work!
My solution: back to basics (DB): MySQL Administrator does not accept NOW() or any other default value than a constant, so:
~ MySQLAdministrator-1.jpg (attached file) ~
TIMESTAMP instead of DATETIME and default value set to CURRENT_TIMESTAMP ! >> it works! See the last record (id=10):
~ MySQLAdministrator-2.jpg (attached file) ~
Patch: mysql alter command should do it.
Mysql command line it seems to accept “now()”
“ALTER TABLE user_list MODIFY COLUMN created DATETIME NOT NULL DEFAULT now();”
so it can be kept as DATETIME.