From e3dea357665ea2989f38bb7aaf0f76bc15ac0c9e 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 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 Signed-off-by: Marcel de Rooy --- 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, } ); -- 1.7.10.4