Was able to get this working, however I can't set a password for a user in rosario anymore:
02/08/2025 10:39:18
Date
DB Execute Failed. 1093 You can't specify target table 'staff' for update in FROM clause
Failure Notice
UPDATE staff
SET PASSWORD='$6$d6c13880b5ae10dd$3gR5IRabSYE1IY1aozgd4Amz/9YBi.qHjMHvOY9uGZxXqm3bwtYJPq14RD3GSHJtJKLYG7/w6L/qd8DUXSEnj1'
WHERE USERNAME=(SELECT USERNAME
FROM staff
WHERE STAFF_ID='5')
SQL query