[Bug 27866] New: cannot create new printer profiles
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27866 Bug ID: 27866 Summary: cannot create new printer profiles Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs@lists.koha-community.org Reporter: lucas@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org to recerate: -go to Home › Tools › Label creator › Profiles › New printer profile (/cgi-bin/koha/labels/label-edit-profile.pl?op=new) -attempt to save a new printer profile -get an error C4::Creators::Profile::save(): DBI Exception: DBD::mysql::st execute failed: Incorrect integer value: '' for column 'template_id' at row 1 [for Statement "INSERT INTO printers_profile (printer_name, offset_vert, creep_vert, paper_bin, template_id, creep_horz, units, creator, offset_horz) VALUES (?,?,?,?,?,?,?,?,?);" with ParamValues: 0="e", 1=0, 2=0, 3="e", 4='', 5=0, 6="MM", 7='Labels', 8=0] at /kohadevbox/koha/C4/Labels/Profile.pm line 23 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27866 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|cannot create new printer |Cannot create new printer |profiles |profiles --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I think the problem might occur when the printer name is left empty. The first time it kinda uses a default value, the second time, things explode: C4::Creators::Profile::save(): DBI Exception: DBD::mysql::st execute failed: Duplicate entry 'DEFAULT PRINTER-0-Tray 1-Labels' for key 'printername' [for Statement "INSERT INTO printers_profile (template_id, creep_vert, creator, printer_name, creep_horz, units, offset_horz, paper_bin, offset_vert) VALUES (?,?,?,?,?,?,?,?,?);" with ParamValues: 0='', 1=0, 2='Labels', 3='DEFAULT PRINTER', 4=0, 5="POINT", 6=0, 7='Tray 1', 8=0] at /home/vagrant/kohaclone/C4/Labels/Profile.pm line 23 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 If I enter a printer name, things save ok. Lucas, could this be it or are you seeing another issue? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org