Insert strings with semicolons or other special characters into strings

[bdinsmore]

Describe the problem/error/question

Recently updated from 1.20 to 1.46 and it appears some behavior changed on the mysql nodes. I have an existing workflow that pulls a variety of fields including some commentary and metadata fields. Same workflow no longer runs due to these fields sometimes containing characters like semicolons in them (example : email field containing “[email protected];[email protected]”) Checking backwards in the data shows that some of these datapoints existed prior to the update so it wasn’t a showstopper at that point. Just need some guidance on whether I need to figure out a Code function to strip these characters out now or if there is a setting toggle somewhere I can adjust that I’ve missed.

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• n8n version: 1.46
• Database (default: SQLite): default for cloud hosted
• n8n EXECUTIONS_PROCESS setting (default: own, main): default for cloud hosted
• Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
• Operating system: n8n cloud

[aya]

Could you share your workflow or parts of it here by copy & pasting the workflow JSON content in between two block quotes (```)? @bdinsmore

[bdinsmore]

@aya

[bdinsmore]

Any updates on this?

[bdinsmore]

Last bump for support. Still having this issue even when I only pass a handful of valid data against an empty table copy with correct column names and data types

[Jon]

Hey @bdinsmore,

Are you able to share bigger versions of the error message so we can see the full thing? There is a newer version of the MySQL node available as well so it could be worth adding the node again to see if anything is different. You can see the node version under the node settings at the bottom.

[bdinsmore]

With New Node Version

Now it’s claiming either a similar parse error or field missing error

{
  "errorMessage": "Unknown column 'Loan.LoanNumber' in 'field list'",
  "errorDescription": "sql: INSERT INTO `2024_data_copy`(`loanId`, `Loan`.`LoanNumber`) VALUES('80f88968-3ee9-4fa5-a54f-e37288d93158','230111237A') ON DUPLICATE KEY UPDATE `Loan`.`LoanNumber` = '230111237A', code: ER_BAD_FIELD_ERROR",
  "errorDetails": {},
  "n8nDetails": {
    "nodeName": "MySQL",
    "nodeType": "n8n-nodes-base.mySql",
    "nodeVersion": 2.4,
    "resource": "database",
    "operation": "upsert",
    "itemIndex": 0,
    "time": "7/29/2024, 12:08:05 PM",
    "n8nVersion": "1.51.1 (Cloud)",
    "binaryDataMode": "filesystem",
    "stackTrace": [
      "NodeOperationError: Unknown column 'Loan.LoanNumber' in 'field list'",
      "    at Object.parseMySqlError (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/helpers/utils.js:81:12)",
      "    at /usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/helpers/utils.js:190:47",
      "    at processTicksAndRejections (node:internal/process/task_queues:95:5)",
      "    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/actions/database/upsert.operation.js:158:18)",
      "    at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/actions/router.js:48:30)",
      "    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/MySqlV2.node.js:16:16)",
      "    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:728:19)",
      "    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:673:51",
      "    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1085:20"
    ]
  }
}```