Mysql stored procedured, node-red stops

Hello community, I have a problem.
When I do a query to call a stored procedure, node-red stops and I get the following information. I mounted node-red on another pc, I did the installation of the mysql node and I tested with a simple SELECT type query and there are no problems, but when I make a query to call a stored procedure, node-red stops, it is important to comment that with the version 1.2 of node-red and the previous one of the mysql node this problem did not occur. Greetings.

Test flow

[{"id":"2c90e6ab.f63112","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"c0da3d58.435548","type":"mysql","z":"2c90e6ab.f63112","mydb":"f0d52b31.059408","name":"","x":340,"y":180,"wires":[["538cb092.52b6b8"]]},{"id":"dd745132.c4f4","type":"inject","z":"2c90e6ab.f63112","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":180,"y":100,"wires":[["b94af6f6.2ca0e8"]]},{"id":"b94af6f6.2ca0e8","type":"function","z":"2c90e6ab.f63112","name":"","func":"msg.topic=\"CALL `OEE_PROD` ('2020-10-01','2021-05-04',false,'none');\";\n//msg.topic=\"SELECT * FROM `OEE` LIMIT 20;\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":330,"y":100,"wires":[["55e5851.a9c9ffc","c0da3d58.435548"]]},{"id":"538cb092.52b6b8","type":"debug","z":"2c90e6ab.f63112","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":490,"y":180,"wires":[]},{"id":"55e5851.a9c9ffc","type":"debug","z":"2c90e6ab.f63112","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":520,"y":100,"wires":[]},{"id":"f0d52b31.059408","type":"MySQLdatabase","name":"iotmysql","host":"","port":"3306","db":"IOTDimatra","tz":"","charset":"UTF8"}]

This has already been reported here:

1 Like

@JUANPAVQ it would be good idea to add a comment and your test flow to the issue so the developers know it is not just a one-off problem.

I don't understand you, attached test flow at the end

I meant to add a comment and your flow to the bug report linked by @hardillb node-red-node-mysql - Uncaught exception error (TypeError: is not a function) · Issue #802 · node-red/node-red-nodes · GitHub

1 Like

Ok, i get it, i will.Thanks

You should probably include details about your stored procedure and db schema for that procedure as we will need something to test it against.

1 Like

I already added a comment as you request.
I uninstalled v0.1.8 and installed v0.1.7 and tested it, it works fine.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.