They were single quotes
fyi. loading mysql node globally to get access to mysql escape.
const mysql = global.get("mysql");
mysql.esacpe adds the single quotes for you.
VALUES (" + mysql.escape(data.partnumber) + "," + mysql.escape(data.name) + "
Produces
VALUES ('USA-BLUEKIT','Scott Drake Bluetooth® Interface for Custom Autosound CD Controller Radios','Bluetooth? Interface for Custom Autosound CD Controller Radios','2021-05-05 09:03:38')
Note the single quotes added.
Harry
edit
Oh you meant in the js
VALUES (' + mysql.escape(data.partnumber) + ',' + mysql.escape(data.name) + '
