Error: D1_ERROR: RangeError: Too many parameter values were provided with a query that had 24 values
Error: D1_ERROR: RangeError: Too many parameter values were provided
BB
Kalter table and it fails with Error code 23: Authorization denied. Reading the table works. Tried both through wranger and through the web console. I'm the only admin in the org, there's noone more powerful. Any ideas?
M
M
ALTER TABLE statement are you trying to run? (Post the query)M
K
alter table emailsignups add column source TEXT CHECK(source IN ('A','B'));K--localKKKKKKKM
PRAGMA ignore_check_constraints 
SSSSSSSSSSSSS
M
T
D1_ERROR: Error: Internal error in D1 storage caused object to be reset.KKKMMalter tableError code 23: Authorization deniedALTER TABLEalter table emailsignups add column source TEXT CHECK(source IN ('A','B'));--localPRAGMA ignore_check_constraintsSqliteError: NOT NULL constraint failed: lines.lineInPersonBuffer D1_ERROR: Error: Internal error in D1 storage caused object to be reset.CREATE TABLE lines (
lineNum INT IDENTITY(1,1) NOT NULL UNIQUE,
lineCreator INT NOT NULL,
lineImage TEXT NOT NULL DEFAULT 'https://maps.lineonline.app/line_default.png',
lineName VARCHAR(100) NOT NULL,
lineDescription TEXT,
lineType VARCHAR(100) NOT NULL,
permanent BOOLEAN NOT NULL,
lineEndTime DATETIME NOT NULL,
lineStartTime DATETIME NOT NULL,
lineInPersonBuffer INT NOT NULL DEFAULT 5,
-- -1 = auto based on average time per person and adjusted by number of misses
lineNumberOfRetries INT NOT NULL DEFAULT 3,
lineTimeoutOfRetryEligibilityMins INT NOT NULL DEFAULT 61,
PRIMARY KEY (lineNum)
);insFields.hasOwnProperty('lineImage')const line = await env.DB.prepare("INSERT INTO lines (?1) VALUES (?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13)")
.bind("lineNum, lineCreator, lineImage, lineName, lineDescription, lineType, permanent, lineEndTime, lineStartTime, lineInPersonBuffer, lineNumberOfRetries, lineTimeoutOfRetryEligibilityMins",
insFields.lineNum, insFields.lineCreator, insFields.lineImage, insFields.lineName, insFields.lineDescription, insFields.lineType, insFields.permanent.toString(), insFields.lineEndTime, insFields.lineStartTime, insFields.lineInPersonBuffer, insFields.lineNumberOfRetries, insFields.lineTimeoutOfRetryEligibilityMins).run();const defaultVal = null;
if (!insFields.hasOwnProperty('lineImage')) {
insFields.lineImage = defaultVal;
}
if (!insFields.hasOwnProperty('lineInPersonBuffer')) {
insFields.lineInPersonBuffer = defaultVal;
}
if (!insFields.hasOwnProperty('lineNumberOfRetries')) {
insFields.lineNumberOfRetries = defaultVal;
}
if (!insFields.hasOwnProperty('lineTimeoutOfRetryEligibilityMins')) {
insFields.lineTimeoutOfRetryEligibilityMins = defaultVal;
}
console.log(typeof insFields.permanent.toString());
const line = await env.DB.prepare("INSERT INTO lines (lineNum, lineCreator, lineImage, lineName, lineDescription, lineType, permanent, lineEndTime, lineStartTime, lineInPersonBuffer, lineNumberOfRetries, lineTimeoutOfRetryEligibilityMins) VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12)")
.bind(insFields.lineNum, insFields.lineCreator, insFields.lineImage, insFields.lineName, insFields.lineDescription, insFields.lineType, insFields.permanent.toString(), insFields.lineEndTime, insFields.lineStartTime, insFields.lineInPersonBuffer, insFields.lineNumberOfRetries, insFields.lineTimeoutOfRetryEligibilityMins).run();