I am trying to change the room on a device, and get the following error. It looks like a sql insert, shouldn't it be a modify?
http://nav.davenport.edu/editdb/netbox/edit/52 Mod_python error: "PythonHandler editdb"Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 156, in handler output = editPage(req,pageList[table](),request,unicodeError) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 463, in editPage outputForm,action) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 2479, in add function) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 590, in insertNetbox ('netboxid','netbox_netboxid_seq')) File "/usr/local/nav/apache/webroot/editdb/editdbSQL.py", line 152, in addEntryFields executeSQL(sqllist) File "/usr/local/nav/apache/webroot/editdb/editdbSQL.py", line 39, in executeSQL database.execute(sql)IntegrityError: ERROR: duplicate key violates unique constraint "netbox_sysname_key"INSERT INTO netbox (sysname,rw,catid,ip,netboxid,prefixid,orgid,deviceid,ro,roomid) VALUES ('bay-wan.network.davenport.edu','youwish','GW','10.200.1.65','60','290','Davenport','129','itsasecret','17 ITS Office') Pete Hoffswell 616-732-1101 (Grand Rapids, x1101) University LAN/WAN Coordinator 616-510-1198 (Mobile) IT Services pete.hoffswell@davenport.edu Davenport University http://www.davenport.eduDavenport University. It's working.