Deleted department keeps showing up

SeuzRoman

Hello There!

My installations details are following:
Server Information
osTicket Version v1.16.3 (e148727) — Up to date
Web Server Software Apache/2.4.54 (Debian)
MySQL Version 10.5.15
PHP Version 8.0.21

Here is my problem. Some months ago I created a department called 'Remote Support'. After some weeks I deleted the department. However, it keeps showing up in some spots. I have noticed it in Tasks and the Dashboard:

I have already cleared the thread tables in my database. The department with such name also does not exist in the database.

select a.id,a.number,a.dept_id,b.name
from ost2_task as a join ost2_department as b on a.dept_id=b.id

+----+--------+---------+-----------------------------------------------+
| id | number | dept_id | name                                          |
+----+--------+---------+-----------------------------------------------+
|  1 | 000155 |       9 | ADMIN                                         |
|  2 | 000157 |       9 | ADMIN                                         |
|  3 | 000158 |       9 | ADMIN                                         |
+----+--------+---------+-----------------------------------------------+
3 rows in set (0.000 sec)

What can I possibly clear to get rid of the phantom department name?

SeuzRoman

Update:
So I've found the 'Remote Support' in my database inside translation table:

MariaDB [osticket]> select * from ost2_translation where text='Remote Support'
    -> ;
+----+------------------+--------+-------+----------+----------+-------+----------------+-------------+---------------------+
| id | object_hash      | type   | flags | revision | agent_id | lang  | text           | source_text | updated             |
+----+------------------+--------+-------+----------+----------+-------+----------------+-------------+---------------------+
| 12 | c3c9cc673671e9d2 | phrase |     0 |     NULL |        1 | en_US | Remote Support | NULL        | 2022-07-26 17:39:28 |
+----+------------------+--------+-------+----------+----------+-------+----------------+-------------+---------------------+
1 row in set (0.000 sec)

Will it make any harm if I delete this entry? I wasn't able to find anything else with curremt hash value in my DB.

SeuzRoman

Took the risk and deleted the rows listed above. Worked fine