Bug 19803

Summary: SQL report export can fail HTTP 414 Request-URI Too Large
Product: Koha Reporter: Fridolin Somers <fridolin.somers>
Component: ToolsAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: nick, sally.healey, victor
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Fridolin Somers 2017-12-13 09:02:54 UTC
After running a saved SQL report, one can download result into a file.

This uses a link with the SQL query as URL argument.
If this query is really big, the download may fail with HTTP 414 "Request-URI Too Large".

This link should use the report id to retrieve SQL query.
There is a comment asking this in reports/guided_reports.pl :
  my $sql = $input->param('sql');  # FIXME: use sql from saved report ID#, not new user-supplied SQL!
Comment 1 Nick Clemens 2018-01-03 13:18:53 UTC

*** This bug has been marked as a duplicate of bug 18497 ***