I noticed that my linux script kept failing to upload data past memory in the current SVN (1085) . After banging my head against the wall for a bit I realized that the admin_pc_add page expects a column called memory_tag to exist. However, the open_audit.sql file doesn't seem to create this column when it creates the table. It currently does the following ...
[code] CREATE TABLE `memory` ( `memory_id` int(10) unsigned NOT NULL auto_increment, `memory_uuid` varchar(100) NOT NULL default '', `memory_bank` varchar(45) NOT NULL default '', `memory_type` varchar(45) NOT NULL default '', `memory_form_factor` varchar(45) NOT NULL default '', `memory_detail` varchar(45) NOT NULL default '', `memory_capacity` int(11) NOT NULL, `memory_speed` varchar(45) NOT NULL default '', `memory_timestamp` bigint(20) unsigned NOT NULL default '0', `memory_first_timestamp` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`memory_id`), KEY `id` (`memory_uuid`), KEY `id2` (`memory_timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; [/code]
I don't really know what this new column is supposed to hold. I'm guessing it should be akin to the following ... ?
[code] CREATE TABLE `memory` ( `memory_id` int(10) unsigned NOT NULL auto_increment, `memory_uuid` varchar(100) NOT NULL default '', `memory_bank` varchar(45) NOT NULL default '', `memory_type` varchar(45) NOT NULL default '', `memory_form_factor` varchar(45) NOT NULL default '', `memory_detail` varchar(45) NOT NULL default '', `memory_capacity` int(11) NOT NULL, `memory_speed` varchar(45) NOT NULL default '', `memory_tag` varchar(45) NOT NULL default '', `memory_timestamp` bigint(20) unsigned NOT NULL default '0', `memory_first_timestamp` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`memory_id`), KEY `id` (`memory_uuid`), KEY `id2` (`memory_timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; [/code]
_________________ OA Server: Debian Squeeze w/ Apache2 Auditing: 700 Workstations, 250 or so Retail Terminals, about 75 Servers OS's: Windows XP/2003/2008/2008 R2/Vista/7, Debian LDAP: Active Directory 2008 R2
|