https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37307 Bug ID: 37307 Summary: Update And Run SQL function appends report ID to savedsql Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: andrewfh@dubcolib.org QA Contact: testopia@bugs.koha-community.org Use of the Update And Run SQL button causes koha to append the report ID to the end of the query. It's commented out, so it doesn't break the query, but it's adding useless characters. To recreate: - save and run this report: SELECT id, savedsql FROM saved_sql WHERE savedsql like "%saved_sql.id: %" - see your report returns itself - click Edit - click Update and Run SQL without changing anything in your report - click Update and Run SQL again - look at your report results, notice that the saved query is now repeating "/* saved_sql.id: 1334 */" at the end -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.