[2022-02-23T01:06:42.866] [ERROR] errorLogger - *************** error log start *************** request method: GET request originalUrl: /dataservice/Bdata?bid=get_mr_router&time1_=2019-10-01%2010:07:00&time2_=2019-10-01%2012:00:00&floor1=28&floor2=30.8&msisdn_name=%E6%9D%82%E7%89%A9%E8%BD%A6 request client ip: ::1 request query: {"bid":"get_mr_router","time1_":"2019-10-01 10:07:00","time2_":"2019-10-01 12:00:00","floor1":"28","floor2":"30.8","msisdn_name":"杂物车"} response time: 391 err name: Error err message: ER_BAD_FIELD_ERROR: Unknown column 't.name_' in 'where clause' err stack: Error: ER_BAD_FIELD_ERROR: Unknown column 't.name_' in 'where clause' at Query.Sequence._packetToError (D:\github\API\server\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14) at Query.ErrorPacket (D:\github\API\server\node_modules\mysql\lib\protocol\sequences\Query.js:77:18) at Protocol._parsePacket (D:\github\API\server\node_modules\mysql\lib\protocol\Protocol.js:278:23) at Parser.write (D:\github\API\server\node_modules\mysql\lib\protocol\Parser.js:76:12) at Protocol.write (D:\github\API\server\node_modules\mysql\lib\protocol\Protocol.js:38:16) at Socket. (D:\github\API\server\node_modules\mysql\lib\Connection.js:91:28) at Socket. (D:\github\API\server\node_modules\mysql\lib\Connection.js:502:10) at Socket.emit (events.js:315:20) at addChunk (_stream_readable.js:309:12) at readableAddChunk (_stream_readable.js:284:9) at Socket.Readable.push (_stream_readable.js:223:10) at TCP.onStreamRead (internal/stream_base_commons.js:188:23) -------------------- at Protocol._enqueue (D:\github\API\server\node_modules\mysql\lib\protocol\Protocol.js:144:48) at PoolConnection.query (D:\github\API\server\node_modules\mysql\lib\Connection.js:200:25) at D:\github\API\server\utils\mysql_db.js:87:20 at Ping.onOperationComplete (D:\github\API\server\node_modules\mysql\lib\Pool.js:110:5) at Ping. (D:\github\API\server\node_modules\mysql\lib\Connection.js:502:10) at Ping._callback (D:\github\API\server\node_modules\mysql\lib\Connection.js:468:16) at Ping.Sequence.end (D:\github\API\server\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24) at Ping.Sequence.OkPacket (D:\github\API\server\node_modules\mysql\lib\protocol\sequences\Sequence.js:92:8) at Protocol._parsePacket (D:\github\API\server\node_modules\mysql\lib\protocol\Protocol.js:278:23) at Parser.write (D:\github\API\server\node_modules\mysql\lib\protocol\Parser.js:76:12) at Protocol.write (D:\github\API\server\node_modules\mysql\lib\protocol\Protocol.js:38:16) at Socket. (D:\github\API\server\node_modules\mysql\lib\Connection.js:91:28) at Socket. (D:\github\API\server\node_modules\mysql\lib\Connection.js:502:10) at Socket.emit (events.js:315:20) at addChunk (_stream_readable.js:309:12) at readableAddChunk (_stream_readable.js:284:9) at Socket.Readable.push (_stream_readable.js:223:10) at TCP.onStreamRead (internal/stream_base_commons.js:188:23) *************** error log end ***************