updateVRA code moves objects back to extragalactic after promotion by human

[genghisken]

Just FYI, I don't think this is a major problem, but I occasionally see this happening recently.

MariaDB [atlas4]> select * from tcs_vra_scores where transient_object_id = 1030503980581015400;
+---------+---------------------+----------+-----------+-------+---------+-----------+-------------+---------------------+-------------+-----------+-------+
| id      | transient_object_id | preal    | pgal      | pfast | rank    | rank_alt1 | is_gal_cand | timestamp           | apiusername | username  | debug |
+---------+---------------------+----------+-----------+-------+---------+-----------+-------------+---------------------+-------------+-----------+-------+
| 2196013 | 1030503980581015400 | 0.982854 | 0.0342512 |  NULL | 9.78325 |      NULL |           0 | 2026-02-13 13:56:45 | vra         | NULL      |     0 |
| 2245014 | 1030503980581015400 | 0.987668 | 0.0155829 |  NULL | 9.86953 |      NULL |           0 | 2026-02-14 15:08:52 | vra         | NULL      |     0 |
| 2295759 | 1030503980581015400 |        1 |         0 |  NULL |    NULL |      NULL |        NULL | 2026-02-15 09:52:07 | NULL        | ken.smith |     0 |
| 2296620 | 1030503980581015400 | 0.987217 | 0.0172515 |  NULL | 9.86207 |      NULL |           0 | 2026-02-15 11:27:39 | vra         | NULL      |     0 |
| 2371775 | 1030503980581015400 |        1 |         0 |  NULL |    NULL |      NULL |        NULL | 2026-02-16 09:51:58 | NULL        | ken.smith |     0 |
+---------+---------------------+----------+-----------+-------+---------+-----------+-------------+---------------------+-------------+-----------+-------+

I promoted the object, but it looks like a VRA update was happening during the time I originally promoted the object. I think there's a quick fix in the SQL update query that can be done to stop this happening.