CD
Cloudflare Developers•2mo ago
HolyKing

Uncaught (async) TypeError: Cannot read properties of undefined (reading 'prepare')

// wrangler.json
...
   "env": {
      "dev": {
         "d1_databases": [
            {
               "database_id": "5d8afa2c-3a3d-4c5e-aab1-37332dd9a6a5",
               "database_name": "drspy-serverless-dev",
               "binding": "DrspyServerless"
            }
         ]
      },
      "prod": {
         "d1_databases": [
            {
               "database_id": "",
               "database_name": "drspy-serverless-prod",
               "binding": "DrspyServerless"
            }
         ]
      }
   }
}
// wrangler.json
...
   "env": {
      "dev": {
         "d1_databases": [
            {
               "database_id": "5d8afa2c-3a3d-4c5e-aab1-37332dd9a6a5",
               "database_name": "drspy-serverless-dev",
               "binding": "DrspyServerless"
            }
         ]
      },
      "prod": {
         "d1_databases": [
            {
               "database_id": "",
               "database_name": "drspy-serverless-prod",
               "binding": "DrspyServerless"
            }
         ]
      }
   }
}
code: 
await c.env.DrspyServerless.prepare("INSERT INTO activity (active_players) VALUES (?);")
      .bind(onlineCount) // Bind the player count dynamically
      .run();
await c.env.DrspyServerless.prepare("INSERT INTO activity (active_players) VALUES (?);")
      .bind(onlineCount) // Bind the player count dynamically
      .run();
I'm trying to insert into a table and I'm getting this error. It works I add d1_databases key instead of nesting it in env. How do I handle different database for multiple environments?
1 Reply
HolyKing
HolyKingOP•2mo ago
Never mind, I forgot to add -e dev

Did you find this page helpful?