From 3a5b977e0a279c233fec0c273a1cd8a7312eeba4 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! --- 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 2c788ce..b2f5c8b 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.1.4