http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1857 cnighswonger@foundations.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Comment #1 from cnighswonger@foundations.edu 2008-02-26 04:59 ------- Not sure what's happening here. The current kohastructure.sql does not set labels_templates.tmpl_id to NULL as default afaict. Here is a dump of the current table structure: mysql> show create table labels_templates\G; *************************** 1. row *************************** Table: labels_templates Create Table: CREATE TABLE `labels_templates` ( `tmpl_id` int(4) NOT NULL auto_increment, `tmpl_code` char(100) default '', `tmpl_desc` char(100) default '', `page_width` float default '0', `page_height` float default '0', `label_width` float default '0', `label_height` float default '0', `topmargin` float default '0', `leftmargin` float default '0', `cols` int(2) default '0', `rows` int(2) default '0', `colgap` float default '0', `rowgap` float default '0', `active` int(1) default NULL, `units` char(20) default 'PX', `fontsize` int(4) NOT NULL default '3', PRIMARY KEY (`tmpl_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec) And here is the structure from kohastructure.sql -- -- Table structure for table `labels_templates` -- DROP TABLE IF EXISTS `labels_templates`; CREATE TABLE `labels_templates` ( `tmpl_id` int(4) NOT NULL auto_increment, `tmpl_code` char(100) default '', `tmpl_desc` char(100) default '', `page_width` float default '0', `page_height` float default '0', `label_width` float default '0', `label_height` float default '0', `topmargin` float default '0', `leftmargin` float default '0', `cols` int(2) default '0', `rows` int(2) default '0', `colgap` float default '0', `rowgap` float default '0', `active` int(1) default NULL, `units` char(20) default 'PX', `fontsize` int(4) NOT NULL default '3', PRIMARY KEY (`tmpl_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Maybe I've missed something, though. Or maybe someone else corrected it, although I don't see a patch for it. Regards ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.