]> git.koha-community.org Git - koha.git/log
koha.git
14 years agoTranslated & to & in xmlrecord
David Birmingham [Wed, 2 Dec 2009 21:23:07 +0000 (16:23 -0500)]
Translated & to & in xmlrecord

If the homebranch tag had an & in its name, then the XML wouldn't parse
correctly.  As a result, if XSLT was turned on, "No copies available" would
always be displayed.

14 years agoBug 3784: Don't fail on opac-detail.pl with invalid biblionumber
Frédéric Demians [Wed, 2 Dec 2009 15:04:49 +0000 (16:04 +0100)]
Bug 3784: Don't fail on opac-detail.pl with invalid biblionumber

14 years agocorrect DBrev
Galen Charlton [Wed, 2 Dec 2009 11:29:39 +0000 (06:29 -0500)]
correct DBrev

Signed-off-by: Galen Charlton <gmcharlt@gmail.com>
14 years agoRenumber DB updates from merge
Galen Charlton [Wed, 2 Dec 2009 02:07:48 +0000 (21:07 -0500)]
Renumber DB updates from merge

Signed-off-by: Galen Charlton <gmcharlt@gmail.com>
14 years agoMerge commit 'koha-biblibre/master' into bl-acq
Galen Charlton [Wed, 2 Dec 2009 02:01:33 +0000 (21:01 -0500)]
Merge commit 'koha-biblibre/master' into bl-acq

14 years agoBug Fixing additem : branchcode unwilling changes
Henri-Damien LAURENT [Thu, 26 Nov 2009 20:53:50 +0000 (21:53 +0100)]
Bug Fixing additem : branchcode unwilling changes

branchcode was unconditionnally changed to user branch when editing an item

14 years agofixing version update
Paul Poulain [Thu, 26 Nov 2009 16:13:08 +0000 (17:13 +0100)]
fixing version update

14 years agodbRev 130 : CAS System preference
Henri-Damien LAURENT [Wed, 25 Nov 2009 11:18:44 +0000 (12:18 +0100)]
dbRev 130 : CAS System preference

Upgrade updatedatabase.pl and kohaversion

14 years agoMerge branch 'MT1105' into public_master
Henri-Damien LAURENT [Wed, 25 Nov 2009 11:16:05 +0000 (12:16 +0100)]
Merge branch 'MT1105' into public_master

14 years agoMT 2050, Follow-up, Fast Cataloging
Matthias Meusburger [Mon, 23 Nov 2009 13:44:51 +0000 (14:44 +0100)]
MT 2050, Follow-up, Fast Cataloging

Adds granular permissions for cataloging
Also adds a link from the circulation home to fast cataloging when fast cataloging is active

14 years agobulkmarcimport.pl Bug Fix matching biblios enhanced
Henri-Damien LAURENT [Mon, 23 Nov 2009 20:40:13 +0000 (21:40 +0100)]
bulkmarcimport.pl Bug Fix matching biblios enhanced

matching biblios is now also getting biblioitemnumber so that Items management can be performed

14 years agofollowup da49fc77df9 enh 3736
Henri-Damien LAURENT [Mon, 23 Nov 2009 20:35:07 +0000 (21:35 +0100)]
followup da49fc77df9 enh 3736

14 years agohaspermission signature had changed
Henri-Damien LAURENT [Mon, 23 Nov 2009 16:05:55 +0000 (17:05 +0100)]
haspermission signature had changed

14 years agoRemove ticket parameter from auto added hidden fields.
Matthias Meusburger [Thu, 7 May 2009 14:18:07 +0000 (16:18 +0200)]
Remove ticket parameter from auto added hidden fields.
(Normal login directly after a failed CAS login didn't work previously to this removal)

14 years agoAdded debug mode for CAS warn messages
Matthias Meusburger [Thu, 7 May 2009 14:10:09 +0000 (16:10 +0200)]
Added debug mode for CAS warn messages

14 years agoAdd missing return when CAS user is invalid
Matthias Meusburger [Thu, 7 May 2009 13:11:44 +0000 (15:11 +0200)]
Add missing return when CAS user is invalid

14 years agoSecond CAS version : CAS and non-CAS login can coexist
Henri-Damien LAURENT [Mon, 23 Nov 2009 15:26:35 +0000 (16:26 +0100)]
Second CAS version : CAS and non-CAS login can coexist

Conflicts solved :

C4/Auth.pm
opac/opac-main.pl

14 years agoAdd a syspref for CAS logout
Matthias Meusburger [Tue, 5 May 2009 15:23:05 +0000 (17:23 +0200)]
Add a syspref for CAS logout

14 years agoMoved CAS configuration from config file to sysprefs
Matthias Meusburger [Thu, 30 Apr 2009 09:04:21 +0000 (11:04 +0200)]
Moved CAS configuration from config file to sysprefs

14 years agoFirst CAS version : when CAS is enabled, login through CAS is mandatory
Henri-Damien LAURENT [Mon, 23 Nov 2009 15:21:37 +0000 (16:21 +0100)]
First CAS version : when CAS is enabled, login through CAS is mandatory

Conflicts solved C4/Auth.pm

14 years ago(bug #3802) fix branch deletion checks
Nahuel ANGELINETTI [Mon, 23 Nov 2009 09:20:00 +0000 (10:20 +0100)]
(bug #3802) fix branch deletion checks

This fix checks that are done when a branch is deleted, and the message shown.
Now it check for borrowers and items attached to the deleted branch.

14 years ago(bug #3801) fix itemtype administration
Nahuel ANGELINETTI [Mon, 23 Nov 2009 08:38:33 +0000 (09:38 +0100)]
(bug #3801) fix itemtype administration

This delete all code related to renewals allowed in itemtype administration.

14 years agomore SQL fixes. Installer now works fine with french & unimarc
Paul Poulain [Fri, 20 Nov 2009 17:28:14 +0000 (18:28 +0100)]
more SQL fixes. Installer now works fine with french & unimarc

14 years agofixing strings (for new acq module) & syspref translations to french
Paul Poulain [Fri, 20 Nov 2009 17:23:44 +0000 (18:23 +0100)]
fixing strings (for new acq module) & syspref translations to french

14 years agosome installer fixes
Paul Poulain [Fri, 20 Nov 2009 16:11:38 +0000 (17:11 +0100)]
some installer fixes

* 2 descriptions not translated to french
* 2 SQL errors (missing , and duplicated syspref)

14 years agoMT 2309, Follow-up : Display item location codes in item adding
Henri-Damien LAURENT [Thu, 19 Nov 2009 22:47:50 +0000 (23:47 +0100)]
MT 2309, Follow-up : Display item location codes in item adding

Conflicts solved cataloguing/additem.pl

14 years agoMT 2051, Follow-up : Fixing typo in granular permissions for guided reports
Matthias Meusburger [Thu, 19 Nov 2009 11:05:15 +0000 (12:05 +0100)]
MT 2051, Follow-up : Fixing typo in granular permissions for guided reports

14 years agoMT1883 : Serials enddate was not cleanly used
Henri-Damien LAURENT [Wed, 11 Nov 2009 11:00:18 +0000 (12:00 +0100)]
MT1883 : Serials enddate was not cleanly used

GetExpirationDate should now be used only to get the NEXT expirationdate based on startdate
Perltidying C4/Serials.pm

14 years agoUpdateDatabase more fixes
Henri-Damien LAURENT [Tue, 10 Nov 2009 21:19:51 +0000 (22:19 +0100)]
UpdateDatabase more fixes

14 years agooups, sorry, fixing mistake in previous patch
Paul Poulain [Tue, 10 Nov 2009 17:32:07 +0000 (18:32 +0100)]
oups, sorry, fixing mistake in previous patch

(reverting a not related and probably bogus change)

14 years agorevamping a little opac-detail for subscription (adding more history information)
Paul Poulain [Tue, 10 Nov 2009 17:28:53 +0000 (18:28 +0100)]
revamping a little opac-detail for subscription (adding more history information)

14 years agoMT1644 : Added HTML Escape on ocoins to prevent unintentional tag ending
Matthias Meusburger [Fri, 13 Nov 2009 16:35:10 +0000 (17:35 +0100)]
MT1644 : Added HTML Escape on ocoins to prevent unintentional tag ending

14 years agoAdd JQuery tablesorters on serials-edit and booksellers
Matthias Meusburger [Fri, 13 Nov 2009 16:11:49 +0000 (17:11 +0100)]
Add JQuery tablesorters on serials-edit and booksellers

14 years agoMT 2050 : Fast cataloging
Matthias Meusburger [Tue, 10 Nov 2009 11:08:57 +0000 (12:08 +0100)]
MT 2050 : Fast cataloging

14 years agoadding SUDOC history to XSLT (fields 955$r and $9)
Paul Poulain [Tue, 10 Nov 2009 19:55:22 +0000 (20:55 +0100)]
adding SUDOC history to XSLT (fields 955$r and $9)

14 years agoMT 2040, Follow-up : Dropdown list for languages in opac
Matthias Meusburger [Mon, 9 Nov 2009 09:30:08 +0000 (10:30 +0100)]
MT 2040, Follow-up : Dropdown list for languages in opac

14 years ago(bug #3655) fix news language detection
Nahuel ANGELINETTI [Wed, 23 Sep 2009 12:56:44 +0000 (14:56 +0200)]
(bug #3655) fix news language detection

This patch improve the language detection for news in opac. If the user have no defined language in his browser.
Mergefix

14 years agoBug Fixing : C4/Acquisition.pm
Henri-Damien LAURENT [Thu, 19 Nov 2009 21:54:41 +0000 (22:54 +0100)]
Bug Fixing : C4/Acquisition.pm

Updating ModStatus to ModSuggestion

14 years agofollowup finishreceive.pl
Henri-Damien LAURENT [Thu, 19 Nov 2009 16:34:27 +0000 (17:34 +0100)]
followup finishreceive.pl

14 years agofollowup 73de4a2e3f39f22d7049d224f516d4f26ac00560
Henri-Damien LAURENT [Thu, 19 Nov 2009 16:08:47 +0000 (17:08 +0100)]
followup 73de4a2e3f39f22d7049d224f516d4f26ac00560

Some merge problems occured

14 years ago(bug #3728) fix mandatory select fields
Nahuel ANGELINETTI [Thu, 22 Oct 2009 14:43:49 +0000 (16:43 +0200)]
(bug #3728) fix mandatory select fields

this fix marc editor for "select" mandatory fields that koha don't take care atm.

14 years ago(bug #3655) fix news language detection
Nahuel ANGELINETTI [Wed, 23 Sep 2009 12:56:44 +0000 (14:56 +0200)]
(bug #3655) fix news language detection

This patch improve the language detection for news in opac. If the user have no defined language in his browser.

14 years ago(bug #3674) allow users creation with disabled password
Nahuel ANGELINETTI [Tue, 29 Sep 2009 09:19:07 +0000 (11:19 +0200)]
(bug #3674) allow users creation with disabled password

14 years agoMT 2298 : Fix hidelostitems
Henri-Damien LAURENT [Thu, 19 Nov 2009 08:33:20 +0000 (09:33 +0100)]
MT 2298 : Fix hidelostitems

This patch fixes the opac search, and C4::Search to take care about hidelostitems for items, and not records.

Conflicts solved C4/Search.pm

14 years ago2298 2299 : Search.pm and opac-search.pl
Henri-Damien LAURENT [Mon, 9 Nov 2009 14:36:28 +0000 (15:36 +0100)]
2298 2299 : Search.pm and opac-search.pl

Removing filter available and hidelostitems at Biblio level

14 years agoSubscription add Updating Online Help file
Henri-Damien LAURENT [Fri, 6 Nov 2009 07:56:06 +0000 (08:56 +0100)]
Subscription add Updating Online Help file

14 years ago[followup](bug #3550) fix opensearch with subtitle
Nahuel ANGELINETTI [Fri, 6 Nov 2009 15:47:39 +0000 (16:47 +0100)]
[followup](bug #3550) fix opensearch with subtitle

14 years ago(bug #3778) GetBranchesLoop and searchMyLibraryFirst
Nahuel ANGELINETTI [Mon, 9 Nov 2009 08:38:25 +0000 (09:38 +0100)]
(bug #3778) GetBranchesLoop and searchMyLibraryFirst

This fix GetBranchesLoop, if searchmylibraryfirst is disabled, getbranchesloop mustn't select any branch.

14 years ago(bug #3783) fix marcurls
Nahuel ANGELINETTI [Thu, 12 Nov 2009 16:00:50 +0000 (17:00 +0100)]
(bug #3783) fix marcurls

this permit to have multiples urls in one field

14 years agoMT 2309 : Display item location codes in item adding
Matthias Meusburger [Tue, 17 Nov 2009 15:12:17 +0000 (16:12 +0100)]
MT 2309 : Display item location codes in item adding

14 years ago(bug #3791) overduerules and numeric categorycodes
Nahuel ANGELINETTI [Wed, 18 Nov 2009 09:02:40 +0000 (10:02 +0100)]
(bug #3791) overduerules and numeric categorycodes

this fix overduesrules.pl when library have numeric category codes.

14 years agoBZ2222 : db definition for frameworkcode in auth_subfield_structure incorrect
Henri-Damien LAURENT [Tue, 17 Nov 2009 20:41:13 +0000 (21:41 +0100)]
BZ2222 : db definition for frameworkcode in auth_subfield_structure incorrect

db definition for frameworkcode was only varchar(8)
corected to 10

14 years agoMT 1059 : Records merging
Matthias Meusburger [Mon, 16 Nov 2009 16:44:33 +0000 (17:44 +0100)]
MT 1059 : Records merging

Give the user the ability to merge two records, one being kept and the other deleted.
Selection of the records to merge can be done from virtualshelves.

14 years agofixing image link
Paul Poulain [Tue, 17 Nov 2009 16:12:37 +0000 (17:12 +0100)]
fixing image link

(removes a warn in apache log)

14 years agoreindenting and removing tmpl_if in doc-head-close
Paul Poulain [Tue, 17 Nov 2009 16:05:20 +0000 (17:05 +0100)]
reindenting and removing tmpl_if in doc-head-close

14 years agoacquisition BasketGroup Bug Fix : wrong script parameter
Henri-Damien LAURENT [Tue, 17 Nov 2009 16:41:40 +0000 (17:41 +0100)]
acquisition BasketGroup Bug Fix : wrong script parameter

14 years agoDate management update Suggestions
Henri-Damien LAURENT [Tue, 17 Nov 2009 15:11:10 +0000 (16:11 +0100)]
Date management update Suggestions

14 years agoFollowup database update ca0b6596eaf
Henri-Damien LAURENT [Tue, 17 Nov 2009 14:18:35 +0000 (15:18 +0100)]
Followup database update ca0b6596eaf

14 years ago(MT 1970) fix javascript
Nahuel ANGELINETTI [Fri, 13 Nov 2009 12:43:48 +0000 (13:43 +0100)]
(MT 1970) fix javascript

This fix javascript to add a supplemental issue that was broken.

14 years ago(bug #3786) fix items edition menu
Nahuel ANGELINETTI [Mon, 16 Nov 2009 14:45:57 +0000 (15:45 +0100)]
(bug #3786) fix items edition menu

This re-allow the user to go back to normal/isbd/marc view when he's in items edition page

14 years ago(bug #3787) update unimarc leader plugin,fix xhtml and design
Nahuel ANGELINETTI [Mon, 16 Nov 2009 15:27:55 +0000 (16:27 +0100)]
(bug #3787) update unimarc leader plugin,fix xhtml and design

14 years agofixing who and when the suggestion is done
Paul Poulain [Tue, 17 Nov 2009 14:56:00 +0000 (15:56 +0100)]
fixing who and when the suggestion is done

14 years agoreindenting
Paul Poulain [Tue, 17 Nov 2009 14:07:29 +0000 (15:07 +0100)]
reindenting

14 years agoAdding a test in C4::Charset in UNIMARC_Encoding
Henri-Damien LAURENT [Fri, 13 Nov 2009 15:38:49 +0000 (16:38 +0100)]
Adding a test in C4::Charset in UNIMARC_Encoding

14 years agoBetter conformance for UNIMARC Authorities Encoding
Henri-Damien LAURENT [Thu, 12 Nov 2009 15:13:22 +0000 (16:13 +0100)]
Better conformance for UNIMARC Authorities Encoding

encoding is on 8th character and not 9th

14 years ago[3.2.x](bug #3623) Alternative 2 pages layout for hte PDF
Jean-André Santoni [Fri, 13 Nov 2009 11:33:17 +0000 (12:33 +0100)]
[3.2.x](bug #3623) Alternative 2 pages layout for hte PDF

This new template shows the order list of all the baskets in one big table.

14 years agoremoving hardcoded (english) string
Paul Poulain [Thu, 12 Nov 2009 14:56:17 +0000 (15:56 +0100)]
removing hardcoded (english) string

14 years agoadding error details
Paul Poulain [Thu, 12 Nov 2009 14:55:56 +0000 (15:55 +0100)]
adding error details

14 years agoMoving language to opac-advsearch.pl fewer options
Paul Poulain [Wed, 11 Nov 2009 14:53:16 +0000 (15:53 +0100)]
Moving language to opac-advsearch.pl fewer options

was in "more option", that contains many options useless to standard patrons. Language limit can be useful

14 years agoAdding ccode at item level in 995$h UNIMARC
Henri-Damien LAURENT [Thu, 12 Nov 2009 13:45:44 +0000 (14:45 +0100)]
Adding ccode at item level in 995$h UNIMARC

14 years agoremoving database revision 124
Henri-Damien LAURENT [Wed, 4 Nov 2009 09:02:17 +0000 (10:02 +0100)]
removing database revision 124

Revisions 124 and 123 were the same

14 years agoFixed wrong SQL syntax in updatedatabase.
Jean-André Santoni [Fri, 6 Nov 2009 12:30:28 +0000 (13:30 +0100)]
Fixed wrong SQL syntax in updatedatabase.

14 years agotypo fix : list_price instead of listprice
Paul Poulain [Mon, 16 Nov 2009 15:11:54 +0000 (16:11 +0100)]
typo fix : list_price instead of listprice

14 years agomissing ) result in SQL error
Paul Poulain [Mon, 16 Nov 2009 15:02:52 +0000 (16:02 +0100)]
missing ) result in SQL error

14 years agoBug Fix : 3343 MT1313 Authorities MARC summary
Henri-Damien LAURENT [Wed, 11 Nov 2009 19:59:32 +0000 (20:59 +0100)]
Bug Fix : 3343 MT1313 Authorities MARC summary

When more than one heading, fields are mixed and not well ordered

14 years agoFollow up : MT1902
Henri-Damien LAURENT [Wed, 11 Nov 2009 14:36:00 +0000 (15:36 +0100)]
Follow up : MT1902

aaa8d0c80c893dbd92ced6c933263002cf6b048b
This fixes the loop with dates with was using implicit variable

14 years agoAdding a warning On subscription deletion for item
Henri-Damien LAURENT [Wed, 11 Nov 2009 14:19:24 +0000 (15:19 +0100)]
Adding a warning On subscription deletion for item

If we really wanted to delete all items linked to a subscription when we delete a subscription
we should change the database structure as such :
ALTER TABLE serialitems ADD FOREIGN KEY ( itemnumber ) REFERENCES items (itemnumber) ON DELETE CASCADE ;
ALTER TABLE serial CHANGE subscriptionid subscriptionid INT( 11 ) NOT NULL
ALTER TABLE serial ADD INDEX subscription ( subscriptionid )
ALTER TABLE serial ADD FOREIGN KEY ( subscriptionid ) REFERENCES subscription (subscriptionid) ON DELETE CASCADE ;

14 years agoMT1883 : Serials enddate was not cleanly used
Henri-Damien LAURENT [Wed, 11 Nov 2009 11:00:18 +0000 (12:00 +0100)]
MT1883 : Serials enddate was not cleanly used

GetExpirationDate should now be used only to get the NEXT expirationdate based on startdate
Perltidying C4/Serials.pm

14 years agoremoving database revision 124
Henri-Damien LAURENT [Wed, 4 Nov 2009 09:02:17 +0000 (10:02 +0100)]
removing database revision 124

Revisions 124 and 123 were the same

14 years agoapplying atomic update for issuingrules, (2929)
Paul Poulain [Tue, 10 Nov 2009 21:21:09 +0000 (22:21 +0100)]
applying atomic update for issuingrules, (2929)

14 years agoremoving warnings
Paul Poulain [Tue, 10 Nov 2009 20:53:27 +0000 (21:53 +0100)]
removing warnings

14 years agotransforming dates to iso to avoid a mySQL error
Paul Poulain [Tue, 10 Nov 2009 20:52:57 +0000 (21:52 +0100)]
transforming dates to iso to avoid a mySQL error

14 years agoreindenting & removing comments
Paul Poulain [Tue, 10 Nov 2009 20:32:33 +0000 (21:32 +0100)]
reindenting & removing comments

14 years agosubscription enddate is not mandatory + add a small hint on the right
Paul Poulain [Tue, 10 Nov 2009 20:32:21 +0000 (21:32 +0100)]
subscription enddate is not mandatory + add a small hint on the right

14 years agoUpdateDatabase more fixes
Henri-Damien LAURENT [Tue, 10 Nov 2009 21:19:51 +0000 (22:19 +0100)]
UpdateDatabase more fixes

14 years agoMT 2269 : Granular permissions for items batch modification and deletion
Matthias Meusburger [Tue, 10 Nov 2009 14:55:52 +0000 (15:55 +0100)]
MT 2269 : Granular permissions for items batch modification and deletion

Notes :
Permissions themselves were already added in commit 50ef9288606077dfc2b457db490f6fc2a5461c6c : (bug #3396)   This add batch deletion of items and fixes permissions for batch modification by Jean-André Santoni
Javascript for bolding currently selected page in tools-menu.inc enhanced to support url with parameters

14 years agoadding SUDOC history to XSLT (fields 955$r and $9)
Paul Poulain [Tue, 10 Nov 2009 19:55:22 +0000 (20:55 +0100)]
adding SUDOC history to XSLT (fields 955$r and $9)

14 years agooups, sorry, fixing mistake in previous patch
Paul Poulain [Tue, 10 Nov 2009 17:32:07 +0000 (18:32 +0100)]
oups, sorry, fixing mistake in previous patch

(reverting a not related and probably bogus change)

14 years agorevamping a little opac-detail for subscription (adding more history information)
Paul Poulain [Tue, 10 Nov 2009 17:28:53 +0000 (18:28 +0100)]
revamping a little opac-detail for subscription (adding more history information)

14 years agoBug 3702 add branch description as primary sort for items in staff mode
Jane Wagner [Fri, 9 Oct 2009 15:06:17 +0000 (11:06 -0400)]
Bug 3702 add branch description as primary sort for items in staff mode

The default sort order for items attached to a title in staff mode is
items.dateaccessioned desc.  This means that a particular library's holdings
will be scattered through the list -- a special problem when it comes to serial
issues.  I've done a change to Items.pm that makes the sort order branch
description followed by dateaccessioned.  Thus, a library's holdings will be
grouped together in the display.

14 years agotypo fix in XSLT
Paul Poulain [Tue, 10 Nov 2009 16:07:44 +0000 (17:07 +0100)]
typo fix in XSLT

14 years agoadding XSLT for intranet (UNIMARC only, MARC21 will be done by kf)
Paul Poulain [Tue, 10 Nov 2009 16:00:37 +0000 (17:00 +0100)]
adding XSLT for intranet (UNIMARC only, MARC21 will be done by kf)

- the XSLTParse4Display sub now has a new parameter : the interface (intranet or opac)
- the XSLTdisplay sysprefs is common to staff & opac (Auth.pm)
- added UNIMARC xslt in intranet templates (modified to deal with staff/opac differences)

14 years agoDisplaying serial call-number on receive.
Paul Poulain [Mon, 9 Nov 2009 18:35:02 +0000 (19:35 +0100)]
Displaying serial call-number on receive.

when the subscription has item creation, the callnumber is inside the item creation.
But when it doesn't have, the callnumber is not displayed, but is useful to be put on physical item.
This patch display the callnumber after the title

14 years ago2 translation fixes
Paul Poulain [Mon, 9 Nov 2009 17:49:17 +0000 (18:49 +0100)]
2 translation fixes

14 years agoMT 2048 : Clickable fields for biblios are now in blue, just like clickable fields...
Matthias Meusburger [Mon, 9 Nov 2009 14:45:00 +0000 (15:45 +0100)]
MT 2048 : Clickable fields for biblios are now in blue, just like clickable fields for authorities

14 years agooverdue performance restored (INCOMPLETE FIX)
Paul Poulain [Mon, 9 Nov 2009 14:44:14 +0000 (15:44 +0100)]
overdue performance restored  (INCOMPLETE FIX)

The performances of this script felt back. Investigating, it's due to the extended attribute filtering improvement
when there are ext attributes, the script does a:
SELECT borrowernumber AS bn, b.code, attribute AS val, category AS avcategory, lib AS avdescription
        FROM borrower_attributes b
        JOIN borrower_attribute_types bt ON (b.code = bt.code)
        LEFT JOIN authorised_values a ON (a.category = bt.authorised_value_category AND a.authorised_value = b.attribute)

that returns a LOT of datas when you have 10 000 patrons and 5 attributes.
That results in the page needing something like 10 seconds to be loaded.
There are some other caveats. I've commented a few lines that remove the extended attr option. The best solution would be to fix it better, but I can't find how to do that now.

(note : i also have commented some lines that are unused)

14 years agosubs declared twice
Paul Poulain [Mon, 9 Nov 2009 10:57:42 +0000 (11:57 +0100)]
subs declared twice

14 years agofixing some errors in updatedatabase
Paul Poulain [Mon, 9 Nov 2009 10:57:28 +0000 (11:57 +0100)]
fixing some errors in updatedatabase

14 years agoMT 2040, Follow-up : Dropdown list for languages in opac
Matthias Meusburger [Mon, 9 Nov 2009 09:30:08 +0000 (10:30 +0100)]
MT 2040, Follow-up : Dropdown list for languages in opac

14 years agoAdding some missing Status
Henri-Damien LAURENT [Mon, 9 Nov 2009 09:11:28 +0000 (10:11 +0100)]
Adding some missing Status

Claimed and Not Available was not managed for display