Random MySQL update row failure
Status: Closed · Asked by MidSouthPabbly on · 0 views
Task History ID: IjU3NjMwNTZlMDYzNTA0MzM1MjZlNTUzNTUxM2E1MTY3NTQzNyI_3D_pc
I have an automation from a Gravity Form that updates a MySQL DB and I got an error in one that ran recently that I cannot figure out.
The first image is from one that went fine. The second image is the one that failed. They are identical except for the data. What am I missing?
Here is the error message:
{
"status": "error",
"message": "Unknown column 'INF' in 'where clause'"
}

Hey @MidSouthPabbly
Can you please try reconnecting the MYSQL action step once and then try again?

I get the same result
Hey @MidSouthPabbly
It seems that the value used in the WHERE clause of the Update Row action step does not exist in your MySQL database, potentially causing an error.
