search

stackhero-io / node-red-contrib-stackhero-mysql

Node-RED node to read and write to a MySQL or a MariaDB database. Compatible with TLS (SSL) and "Caching SHA2 password" authentication method.
16 stars 7 forks source link

1.0.3 : breaking change #6

Closed 0rsa closed 3 years ago

0rsa commented 3 years ago

Upgrading to the latest 1.0.3, all my queries return now : "msg.payload should be an object containing the query arguments." msg.payload is correct and was working fine before update. I roll back to previous version.

"msg.payload should be an object containing the query arguments."

topic: "INSERT IGNORE INTO enedis VALUES(:id, :instant, :base);" payload: object id: "2021-01-23 07:53:24" instant: "13" base: "017387265"

GrimbiXcode commented 3 years ago

I have already opened a pull request for this: https://github.com/stackhero-io/node-red-contrib-stackhero-mysql/pull/3

Bacto commented 3 years ago

Hi @0rsa and @GrimbiXcode, Can you give me an example of payload that is rejected? I don't understand why it doesn't work with the current code.

Bacto commented 3 years ago

Got it. It didn't work with Object.create(null). It is resolved with 1.0.4. Thanks to you two :)

GrimbiXcode commented 3 years ago

Nice, thanks!