Failed Apple IAP Receipt Validation

Runtime Framework
,
1

When validating sandbox receipts, I receive a strange error that doesn’t give me much to go on. Validating the receipt locally works. I can provide the receipt and shared secret if needed.

I have tried completely deleting the database and starting fresh, but I still get the same error.

  1. Versions: Nakama v3.15.0, Docker, REST
  2. Server Framework Runtime language: Go
REST Endpoint: "v2/iap/purchase/apple"

Response: NakamaError(code: 2, message: "ERROR: syntax error at or near \"$8\" (SQLSTATE 42601)")

Just looking for any input on what I am possibly doing wrong; thanks!

EDIT: It looks like it’s an error thrown from the database:

2023-02-04 19:59:20.133 UTC [66] ERROR:  syntax error at or near "$8" at character 274
2023-02-04 19:59:20.133 UTC [66] STATEMENT:  
        INSERT
        INTO
            purchase
                (
                    user_id,
                    store,
                    transaction_id,
                    product_id,
                    purchase_time,
                    raw_response,
                    environment,
                                                        refund_time
                )
        VALUES
            ($1, $2, $3, $4, $5, $6, $7 $8), ($9, $10, $11, $12, $13, $14, $15 $16), ($17, $18, $19, $20, $21, $22, $23 $24)
        ON CONFLICT
            (transaction_id)
        DO UPDATE SET
            refund_time = $8, update_time = now()
        RETURNING
            transaction_id, create_time, update_time, refund_time
2

Hello @BergerBytes, please see: Getting SQL Error on Google Receipt Validation persist=true - #2 by mharis

3

Ah, I missed that post. I only searched for Apple. Thank you!