sails MSSQL DB更新错误

Question

我无法从sails中进行MSSQL更新。我面临着下面的错误。

User.update({ id: 1 },

        { id: 1, name: 'test' }).exec(function afterwards (err, user) {

            if (err) {
                console.log(err);

            } else {
                console.log("Users updated:", users);
            }
        });

2018-03-21T08:21:52.868Z -错误:错误:错误(E_UNKNOWN) :：遇到意外错误RequestError:在关键字'WHERE‘附近不正确的语法。在连接处。(D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\lib\tedious.js:658:17) at emitOne (events.js:116:13) at Connection.emit (events.js:211:7) at Parser.(D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\connection.js:444:15) at emitOne (events.js:116:13) at Parser.emit (events.js:211:7) at Parser.nextToken (D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\token\token-stream-parser.js:91:18) at Parser.addBuffer (D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\token\token-stream-parser.js:68:17) at Connection.sendDataToTokenStreamParser (D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\connection.js:891:35) at Connection.data (D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\connection.js:275:23) at Connection.dispatchEvent (D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\connection.js:752:59) at MessageIO.(D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\connection.js:680:22) at emitOne (events.js:116:13) at MessageIO.emit (events.js:211:7) 在套接字处的(D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\message-io.js:56:12) MessageIO.eventData。(D:\Project\WODevelopment\trunk\QMS3.0\POC\WideOrbit-Server\node_modules\sails-sqlserver\node_modules\mssql\node_modules\tedious\lib\message-io.js:3:59) at emitOne (events.js:116:13) at Socket.emit (events.js:211:7) at addChunk (_stream_readable.js:263:12) at readableAddChunk (_stream_readable.js:250:11) at Socket.Readable.push (_stream_readable.js:208:10) at TCP.onread (net.js:594:20) Details: RequestError:关键字“WHERE”附近的不正确语法。

Answer 1

首先，尝试使用sails-mssql，如果不能解决您的问题，请执行下面的操作。

Sails使用不提供任何特定的方法来调试、查询、生成和执行水平线Orm。

下面列出了几种更有效地调试问题的方法，因为错误堆栈说它们是在Where子句附近的查询中的一个问题。

2018-03-21T08:21:52.868Z - error: error: Error (E_UNKNOWN) :: Encountered an 
unexpected error RequestError: Incorrect syntax near the keyword 'WHERE'. at 
Connection. 

1)使用这些方法用How to see query history in SQL Server Management Studio调试mssql管理studio查询日志。

2)尝试访问mssql > core文件的驱动程序，执行查询并执行console.log。

希望它对你有帮助