[Koha] Upgrade reports from 3.0 to 3.2.10

[rfblanchard]

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.