Hello! I have a problem when I try to change the orders_status from pending to delivered. the message is
There has been a problem....
java.sql.SQLException: No data - zero rows fetched, selected, or processed
I try to change the status from mysql console with a UPDATE sentence, but the message is the same.
Can you help me?
Thanks!!
the UPDATE sentence is : UPDATE orders SET orders_status = 3 WHERE orders_id = 2;
and orders_id = 2 exists