[Koha-bugs] [Bug 24001] Cannot edit card template

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24001

--- Comment #19 from Chris Nighswonger <cnighswonger at foundations.edu> ---
(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.