Hi everybody,

I am struggling to set up an EVENT in mysql - But it doesnt execute the commands, and I have spend hours to figure out why by now.
I hope to find the answer here :-)

This is the code for the event:

Code MySQL:
delimiter | 
CREATE EVENT delete_cart 
ON SCHEDULE 
EVERY 5 MINUTE 
DO 
BEGIN 
 
DECLARE cartID INTEGER( 11 ) ; 
DECLARE cartProductID INTEGER( 11 ) ; 
DECLARE cartAntal INTEGER( 11 ) ; 
DECLARE cartStr VARCHAR( 5 ) ;
 
SELECT id, produkt_id, antal, str INTO cartID, cartProductID, cartAntal, cartStr FROM cart WHERE added_date >= added_date +10000 LIMIT 1;
 
UPDATE products SET stock = stock + cartAntal WHERE produkt_id = cartProductID;
 
UPDATE sizes SET antal = antal + cartAntal WHERE size = cartStr AND product_id = cartProductID;
 
DELETE FROM cart WHERE id = cartID;
 
END | 
delimiter ;

It is pretty straight forward what should happen here. The EVENT is set up and running, but nothing happens.

The event_scheduler is set to ON.

I just cant see why?

Has the variables been declared with a wrong syntax?

Hope to get an answer on this soon, thanks!

Klemme