(node:25745) UnhandledPromiseRejectionWarning: Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xF0\x9F\xA4\x96 B...' for column 'FullDescription' at row 1
at Query.Sequence._packetToError (/home/new-dblista/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/home/new-dblista/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
at Protocol._parsePacket (/home/new-dblista/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/home/new-dblista/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/home/new-dblista/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/home/new-dblista/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket. (/home/new-dblista/node_modules/mysql/lib/Connection.js:91:28)
at Socket. (/home/new-dblista/node_modules/mysql/lib/Connection.js:525:10)
at Socket.emit (events.js:210:5)
at addChunk (_stream_readable.js:326:12)
--------------------
at Protocol._enqueue (/home/new-dblista/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Connection.query (/home/new-dblista/node_modules/mysql/lib/Connection.js:201:25)
at /home/new-dblista/database.js:29:24
at new Promise ()
at Object.queryV (/home/new-dblista/database.js:28:16)
at /home/new-dblista/move.js:8:9
at Array.forEach ()
at Object. (/home/new-dblista/move.js:6:32)
at Module._compile (internal/modules/cjs/loader.js:1121:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1160:10)
(node:25745) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 2)“Incorrect string value” - błąd MySQL
Pytania i problemy
Mespi
Mespi
Kodowanie: uft8mb4_general_ci
error
UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch().Wystąpił błąd a ty go nie złapałeś i nie obsłużyłeś, więc rzuca błędami na całą konsolę :man_shrugging:
Mespi
error:
Wystąpił błąd a ty go nie złapałeś i nie obsłużyłeś, więc rzuca błędami na całą konsolę :man_shrugging:
Akurat nie chodzi mi o to
Mówię o tym ↓
Mespi:
UnhandledPromiseRejectionWarning: Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: ‘\xF0\x9F\xA4\x96 B…’ for column ‘FullDescription’ at row 1
DBanaszewski α-tester v3
Jeżeli używasz biblioteki mysql z npma, do poola/connection dodaj:
charset: "utf8mb4"Przykład z poolem:
let pool = mysql.createPool({
host: "localhost",
port: 3306,
user: "root",
password: "password",
database: "database",
charset: "utf8mb4",
waitForConnections: true,
connectionLimit: 50,
queueLimit: 0
});Przykład z connection:
let conn = mysql.createConnection{
host: "localhost",
port: 3306,
user: "root",
password: "password",
database: "database",
charset: "utf8mb4"
});
system
Ten temat został automatycznie zamknięty 32 dni po ostatnim wpisie. Tworzenie nowych odpowiedzi nie jest już możliwe.