Would some kind librarian with more than 10,000 biblios please try running the following Mysql report. I works as expected, except that the csv output truncates at 10,000. If confirmed, I will attempt to post a bug. SELECT biblionumber, CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',title,'</a>') AS Title FROM biblio ORDER BY biblionumber Thanks, Paul Tired old sys-admin
Paul, Try adding a LIMIT <some number way over the top of what you expect for reults> to the end of that report, and see if it works. Liz Rea NEKLS On Apr 21, 2011, at 12:57 PM, Paul wrote:
Would some kind librarian with more than 10,000 biblios please try running the following Mysql report. I works as expected, except that the csv output truncates at 10,000. If confirmed, I will attempt to post a bug.
SELECT biblionumber, CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',title,'</a>') AS Title FROM biblio ORDER BY biblionumber
Thanks,
Paul Tired old sys-admin
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi. There is a default "limit" of 10000 on the sql reports. I believe that if you provide your own "limit" statement in your sql then you should get your choice of the limit rather than the default. So try adding "limit 99999" to your sql perhaps. I hope it still works... Ian On 21/04/2011 18:57, Paul wrote:
Would some kind librarian with more than 10,000 biblios please try running the following Mysql report. I works as expected, except that the csv output truncates at 10,000. If confirmed, I will attempt to post a bug.
SELECT biblionumber, CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',title,'</a>') AS Title FROM biblio ORDER BY biblionumber
Thanks,
Paul Tired old sys-admin
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
On 04/21/2011 01:57 PM, Paul wrote:
Would some kind librarian with more than 10,000 biblios please try running the following Mysql report. I works as expected, except that the csv output truncates at 10,000. If confirmed, I will attempt to post a bug.
SELECT biblionumber, CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',title,'</a>') AS Title FROM biblio ORDER BY biblionumber
Thanks,
Paul Tired old sys-admin
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I can confirm it. select count(*) biblio shows 15717 records. Your test shows a high biblio number of 16266 but the csv output truncates at bibio number 10418 with 19903 lines in the file. -- Bob Stonewall National Museum
Hi! On 21 April 2011 19:57, Paul <paul.a@aandc.org> wrote:
Would some kind librarian with more than 10,000 biblios please try running the following Mysql report. I works as expected, except that the csv output truncates at 10,000. If confirmed, I will attempt to post a bug.
This sounds like a known bug, which will be fixed in 3.4: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6028 Best regards, Magnus Enger libriotech.no
At 08:43 PM 4/21/2011 +0200, Magnus Enger wrote:
This sounds like a known bug, which will be fixed in 3.4: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6028
Thanks - as soon as I got the reply about a hard limit I grepped the code, found it in c4/records/guided.pm and modded it. I'm sure there was a good reason for it, but am happy to see that 3.4 is increasing the default limit. It's rather like the "$limit = 20" in cgi-bin/reports/guided_reports.pl which sets the number of html lines/page for the console reports - I've upped ours to 100, which still gives manageable page sizes but reduces the "back|forward|reloads" for a good proportion or our workload. Perhaps not suitable for everyone, but ... Best regards, Paul Tired old sys-admin
participants (5)
-
Bob Ewart -
Ian Bays -
Liz Rea -
Magnus Enger -
Paul