#142 constraint violation when adding devices

[Anonymous]

When trying to add devices, I get the following error:

Fatal error: Database Error: MDB Error: constraint
violation (INSERT INTO networking
(ID,name,type,ram,ip,mac,location,serial,otherserial,contact,contact_num,datemod,comments)
VALUES
('2','',NULL,'','','',NULL,'','','','','2006-10-18
00:10:16','') [nativecode=1048]) in
/var/www/html/trunk_1.5.8/lib/IRMDB.php on line 346

running:

php-pear-1.4.9-1
php-5.1.4-1
mdb 1.3.0
on

2.6.17-1.2157_FC5

and running the latest trunk release

[Nobody/Anonymous]

Logged In: NO

table networking, location field type is not NULL.
please setup, "Setup dropdowns" -> locations filed.

[Martin Stevens]

Logged In: YES
user_id=255024

Yup, you need an entry in the location dropdown.

We should really add some error handling for this.