SS
K
C
P
Y
. I need help accessing tables in databases. I have created a database and binded it to my worker through workers.toml file. But when I make a search in a particular table, it gives "no such table" error. Here is an image of tables in my database, "Customers" is just for test purposes.
Y
app.get('/posts/:lang/:slug/comments', async c => {
const { results } = await c.env.comDB.prepare();
return c.text(results, 200);
}Y
YC
—local flag
ICIIY
C
.all()Error: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'CPP
email_verified BOOLEAN DEFAULT 0,PCtrue1
R
U
T
K
G
HGHGH
HGCG
M
F
E
Z
N
migrations directory?db, the complete location being ./db/migrationsapp.get('/posts/:lang/:slug/comments', async c => {
const { results } = await c.env.comDB.prepare();
return c.text(results, 200);
}—localError: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'email_verified BOOLEAN DEFAULT 0,migrationsdb./db/migrationsmigrations_dir = "db/migrations"
CDCloudflare Developers / d1-databaseCDCloudflare Developers / pages-helpCDCloudflare Developers / workers-and-pages-helpCDCloudflare Developers / workers-and-pages-help