Bugzilla – Attachment 3734 Details for
Bug 5547
A "hidelostitems" option for the staff client
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Fix for inserting new database record
0425-Bug-5547-corrected-insert-to-database.patch (text/plain), 1.66 KB, created by
Mark G
on 2011-04-06 10:40:11 UTC
(
hide
)
Description:
Fix for inserting new database record
Filename:
MIME Type:
Creator:
Mark G
Created:
2011-04-06 10:40:11 UTC
Size:
1.66 KB
patch
obsolete
>From 990a952a3d9aec0143086f8eb31504d71b49e412 Mon Sep 17 00:00:00 2001 >From: Mark Gavillet <mark.gavillet@ptfs-europe.com> >Date: Wed, 6 Apr 2011 11:19:21 +0100 >Subject: [PATCH] Bug: 5547 - corrected insert to database > >Inserting a new category failed because only 10 bind variables were present and 11 were required. >--- > 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.5.6.5 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 5547
:
3466
|
3734
|
3739