Have you tested changing the status on an order manually through the drop down list in the Store Admin module? Does it update the status or show an error at the top of the page? Does the trigger function when you do this? I would recommend testing and then remove the triggers and test again to eliminate them as the cause of your IPN issues. I too am having IPN issues with the Store module even if the triggers have not been installed. To answer your question - yes - you can change the trigger to work on Awaiting Payment (status of 2) instead of Paid (status of 7). I would NOT recommend doing that because users who go to PayPal and cancel without paying will also be unlocked! If you want to make this change anyway then change the following line of code: IF (SELECT OrderStatusID FROM INSERTED) = 7 --PAID to IF (SELECT OrderStatusID FROM INSERTED) = 2 --Awaiting Payment Again, I would not make that change unless you are OK with giving away your products!

Hi,

You should read this post! :-)

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.

I am no longer using the triggers since Gilles built this functionality into version 2.1.34, but the error sounds like there is now a column named RoleID in a store table where there was not before. The fix would be to add the table name to the column so SQL can identify which RoleID we want (since this field now exists in more than one table). Just add “Table.” to the RoleID (like v05_ProductRoles.roleid) in the trigger to disambiguate the reference. I don’t remember the name of the table I created but it starts with v05_ By the way – my error with PayPal IPN not working turned out to be that I had the Store Account page visible only to registered users. Thanks to Gilles once more for his assistance and tireless professional support of such a great product!