https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24001
--- Comment #19 from Chris Nighswonger <[email protected]> --- (In reply to Jonathan Druart from comment #17) > (In reply to Chris Nighswonger from comment #16) > > Just to be clear: I think we are encountering different issues in the > > description and comment #1. > > Yes of course, it is what I said in comment #1. > > If you have the strict_sql_modes turned on it explodes on creating the > template. > Let's open a separate bug for the second issue you mention. The strict sql issue. > > (In reply to Chris Nighswonger from comment #15) > > (In reply to Jonathan Druart from comment #14) > > > It has a printers_profile.profile_id = 22, but I think here we are talking > > > about creator_templates.profile_id > > > > > > MySQL [koha_kohadev]> select template_id, profile_id from > > > creator_templates; > > > > The error occurs on attempting to execute the following on your system in > > the script: > > > > SELECT * FROM printers_profile WHERE profile_id = 22 AND creator = > > 'Patroncards'; > > > > What does that say in the client? > > 0. I am using the fresh install, with all the sample data. > 1. Turning off strict_sql_modes > 2. Go to Home › Tools › Patron card creator › Templates > 3. New > Card template > 4. Save > 5. Edit > 6. Save > > Can't bless non-reference value at /kohadevbox/koha/C4/Creators/Profile.pm > line 89 > > C4::Creators::Profile::retrieve('C4::Patroncards::Profile', > 'profile_id', 22, 'creator', 'Patroncards') called at > /kohadevbox/koha/C4/Patroncards/Profile.pm line 29 > > C4::Patroncards::Profile::retrieve('profile_id', 22, 'creator', > 'Patroncards') called at /kohadevbox/koha/patroncards/edit-template.pl line > 78 > eval {...} at /kohadevbox/koha/patroncards/edit-template.pl line 2 > > > MariaDB [koha_kohadev]> SELECT * FROM printers_profile WHERE profile_id = 22 > AND creator = 'Patroncards'; > Empty set (0.00 sec) Forgive me as I do not have a test installation setup nor the time to get one up and running: What does 'SELECT template_id, profile_id, template_desc, creator FROM creator_templates;' say? I think I know what is causing this. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
