{"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:43:15.854Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:43:15.854Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:44:15.828Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:44:15.829Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:45:15.830Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:45:15.830Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:46:15.830Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:46:15.831Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE bookings SET status = 'cancelled', cancellation_reason = 'auto_expired'\n WHERE status = 'pending' AND expires_at < NOW()","timestamp":"2026-04-29T06:47:15.831Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Booking lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:47:15.832Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:47:15.835Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:47:15.835Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:48:15.834Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:48:15.835Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:49:15.834Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:49:15.835Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:50:15.841Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:50:15.842Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:51:15.836Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:51:15.836Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE bookings SET status = 'cancelled', cancellation_reason = 'auto_expired'\n WHERE status = 'pending' AND expires_at < NOW()","timestamp":"2026-04-29T06:52:15.827Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Booking lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:52:15.828Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:52:15.841Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:52:15.841Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:53:15.842Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:53:15.842Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T06:54:15.844Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T06:54:15.844Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T07:10:38.164Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T07:10:38.165Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE bookings SET status = 'cancelled', cancellation_reason = 'auto_expired'\n WHERE status = 'pending' AND expires_at < NOW()","timestamp":"2026-04-29T07:10:38.165Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Booking lifecycle error","service":"Zufiti","timestamp":"2026-04-29T07:10:38.166Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-04-29T07:21:45.016Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Auction lifecycle error","service":"Zufiti","timestamp":"2026-04-29T07:21:45.017Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE bookings SET status = 'cancelled', cancellation_reason = 'auto_expired'\n WHERE status = 'pending' AND expires_at < NOW()","timestamp":"2026-04-29T07:21:45.018Z"} {"error":"Access denied for user ''@'localhost' to database 'zufiti'","level":"error","message":"Booking lifecycle error","service":"Zufiti","timestamp":"2026-04-29T07:21:45.018Z"} {"level":"error","message":"Unhandled rejection","reason":"Error: Can't add new command when connection is in closed state","service":"Zufiti","timestamp":"2026-04-29T07:28:17.781Z"} {"level":"error","message":"Unhandled rejection","reason":"Error: Can't add new command when connection is in closed state","service":"Zufiti","timestamp":"2026-04-29T07:30:09.015Z"} {"level":"error","message":"Unhandled rejection","reason":"Error: Can't add new command when connection is in closed state","service":"Zufiti","timestamp":"2026-04-29T07:49:09.488Z"} {"error":"Pool is closed.","level":"error","message":"DB query error","service":"Zufiti","sql":"UPDATE auctions SET status = 'live' WHERE status = 'scheduled' AND starts_at <= ?","timestamp":"2026-05-30T15:32:41.726Z"} {"error":"Unknown column 'listing_type' in 'INSERT INTO'","level":"error","message":"DB query error","service":"Zufiti","sql":"INSERT INTO properties\n (id, tenant_id, owner_id, title, description, type, listing_type, shipping_address,\n display_type, screen_resolution,\n address_line1, address_line2, city, state_p","timestamp":"2026-05-31T07:02:53.017Z"} {"error":"Unknown column 'listing_type' in 'INSERT INTO'","level":"error","message":"Unhandled error","path":"/api/v1/properties","service":"Zufiti","stack":"Error: Unknown column 'listing_type' in 'INSERT INTO'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at Object.create (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/repositories/propertyRepository.js:7:9)\n at Object.createProperty (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/propertyService.js:8:23)\n at create (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/propertyController.js:24:37)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/auditLog.js:27:5\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at module.exports (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/validate.js:11:3)","timestamp":"2026-05-31T07:02:53.018Z"} {"error":"Bind parameters must not contain undefined. To pass SQL NULL specify JS null","level":"error","message":"DB query error","service":"Zufiti","sql":"SELECT * FROM ad_slots WHERE id = ?","timestamp":"2026-05-31T16:21:16.492Z"} {"error":"Bind parameters must not contain undefined. To pass SQL NULL specify JS null","level":"error","message":"Unhandled error","path":"/api/v1/bookings/quote","service":"Zufiti","stack":"TypeError: Bind parameters must not contain undefined. To pass SQL NULL specify JS null\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at queryOne (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:41:22)\n at Object.findById (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/repositories/adSlotRepository.js:32:10)\n at Object.quote (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/bookingService.js:196:33)\n at quoteHandler (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/bookingController.js:30:41)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-05-31T16:21:16.496Z"} {"error":"Cannot find module 'stripe'\nRequire stack:\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/paymentController.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/bookings.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/index.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/server.js","level":"error","message":"Unhandled error","path":"/api/v1/bookings/74738f55-030d-4252-a416-c65337ae2bd2/payments/create-intent","service":"Adzifi","stack":"Error: Cannot find module 'stripe'\nRequire stack:\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/paymentController.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/bookings.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/index.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/server.js\n at Function._resolveFilename (node:internal/modules/cjs/loader:1383:15)\n at defaultResolveImpl (node:internal/modules/cjs/loader:1025:19)\n at resolveForCJSWithHooks (node:internal/modules/cjs/loader:1030:22)\n at Function._load (node:internal/modules/cjs/loader:1192:37)\n at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n at wrapModuleLoad (node:internal/modules/cjs/loader:237:24)\n at Module.require (node:internal/modules/cjs/loader:1463:12)\n at require (node:internal/modules/helpers:147:16)\n at getStripe (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js:9:10)\n at Object.createPaymentIntent (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js:29:18)","timestamp":"2026-06-01T06:38:38.081Z"} {"error":"Cannot find module 'stripe'\nRequire stack:\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/paymentController.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/bookings.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/index.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/server.js","level":"error","message":"Unhandled error","path":"/api/v1/bookings/74738f55-030d-4252-a416-c65337ae2bd2/payments/create-intent","service":"Adzifi","stack":"Error: Cannot find module 'stripe'\nRequire stack:\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/paymentController.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/bookings.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/index.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/server.js\n at Function._resolveFilename (node:internal/modules/cjs/loader:1383:15)\n at defaultResolveImpl (node:internal/modules/cjs/loader:1025:19)\n at resolveForCJSWithHooks (node:internal/modules/cjs/loader:1030:22)\n at Function._load (node:internal/modules/cjs/loader:1192:37)\n at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n at wrapModuleLoad (node:internal/modules/cjs/loader:237:24)\n at Module.require (node:internal/modules/cjs/loader:1463:12)\n at require (node:internal/modules/helpers:147:16)\n at getStripe (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js:9:10)\n at Object.createPaymentIntent (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js:29:18)","timestamp":"2026-06-01T06:38:43.504Z"} {"error":"Cannot find module 'stripe'\nRequire stack:\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/paymentController.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/bookings.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/index.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/server.js","level":"error","message":"Unhandled error","path":"/api/v1/bookings/74738f55-030d-4252-a416-c65337ae2bd2/payments/create-intent","service":"Adzifi","stack":"Error: Cannot find module 'stripe'\nRequire stack:\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/paymentController.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/bookings.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/routes/index.js\n- /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/server.js\n at Function._resolveFilename (node:internal/modules/cjs/loader:1383:15)\n at defaultResolveImpl (node:internal/modules/cjs/loader:1025:19)\n at resolveForCJSWithHooks (node:internal/modules/cjs/loader:1030:22)\n at Function._load (node:internal/modules/cjs/loader:1192:37)\n at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n at wrapModuleLoad (node:internal/modules/cjs/loader:237:24)\n at Module.require (node:internal/modules/cjs/loader:1463:12)\n at require (node:internal/modules/helpers:147:16)\n at getStripe (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js:9:10)\n at Object.createPaymentIntent (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/paymentService.js:29:18)","timestamp":"2026-06-01T06:38:49.096Z"} {"error":"queryA EBADNAME no.reply@beezifi.com","level":"error","message":"Failed to send email","service":"Adzifi","timestamp":"2026-06-01T07:07:12.178Z","to":"moophi@gmail.com"} {"error":"queryA EBADNAME no.reply@beezifi.com","level":"error","message":"Failed to send email","service":"Adzifi","timestamp":"2026-06-01T18:14:36.025Z","to":"moophi@gmail.com"} {"error":"queryA EBADNAME no.reply@beezifi.com","level":"error","message":"Failed to send email","service":"Adzifi","timestamp":"2026-06-01T18:16:15.680Z","to":"thien.pham@beezifi.com"} {"error":"Can't send mail - all recipients were rejected: 554 5.7.1 : Recipient address rejected: Sender is not same as SMTP authenticate username","level":"error","message":"Failed to send email","service":"Adzifi","timestamp":"2026-06-01T18:19:22.442Z","to":"thien.pham@beezifi.com"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:45:49.428Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:45:49.431Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:45:51.223Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:45:51.224Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:45:53.385Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:45:53.386Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:46:11.763Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:46:11.763Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:46:12.893Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:46:12.893Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:46:14.217Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:46:14.218Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:46:34.361Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:46:34.362Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:46:37.743Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:46:37.744Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:46:38.980Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:46:38.982Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:47:46.619Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:47:46.620Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:47:47.619Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:47:47.620Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"DB query error","service":"Adzifi","sql":"SELECT pa.id, pa.user_id, pa.w9_status, pa.pending_balance, pa.total_earned, pa.total_paid_out,\n pa.bank_name, pa.account_number_last4, pa.account_type, pa.routing_number,\n ","timestamp":"2026-06-01T18:47:49.285Z"} {"error":"Unknown column 'pa.has_banking_info' in 'SELECT'","level":"error","message":"Unhandled error","path":"/api/v1/payouts/admin/owners","service":"Adzifi","stack":"Error: Unknown column 'pa.has_banking_info' in 'SELECT'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at listOwnerBalances (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/payoutController.js:184:7)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/authenticate.js:32:76\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at /Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/index.js:284:15","timestamp":"2026-06-01T18:47:49.287Z"} {"error":"Unknown column 'placement_method' in 'INSERT INTO'","level":"error","message":"DB query error","service":"Adzifi","sql":"INSERT INTO ad_slots\n (id, tenant_id, property_id, name, description, fulfillment_type, placement_method,\n physical_material_notes, installation_fee,\n width_ft, height_ft, width_px, heig","timestamp":"2026-06-01T23:25:13.909Z"} {"error":"Unknown column 'placement_method' in 'INSERT INTO'","level":"error","message":"Unhandled error","path":"/api/v1/properties/32f115f4-3e6e-4bed-802c-fc5b84d54535/slots","service":"Adzifi","stack":"Error: Unknown column 'placement_method' in 'INSERT INTO'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at Object.create (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/repositories/adSlotRepository.js:7:9)\n at create (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/adSlotController.js:20:35)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at module.exports (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/validate.js:11:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at middleware (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express-validator/lib/middlewares/check.js:16:13)\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"2026-06-01T23:25:13.912Z"} {"error":"Unknown column 'placement_method' in 'INSERT INTO'","level":"error","message":"DB query error","service":"Adzifi","sql":"INSERT INTO ad_slots\n (id, tenant_id, property_id, name, description, fulfillment_type, placement_method,\n physical_material_notes, installation_fee,\n width_ft, height_ft, width_px, heig","timestamp":"2026-06-01T23:27:38.727Z"} {"error":"Unknown column 'placement_method' in 'INSERT INTO'","level":"error","message":"Unhandled error","path":"/api/v1/properties/32f115f4-3e6e-4bed-802c-fc5b84d54535/slots","service":"Adzifi","stack":"Error: Unknown column 'placement_method' in 'INSERT INTO'\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at Object.create (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/repositories/adSlotRepository.js:7:9)\n at create (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/adSlotController.js:20:35)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at module.exports (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/validate.js:11:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at middleware (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express-validator/lib/middlewares/check.js:16:13)\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"2026-06-01T23:27:38.727Z"} {"error":"Incorrect datetime value: '2026-06-02T00:17:00.000Z' for column `zufiti`.`auctions`.`starts_at` at row 1","level":"error","message":"DB query error","service":"Adzifi","sql":"INSERT INTO auctions (id, tenant_id, ad_slot_id, start_date, end_date, starts_at, ends_at,\n reserve_price, buy_now_price, bid_increment, current_price, status)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?,","timestamp":"2026-06-02T00:19:16.682Z"} {"error":"Incorrect datetime value: '2026-06-02T00:17:00.000Z' for column `zufiti`.`auctions`.`starts_at` at row 1","level":"error","message":"Unhandled error","path":"/api/v1/auctions","service":"Adzifi","stack":"Error: Incorrect datetime value: '2026-06-02T00:17:00.000Z' for column `zufiti`.`auctions`.`starts_at` at row 1\n at query (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/utils/db.js:32:28)\n at Object.createAuction (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/services/auctionService.js:11:9)\n at create (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/controllers/auctionController.js:22:42)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at module.exports (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/middlewares/validate.js:11:3)\n at Layer.handle [as handle_request] (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/layer.js:95:5)\n at next (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express/lib/router/route.js:149:13)\n at middleware (/Users/thienpham/Desktop/F9Networks/Software/Zufiti/backend/node_modules/express-validator/lib/middlewares/check.js:16:13)\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"2026-06-02T00:19:16.683Z"}