API Error: PUT /orders/:poId Error: Failed to update purchase order 21: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' VALUES (7, '11047', 'Enviroplug Medium (50 LB)', '20 skids of 60 bags per s...' at line 2 at updatePurchaseOrder (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:212:15) at process._tickCallback (internal/process/next_tick.js:68:7) *** AUTH FAILED: Token verification error: jwt expired API Error: GET /vendors Error: Failed to retrieve vendors: Unknown column 'contact_person' in 'SELECT' at getAllVendors (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:820:15) at process._tickCallback (internal/process/next_tick.js:68:7) API Error: GET /vendors Error: Failed to retrieve vendors: Unknown column 'contact_person' in 'SELECT' at getAllVendors (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:820:15) at process._tickCallback (internal/process/next_tick.js:68:7) API Error: GET /vendors Error: Failed to retrieve vendors: Unknown column 'contact_person' in 'SELECT' at getAllVendors (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:820:15) at process._tickCallback (internal/process/next_tick.js:68:7) API Error: GET /vendors Error: Failed to retrieve vendors: Unknown column 'contact_person' in 'SELECT' at getAllVendors (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:820:15) at process._tickCallback (internal/process/next_tick.js:68:7) API Error: GET /vendors Error: Failed to retrieve vendors: Unknown column 'contact_person' in 'SELECT' at getAllVendors (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:831:15) at process._tickCallback (internal/process/next_tick.js:68:7) API Error: GET /vendors Error: Failed to retrieve vendors: Unknown column 'contact_person' in 'SELECT' at getAllVendors (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:831:15) at process._tickCallback (internal/process/next_tick.js:68:7) API Error: POST /vendors Error: Failed to create vendor: Unknown column 'contact_person' in 'INSERT INTO' at createVendor (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:753:15) at process._tickCallback (internal/process/next_tick.js:68:7) API Error: GET /vendors Error: Failed to retrieve vendors: Unknown column 'contact_person' in 'SELECT' at getAllVendors (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:831:15) at process._tickCallback (internal/process/next_tick.js:68:7) /home/davihvkj/procurement.davisdrilling.ca/server.js:10 const procurementRouter = require(' ^ SyntaxError: Invalid or unexpected token at Module._compile (internal/modules/cjs/loader.js:723:23) 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) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at startApplication (/usr/local/lsws/fcgi-bin/lsnode.js:48:15) at Object. (/usr/local/lsws/fcgi-bin/lsnode.js:16:1) at Module._compile (internal/modules/cjs/loader.js:778:30) /home/davihvkj/procurement.davisdrilling.ca/server.js:10 const procurementRouter = require(' ^ SyntaxError: Invalid or unexpected token at Module._compile (internal/modules/cjs/loader.js:723:23) 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) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at startApplication (/usr/local/lsws/fcgi-bin/lsnode.js:48:15) at Object. (/usr/local/lsws/fcgi-bin/lsnode.js:16:1) at Module._compile (internal/modules/cjs/loader.js:778:30) /home/davihvkj/procurement.davisdrilling.ca/server.js:10 const procurementRouter = require(' ^ SyntaxError: Invalid or unexpected token at Module._compile (internal/modules/cjs/loader.js:723:23) 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) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at startApplication (/usr/local/lsws/fcgi-bin/lsnode.js:48:15) at Object. (/usr/local/lsws/fcgi-bin/lsnode.js:16:1) at Module._compile (internal/modules/cjs/loader.js:778:30) /home/davihvkj/procurement.davisdrilling.ca/server.js:10 const procurementRouter = require(' ^ SyntaxError: Invalid or unexpected token at Module._compile (internal/modules/cjs/loader.js:723:23) 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) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at startApplication (/usr/local/lsws/fcgi-bin/lsnode.js:48:15) at Object. (/usr/local/lsws/fcgi-bin/lsnode.js:16:1) at Module._compile (internal/modules/cjs/loader.js:778:30) /home/davihvkj/procurement.davisdrilling.ca/server.js:10 const procurementRouter = require(' ^ SyntaxError: Invalid or unexpected token at Module._compile (internal/modules/cjs/loader.js:723:23) 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) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at startApplication (/usr/local/lsws/fcgi-bin/lsnode.js:48:15) at Object. (/usr/local/lsws/fcgi-bin/lsnode.js:16:1) at Module._compile (internal/modules/cjs/loader.js:778:30) /home/davihvkj/procurement.davisdrilling.ca/server.js:10 const procurementRouter = require(' ^ SyntaxError: Invalid or unexpected token at Module._compile (internal/modules/cjs/loader.js:723:23) 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) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at startApplication (/usr/local/lsws/fcgi-bin/lsnode.js:48:15) at Object. (/usr/local/lsws/fcgi-bin/lsnode.js:16:1) at Module._compile (internal/modules/cjs/loader.js:778:30) /home/davihvkj/procurement.davisdrilling.ca/server.js:10 const procurementRouter = require(' ^ SyntaxError: Invalid or unexpected token at Module._compile (internal/modules/cjs/loader.js:723:23) 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) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at startApplication (/usr/local/lsws/fcgi-bin/lsnode.js:48:15) at Object. (/usr/local/lsws/fcgi-bin/lsnode.js:16:1) at Module._compile (internal/modules/cjs/loader.js:778:30) /home/davihvkj/procurement.davisdrilling.ca/server.js:10 const procurementRouter = require(' ^ SyntaxError: Invalid or unexpected token at Module._compile (internal/modules/cjs/loader.js:723:23) 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) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at startApplication (/usr/local/lsws/fcgi-bin/lsnode.js:48:15) at Object. (/usr/local/lsws/fcgi-bin/lsnode.js:16:1) at Module._compile (internal/modules/cjs/loader.js:778:30) *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired Login attempt failed: User mcculochbrandon@gmail.com not found in database. Login attempt failed: User mcculochbrandon@gmail.com not found in database. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: User mcculochbrandon@gmail.com not found in database. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired API Error: PUT /products Error: Product update failed: Duplicate entry detected. Check SKU/UOM/Vendor combination. at updateProduct (/home/davihvkj/procurement.davisdrilling.ca/procurementService.js:752:19) at process._tickCallback (internal/process/next_tick.js:68:7) *** AUTH FAILED: Token verification error: jwt expired Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. *** AUTH FAILED: Token verification error: jwt expired Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired *** AUTH FAILED: Token verification error: jwt expired Login attempt failed: User admin@davisdrilling.ca not found in database. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. (node:3075671) UnhandledPromiseRejectionWarning: ReferenceError: crypto is not defined at app.get (/home/davihvkj/procurement.davisdrilling.ca/server.js:148:18) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:95:5) at next (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/route.js:149:13) at Route.dispatch (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/route.js:119:3) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:95:5) at /home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:284:15 at Function.process_params (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:346:12) at next (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:280:10) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:91:12) at trim_prefix (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:328:13) (node:3075671) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1) (node:3075671) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code. (node:3075671) UnhandledPromiseRejectionWarning: ReferenceError: crypto is not defined at app.get (/home/davihvkj/procurement.davisdrilling.ca/server.js:148:18) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:95:5) at next (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/route.js:149:13) at Route.dispatch (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/route.js:119:3) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:95:5) at /home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:284:15 at Function.process_params (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:346:12) at next (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:280:10) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:91:12) at trim_prefix (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:328:13) (node:3075671) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 2) (node:3075671) UnhandledPromiseRejectionWarning: ReferenceError: crypto is not defined at app.get (/home/davihvkj/procurement.davisdrilling.ca/server.js:148:18) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:95:5) at next (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/route.js:149:13) at Route.dispatch (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/route.js:119:3) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:95:5) at /home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:284:15 at Function.process_params (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:346:12) at next (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:280:10) at Layer.handle [as handle_request] (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/layer.js:91:12) at trim_prefix (/home/davihvkj/nodevenv/procurement.davisdrilling.ca/10/lib/node_modules/express/lib/router/index.js:328:13) (node:3075671) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 3) Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. *** AUTH FAILED: Token verification error: jwt expired Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: User wells@davisdrilling.ca not found in database. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com. Login attempt failed: Password mismatch for user mccullochbrandon@gmail.com.