How to update a foreign key with an UPDATE query?

Question

MySQL

There are orders tables in it, there is a foreign key of the statuses table (id_status).
You need to change id_status.
I make a request

UPDATE orders_print SET id_status = '2' WHERE id_order_print = '1'

I put down the actions for both deletions and updates.
Gives an error message.
#1452 - Cannot add or update a child row: a foreign key constraint fails (`odeon`.`orders_print`, CONSTRAINT `fk_orders_print_status1` FOREIGN KEY (`id_status`) REFERENCES `status` (`id_status`) ON DELETE CASCADE ON UPDATE CASCADE)
How to fix?

Answer 1

Most likely there is no status in the `status` table with `id_status` = 2