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

  • Due to Diwali and Bhai Dooj celebrations, our team will have limited availability. While we’ll continue to monitor threads, responses may be slightly delayed. Normal operations will resume on Friday, 24th October 2025.

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