Bug 11675: check allocated total correctly when editing a fund that has a parent...
authorJonathan Druart <jonathan.druart@biblibre.com>
Tue, 4 Feb 2014 11:15:42 +0000 (12:15 +0100)
committerKyle M Hall <kyle@bywatersolutions.com>
Fri, 6 Jun 2014 13:14:12 +0000 (09:14 -0400)
commit3d1598e2ec1eca14173382735f800faa3b30188e
tree6816b433d0e701362ea5c34c31d0d19791865fa0
parent5e172f3915877dcef54275421dddd0633cc13251
Bug 11675: check allocated total correctly when editing a fund that has a parent fund

The sth was created before the query.
The query was modified after the sth creation and an error was raised.

Test plan:
0/ Don't apply the patch
1/ Create a budget A (amount=1000)
2/ Create a fund A1 (amount=1000)
3/ Create a child fund A11 (amount=1000)
4/ Edit A11 and change the amount to 2000
You are able to do it, an error appears in the Koha log:
  "check_parent_total.pl: DBD::mysql::st execute failed: called with 2 bind
  variables when 1 are needed"
5/ Apply the patch, edit A11 and save. You get an error
6/ Edit A11 and change the amount to <=1000
7/ Verify that there is no regression on adding/removing/editing budgets
and funds.

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Passes all tests and QA script.
Works as described, no regressions found.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
(cherry picked from commit 331ca7df3ec351a83982496bed7f103050e89af5)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit 098ffcdd9ad10307ab63ea49b05c474263561992)
admin/check_parent_total.pl