[SEQUELIZE003] DeprecateWarning

[Sebastian Cabrera Barreto]

Hello! After installing and configuring unified-red, i get this error when the node-red application is starting.

Welcome to Node-RED

===================

26 Apr 11:35:40 - [info] Node-RED version: v3.1.9
26 Apr 11:35:40 - [info] Node.js  version: v16.20.2
26 Apr 11:35:40 - [info] Linux 5.14.0-362.24.1.el9_3.0.1.x86_64 x64 LE
26 Apr 11:35:41 - [info] Loading palette nodes
26 Apr 11:35:42 - [info] Unified-RED Dashboard version 2.4.0 started at /
(node:5893) [SEQUELIZE0003] DeprecationWarning: String based operators are deprecated. Please use Symbol based operators for better security, read more at https://sequelize.org/master/manual/querying.html#operators
(Use `node --trace-deprecation ...` to show where the warning was created)
26 Apr 11:35:43 - [red] Uncaught Exception:
26 Apr 11:35:43 - [error] Error
    at Database.<anonymous> (/home/soporte/.node-red/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27)
    at /home/soporte/.node-red/node_modules/sequelize/lib/dialects/sqlite/query.js:183:50
    at new Promise (<anonymous>)
    at Query.run (/home/soporte/.node-red/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12)
    at /home/soporte/.node-red/node_modules/sequelize/lib/sequelize.js:315:28
    at async SQLiteQueryInterface.select (/home/soporte/.node-red/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)
    at async Function.findAll (/home/soporte/.node-red/node_modules/sequelize/lib/model.js:1140:21)
    at async Function.findOne (/home/soporte/.node-red/node_modules/sequelize/lib/model.js:1240:12)

    at async init (/home/soporte/.node-red/node_modules/unified-red/api/users/role.service.js:10:11)

sqlite3 --version :  3.34.1

[Jean-Rem]

Hello,

Same situation after Unified-red installation and configuration in the initial setup page

16 Jun 18:45:46 - [info] Unified-RED Dashboard version 2.4.0 started at /
(node:6404) [SEQUELIZE0003] DeprecationWarning: String based operators are deprecated. Please use Symbol based operators for better security, read more at https://sequelize.org/master/manual/querying.html#operators

(Use `node --trace-deprecation ...` to show where the warning was created)

16 Jun 18:45:47 - [red] Uncaught Exception:
16 Jun 18:45:47 - [error] Error
    at Query.run (C:\Users\STEMP5\.node-red\node_modules\sequelize\lib\dialects\mysql\query.js:52:25)
    at C:\Users\STEMP5\.node-red\node_modules\sequelize\lib\sequelize.js:315:28
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async MySQLQueryInterface.select (C:\Users\STEMP5\.node-red\node_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12)
    at async Role.findAll (C:\Users\STEMP5\.node-red\node_modules\sequelize\lib\model.js:1140:21)
    at async Role.findOne (C:\Users\STEMP5\.node-red\node_modules\sequelize\lib\model.js:1240:12)
    at async init (C:\Users\STEMP5\.node-red\node_modules\unified-red\api\users\role.service.js:10:11)

Actually i could not find where the problem could come from.

The only thing I could confirme is that the parameter to mysql DB are good. When entering these parameter directly in the db.squelize.js and running,

parameter are created in Mysql DB. But still stuck with the above error message.

Could someone tell me where I have to look ?

Kind Regards

[Sebastian Cabrera Barreto]

Hi Jean.

I remember solved that issue with a downgrade of sqlite version. Don´t know wich version worked at the moment since i deleted the project and started using the classic dashboard.

Try with some major version downgrade, maybe that works for you too.

Best regards

[Samy Arbid]

We were able to resolve this issue and the fix is included in the next release.