[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

--- Comment #45 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Jonathan Druart from comment #42)
> 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.

See bug 22905, not related to this patchset.

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

Not sure what is that (need to do something?), but IIRC it already happened
before this patchset as well.

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