Any idea why I'd be seeing the following in the ObjectCustomFieldValues table:
mysql> select id, CustomField, ObjectType, ObjectId, Content, LastUpdated from ObjectCustomFieldValues where Objectid = 80487 and CustomField = 5; +-------+-------------+------------+----------+----------+---------------------+ | id | CustomField | ObjectType | ObjectId | Content | LastUpdated | +-------+-------------+------------+----------+----------+---------------------+ | 24363 | 5 | RT::Ticket | 80487 | Email | 2009-02-25 13:23:16 | | 24544 | 5 | RT::Ticket | 80487 | Hardware | 2009-02-25 13:23:16 | +-------+-------------+------------+----------+----------+---------------------+ 2 rows in set (0.00 sec) Two rows being inserted at exactly the same time with different Contents? FWIW, came across this while pulling out TimeTaken info from the Transactions table and mapping it to a Category custom field. Was getting duplicates that it took me a while to track down.
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
