Mysql issue with preparedquery and sha string

Questions
1

Hello,

When trying to insert 728e790 it seems it’s automatically converted to scientific notation and I’ve got an error
NodeOperationError: Unknown column 'Infinity' in 'field list' at Object.parseMySqlError

Seems to happen only with Mysql (ok with Postgresql).

Same issue with the most recent release of n8n as well (1.73.1, on my side, I’m running 1.59.4)

Do you know a way to force string evaluation ?

Many thanks !

Here how to reproduce:

  • n8n version: 1.59.4
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: linux
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

Ok think it’s 100% related to MySQL node bug: number string should not convert to Number · Issue #10151 · n8n-io/n8n · GitHub

Gonna add my inputs there

1 Like