Database Error: Unknown Column in WHERE Clause

  • kush2904

    (@kush2904)


    10 months ago

    Database Error: Unknown Column in WHERE Clause (Razorpay Webhook)

    This is the error log:

    Unknown column ‘2280rzp_order_id’ in ‘where clause’
    SELECT rzp_webhook_data FROM c6_rzp_webhook_requests where order_id=2280rzp_order_id=order_QM32FeYf3PS6IO

    The Razorpay webhook plugin is executing a malformed SQL query.

    It’s trying to look for a column named 2280rzp_order_id, which clearly isn’t a valid column.

    Looks like a concatenation error in how the plugin is processing order IDs in the SQL WHERE clause.

    The WHERE clause is malformed.

    2286rzp_order_id=order_QM9zcghzNIL9Zx is not valid SQL.

    2286rzp_order_id is being interpreted as a column (which doesn’t exist).

    Suggest a fix.

    The page I need help with: [log in to see the link]

The topic ‘Database Error: Unknown Column in WHERE Clause’ is closed to new replies.