[Koha-bugs] [Bug 17323] New: MySQL 5.7 - Column search_history.time cannot be null

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Sep 20 12:24:55 CEST 2016


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17323

            Bug ID: 17323
           Summary: MySQL 5.7 - Column search_history.time cannot be null
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Searching
          Assignee: gmcharlt at gmail.com
          Reporter: jonathan.druart at bugs.koha-community.org
        QA Contact: testopia at bugs.koha-community.org

When doing a search, with SearchHistory pref switched on:

DBD::mysql::st execute failed: Column 'time' cannot be null [for Statement "
        INSERT INTO search_history(
            userid, sessionid, query_desc, query_cgi, type, total, time
        ) VALUES(
            ?, ?, ?, ?, ?, ?, ?
        )
    " with ParamValues: 0="7874", 1='12338a0bd8da63e32c79ee84f8493a07',
2="kw,wrdl: d", 3='q=d', 4='biblio', 5=6104, 6=undef] at C4/Search/History.pm
line 34.
127.0.0.1 - - [20/Sep/2016:11:22:05 +0100] "GET
/cgi-bin/koha/opac-search.pl?q=d HTTP/1.1" 200 272867
"http://catalogue.koha-qa.vm/" "Mozilla/5.0 (X11; Linux x86_64; rv:45.0)
Gecko/20100101 Firefox/45.0"

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list