[Koha-bugs] [Bug 1857] updatedatabase fails w/ constraint

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1857


cnighswonger at foundations.edu changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED




------- Comment #1 from cnighswonger at 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.