I should add that the two results do have different Created values: +-------+----------+----------+---------------------+---------------------+ | id | ObjectId | Content | LastUpdated | Created | +-------+----------+----------+---------------------+---------------------+ | 24363 | 80487 | Email | 2009-02-25 13:23:16 | 2009-02-23 14:20:58 | | 24544 | 80487 | Hardware | 2009-02-25 13:23:16 | 2009-02-25 13:23:16 | +-------+----------+----------+---------------------+---------------------+ 2 rows in set (0.00 sec)
On Wed, Mar 4, 2009 at 12:06 AM, Stephen Cochran < [email protected]> wrote: > > 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
