[Bug 38603] New: Error 500 when creating, or editing sql in reports
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 Bug ID: 38603 Summary: Error 500 when creating, or editing sql in reports Change sponsored?: --- Product: Koha Version: 24.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs@lists.koha-community.org Reporter: ism@kis.in QA Contact: testopia@bugs.koha-community.org cgi-bin/koha/reports/guided_reports.pl?op=add_form_sql This page throws the following error when the option create from SQL is selected, or while editing existing saved reports : An error has occurred! Error 500 This message may have been caused by any of the following reasons: You made use of an external link to an item that is no longer available You followed an outdated link e.g. from a search engine or a bookmark You tried to access a page that needs authentication An internal link in the client is broken and the page does not exist What's next? Use top menu bar to navigate to another part of Koha. To report a broken link or any other issue, please contact the Koha administrator. Send email -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 --- Comment #1 from Owen Leonard <oleonard@myacpl.org> --- I cannot reproduce this problem in 24.05.00. The error message you shared is a generic one with no technical information which could help identify the problem. Do you have access to your server logs? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 --- Comment #2 from shalini <ism@kis.in> --- I moved old koha 18 database to koha 24.05 new installation. Everything seems to be working fine except for the reports. here is the log opac-error.log. [Tue Dec 03 09:16:30.033642 2024] [cgi:error] [pid 5232] [client 172.16.60.218:50190] AH01215: Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: https://koha24.kis.in/ [Tue Dec 03 09:17:01.591757 2024] [cgi:error] [pid 5498] [client 172.16.60.218:50209] AH01215: Use of uninitialized value $stored_hash in string eq at /usr/share/koha/lib/C4/Auth.pm line 2118.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: https://koha24.kis.in/cgi-bin/koha/opac-search.pl?idx=&q=math&weight_search=1 [Tue Dec 03 09:17:01.591979 2024] [cgi:error] [pid 5498] [client 172.16.60.218:50209] AH01215: Use of uninitialized value $stored_hash in substr at /usr/share/koha/lib/C4/Auth.pm line 2122.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: https://koha24.kis.in/cgi-bin/koha/opac-search.pl?idx=&q=math&weight_search=1 [Tue Dec 03 09:17:01.592084 2024] [cgi:error] [pid 5498] [client 172.16.60.218:50209] AH01215: Use of uninitialized value $stored_hash in string eq at /usr/share/koha/lib/C4/Auth.pm line 2127.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: https://koha24.kis.in/cgi-bin/koha/opac-search.pl?idx=&q=math&weight_search=1 [Tue Dec 03 09:17:23.771541 2024] [cgi:error] [pid 5564] [client 172.16.60.218:50211] AH01215: Use of uninitialized value $stored_hash in string eq at /usr/share/koha/lib/C4/Auth.pm line 2118.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: https://koha24.kis.in/cgi-bin/koha/opac-user.pl [Tue Dec 03 09:17:23.771736 2024] [cgi:error] [pid 5564] [client 172.16.60.218:50211] AH01215: Use of uninitialized value $stored_hash in substr at /usr/share/koha/lib/C4/Auth.pm line 2122.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: https://koha24.kis.in/cgi-bin/koha/opac-user.pl [Tue Dec 03 09:17:23.771863 2024] [cgi:error] [pid 5564] [client 172.16.60.218:50211] AH01215: Use of uninitialized value $stored_hash in string eq at /usr/share/koha/lib/C4/Auth.pm line 2127.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: https://koha24.kis.in/cgi-bin/koha/opac-user.pl thank you for your support -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to shalini from comment #2)
I moved old koha 18 database to koha 24.05 new installation. Everything seems to be working fine except for the reports. here is the log opac-error.log. [Tue Dec 03 09:16:30.033642 2024] [cgi:error] [pid 5232] [client 172.16.60.218:50190] AH01215: Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: https://koha24.kis.in/
This is the wrong log file as it's the OPAC log. Try: tail -f /var/log/koha/<nameofyourinstance>/*.log and reproduce the error. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 --- Comment #4 from shalini <ism@kis.in> --- [Tue Dec 03 15:25:56.536699 2024] [cgi:error] [pid 21865] [client 10.11.26.91:63133] AH01215: main::get_tables(): DBI Exception: DBD::mysql::db selectall_arrayref failed: View 'koha_library.StatisticsView' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them at /usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 766: /usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer: https://koha24.kis.in:8080/cgi-bin/koha/reports/reports-home.pl [Tue Dec 03 15:25:56.592395 2024] [cgi:error] [pid 21865] [client 10.11.26.91:63133] End of script output before headers: guided_reports.pl, referer: https://koha24.kis.in:8080/cgi-bin/koha/reports/reports-home.pl [Tue Dec 03 15:27:01.734713 2024] [cgi:error] [pid 21917] [client 10.11.26.91:63142] AH01215: main::get_tables(): DBI Exception: DBD::mysql::db selectall_arrayref failed: View 'koha_library.StatisticsView' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them at /usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 766: /usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer: https://koha24.kis.in:8080/cgi-bin/koha/reports/reports-home.pl [Tue Dec 03 15:27:01.789365 2024] [cgi:error] [pid 21917] [client 10.11.26.91:63142] End of script output before headers: guided_reports.pl, referer: https://koha24.kis.in:8080/cgi-bin/koha/reports/reports-home.pl Here is it. Thanks -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Have you changed the database structure of your Koha like adding tables or views? koha_library.StatisticsView doesn't exist in a standard installation and views are not in use. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 --- Comment #6 from shalini <ism@kis.in> --- Yes, but those are meant for the koha interface. Those are used by our intranet site. Why is this happening when I try to create a sql? Why is the form not getting displayed? https://koha24.kis.in:8080/cgi-bin/koha/reports/guided_reports.pl?op=add_for... Thanks -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 --- Comment #7 from shalini <ism@kis.in> --- Thank you so much. I deleted the table and that resolved the issue. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38603 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org