Adding trigger on DB fail validation with error 500

[joel]

I've posted my problem on stackoverflow Here.
Appreciate any help

[bellini13]

first place is to look at your php error log.  a error 500 is almost always logged in the php error log

if I had to guess at the issue, Prestashop is performing some action at the same time the trigger is changing the reference.  Perhaps Prestashop or your payment module is attempting to update the same record using the reference, and that original reference no longer exists.

if you disable the trigger in mysql, does the 500 error go away?

[joel]

1 hour ago, bellini13 said:

 

 

yes