kehangchen / node-red-contrib-sqldbs

1 stars 4 forks source link

RangeError: Index out of range #3

Open rossnewby opened 7 years ago

rossnewby commented 7 years ago

After install, my node-red now has a fatal error when trying to launch. I have tried uninstalling and restarting, what is happening? Output on the command line below:

7 Sep 13:02:27 - [info] Starting flows
{ id: 'ac64dd65.12274',
  type: 'sqldbsdatabase',
  z: '',
  host: '127.0.0.1',
  port: '3306',
  db: 'eisquality',
  dialect: 'mssql',
  _users: [ '6d1998e5.7dcb88' ] }
dialect: mssql
Sequelize {
  options:
   { dialect: 'mssql',
     dialectModulePath: null,
     host: '127.0.0.1',
     protocol: 'tcp',
     define: {},
     query: {},
     sync: {},
     timezone: '+00:00',
     logging: [Function: bound ],
     omitNull: false,
     native: false,
     replication: false,
     ssl: undefined,
     pool: { max: 5, min: 0, idle: 10000 },
     quoteIdentifiers: true,
     hooks: {},
     retry: { max: 5, match: [Object] },
     transactionType: 'DEFERRED',
     isolationLevel: 'REPEATABLE READ',
     databaseVersion: 0,
     typeValidation: false,
     benchmark: false,
     port: '3306' },
  config:
   { database: 'eisquality',
     username: 'root',
     password: 'password',
     host: '127.0.0.1',
     port: '3306',
     pool: { max: 5, min: 0, idle: 10000 },
     protocol: 'tcp',
     native: false,
     ssl: undefined,
     replication: false,
     dialectModulePath: null,
     keepDefaultTimezone: undefined,
     dialectOptions: undefined },
  dialect:
   MssqlDialect {
     sequelize: [Circular],
     connectionManager:
      ConnectionManager {
        sequelize: [Circular],
        config: [Object],
        dialect: [Circular],
        versionPromise: null,
        dialectName: 'mssql',
        onProcessExit: [Function: bound ],
        lib: [Object],
        pool: [Object] },
     QueryGenerator:
      { options: [Object],
        extractTableDetails: [Function: extractTableDetails],
        addSchema: [Function: addSchema],
        dropSchema: [Function: dropSchema],
        createTableQuery: [Function: createTableQuery],
        versionQuery: [Function: versionQuery],
        describeTableQuery: [Function: describeTableQuery],
        dropTableQuery: [Function: dropTableQuery],
        renameTableQuery: [Function: renameTableQuery],
        showTablesQuery: [Function: showTablesQuery],
        addColumnQuery: [Function: addColumnQuery],
        removeColumnQuery: [Function: removeColumnQuery],
        changeColumnQuery: [Function: changeColumnQuery],
        renameColumnQuery: [Function: renameColumnQuery],
        insertQuery: [Function: insertQuery],
        bulkInsertQuery: [Function: bulkInsertQuery],
        updateQuery: [Function: updateQuery],
        upsertQuery: [Function: upsertQuery],
        deleteQuery: [Function: deleteQuery],
        incrementQuery: [Function: incrementQuery],
        nameIndexes: [Function: nameIndexes],
        addIndexQuery: [Function: addIndexQuery],
        showIndexesQuery: [Function: showIndexesQuery],
        removeIndexQuery: [Function: removeIndexQuery],
        attributesToSQL: [Function: attributesToSQL],
        findAutoIncrementField: [Function: findAutoIncrementField],
        quoteTable: [Function: quoteTable],
        quote: [Function: quote],
        createTrigger: [Function: createTrigger],
        dropTrigger: [Function: dropTrigger],
        renameTrigger: [Function: renameTrigger],
        createFunction: [Function: createFunction],
        dropFunction: [Function: dropFunction],
        renameFunction: [Function: renameFunction],
        quoteIdentifier: [Function: quoteIdentifier],
        quoteIdentifiers: [Function: quoteIdentifiers],
        escape: [Function: escape],
        getForeignKeysQuery: [Function: getForeignKeysQuery],
        dropForeignKeyQuery: [Function: dropForeignKeyQuery],
        selectQuery: [Function: selectQuery],
        getQueryOrders: [Function: getQueryOrders],
        selectFromTableFragment: [Function: selectFromTableFragment],
        joinIncludeQuery: [Function: joinIncludeQuery],
        setAutocommitQuery: [Function: setAutocommitQuery],
        setIsolationLevelQuery: [Function: setIsolationLevelQuery],
        generateTransactionId: [Function: generateTransactionId],
        startTransactionQuery: [Function: startTransactionQuery],
        deferConstraintsQuery: [Function: deferConstraintsQuery],
        setConstraintQuery: [Function: setConstraintQuery],
        setDeferredQuery: [Function: setDeferredQuery],
        setImmediateQuery: [Function: setImmediateQuery],
        commitTransactionQuery: [Function: commitTransactionQuery],
        rollbackTransactionQuery: [Function: rollbackTransactionQuery],
        addLimitAndOffset: [Function: addLimitAndOffset],
        handleSequelizeMethod: [Function: handleSequelizeMethod],
        whereQuery: [Function: whereQuery],
        whereItemsQuery: [Function: whereItemsQuery],
        whereItemQuery: [Function: whereItemQuery],
        getWhereConditions: [Function: getWhereConditions],
        booleanValue: [Function: booleanValue],
        dialect: 'mssql',
        createSchema: [Function: createSchema],
        showSchemasQuery: [Function: showSchemasQuery],
        attributeToSQL: [Function: attributeToSQL],
        getForeignKeyQuery: [Function: getForeignKeyQuery],
        getPrimaryKeyConstraintQuery: [Function: getPrimaryKeyConstraintQuery],
        getDefaultConstraintQuery: [Function: getDefaultConstraintQuery],
        dropConstraintQuery: [Function: dropConstraintQuery],
        _dialect: [Circular],
        sequelize: [Circular],
        typeValidation: undefined } },
  models: {},
  modelManager: ModelManager { models: [], sequelize: [Circular] },
  connectionManager:
   ConnectionManager {
     sequelize: [Circular],
     config:
      { database: 'eisquality',
        username: 'root',
        password: 'password',
        host: '127.0.0.1',
        port: '3306',
        pool: [Object],
        protocol: 'tcp',
        native: false,
        ssl: undefined,
        replication: false,
        dialectModulePath: null,
        keepDefaultTimezone: undefined,
        dialectOptions: undefined },
     dialect:
      MssqlDialect {
        sequelize: [Circular],
        connectionManager: [Circular],
        QueryGenerator: [Object] },
     versionPromise: null,
     dialectName: 'mssql',
     onProcessExit: [Function: bound ],
     lib:
      { BulkLoad: [Function: BulkLoad],
        Connection: [Function: Connection],
        Request: [Function: Request],
        library: [Object],
        ConnectionError: [Object],
        RequestError: [Object],
        TYPES: [Object],
        ISOLATION_LEVEL: [Object],
        TDS_VERSION: [Object] },
     pool:
      Pool {
        _factory: [Object],
        _inUseObjects: [],
        _draining: false,
        _waitingClients: [Object],
        _availableObjects: [],
        _count: 0,
        _removeIdleTimer: null,
        _removeIdleScheduled: false } },
  importCache: {},
  test:
   { '$trackRunningQueries': false,
     '$runningQueries': 0,
     trackRunningQueries: [Function: trackRunningQueries],
     verifyNoRunningQueries: [Function: verifyNoRunningQueries] } }
7 Sep 13:02:28 - [info] Started flows
7 Sep 13:02:28 - Connection successful for database eisquality with user root
7 Sep 13:02:28 - [red] Uncaught Exception:
7 Sep 13:02:28 - RangeError: Index out of range
    at checkOffset (buffer.js:831:11)
    at Buffer.readUInt8 (buffer.js:869:5)
    at Packet.isLast (C:\Users\Ross\.node-red\node_modules\tedious\lib\packet.js:116:29)
    at ReadablePacketStream.<anonymous> (C:\Users\Ross\.node-red\node_modules\tedious\lib\message-io.js:101:18)
    at emitOne (events.js:96:13)
    at ReadablePacketStream.emit (events.js:188:7)
    at addChunk (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_readable.js:284:12)
    at readableAddChunk (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_readable.js:271:11)
    at ReadablePacketStream.Readable.push (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_readable.js:238:10)
    at ReadablePacketStream.Transform.push (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_transform.js:146:32)
    at ReadablePacketStream._transform (C:\Users\Ross\.node-red\node_modules\tedious\lib\message-io.js:70:16)
    at ReadablePacketStream.Transform._read (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_transform.js:182:10)
    at ReadablePacketStream.Transform._write (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_transform.js:170:83)
    at doWrite (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_writable.js:406:64)
    at writeOrBuffer (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_writable.js:395:5)
    at ReadablePacketStream.Writable.write (C:\Users\Ross\.node-red\node_modules\readable-stream\lib\_stream_writable.js:322:11)