Random MySQL update row failure

Status: Closed · Asked by MidSouthPabbly on · 0 views

MidSouthPabbly — Question ·
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'"
}

Pabblymember11 — Reply ·

Hey @MidSouthPabbly

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

MidSouthPabbly — Reply ·

I get the same result

Pabblymember11 — Reply ·

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.

Back to all forum threads · Log in to reply