X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=routes%2Fall.js;fp=routes%2Fall.js;h=d5b4e569d1cde8fc3ffd99c056aa6576e4b955ce;hb=3a60958052399bcfcdda221de2c3cb8abe7f19ea;hp=b9665327dab08dd76a24bfbcb5d0e38cfa586484;hpb=5411d2cd3bc44c836cd7698e4d475887a1ebe74d;p=vchess.git

diff --git a/routes/all.js b/routes/all.js
index b9665327..d5b4e569 100644
--- a/routes/all.js
+++ b/routes/all.js
@@ -74,7 +74,8 @@ router.post("/problems/:variant([a-zA-Z0-9]+)", (req,res) => {
 	const instructions = sanitizeHtml(req.body["instructions"]);
 	const solution = sanitizeHtml(req.body["solution"]);
 	db.serialize(function() {
-		let stmt = db.prepare("INSERT INTO Problems VALUES (?,?,?,?,?)");
+		let stmt = db.prepare("INSERT INTO Problems " +
+			"(added,variant,fen,instructions,solution) VALUES (?,?,?,?,?)");
 		stmt.run(timestamp, vname, fen, instructions, solution);
 		stmt.finalize();
 	});