Post reply

Recursive Triggers

  • December 19, 2022 at 12:48 pm

    #4127413

    I'm not sure about this.  It's a pretty common trigger to update the last updated date.  By default, that trigger does not cause the trigger to fire again.  Otherwise it would quickly hit the recursion limit.  This is the desired behavior.  If it needed to be changed, I'd have to change something.  Hopefully someone can provide more information.

  • December 19, 2022 at 4:40 pm

    #4127567

    Good catch. The server option defaults to on, but each database needs this enabled. Question changed.

  • December 20, 2022 at 12:16 pm

    #4127916

    Can you fix my wrong answer? 🙂

  • December 20, 2022 at 5:32 pm

    #4128056

    Maybe, I tripped some settings. Did that update you?

  • December 20, 2022 at 6:54 pm

    #4128100

    Still shows I'm wrong, but no worries.  Not a big deal.

  • December 20, 2022 at 6:58 pm

    #4128101

    I tried one more thing. Can you check again?

  • December 20, 2022 at 7:57 pm

    #4128119

    That worked.  Thanks.

  • December 21, 2022 at 3:44 pm

    #4128506

    Excellent. I was wondering what might fix things. This was something I used to just do wtih an UPDATE on the back end, but I lost an easy way to do this with the WP upgrade. Glad that the fix I requested actually works.

Viewing 8 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply