@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_13668.sql | 2 ++ installer/data/mysql/kohastructure.sql | 3 ++- .../intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt | 6 +++++- 3 files changed, 9 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_13668.sql --- a/installer/data/mysql/atomicupdate/bug_13668.sql +++ a/installer/data/mysql/atomicupdate/bug_13668.sql @@ -0,0 +1,2 @@ +UPDATE saved_sql LEFT JOIN borrowers on saved_sql.borrowernumber=borrowers.borrowernumber SET saved_sql.borrowernumber=NULL WHERE borrowers.borrowernumber IS NULL; +ALTER TABLE saved_sql ADD FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -1910,7 +1910,8 @@ CREATE TABLE saved_sql ( -- saved sql reports report_subgroup varchar(80) default NULL, PRIMARY KEY (`id`), KEY sql_area_group_idx (report_group, report_subgroup), - KEY boridx (`borrowernumber`) + KEY boridx (`borrowernumber`), + CONSTRAINT `saved_sql_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt @@ -333,7 +333,11 @@ canned reports and writing custom SQL reports.

[% savedreport.groupname %] [% savedreport.subgroupname %] [% savedreport.notes %] - [% savedreport.borrowersurname %][% IF ( savedreport.borrowerfirstname ) %], [% savedreport.borrowerfirstname %][% END %] ([% savedreport.borrowernumber %]) + + [% IF savedreport.borrowernumber %] + [% savedreport.borrowersurname %][% IF ( savedreport.borrowerfirstname ) %], [% savedreport.borrowerfirstname %][% END %] ([% savedreport.borrowernumber %]) + [% END %] + [% savedreport.date_created | $KohaDates %] [% IF (savedreport.public) %] Yes --