Trigger & error #1329 No data - zero rows fetched, selected, or processed

[saydack]

Hi
I've a problem with trigger

CREATE TRIGGER `jos_vm_shopper_group_after_upd_tr` AFTER UPDATE ON `jos_vm_shopper_group` FOR EACH ROW
BEGIN
DECLARE orgPrice DECIMAL(9,5);
     DECLARE newPrice DECIMAL(9,5);
     DECLARE proId int;
     DECLARE cur CURSOR FOR SELECT product_price,product_Id FROM jos_vm_product_price as t1 WHERE shopper_group_id=5;
 
 
IF (NEW.shopper_group_id=6) THEN
OPEN cur;
     LOOP
     FETCH cur INTO orgPrice,proId;
     SET newPrice=((orgPrice*100)/(100-NEW.shopper_group_discount));
 
     UPDATE jos_vm_product_price AS t3 SET product_price=newPrice WHERE shopper_group_id=6 AND t3.product_id=proId;
 
     END LOOP;
     CLOSE cur;
END IF;
END

trigger works but i get an error #1329 - No data - zero rows fetched, selected, or processed

Can someone help me?

MySQL v.5.1.54

[Rabbit]

If there's an error, then it's not working right?

Is your cursor supposed to use shopper group id 5 while the rest uses 6?

[saydack]

@Rabbit
ad1. Despite the fact it is a error UPDATE performed correctly
ad2. cursor takes the old price, rest update new price for other group