Description: ------------ In forms (built with html_quickform); updating the mysql database with dataobjects methods : 1) fields of type YEAR in MYSQL are handled incorrectly and end up the the database with a default of 1970 A fix was proposed by Alan Knowles : quote : can you try adding this to Generator.php - in the big switch case section. case 'YEAR': $type = DB_DATAOBJECT_INT; break; end quote : THIS DOES WORK 2) TIMESTAMP : the issue sounds more complex here although the same fix as above but for TIMESTAMP helps to some extent. A single TIMESTAMP field should be automatically updated to the current unix timestamp (except in some situations) the normal mysql behaviour should be for example UPDATE `table` SET `last_update` = NOW('00000000000000') while DatabaseObject replaces it by UPDATE `table` SET `last_update` = '00000000000000' which is the wrong behaviour. Thanks Paul Windey

This bug has been fixed in CVS. In case this was a documentation problem, the fix will show up at the end of next Sunday (CET) on pear.php.net. In case this was a pear.php.net website problem, the change will show up on the website in short time. Thank you for the report, and for helping us make PEAR better. see release notes for next release = timestamps are ignored for insert/update .. - if you really need to set them manually - use query()