mysql - UnhandledPromiseRejectionWarning 与 nodejs 和 mysql 请让我知道是什么问题

Question

(node:15157) UnhandledPromiseRejectionWarning: Error: ER_BAD_FIELD_ERROR: Unknown column 'transaction_date' in 'where clause'
at Query.Sequence._packetToError (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
at Protocol._parsePacket (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (events.js:198:13)
at addChunk (_stream_readable.js:288:12)
--------------------
at Pool.query (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/node_modules/mysql/lib/Pool.js:199:23)
at Promise (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/util/async_db_call.js:5:14)
at new Promise (<anonymous>)
at module.exports (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/util/async_db_call.js:4:12)
at main (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/jobs/dailyjobs.js:98:33)
at Object.<anonymous> (/home/jigyasoo/Documents/Gaurav's Folder/CocoCoala/jobs/dailyjobs.js:299:1)
at Module._compile (internal/modules/cjs/loader.js:778:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
at Module.load (internal/modules/cjs/loader.js:653:32)
at tryModuleLoad (internal/modules/cjs/loader.js:593:12)

（节点：15157）UnhandledPromiseRejectionWarning：未处理的承诺拒绝。此错误源于在没有 catch 块的情况下抛出异步函数内部，或拒绝未使用 .catch() 处理的承诺。（拒绝 id：1）（节点：15157）[DEP0018] DeprecationWarning：不推荐使用未处理的承诺拒绝。将来，未处理的 Promise 拒绝将使用非零退出代码终止 Node.js 进程。

标签： mysqlnode.jsexpress