Bugzilla – Attachment 120775 Details for
Bug 26995
Drop column relationship from borrower tables
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 26995: Fix SQL syntax error on the about page
Bug-26995-Fix-SQL-syntax-error-on-the-about-page.patch (text/plain), 1.34 KB, created by
Jonathan Druart
on 2021-05-10 12:28:20 UTC
(
hide
)
Description:
Bug 26995: Fix SQL syntax error on the about page
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2021-05-10 12:28:20 UTC
Size:
1.34 KB
patch
obsolete
>From 58abe3a7a9c68495dc1af0f9dd6c2db2cc945ec2 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Mon, 10 May 2021 14:27:58 +0200 >Subject: [PATCH] Bug 26995: Fix SQL syntax error on the about page > >--- > about.pl | 8 ++------ > 1 file changed, 2 insertions(+), 6 deletions(-) > >diff --git a/about.pl b/about.pl >index 992bc771f40..a814acc88f5 100755 >--- a/about.pl >+++ b/about.pl >@@ -496,17 +496,13 @@ $template->param( 'bad_yaml_prefs' => \@bad_yaml_prefs ) if @bad_yaml_prefs; > { > my $dbh = C4::Context->dbh; > my ($bad_relationships_count) = $dbh->selectall_arrayref(q{ >- SELECT COUNT(*) >- FROM ( >- SELECT relationship FROM borrower_relationships WHERE relationship='_bad_data' >+ SELECT COUNT(*) FROM borrower_relationships WHERE relationship='_bad_data' > }); > > $bad_relationships_count = $bad_relationships_count->[0]->[0]; > > my $existing_relationships = $dbh->selectall_arrayref(q{ >- SELECT DISTINCT(relationship) >- FROM ( >- SELECT relationship FROM borrower_relationships WHERE relationship IS NOT NULL >+ SELECT DISTINCT(relationship) FROM borrower_relationships WHERE relationship IS NOT NULL > }); > > my %valid_relationships = map { $_ => 1 } split( /,|\|/, C4::Context->preference('borrowerRelationship') ); >-- >2.20.1
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 26995
:
115532
|
115533
|
115534
|
115537
|
115538
|
115539
|
120399
|
120400
|
120451
|
120452
|
120453
|
120744
|
120745
|
120746
| 120775 |
120793
|
120826