netlify/gocommerce

transactions list endpoint fails with SQL error

mraerino opened this issue · 0 comments

- Do you want to request a feature or report a bug?

Bug

- What is the current behavior?

When doing GET /payments with a valid admin JWT

Response:

{
    "code": 500,
    "msg": "Error while querying for transactions",
    "error_id": "d26ed729-8b42-4338-8eff-8106f1caa19b"
}

Log line:

time="2019-09-06T07:12:41Z" level=error msg="500: Error while querying for transactions" admin_id=46c504a5-2842-424b-b7f4-c37ccbddef17 component=api error="sql: expected 1 arguments, got 2" instance_id=1e551f3a-20c2-412c-9363-3eac1425606d method=GET netlify_id=344dbf88-fdf9-42bb-adb4-46f01eedd629 path=/payments referer= remote_addr="<redacted>:52247" request_id=d26ed729-8b42-4338-8eff-8106f1caa19b site_url="https://<redacted>" 

- If the current behavior is a bug, please provide the steps to reproduce.

Get a Netlify site with a GoCommerce service. Get an admin JWT for that site.
Do GET https://<site>/.netlify/commerce/payments

- What is the expected behavior?

Payments should be returned.

- Please mention your Go version, and operating system version.

Docker image of tag v1.7.0 on Netlify Kubernetes Cluster