Running a query to D1 throws 'D1_ERROR: Wrong number of parameter bindings for SQL'

Developers D1
1

Trying to run a query with 32 parameters. Happens with both anonymous, and numbered parameters. Reduced it to two parameters, same issue:

Log from Real-time log:

{
  "outcome": "exception",
  "scriptName": "my-script",
  "diagnosticsChannelEvents": [],
  "exceptions": [
    {
      "name": "Error",
      "message": "D1_ERROR: Wrong number of parameter bindings for SQL query.",
      "timestamp": 1709850594590
    }
  ],
...
npx wrangler info PROD_DB 
MacBook-Pro /Users/macbook $ npx wrangler d1 info PROD_DB
 ⛅️ wrangler 3.31.0 (update available 3.32.0)
-------------------------------------------------------
┌───────────────────┬──────────────────────────────────────┐
│ PROD_DB           │ b9871b58-e354-40e0-be77-91fa8d50edfe │
├───────────────────┼──────────────────────────────────────┤
│ name              │ prod-data                            │
├───────────────────┼──────────────────────────────────────┤
│ created_at        │ 2024-03-06T14:53:07.216Z             │
├───────────────────┼──────────────────────────────────────┤
│ version           │ beta                                 │
├───────────────────┼──────────────────────────────────────┤
│ num_tables        │ 1                                    │
├───────────────────┼──────────────────────────────────────┤
│ running_in_region │ WEUR                                 │
├───────────────────┼──────────────────────────────────────┤

The code snippet from the worker:

const query = `SELECT * FROM Prices WHERE Name = ? AND Day = ?`;

const stmt = env.PROD_DB.prepare(query);
stmt.bind(cardName, '2024-03-01');

return { ok: await stmt.all(), metadata: 'cool' };

What am I doing wrong?

1 Like
4

Try putting your args in an array and spreading it in .bind(), that did the trick for me and others (Error: D1_ERROR: Wrong number of parameter bindings for SQL query. · Issue #755 · cloudflare/miniflare · GitHub):

const arrArgs = [cardName, '2024-03-01'];
stmt.bind(...arrArgs)