• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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