http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11391 Bug ID: 11391 Summary: suggestions.suggesteddate has a problematic default value Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt@gmail.com Reporter: gmcharlt@gmail.com QA Contact: testopia@bugs.koha-community.org Blocks: 7365 The column suggesteddate in the suggestions table is currently defined as "date NOT NULL default 0". When DBIx::Class translates that PostgreSQLese, it ends up as "date DEFAULT '0000-00-00' NOT NULL". Since 0000-00-00 is not a valid date, DBIC will fail to deploy the suggestions table to a Pg database. Since suggesteddate is supposed to be the date that the suggestion was submitted, CURRENT_DATE is a better default value regardless. -- You are receiving this mail because: You are watching all bug changes.