[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.<anonymous> (D:\github\API\server\node_modules\mysql\lib\Connection.js:91:28)
|
at Socket.<anonymous> (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.<anonymous> (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.<anonymous> (D:\github\API\server\node_modules\mysql\lib\Connection.js:91:28)
|
at Socket.<anonymous> (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 ***************
|
|
