From aa0136d7cb527296f783fbef2a3b8f0b28f39150 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 20 Apr 2016 20:37:13 +0000 Subject: [PATCH] [SIGNED-OFF] Bug 16317 - Attempt to share private list results in error Content-Type: text/plain; charset="utf-8" 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 --- 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