[rt-users] ObjectCustomFieldValues weirdness

[Stephen Cochran]

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 <
stephen.a.cochran.lists at cahir.net> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090304/bd5d30a2/attachment.htm>