“Incorrect string value” - błąd MySQL

Mespi | 2020-01-04 10:13:58 UTC | #1

(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.<anonymous> (/home/new-dblista/node_modules/mysql/lib/Connection.js:91:28)
    at Socket.<anonymous> (/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 (<anonymous>)
    at Object.queryV (/home/new-dblista/database.js:28:16)
    at /home/new-dblista/move.js:8:9
    at Array.forEach (<anonymous>)
    at Object.<anonymous> (/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)

Mespi | 2020-01-04 09:46:09 UTC | #2

Kodowanie: uft8mb4generalci

error | 2020-01-04 09:52:30 UTC | #3

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 | 2020-01-04 09:58:22 UTC | #4

[quote=”error, post:3, topic:13173”]
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:
[/quote]

Akurat nie chodzi mi o to

Mówię o tym ↓

[quote=”Mespi, post:1, topic:13173”]
UnhandledPromiseRejectionWarning: Error: ERTRUNCATEDWRONGVALUEFOR_FIELD: Incorrect string value: ‘\xF0\x9F\xA4\x96 B…’ for column ‘FullDescription’ at row 1
[/quote]

DBanaszewski | 2020-01-04 10:35:08 UTC | #5

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 | 2020-02-05 10:16:15 UTC | #6

Ten temat został automatycznie zamknięty 32 dni po ostatnim wpisie. Tworzenie nowych odpowiedzi nie jest już możliwe.