[Koha-bugs] [Bug 5770] Email librarian when purchase suggestion made

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

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

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart at bugs.koha-c
                   |                            |ommunity.org

--- Comment #42 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
When approving a pending suggestion, nothing happens. In the logs there are two
errors:

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`suggestions`, CONSTRAINT
`suggestions_ibfk_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches`
(`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE) [for Statement "UPDATE
`suggestions` SET `STATUS` = ?, `acceptedby` = ?, `accepteddate` = ?,
`branchcode` = ?, `managedby` = ?, `manageddate` = ? WHERE ( `suggestionid` = ?
)" with ParamValues: 0="ACCEPTED", 1="51", 2='2019-05-14T15:34:15',
3="__ANY__", 4="51", 5='2019-05-14T15:34:15', 6="3"] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.

No suggestions ASKED letter transported by email at
/home/vagrant/kohaclone/C4/Letters.pm line 608.

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