[Koha-patches] [PATCH] [SIGNED-OFF] Bug: 5547 - corrected insert to database

[Katrin Fischer]

From: Mark Gavillet <mark.gavillet at ptfs-europe.com>

Inserting a new category failed because only 10 bind variables were present and 11 were required.

Signed-off-by: Katrin Fischer <Katrin.Fischer.83 at web.de>
---
 admin/categorie.pl |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/admin/categorie.pl b/admin/categorie.pl
index d0211fd..576d7ca 100755
--- a/admin/categorie.pl
+++ b/admin/categorie.pl
@@ -133,7 +133,7 @@ if ($op eq 'add_form') {
             $sth->execute(map { $input->param($_) } ('description','enrolmentperiod','enrolmentperioddate','upperagelimit','dateofbirthrequired','enrolmentfee','reservefee','hidelostitems','overduenoticerequired','category_type','categorycode'));
             $sth->finish;
         } else {
-            my $sth=$dbh->prepare("INSERT INTO categories  (categorycode,description,enrolmentperiod,enrolmentperioddate,upperagelimit,dateofbirthrequired,enrolmentfee,reservefee,hidelostitems,overduenoticerequired,category_type) values (?,?,?,?,?,?,?,?,?,?)");
+            my $sth=$dbh->prepare("INSERT INTO categories  (categorycode,description,enrolmentperiod,enrolmentperioddate,upperagelimit,dateofbirthrequired,enrolmentfee,reservefee,hidelostitems,overduenoticerequired,category_type) values (?,?,?,?,?,?,?,?,?,?,?)");
             $sth->execute(map { $input->param($_) } ('categorycode','description','enrolmentperiod','enrolmentperioddate','upperagelimit','dateofbirthrequired','enrolmentfee','reservefee','hidelostitems','overduenoticerequired','category_type'));
             $sth->finish;
         }
-- 
1.7.1