Problem with setup of d1 database

P

proudyyyy•12/10/23, 9:17 PM

Hey, so I've got a problem with setting up my d1 database. I was following the cloudflare d1 docs carefully and doing all the steps (https://developers.cloudflare.com/d1/get-started/), and then it threw this error:

PS C:\Users\Pyke\vscode-projects\healthInspection\database> npx wrangler d1 execute healthyinspection-db --local --file=./schema.sql
🌀 Mapping SQL input into an array of statements
🌀 Executing on local database healthyinspection-db (a3b682b3-f960-44d4-a85d-17871c266637) from .wrangler\state\v3\d1:

X [ERROR] SQL code did not contain a statement.


If you think this is a bug then please create an issue at https://github.com/cloudflare/workers-sdk/issues/new/choose
🪵  Logs were written to "C:\Users\Pyke\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2023-12-10_21-14-19_077.log"

PS C:\Users\Pyke\vscode-projects\healthInspection\database> npx wrangler d1 execute healthyinspection-db --local --file=./schema.sql
🌀 Mapping SQL input into an array of statements
🌀 Executing on local database healthyinspection-db (a3b682b3-f960-44d4-a85d-17871c266637) from .wrangler\state\v3\d1:

X [ERROR] SQL code did not contain a statement.


If you think this is a bug then please create an issue at https://github.com/cloudflare/workers-sdk/issues/new/choose
🪵  Logs were written to "C:\Users\Pyke\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2023-12-10_21-14-19_077.log"

PS C:\Users\Pyke\vscode-projects\healthInspection\database> npx wrangler d1 execute healthyinspection-db --local --file=./schema.sql
🌀 Mapping SQL input into an array of statements
🌀 Executing on local database healthyinspection-db (a3b682b3-f960-44d4-a85d-17871c266637) from .wrangler\state\v3\d1:

X [ERROR] SQL code did not contain a statement.


If you think this is a bug then please create an issue at https://github.com/cloudflare/workers-sdk/issues/new/choose
🪵  Logs were written to "C:\Users\Pyke\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2023-12-10_21-14-19_077.log"

PS C:\Users\Pyke\vscode-projects\healthInspection\database> npx wrangler d1 execute healthyinspection-db --local --file=./schema.sql
🌀 Mapping SQL input into an array of statements
🌀 Executing on local database healthyinspection-db (a3b682b3-f960-44d4-a85d-17871c266637) from .wrangler\state\v3\d1:

X [ERROR] SQL code did not contain a statement.


If you think this is a bug then please create an issue at https://github.com/cloudflare/workers-sdk/issues/new/choose
🪵  Logs were written to "C:\Users\Pyke\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2023-12-10_21-14-19_077.log"

This is how my schema.sql file looks like, and as you can see there is in fact a statement so that can't be true the error message:

DROP TABLE IF EXISTS Accounts;
CREATE TABLE IF NOT EXISTS Accounts (
    Id INTEGER PRIMARY KEY NOT NULL, 
    Email TEXT NOT NULL, 
    Username TEXT NOT NULL, Password TEXT NOT NULL, 
    FirstName TEXT, LastName TEXT, 'Language' TEXT NOT NULL DEFAULT 'de', 
    Age INTEGER, Height INTEGER, 'Weight' INTEGER, 
    UpdatedAt TEXT DEFAULT CURRENT_TIMESTAMP, 
    CreatedAt TEXT DEFAULT CURRENT_TIMESTAMP
);

-- INSERT INTO Customers (CustomerID, CompanyName, ContactName) 
--     VALUES (1, 'Alfreds Futterkiste', 'Maria Anders'), 
--     (4, 'Around the Horn', 'Thomas Hardy'), 
--     (11, 'Bs Beverages', 'Victoria Ashworth'), 
--     (13, 'Bs Beverages', 'Random Name');

DROP TABLE IF EXISTS Accounts;
CREATE TABLE IF NOT EXISTS Accounts (
    Id INTEGER PRIMARY KEY NOT NULL, 
    Email TEXT NOT NULL, 
    Username TEXT NOT NULL, Password TEXT NOT NULL, 
    FirstName TEXT, LastName TEXT, 'Language' TEXT NOT NULL DEFAULT 'de', 
    Age INTEGER, Height INTEGER, 'Weight' INTEGER, 
    UpdatedAt TEXT DEFAULT CURRENT_TIMESTAMP, 
    CreatedAt TEXT DEFAULT CURRENT_TIMESTAMP
);

-- INSERT INTO Customers (CustomerID, CompanyName, ContactName) 
--     VALUES (1, 'Alfreds Futterkiste', 'Maria Anders'), 
--     (4, 'Around the Horn', 'Thomas Hardy'), 
--     (11, 'Bs Beverages', 'Victoria Ashworth'), 
--     (13, 'Bs Beverages', 'Random Name');

DROP TABLE IF EXISTS Accounts;
CREATE TABLE IF NOT EXISTS Accounts (
    Id INTEGER PRIMARY KEY NOT NULL, 
    Email TEXT NOT NULL, 
    Username TEXT NOT NULL, Password TEXT NOT NULL, 
    FirstName TEXT, LastName TEXT, 'Language' TEXT NOT NULL DEFAULT 'de', 
    Age INTEGER, Height INTEGER, 'Weight' INTEGER, 
    UpdatedAt TEXT DEFAULT CURRENT_TIMESTAMP, 
    CreatedAt TEXT DEFAULT CURRENT_TIMESTAMP
);

-- INSERT INTO Customers (CustomerID, CompanyName, ContactName) 
--     VALUES (1, 'Alfreds Futterkiste', 'Maria Anders'), 
--     (4, 'Around the Horn', 'Thomas Hardy'), 
--     (11, 'Bs Beverages', 'Victoria Ashworth'), 
--     (13, 'Bs Beverages', 'Random Name');

DROP TABLE IF EXISTS Accounts;
CREATE TABLE IF NOT EXISTS Accounts (
    Id INTEGER PRIMARY KEY NOT NULL, 
    Email TEXT NOT NULL, 
    Username TEXT NOT NULL, Password TEXT NOT NULL, 
    FirstName TEXT, LastName TEXT, 'Language' TEXT NOT NULL DEFAULT 'de', 
    Age INTEGER, Height INTEGER, 'Weight' INTEGER, 
    UpdatedAt TEXT DEFAULT CURRENT_TIMESTAMP, 
    CreatedAt TEXT DEFAULT CURRENT_TIMESTAMP
);

-- INSERT INTO Customers (CustomerID, CompanyName, ContactName) 
--     VALUES (1, 'Alfreds Futterkiste', 'Maria Anders'), 
--     (4, 'Around the Horn', 'Thomas Hardy'), 
--     (11, 'Bs Beverages', 'Victoria Ashworth'), 
--     (13, 'Bs Beverages', 'Random Name');

So when further searching for the error, I was watching the .wrangler's logs and found this:

--- 2023-12-10T21:18:54.162Z debug
🪵  Writing logs to "C:\Users\Pyke\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2023-12-10_21-18-53_940.log"
---

--- 2023-12-10T21:18:54.162Z debug
Failed to load .env file ".env": Error: ENOENT: no such file or directory, open '.env'
    at Object.openSync (node:fs:603:3)
    at Object.readFileSync (node:fs:471:35)
    at tryLoadDotEnv (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:122684:72)
    at loadDotEnv (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:122693:12)
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:145784:20
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:129270:16
    at maybeAsyncResult (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:127491:44)
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:129269:14
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:127478:22
    at Array.reduce (<anonymous>) {
  errno: -4058,
  syscall: 'open',
  code: 'ENOENT',
  path: '.env'
}
---

--- 2023-12-10T21:18:54.170Z log
🌀 Mapping SQL input into an array of statements
---

--- 2023-12-10T21:18:54.172Z log
🌀 Executing on local database healthyinspection-db (a3b682b3-f960-44d4-a85d-17871c266637) from .wrangler\state\v3\d1:
---

--- 2023-12-10T21:18:54.162Z debug
🪵  Writing logs to "C:\Users\Pyke\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2023-12-10_21-18-53_940.log"
---

--- 2023-12-10T21:18:54.162Z debug
Failed to load .env file ".env": Error: ENOENT: no such file or directory, open '.env'
    at Object.openSync (node:fs:603:3)
    at Object.readFileSync (node:fs:471:35)
    at tryLoadDotEnv (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:122684:72)
    at loadDotEnv (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:122693:12)
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:145784:20
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:129270:16
    at maybeAsyncResult (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:127491:44)
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:129269:14
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:127478:22
    at Array.reduce (<anonymous>) {
  errno: -4058,
  syscall: 'open',
  code: 'ENOENT',
  path: '.env'
}
---

--- 2023-12-10T21:18:54.170Z log
🌀 Mapping SQL input into an array of statements
---

--- 2023-12-10T21:18:54.172Z log
🌀 Executing on local database healthyinspection-db (a3b682b3-f960-44d4-a85d-17871c266637) from .wrangler\state\v3\d1:
---

--- 2023-12-10T21:18:54.162Z debug
🪵  Writing logs to "C:\Users\Pyke\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2023-12-10_21-18-53_940.log"
---

--- 2023-12-10T21:18:54.162Z debug
Failed to load .env file ".env": Error: ENOENT: no such file or directory, open '.env'
    at Object.openSync (node:fs:603:3)
    at Object.readFileSync (node:fs:471:35)
    at tryLoadDotEnv (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:122684:72)
    at loadDotEnv (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:122693:12)
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:145784:20
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:129270:16
    at maybeAsyncResult (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:127491:44)
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:129269:14
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:127478:22
    at Array.reduce (<anonymous>) {
  errno: -4058,
  syscall: 'open',
  code: 'ENOENT',
  path: '.env'
}
---

--- 2023-12-10T21:18:54.170Z log
🌀 Mapping SQL input into an array of statements
---

--- 2023-12-10T21:18:54.172Z log
🌀 Executing on local database healthyinspection-db (a3b682b3-f960-44d4-a85d-17871c266637) from .wrangler\state\v3\d1:
---

--- 2023-12-10T21:18:54.162Z debug
🪵  Writing logs to "C:\Users\Pyke\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2023-12-10_21-18-53_940.log"
---

--- 2023-12-10T21:18:54.162Z debug
Failed to load .env file ".env": Error: ENOENT: no such file or directory, open '.env'
    at Object.openSync (node:fs:603:3)
    at Object.readFileSync (node:fs:471:35)
    at tryLoadDotEnv (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:122684:72)
    at loadDotEnv (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:122693:12)
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:145784:20
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:129270:16
    at maybeAsyncResult (C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:127491:44)
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:129269:14
    at C:\Users\Pyke\vscode-projects\healthInspection\database\node_modules\wrangler\wrangler-dist\cli.js:127478:22
    at Array.reduce (<anonymous>) {
  errno: -4058,
  syscall: 'open',
  code: 'ENOENT',
  path: '.env'
}
---

--- 2023-12-10T21:18:54.170Z log
🌀 Mapping SQL input into an array of statements
---

--- 2023-12-10T21:18:54.172Z log
🌀 Executing on local database healthyinspection-db (a3b682b3-f960-44d4-a85d-17871c266637) from .wrangler\state\v3\d1:
---

M

Matt Silverlock•12/10/23, 9:56 PM

The missing

env

env

env

env file is unrelated.

M

Matt Silverlock•12/10/23, 9:56 PM

Remove the comments from the file.

M

Matt Silverlock•12/10/23, 9:57 PM

schema.sql

schema.sql

schema.sql

schema.sql in the docs does not look like that: https://developers.cloudflare.com/d1/get-started/#configure-your-d1-database

Get started · Cloudflare D1 docs

This guide will instruct you through:

J

JustinNoel•12/10/23, 11:19 PM

SQL code did not contain a statement.

does your file have a commented out line of code? If so, the importer won't work. You'll have to remove the comment.

P

proudyyyy•12/11/23, 6:40 PM

thank you the comment was the issue, I didn't knew that the importer doesn't support comments.

Similar Threads

Similar Threads

Similar Threads