[Koha-bugs] [Bug 4461] Context-sensitive report a problem screen

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #140 from David Nind <david at davidnind.com> ---
Also, the results from Comment 139 were from testing with koha-testing-dock and
starting with ku (Koha using MySQL 5.5).

If I test with ku-mdb (MariaDB) then I get different problems. With
KohaAdminEmailAddress set and a library email address set I get this error
message when submitting a problem report "[#% We really should avoid reaching
this! %] Something wrong happened when sending the report. Please contact your
library."

Something has happened since I originally tested, as I didn't have this problem
then.

This is the error in the plack-error.log after submitting the problem report in
the OPAC (using MariaDB):

36 DBD::mysql::st execute failed: Incorrect datetime value:
'current_timestamp()' for column `koha_kohadev`.`problem_reports`.`created_on` 
   at row 1 [for Statement "INSERT INTO `problem_reports` ( `borrowernumber`,
`branchcode`, `content`, `created_on`, `problempage`, `reci    pient`, `title`,
`username`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0="51",
1='CPL', 2="Test 145", 3='current_timestamp()    ',
4="http://kohadev.myDNSname.org:8080/", 5="admin", 6="Test 145", 7='koha'] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
37 DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect datetime value:
'current_timestamp()' for column `koha_kohadev`.`problem_reports`.   
`created_on` at row 1 at /kohadevbox/koha/Koha/Object.pm line 164
38 Something wrong happened when sending the report problem: Invalid value
passed, problem_reports.created_on=current_timestamp() expected     type is
datetime at /kohadevbox/koha/opac/opac-reportproblem.pl line 131.

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