Edit History

Hi guys.

I have many products need preparation, so they are inactive until all informations has been added. I would like to change add_date for present when I click on Active on product card. I found this topic :

Vekia posted SQL trigger but it doesn't work on Presta 1.7.7, I'm getting message "#1064 - Something is wrong in your syntax obok 'END IF"

Do you have any solution to fix it?

Thanks in advance

//edit: I posted it in wrong section, please move it