My problem is related to koha permissions. I doubt anyone has delt with this situation, so I'll try to explain the problem.
I recently took over the support of the koha system that takes care of all the schools for my province. We are using koha 3.0 that has customizations. Because of these customizations we are not able to upgrade right now to the latest 3.6 version of koha. We are just now starting to take advantage of koha reports. Koha 3.2 introduced 'runtime parameters'. We need this feature but it didn't exist in 3.0. My plan is to 'overwrite' the reports files in my system with the reports from version 3.2.10. Note: I'd like to use the reports from 3.4.5 however version 3.4 koha introduced Template::Toolkit. Version 3.0 used HTML::Template::Pro, so grabbing files from version 3.4+ caused additional problems. With all that said, I have successfully moved over a number of report files from 3.2.10 to my old 3.0 project. It now had the ability to do 'runtime parameters'. When I set up a patrons permissions, if I give them access to 'create' and 'execute' reports then everything works perfect. However, if they only have access to one permission 'create' or 'execute' then the moment I click 'used saved' then the user is booted out of the system with: 'Error: Unauthorized user click to log out' Does anyone know what file I may also need to update? Here is a list of what I did so far: Upgrade Reports to v3.2.10 ---- C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\reports\ /usr/share/koha/intranet/cgi-bin/reports cd /usr/share/koha/intranet/cgi-bin/reports chmod 755 *.pl chmod 755 *.plugin ---- open C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\reports\guided_reports.pl find my $url = "/cgi-bin/koha/reports/guided_reports.pl?reports=$report&phase=Run%20this%20report"; add this section under it if (@sql_params) { $url = join('&sql_params=', $url, map { URI::Escape::uri_escape($_) } @sql_params); } save file and ftp this change to C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\reports\ ---- C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\C4\Reports.pm /usr/share/koha/lib/C4/Reports.pm ---- C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\C4\Branch.pm /usr/share/koha/lib/C4/Branch.pm ---- C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\C4\Reports\ /usr/share/koha/lib/C4/Reports ---- C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\koha-tmpl\intranet-tmpl\prog\en\includes\reports-menu.inc /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/reports-menu.inc ---- C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\koha-tmpl\intranet-tmpl\prog\en\includes\guided-reports-view.inc /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/guided-reports-view.inc ---- C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\koha-tmpl\intranet-tmpl\prog\en\includes\date-format.inc /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/date-format.inc ---- C:\Documents and Settings\rblanchard\Desktop\koha-3.2.10\koha-tmpl\intranet-tmpl\prog\en\modules\reports\ /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/reports ---- run permissions against DB USE kohadb; insert into `permissions`(`module_bit`,`code`,`description`) values (16,'create_reports','Create SQL Reports'); insert into `permissions`(`module_bit`,`code`,`description`) values (16,'execute_reports','Execute SQL reports'); ---- -- View this message in context: http://koha.1045719.n5.nabble.com/Upgrade-reports-from-3-0-to-3-2-10-tp4924900p4924900.html Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha