• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Random MySQL update row failure

Your 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'"
}
Screenshot 2024-02-18 144833.png

Screenshot 2024-02-18 144735.png
 
P

Pabblymember11

Guest
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.


2024-02-20_15h57_09.png
 
Top