HolyKing
HolyKing
PostsComments
CDCloudflare Developers
Created by HolyKing on 1/31/2025 in #workers-help
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?
2 replies