From 75c4cec67f42ca0c7baa80796c4cb85d29daad26 Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Tue, 17 Jun 2014 16:38:54 +0200 Subject: [PATCH] Bug 12438 - Bad encoding in acquisition basket We noticed a bad encoding (diacritics replaced by ) in acquisition basket when updating a server to Debian Wheezy. We found it comes from a query containing biblio.title twice. Maybe the mysql newer version creates this side-effect. Test plan : - Create an order on a record containing a diacritic in title - Look at the basket : cgi-bin/koha/acqui/basket.pl?basketno=x => Without the patch the record title is bad encoded (with ) => With this patch the record title is well encoded - Check also basket CSV export Signed-off-by: Paola Rossi --- C4/Acquisition.pm | 1 - 1 file changed, 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 2e013ac..4550dc2 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -1052,7 +1052,6 @@ sub GetOrders { SELECT biblio.*,biblioitems.*, aqorders.*, aqbudgets.*, - biblio.title, aqorders_transfers.ordernumber_from AS transferred_from, aqorders_transfers.timestamp AS transferred_from_timestamp FROM aqorders -- 1.7.10.4