Affects Version/s: 2.0
Fix Version/s: 2.0
2.0 Upgrade (CRM/Upgrade/TwoZero/sql/others.mysql) has incorrect format value for the 'mailing' date type.
(@domain_id, 'mailing', 'Date and time. Used for scheduling mailings.', 0, 1, 15, 'Y M d H i'),
(@domain_id, 'mailing', 'Date and time. Used for scheduling mailings.', 0, 1, 15, 'Y M d h i A'),
NOTE: The 'custom' setting may also be incorrect as it has the same value and I don't think our Quickform date / time field supports that format:
(@domain_id, 'custom', 'Uses date range passed in by form field. Can pass in a posix date part parameter. Start and end offsets defined here are ignored.', 20, 20, 15, 'Y M d H i'),
— Original Post ----
See discussion at http://forum.civicrm.org/index.php/topic,3230.0.html
Dave G suggests this may be an issue with the date preference setting, but as this has affected several installs (as reported in thread) it may be that the preference setting has originated from defaults in the DB.