Unable to delete item, error in query.

[wax66]

I'm unable to delete one of the items on one of my hosts.

Using 1.8.1, just recently patched my db.inc.php file to correct the Dashboard issue with InnoDB (related or not?).


* POSSIBLE ERROR: Used incorrect logic in database processing, started subtransaction!
* POSSIBLE ERROR: Used incorrect logic in database processing, started subtransaction!
* Error in query [INSERT INTO housekeeper (housekeeperid,tablename,field,value) VALUES (1,'history_text','itemid',100100000050088)] [Duplicate entry '1' for key 1]
* POSSIBLE ERROR: Used incorrect logic in database processing, started subtransaction!
* Error in query [INSERT INTO housekeeper (housekeeperid,tablename,field,value) VALUES (,'history_log','itemid',100100000050088)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''history_log','itemid',100100000050088)' at line 1]
* POSSIBLE ERROR: Used incorrect logic in database processing, started subtransaction!
* Error in query [INSERT INTO housekeeper (housekeeperid,tablename,field,value) VALUES (,'history_uint','itemid',100100000050088)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''history_uint','itemid',100100000050088)' at line 1]
* POSSIBLE ERROR: Used incorrect logic in database processing, started subtransaction!
* Error in query [INSERT INTO housekeeper (housekeeperid,tablename,field,value) VALUES (,'history_str','itemid',100100000050088)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''history_str','itemid',100100000050088)' at line 1]
* POSSIBLE ERROR: Used incorrect logic in database processing, started subtransaction!
* Error in query [INSERT INTO housekeeper (housekeeperid,tablename,field,value) VALUES (,'history','itemid',100100000050088)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''history','itemid',100100000050088)' at line 1]
* POSSIBLE ERROR: Used incorrect logic in database processing, started subtransaction!
* Error in query [INSERT INTO auditlog (auditid,userid,clock,ip,action,resourcetype,resou rceid,resourcename) values (,100100000000003,1265810931,'10.130.254.114',2,15 ,100100000050088,'Total disk space on $1')] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '100100000000003,1265810931,'10.130.254.114',2,15, 100100000050088,'Total disk spa' at line 1]
* Item 'warehouse01.atl:vfs.fs.size[r:,total]' deleted


Any ideas?

Thanks!
-Ron

[wax66]

Resolved by changing one of the lines in the patch:

mschlegel said:
"I changed the '$ret2 = DBend($ret2);' line to '$ret3 = DBend($ret2);' and the ID issue goes away."

Thanks!
-Ron