Node-mssql: Issues with tedious

[dang-1234]

I just installed mssql in to my new environment and I see these errors:
It works without errors in my old environment.

Any ideas?

Thanks!

_### tedious deprecated The IntN data type is internal and will be removed. node_modules\mssql\lib\tedious.js:63:20
tedious deprecated The BitN data type is internal and will be removed. node_modules\mssql\lib\tedious.js:71:40
tedious deprecated The FloatN data type is internal and will be removed. node_modules\mssql\lib\tedious.js:73:20
tedious deprecated The MoneyN data type is internal and will be removed. node_modules\mssql\lib\tedious.js:78:20
tedious deprecated The NumericN data type is internal and will be removed. node_modules\mssql\lib\tedious.js:82:44
tedious deprecated The DecimalN data type is internal and will be removed. node_modules\mssql\lib\tedious.js:83:44
tedious deprecated The DateTimeN data type is internal and will be removed. node_modules\mssql\lib\tedious.js:85:20
tedious deprecated The TimeN data type alias is deprecated, please use Time instead. node_modules\mssql\lib\tedious.js:88:20
tedious deprecated The DateN data type alias is deprecated, please use Date instead. node_modules\mssql\lib\tedious.js:89:20
tedious deprecated The DateTime2N data type alias is deprecated, please use DateTime2 instead. node_modules\mssql\lib\tedious.js:90:20
tedious deprecated The DateTimeOffsetN data type alias is deprecated, please use DateTimeOffset instead. node_modules\mssql\lib\tedious.js:91:20_

[cepm-nate]

I'm seeing this as well. Brand new install of node-mssql.

[CrescentCraftorium]

+1 - Version 4.1.0

Edit:

Rolling tedious back to Version 2.2.4 gets rid of these messages. May be an issue with that package.

[serkandurusoy]

Yup, and I'm getting

tedious deprecated The `IntN` data type is internal and will be removed. at ../../../../../node_modules/mssql-updated/lib/tedious.js:63:20

coming in from https://github.com/patriksimek/node-mssql/blob/master/lib/tedious.js#L63

[deepakbajaj]

Can you suggest how to roll back tedious to suggested version to solve the issue.

[CrescentCraftorium]

Either install that specific version with
npm install --save [email protected]
or edit your package.json to reflect that version and run npm update

"dependencies": {
  "mssql": "^4.1.0",
  "tedious": "2.2.4"
}

I did this as a troubleshooting step though. I don't know if mssql requires the latest version of tedious to operate properly or not, so this may break other features

[serkandurusoy]

@WebGaze nice workaroung, though I'd prefer moving forward instead of backward ;)

[deepakbajaj]

Thanks for quick reply :)

[magnusjt]

Why keep inaccurate dependencies in the first place? ("tedious": "^2.0.0"). I know it's supposed to be backwards compatible, but that's often just in theory.

[reksc]

Hi, is there a plan to include aca00f0 into a stable release? I have plenty of messages in my log due to this while using TypeORM.

[mottykohn]

Just realized @davepreston also created a fix, but not sure how that PR fixes the problem it only changes the switch from tds to sql. I think both have to be pulled to fully fix the problem.

[saostad]

What's the solution?
Any Help please?

[mottykohn]

@saostad for now you can do the following:
npm install https://github.com/justinwoo/node-mssql.git#fixes
Please note that this is not the official way of doing things but it should work. Maybe https://github.com/justinwoo can help you he is reachable on tweeter as posted on link.

[jonstuebe]

@mottykohn that is missing a couple of things. I added the rest of the deprecations in a new pr: https://github.com/tediousjs/node-mssql/pull/643

[jxjj]

If anyone lands here just wanting to silence the deprecation warnings, you can add an environment variable NO_DEPRECATION=tedious, as pointed out in tediousjs/tedious/pull/691.

For example, inpackage.json with ava as a testrunner:

"scripts": {
   "test": "NO_DEPRECATION=tedious ava"
}

[luker2]

Referencing @jonstuebe commit in package.json as described here works for me temporarily.

  "dependencies": {
    "mssql": "git+https://github.com/tediousjs/node-mssql.git#c9209d8b44141561de4fdf20bc43e30c140b5da7",
  }

UPDATE: I actually began receiving error fatal: reference is not a tree during npm install. Didn't dig into it too much, I'm back to defining "tedious": "2.2.4" in package.json

[frostbytedata]

So as a dev is it safe for me to suppress these errors for now until an update comes from Knex or Tedious (both)? I feel dirty just sweeping them under the rug.

[shawnmgoulet]

+1 for v4.1.0 - @WebGaze workaround throwing it back to v2.2.4 still works, looks like this PR submitted April 14th addresses it, but still hasn't been merged????? 🤔🤔

[patriksimek]

Fixed in #643. Sorry for the delay.

[ves-krd]

Still not fixed for me...

[patriksimek]

@ves-krd What version of node-mssql do you use?

[MyPublicGitHubAcct]

I am seeing something very similar today -

tedious deprecated The `IntN` data type is internal and will be removed. node_modules/mssql/lib/tedious.js:63:20
tedious deprecated The `BitN` data type is internal and will be removed. node_modules/mssql/lib/tedious.js:71:40
tedious deprecated The `FloatN` data type is internal and will be removed. node_modules/mssql/lib/tedious.js:73:20
tedious deprecated The `MoneyN` data type is internal and will be removed. node_modules/mssql/lib/tedious.js:78:20
tedious deprecated The `NumericN` data type is internal and will be removed. node_modules/mssql/lib/tedious.js:82:44
tedious deprecated The `DecimalN` data type is internal and will be removed. node_modules/mssql/lib/tedious.js:83:44
tedious deprecated The `DateTimeN` data type is internal and will be removed. node_modules/mssql/lib/tedious.js:85:20
tedious deprecated The `TimeN` data type alias is deprecated, please use `Time` instead. node_modules/mssql/lib/tedious.js:88:20
tedious deprecated The `DateN` data type alias is deprecated, please use `Date` instead. node_modules/mssql/lib/tedious.js:89:20
tedious deprecated The `DateTime2N` data type alias is deprecated, please use `DateTime2` instead. node_modules/mssql/lib/tedious.js:90:20
tedious deprecated The `DateTimeOffsetN` data type alias is deprecated, please use `DateTimeOffset` instead. node_modules/mssql/lib/tedious.js:91:20
tedious deprecated The `UniqueIdentifierN` data type alias is deprecated, please use `UniqueIdentifier` instead. node_modules/mssql/lib/tedious.js:93:20

with the following dependencies...

"dependencies": {
    "express": "^4.16.3",
    "mssql": "^4.1.0",
    "tedious": "^2.6.4"
  },

[mottykohn]

@MyPublicGitHubAcct You need version 4.2.0 via npm i mssql@next for this fix.