[Koha-bugs] [Bug 11391] New: suggestions.suggesteddate has a problematic default value

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Dec 13 01:54:21 CET 2013


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 at gmail.com
          Reporter: gmcharlt at gmail.com
        QA Contact: testopia at 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.


More information about the Koha-bugs mailing list