(/Users/gianwnp/Documents/Self-Learning/Web Development/alt-dental-art-ptk/server/node_modules/mysql/lib/Connection.js:88:28)Īt Socket. here are the details: Error inserting rows: Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '36809' for column 'tgl_kunjungan' at row 1Īt Query.Sequence._packetToError (/Users/gianwnp/Documents/Self-Learning/Web Development/alt-dental-art-ptk/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)Īt Query.ErrorPacket (/Users/gianwnp/Documents/Self-Learning/Web Development/alt-dental-art-ptk/server/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)Īt Protocol._parsePacket (/Users/gianwnp/Documents/Self-Learning/Web Development/alt-dental-art-ptk/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)Īt Parser._parsePacket (/Users/gianwnp/Documents/Self-Learning/Web Development/alt-dental-art-ptk/server/node_modules/mysql/lib/protocol/Parser.js:433:10)Īt Parser.write (/Users/gianwnp/Documents/Self-Learning/Web Development/alt-dental-art-ptk/server/node_modules/mysql/lib/protocol/Parser.js:43:10)Īt Protocol.write (/Users/gianwnp/Documents/Self-Learning/Web Development/alt-dental-art-ptk/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)Īt Socket. When I try to upload a file, it seems that it tells the date value that is inside the file is not in the correct format. Here's one of the samples and the data that I inserted on excel:
All sheets have been processed, remove the temporary file and send the response SheetsProcessed++ // Increment the counter for processed sheets Res.status(500).send("Error inserting rows.")
The codes are as follows: const router = require("express").Router() Ĭonst upload = multer() VALUES ?` Ĭonsole.error("Error inserting rows:", err)
#Php date format for mysql datetime code#
I have backend code that handles data insertion into the MySQL database from Excel file that will be uploaded on the client side.
0 kommentar(er)
