Open-AudIT

In the software_licenses table the license_purchase_number is defined as int(10) unsigned but the form "add license" (software_add_license.php) says "Set to "-1" if this is free".

when you insert -1 in the form field the insert fails.

i change the open_audit.sql script in the script folder to match the request )open_audit.sql lines from 737 to 739):

[code]
DROP TABLE IF EXISTS `software_licenses`;
CREATE TABLE `software_licenses` (
`license_id` int(10) unsigned NOT NULL auto_increment,
`license_software_id` int(10) unsigned NOT NULL default '0',
`license_purchase_cost_each` int(10) NOT NULL default '0',
`license_purchase_number` int(10) NOT NULL default '0',
`license_purchase_date` date NOT NULL default '0000-00-00',
`license_purchase_vendor` varchar(150) NOT NULL default '',
`license_comments` varchar(200) NOT NULL default '',
`license_purchase_type` varchar(50) NOT NULL default '',
`license_order_number` varchar(50) NOT NULL default '',
PRIMARY KEY (`license_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;[/code]

i hope this will be usefull

Flavio, you are probably using an old DB version: these mods were applied starting from DB v. 07.08.28. The current version is 07.12.09: try updating all files from SVN.

_________________
Edoardo

i had suspect of it, but in SVN 946 i still have the wrong definition (or i fail something...).

[quote="flavio"]i had suspect of it, but in SVN 946 i still have the wrong definition (or i fail something...).

_________________
Edoardo