For Workers & Pages, what is the name of the domain?
no
What is the error number?
7500
What is the error message?
{“errors”:[{“code”:7500,“message”:“internal error; reference = e_PVSMDp_40009b88312c4a19a794699a0e38bac9”}],“success”:false,“messages”:,“result”:null}
What is the issue or error you’re encountering
I’m calling POST /accounts/{account_id}/d1/database/{database_id}/query, using {"sql":"DROP TABLE IF EXISTS collections;DROP TABLE IF EXISTS collection_items","params":[]}
, and get the error above.
What steps have you taken to resolve the issue?
Check Cloudflare Token, SQL syntax and so one.
Single sql statement is ok, but, according the document,
sql: string
Your SQL query. Supports multiple statements, joined by semicolons, which will be executed as a batch.
SQL statements joined by ‘;’ can not be run like
DROP TABLE IF EXISTS collections;DROP TABLE IF EXISTS collection_items
SELECT * FROM collections; SELECT * FROM collection_items LIMIT 10
What are the steps to reproduce the issue?
run the sqls joined by ‘;’ using the /accounts/{account_id}/d1/database/{database_id}/query API