From d26b3591b1da9f4eab2555f142b88a6f703c578e Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 20 Apr 2016 20:37:13 +0000 Subject: [PATCH] Bug 16317 - Attempt to share private list results in error When sharing a private list, the the receiver of the share link will get the following error when they are logged in and try to click the link: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'sharedate desc' in 'order clause' at /home/koha/kohaclone/Koha/Objects.pm line 150 Test Plan: 1) Create a private list 2) Share that list to another account 3) Log in as the other account 4) Click the link in the email you recieved 5) Note the error 6) Apply this patch 7) Click the link again 8) You should see no error and be able to view the list! Signed-off-by: Owen Leonard Signed-off-by: Marcel de Rooy Signed-off-by: Brendan Gallagher (cherry picked from commit ce47345c21930074a4ebf79f658d4a43b8944f6c) Signed-off-by: Julian Maurice --- opac/opac-shareshelf.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/opac/opac-shareshelf.pl b/opac/opac-shareshelf.pl index 2c788ce12c..b2f5c8b668 100755 --- a/opac/opac-shareshelf.pl +++ b/opac/opac-shareshelf.pl @@ -138,7 +138,7 @@ sub show_accept { shelfnumber => $param->{shelfnumber}, }, { - order_by => 'sharedate desc', + order_by => { -desc => 'sharedate' }, limit => 1, } ); -- 2.20.1