Package: irm Severity: important
The install.sql is missing a column (flags_surplus) for the table 'templates' With this missing, you cannot 'edit' the templates, nor can you add new ones. After the package is installed, you can run this from the mysql prompt to add the missing column. alter table templates add column flags_surplus TINYINT(4) default NULL; Or you could patch the install.sql with attached patch. -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.7 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
231c231 < CREATE TABLE templates ( ID int(11) DEFAULT '0' NOT NULL auto_increment, templname varchar(200), name varchar(200), type varchar(200), flags_server tinyint(4) DEFAULT '0' NOT NULL, os varchar(200), osver varchar(20), processor varchar(200), processor_speed varchar(100), location varchar(200), serial varchar(200), otherserial varchar(200), ramtype varchar(200), ram varchar(20), network varchar(200), ip varchar(20), mac varchar(40), hdspace varchar(10), contact varchar(200), contact_num varchar(200), comments text, iface varchar(100), PRIMARY KEY (ID)); --- > CREATE TABLE templates ( ID int(11) DEFAULT '0' NOT NULL auto_increment, > templname varchar(200), name varchar(200), type varchar(200), flags_server > tinyint(4) DEFAULT '0' NOT NULL, os varchar(200), osver varchar(20), > processor varchar(200), processor_speed varchar(100), location varchar(200), > serial varchar(200), otherserial varchar(200), ramtype varchar(200), ram > varchar(20), network varchar(200), ip varchar(20), mac varchar(40), hdspace > varchar(10), contact varchar(200), contact_num varchar(200), comments text, > iface varchar(100), flags_surplus TINYINT(4) default NULL, PRIMARY KEY (ID)); 237,240c237,240 < INSERT INTO templates VALUES (1,'Blank Template','','Generic PC',0,'Windows','','Intel Pentium','','Library Back Room','','','72pin SIMMS (EDO)','','Generic 10Mbps Card','','','','','','',NULL); < INSERT INTO templates VALUES (2,'Mac G3 All-in-One','','Macintosh PPC (other)',1,'Mac OS','8.1','486 DX','266','MAOS Lab','','','SDRAM DIMMs (<10ns)','96','Generic 100Mbps Card','205.155.38','','3','','','','100Mbps Ethernet (UTP)'); < INSERT INTO templates VALUES (3,'iMac','','iMac',0,'Mac OS','8.6','PowerPC G3','333','Library Back Room','','','iMac DIMMS','32','Generic 100Mbps Card','','00 50 E4','6','','','','100Mbps Ethernet (UTP)'); < INSERT INTO templates VALUES (4,'iMac DV','','iMac DV',0,'Mac OS','9.0.4','PowerPC G3','400','Library Back Room','','','SDRAM DIMMs (<10ns)','64','Generic 100Mbps Card','','','13','','','','100Mbps Ethernet (UTP)'); --- > INSERT INTO templates VALUES (1,'Blank Template','','Generic > PC',0,'Windows','','Intel Pentium','','Library Back Room','','','72pin SIMMS > (EDO)','','Generic 10Mbps Card','','','','','','',NULL,NULL); > INSERT INTO templates VALUES (2,'Mac G3 All-in-One','','Macintosh PPC > (other)',1,'Mac OS','8.1','486 DX','266','MAOS Lab','','','SDRAM DIMMs > (<10ns)','96','Generic 100Mbps Card','205.155.38','','3','','','','100Mbps > Ethernet (UTP)',NULL); > INSERT INTO templates VALUES (3,'iMac','','iMac',0,'Mac OS','8.6','PowerPC > G3','333','Library Back Room','','','iMac DIMMS','32','Generic 100Mbps > Card','','00 50 E4','6','','','','100Mbps Ethernet (UTP)',NULL); > INSERT INTO templates VALUES (4,'iMac DV','','iMac DV',0,'Mac > OS','9.0.4','PowerPC G3','400','Library Back Room','','','SDRAM DIMMs > (<10ns)','64','Generic 100Mbps Card','','','13','','','','100Mbps Ethernet > (UTP)',NULL);
