[01:06:56.000] INFO: HTTP Server is running on port 3000 [01:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [01:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [01:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [01:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [01:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [01:37:40.000] INFO: HTTP Server is running on port 3000 [01:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [01:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:25:31.000] INFO: HTTP Server is running on port 3000 [08:22:04.000] INFO: HTTP Server is running on port 3000 [08:22:04.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [08:22:04.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [08:22:32.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [08:22:32.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [08:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [08:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [08:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [08:35:00.000] INFO: No unpaid bookings found for auto-cancellation. [08:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [08:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [09:27:28.000] INFO: HTTP Server is running on port 3000 [09:27:28.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [09:27:28.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [09:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [09:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [09:41:16.000] INFO: HTTP Server is running on port 3000 [09:41:16.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [09:41:16.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [09:41:29.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [09:41:29.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [09:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [09:53:30.000] INFO: HTTP Server is running on port 3000 [09:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [10:00:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:04:14.000] INFO: HTTP Server is running on port 3000 [10:04:16.000] INFO: PayMongo checkout session created: { "data": { "id": "cs_DXuLiiWhsGJjMRifdLHVngag", "type": "checkout_session", "attributes": { "billing": { "address": { "city": null, "country": null, "line1": null, "line2": null, "postal_code": null, "state": null }, "email": null, "name": null, "phone": null }, "billing_information_fields_editable": "enabled", "cancel_url": "https://uat.aircamp.ph/bookings/app/?success=false&bookingNo=ACPH-135718&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=Public&spot=Riverside+Tent&dateCreated=11%2F17%2F2025%2C+10%3A04%3A14+AM&checkIn=November+17%2C+2025&checkOut=November+18%2C+2025&paymentStatus=Unpaid&price=100.00&guestFee=10&discount=0&paymentMethod=online&subtotal=110&totalPayment=110&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "checkout_url": "https://checkout.paymongo.com/cs_DXuLiiWhsGJjMRifdLHVngag_client_6qkcc52fvJLCHYYo7o1CAo8k#cGtfdGVzdF9Wd2R2SFp0bkJhSEI3NHdyQ3JmaWdaUHo=", "client_key": "cs_DXuLiiWhsGJjMRifdLHVngag_client_6qkcc52fvJLCHYYo7o1CAo8k", "customer_email": null, "description": "AirCamp Booking ACPH-135718 - Christine Camp - Riverside Tent", "line_items": [ { "amount": 11000, "currency": "PHP", "description": null, "images": [], "name": "AirCamp Booking ACPH-135718 - Christine Camp - Riverside Tent", "quantity": 1 } ], "livemode": false, "merchant": "Berresn05", "payments": [], "payment_intent": { "id": "pi_DXntDFy5GvjaM1nG85jpu938", "type": "payment_intent", "attributes": { "amount": 11000, "capture_type": "automatic", "client_key": "pi_DXntDFy5GvjaM1nG85jpu938_client_bBJzZgY7jvgBPTqob6P3itWD", "currency": "PHP", "description": "AirCamp Booking ACPH-135718 - Christine Camp - Riverside Tent", "livemode": false, "original_amount": 11000, "statement_descriptor": "Berresn05", "status": "awaiting_payment_method", "last_payment_error": null, "payment_method_allowed": [ "paymaya", "qrph", "billease", "card", "gcash", "dob", "grab_pay" ], "payments": [], "next_action": null, "payment_method_options": { "card": { "request_three_d_secure": "any" } }, "metadata": { "booking_no": "ACPH-135718" }, "setup_future_usage": null, "created_at": 1763345055, "updated_at": 1763345055 } }, "payment_method_types": [ "gcash", "billease", "paymaya", "card", "qrph", "grab_pay", "dob" ], "reference_number": null, "send_email_receipt": false, "show_description": true, "show_line_items": true, "status": "active", "success_url": "https://uat.aircamp.ph/bookings/app/?success=true&bookingNo=ACPH-135718&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=Public&spot=Riverside+Tent&dateCreated=11%2F17%2F2025%2C+10%3A04%3A14+AM&checkIn=November+17%2C+2025&checkOut=November+18%2C+2025&paymentStatus=Paid&price=100.00&guestFee=10&discount=0&paymentMethod=online&subtotal=110&totalPayment=110&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "created_at": 1763345055, "updated_at": 1763345055, "metadata": { "booking_no": "ACPH-135718" } } } } [10:04:36.000] INFO: PayMongo checkout session created: { "data": { "id": "cs_Y7J31oYr2uMFhSDwowD4NajH", "type": "checkout_session", "attributes": { "billing": { "address": { "city": null, "country": null, "line1": null, "line2": null, "postal_code": null, "state": null }, "email": null, "name": null, "phone": null }, "billing_information_fields_editable": "enabled", "cancel_url": "https://uat.aircamp.ph/bookings/app/?success=false&bookingNo=ACPH-135718&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=&spot=Riverside+Tent&dateCreated=11%2F17%2F2025%2C+10%3A04%3A14+AM&checkIn=November+17%2C+2025&checkOut=November+18%2C+2025&paymentStatus=Unpaid&price=&guestFee=10.00&discount=&paymentMethod=online&subtotal=110.00&totalPayment=110.00&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "checkout_url": "https://checkout.paymongo.com/cs_Y7J31oYr2uMFhSDwowD4NajH_client_Kqp2z2YicM659YMFj7vFqqrK#cGtfdGVzdF9Wd2R2SFp0bkJhSEI3NHdyQ3JmaWdaUHo=", "client_key": "cs_Y7J31oYr2uMFhSDwowD4NajH_client_Kqp2z2YicM659YMFj7vFqqrK", "customer_email": null, "description": "AirCamp Booking ACPH-135718 - Christine Camp - Riverside Tent", "line_items": [ { "amount": 11000, "currency": "PHP", "description": null, "images": [], "name": "AirCamp Booking ACPH-135718 - Christine Camp - Riverside Tent", "quantity": 1 } ], "livemode": false, "merchant": "Berresn05", "payments": [], "payment_intent": { "id": "pi_oym95hButBnKY9HqCo9dPP2o", "type": "payment_intent", "attributes": { "amount": 11000, "capture_type": "automatic", "client_key": "pi_oym95hButBnKY9HqCo9dPP2o_client_9zEfJYGjph6e8gjwKQ6a7Lsh", "currency": "PHP", "description": "AirCamp Booking ACPH-135718 - Christine Camp - Riverside Tent", "livemode": false, "original_amount": 11000, "statement_descriptor": "Berresn05", "status": "awaiting_payment_method", "last_payment_error": null, "payment_method_allowed": [ "billease", "paymaya", "dob", "grab_pay", "gcash", "qrph", "card" ], "payments": [], "next_action": null, "payment_method_options": { "card": { "request_three_d_secure": "any" } }, "metadata": { "booking_no": "ACPH-135718" }, "setup_future_usage": null, "created_at": 1763345075, "updated_at": 1763345075 } }, "payment_method_types": [ "qrph", "billease", "grab_pay", "gcash", "dob", "card", "paymaya" ], "reference_number": null, "send_email_receipt": false, "show_description": true, "show_line_items": true, "status": "active", "success_url": "https://uat.aircamp.ph/bookings/app/?success=true&bookingNo=ACPH-135718&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=&spot=Riverside+Tent&dateCreated=11%2F17%2F2025%2C+10%3A04%3A14+AM&checkIn=November+17%2C+2025&checkOut=November+18%2C+2025&paymentStatus=Paid&price=&guestFee=10.00&discount=&paymentMethod=online&subtotal=110.00&totalPayment=110.00&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "created_at": 1763345075, "updated_at": 1763345075, "metadata": { "booking_no": "ACPH-135718" } } } } [10:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:08:58.000] INFO: PayMongo checkout session created: { "data": { "id": "cs_xhQPsemd8VEz4Mk5nHzDm6jA", "type": "checkout_session", "attributes": { "billing": { "address": { "city": null, "country": null, "line1": null, "line2": null, "postal_code": null, "state": null }, "email": null, "name": null, "phone": null }, "billing_information_fields_editable": "enabled", "cancel_url": "https://uat.aircamp.ph/bookings/app/?success=false&bookingNo=ACPH-443058&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=Public&spot=Tamarind+Hill&dateCreated=11%2F17%2F2025%2C+10%3A08%3A57+AM&checkIn=November+17%2C+2025&checkOut=November+18%2C+2025&paymentStatus=Unpaid&price=100.00&guestFee=10&discount=0&paymentMethod=online&subtotal=110&totalPayment=110&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "checkout_url": "https://checkout.paymongo.com/cs_xhQPsemd8VEz4Mk5nHzDm6jA_client_vA49XiB36ioPk3zqqKdHbcNe#cGtfdGVzdF9Wd2R2SFp0bkJhSEI3NHdyQ3JmaWdaUHo=", "client_key": "cs_xhQPsemd8VEz4Mk5nHzDm6jA_client_vA49XiB36ioPk3zqqKdHbcNe", "customer_email": null, "description": "AirCamp Booking ACPH-443058 - Christine Camp - Tamarind Hill", "line_items": [ { "amount": 11000, "currency": "PHP", "description": null, "images": [], "name": "AirCamp Booking ACPH-443058 - Christine Camp - Tamarind Hill", "quantity": 1 } ], "livemode": false, "merchant": "Berresn05", "payments": [], "payment_intent": { "id": "pi_BCwxrRw32YKbJqspvgW1mGi1", "type": "payment_intent", "attributes": { "amount": 11000, "capture_type": "automatic", "client_key": "pi_BCwxrRw32YKbJqspvgW1mGi1_client_XGgVdDXiEPyfZ72BaMtghN81", "currency": "PHP", "description": "AirCamp Booking ACPH-443058 - Christine Camp - Tamarind Hill", "livemode": false, "original_amount": 11000, "statement_descriptor": "Berresn05", "status": "awaiting_payment_method", "last_payment_error": null, "payment_method_allowed": [ "gcash", "dob", "card", "billease", "paymaya", "grab_pay", "qrph" ], "payments": [], "next_action": null, "payment_method_options": { "card": { "request_three_d_secure": "any" } }, "metadata": { "booking_no": "ACPH-443058" }, "setup_future_usage": null, "created_at": 1763345338, "updated_at": 1763345338 } }, "payment_method_types": [ "dob", "grab_pay", "gcash", "qrph", "billease", "card", "paymaya" ], "reference_number": null, "send_email_receipt": false, "show_description": true, "show_line_items": true, "status": "active", "success_url": "https://uat.aircamp.ph/bookings/app/?success=true&bookingNo=ACPH-443058&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=Public&spot=Tamarind+Hill&dateCreated=11%2F17%2F2025%2C+10%3A08%3A57+AM&checkIn=November+17%2C+2025&checkOut=November+18%2C+2025&paymentStatus=Paid&price=100.00&guestFee=10&discount=0&paymentMethod=online&subtotal=110&totalPayment=110&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "created_at": 1763345338, "updated_at": 1763345338, "metadata": { "booking_no": "ACPH-443058" } } } } [10:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [10:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:25:01.000] INFO: No unpaid bookings found for auto-cancellation. [10:28:55.000] INFO: PayMongo checkout session created: { "data": { "id": "cs_1NQ9Dxh56xeUXDhJx3eLX3aW", "type": "checkout_session", "attributes": { "billing": { "address": { "city": null, "country": null, "line1": null, "line2": null, "postal_code": null, "state": null }, "email": null, "name": null, "phone": null }, "billing_information_fields_editable": "enabled", "cancel_url": "https://uat.aircamp.ph/bookings/app/?success=false&bookingNo=ACPH-733577&status=For+Approval&listing=+Pine+Forest+Nook&guestName=Andrea+de+Dios&listingType=Public&spot=Camp+Mango&dateCreated=11%2F17%2F2025%2C+10%3A28%3A54+AM&checkIn=November+22%2C+2025&checkOut=November+24%2C+2025&paymentStatus=Unpaid&price=20.00&guestFee=4&discount=0&paymentMethod=online&subtotal=44&totalPayment=44&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "checkout_url": "https://checkout.paymongo.com/cs_1NQ9Dxh56xeUXDhJx3eLX3aW_client_FdJFYYn6nVc8Jfhq3e1Z6FV8#cGtfdGVzdF9Wd2R2SFp0bkJhSEI3NHdyQ3JmaWdaUHo=", "client_key": "cs_1NQ9Dxh56xeUXDhJx3eLX3aW_client_FdJFYYn6nVc8Jfhq3e1Z6FV8", "customer_email": null, "description": "AirCamp Booking ACPH-733577 - Pine Forest Nook - Camp Mango", "line_items": [ { "amount": 4400, "currency": "PHP", "description": null, "images": [], "name": "AirCamp Booking ACPH-733577 - Pine Forest Nook - Camp Mango", "quantity": 1 } ], "livemode": false, "merchant": "Berresn05", "payments": [], "payment_intent": { "id": "pi_JDj1S6761ZbSBkWQ7kswkVaj", "type": "payment_intent", "attributes": { "amount": 4400, "capture_type": "automatic", "client_key": "pi_JDj1S6761ZbSBkWQ7kswkVaj_client_bfvF9xdZLKNApRAQq2ZJus8v", "currency": "PHP", "description": "AirCamp Booking ACPH-733577 - Pine Forest Nook - Camp Mango", "livemode": false, "original_amount": 4400, "statement_descriptor": "Berresn05", "status": "awaiting_payment_method", "last_payment_error": null, "payment_method_allowed": [ "gcash", "dob", "billease", "grab_pay", "card", "qrph", "paymaya" ], "payments": [], "next_action": null, "payment_method_options": { "card": { "request_three_d_secure": "any" } }, "metadata": { "booking_no": "ACPH-733577" }, "setup_future_usage": null, "created_at": 1763346535, "updated_at": 1763346535 } }, "payment_method_types": [ "gcash", "paymaya", "billease", "dob", "qrph", "card", "grab_pay" ], "reference_number": null, "send_email_receipt": false, "show_description": true, "show_line_items": true, "status": "active", "success_url": "https://uat.aircamp.ph/bookings/app/?success=true&bookingNo=ACPH-733577&status=For+Approval&listing=+Pine+Forest+Nook&guestName=Andrea+de+Dios&listingType=Public&spot=Camp+Mango&dateCreated=11%2F17%2F2025%2C+10%3A28%3A54+AM&checkIn=November+22%2C+2025&checkOut=November+24%2C+2025&paymentStatus=Paid&price=20.00&guestFee=4&discount=0&paymentMethod=online&subtotal=44&totalPayment=44&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "created_at": 1763346535, "updated_at": 1763346535, "metadata": { "booking_no": "ACPH-733577" } } } } [10:29:43.000] INFO: PayMongo checkout session created: { "data": { "id": "cs_ru268yCx6tzBJ6zHh9xZRQUe", "type": "checkout_session", "attributes": { "billing": { "address": { "city": null, "country": null, "line1": null, "line2": null, "postal_code": null, "state": null }, "email": null, "name": null, "phone": null }, "billing_information_fields_editable": "enabled", "cancel_url": "https://uat.aircamp.ph/bookings/app/?success=false&bookingNo=ACPH-817070&status=Upcoming&listing=Bamboo+Shores+Glamp&guestName=Andrea+de+Dios&listingType=Public&spot=Seashell+Bay&dateCreated=11%2F17%2F2025%2C+10%3A29%3A42+AM&checkIn=November+21%2C+2025&checkOut=November+22%2C+2025&paymentStatus=Unpaid&price=20.00&guestFee=2&discount=0&paymentMethod=online&subtotal=22&totalPayment=22&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "checkout_url": "https://checkout.paymongo.com/cs_ru268yCx6tzBJ6zHh9xZRQUe_client_vaKFyP2Nchjti6qgHLJppvgs#cGtfdGVzdF9Wd2R2SFp0bkJhSEI3NHdyQ3JmaWdaUHo=", "client_key": "cs_ru268yCx6tzBJ6zHh9xZRQUe_client_vaKFyP2Nchjti6qgHLJppvgs", "customer_email": null, "description": "AirCamp Booking ACPH-817070 - Bamboo Shores Glamp - Seashell Bay", "line_items": [ { "amount": 2200, "currency": "PHP", "description": null, "images": [], "name": "AirCamp Booking ACPH-817070 - Bamboo Shores Glamp - Seashell Bay", "quantity": 1 } ], "livemode": false, "merchant": "Berresn05", "payments": [], "payment_intent": { "id": "pi_Y5Kfj2qvxpLLfFeaRR9mx21Z", "type": "payment_intent", "attributes": { "amount": 2200, "capture_type": "automatic", "client_key": "pi_Y5Kfj2qvxpLLfFeaRR9mx21Z_client_tGRDiHFVGvJrYCh2Kkqoakcw", "currency": "PHP", "description": "AirCamp Booking ACPH-817070 - Bamboo Shores Glamp - Seashell Bay", "livemode": false, "original_amount": 2200, "statement_descriptor": "Berresn05", "status": "awaiting_payment_method", "last_payment_error": null, "payment_method_allowed": [ "billease", "gcash", "grab_pay", "dob", "card", "paymaya", "qrph" ], "payments": [], "next_action": null, "payment_method_options": { "card": { "request_three_d_secure": "any" } }, "metadata": { "booking_no": "ACPH-817070" }, "setup_future_usage": null, "created_at": 1763346583, "updated_at": 1763346583 } }, "payment_method_types": [ "paymaya", "dob", "qrph", "grab_pay", "card", "billease", "gcash" ], "reference_number": null, "send_email_receipt": false, "show_description": true, "show_line_items": true, "status": "active", "success_url": "https://uat.aircamp.ph/bookings/app/?success=true&bookingNo=ACPH-817070&status=Upcoming&listing=Bamboo+Shores+Glamp&guestName=Andrea+de+Dios&listingType=Public&spot=Seashell+Bay&dateCreated=11%2F17%2F2025%2C+10%3A29%3A42+AM&checkIn=November+21%2C+2025&checkOut=November+22%2C+2025&paymentStatus=Paid&price=20.00&guestFee=2&discount=0&paymentMethod=online&subtotal=22&totalPayment=22&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "created_at": 1763346583, "updated_at": 1763346583, "metadata": { "booking_no": "ACPH-817070" } } } } [10:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [10:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:30:20.000] INFO: PayMongo checkout session created: { "data": { "id": "cs_dL72dU1usi469Y3rY4kUoY2w", "type": "checkout_session", "attributes": { "billing": { "address": { "city": null, "country": null, "line1": null, "line2": null, "postal_code": null, "state": null }, "email": null, "name": null, "phone": null }, "billing_information_fields_editable": "enabled", "cancel_url": "https://uat.aircamp.ph/bookings/app/?success=false&bookingNo=ACPH-109487&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=Public&spot=Tamarind+Hill&dateCreated=11%2F17%2F2025%2C+10%3A30%3A19+AM&checkIn=November+22%2C+2025&checkOut=November+23%2C+2025&paymentStatus=Unpaid&price=100.00&guestFee=10&discount=0&paymentMethod=online&subtotal=110&totalPayment=110&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "checkout_url": "https://checkout.paymongo.com/cs_dL72dU1usi469Y3rY4kUoY2w_client_3E1tik6Dp8w7GGVFRc7asDQe#cGtfdGVzdF9Wd2R2SFp0bkJhSEI3NHdyQ3JmaWdaUHo=", "client_key": "cs_dL72dU1usi469Y3rY4kUoY2w_client_3E1tik6Dp8w7GGVFRc7asDQe", "customer_email": null, "description": "AirCamp Booking ACPH-109487 - Christine Camp - Tamarind Hill", "line_items": [ { "amount": 11000, "currency": "PHP", "description": null, "images": [], "name": "AirCamp Booking ACPH-109487 - Christine Camp - Tamarind Hill", "quantity": 1 } ], "livemode": false, "merchant": "Berresn05", "payments": [], "payment_intent": { "id": "pi_yyuPnD527gtTzVcWXqnZ4qoh", "type": "payment_intent", "attributes": { "amount": 11000, "capture_type": "automatic", "client_key": "pi_yyuPnD527gtTzVcWXqnZ4qoh_client_pcfWtgQjpgzrw5U61T3Y86zg", "currency": "PHP", "description": "AirCamp Booking ACPH-109487 - Christine Camp - Tamarind Hill", "livemode": false, "original_amount": 11000, "statement_descriptor": "Berresn05", "status": "awaiting_payment_method", "last_payment_error": null, "payment_method_allowed": [ "grab_pay", "billease", "dob", "qrph", "paymaya", "gcash", "card" ], "payments": [], "next_action": null, "payment_method_options": { "card": { "request_three_d_secure": "any" } }, "metadata": { "booking_no": "ACPH-109487" }, "setup_future_usage": null, "created_at": 1763346620, "updated_at": 1763346620 } }, "payment_method_types": [ "paymaya", "billease", "grab_pay", "dob", "qrph", "gcash", "card" ], "reference_number": null, "send_email_receipt": false, "show_description": true, "show_line_items": true, "status": "active", "success_url": "https://uat.aircamp.ph/bookings/app/?success=true&bookingNo=ACPH-109487&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=Public&spot=Tamarind+Hill&dateCreated=11%2F17%2F2025%2C+10%3A30%3A19+AM&checkIn=November+22%2C+2025&checkOut=November+23%2C+2025&paymentStatus=Paid&price=100.00&guestFee=10&discount=0&paymentMethod=online&subtotal=110&totalPayment=110&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "created_at": 1763346620, "updated_at": 1763346620, "metadata": { "booking_no": "ACPH-109487" } } } } [10:35:00.000] INFO: Auto-cancelled 1 unpaid bookings (older than 30 minutes). Transactions updated. [10:37:16.000] INFO: HTTP Server is running on port 3000 [10:37:37.000] INFO: PayMongo checkout session created: { "data": { "id": "cs_WM27PcwvcFQwFZCaJoatKh6r", "type": "checkout_session", "attributes": { "billing": { "address": { "city": null, "country": null, "line1": null, "line2": null, "postal_code": null, "state": null }, "email": null, "name": null, "phone": null }, "billing_information_fields_editable": "enabled", "cancel_url": "https://uat.aircamp.ph/bookings/app/?success=false&bookingNo=ACPH-109487&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=&spot=Tamarind+Hill&dateCreated=11%2F17%2F2025%2C+10%3A30%3A19+AM&checkIn=November+22%2C+2025&checkOut=November+23%2C+2025&paymentStatus=Unpaid&price=&guestFee=10.00&discount=&paymentMethod=online&subtotal=110.00&totalPayment=110.00&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "checkout_url": "https://checkout.paymongo.com/cs_WM27PcwvcFQwFZCaJoatKh6r_client_Y9dze9H9RJqig6JYTDMZ2Ryd#cGtfdGVzdF9Wd2R2SFp0bkJhSEI3NHdyQ3JmaWdaUHo=", "client_key": "cs_WM27PcwvcFQwFZCaJoatKh6r_client_Y9dze9H9RJqig6JYTDMZ2Ryd", "customer_email": null, "description": "AirCamp Booking ACPH-109487 - Christine Camp - Tamarind Hill", "line_items": [ { "amount": 11000, "currency": "PHP", "description": null, "images": [], "name": "AirCamp Booking ACPH-109487 - Christine Camp - Tamarind Hill", "quantity": 1 } ], "livemode": false, "merchant": "Berresn05", "payments": [], "payment_intent": { "id": "pi_Jb8s7BHBdqAWQcPUfwidwjaU", "type": "payment_intent", "attributes": { "amount": 11000, "capture_type": "automatic", "client_key": "pi_Jb8s7BHBdqAWQcPUfwidwjaU_client_3HLqtsxrppzHu3HdMozqmCDz", "currency": "PHP", "description": "AirCamp Booking ACPH-109487 - Christine Camp - Tamarind Hill", "livemode": false, "original_amount": 11000, "statement_descriptor": "Berresn05", "status": "awaiting_payment_method", "last_payment_error": null, "payment_method_allowed": [ "dob", "paymaya", "card", "grab_pay", "gcash", "qrph", "billease" ], "payments": [], "next_action": null, "payment_method_options": { "card": { "request_three_d_secure": "any" } }, "metadata": { "booking_no": "ACPH-109487" }, "setup_future_usage": null, "created_at": 1763347057, "updated_at": 1763347057 } }, "payment_method_types": [ "grab_pay", "qrph", "billease", "dob", "gcash", "paymaya", "card" ], "reference_number": null, "send_email_receipt": false, "show_description": true, "show_line_items": true, "status": "active", "success_url": "https://uat.aircamp.ph/bookings/app/?success=true&bookingNo=ACPH-109487&status=For+Approval&listing=Christine+Camp+&guestName=Andrea+de+Dios&listingType=&spot=Tamarind+Hill&dateCreated=11%2F17%2F2025%2C+10%3A30%3A19+AM&checkIn=November+22%2C+2025&checkOut=November+23%2C+2025&paymentStatus=Paid&price=&guestFee=10.00&discount=&paymentMethod=online&subtotal=110.00&totalPayment=110.00&address=City+of+Baliwag%2C+Philippines&userImage=&firstname=Andrea&lastname=de+Dios", "created_at": 1763347057, "updated_at": 1763347057, "metadata": { "booking_no": "ACPH-109487" } } } } [10:40:00.000] INFO: Auto-cancelled 1 unpaid bookings (older than 30 minutes). Transactions updated. [10:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:51:47.000] INFO: HTTP Server is running on port 3000 [10:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [11:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [11:00:00.000] INFO: Auto-cancelled 2 unpaid bookings (older than 30 minutes). Transactions updated. [11:05:00.000] INFO: Auto-cancelled 1 unpaid bookings (older than 30 minutes). Transactions updated. [11:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [11:31:08.000] INFO: HTTP Server is running on port 3000 [11:31:08.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [11:31:08.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [11:38:29.000] INFO: HTTP Server is running on port 3000 [11:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [11:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [11:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:28:05.000] INFO: HTTP Server is running on port 3000 [13:28:05.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [13:28:05.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [13:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [14:29:33.000] INFO: HTTP Server is running on port 3000 [14:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [14:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [14:35:00.000] INFO: No unpaid bookings found for auto-cancellation. [14:55:10.000] INFO: HTTP Server is running on port 3000 [16:12:38.000] INFO: HTTP Server is running on port 3000 [16:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [16:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [17:05:08.000] INFO: HTTP Server is running on port 3000 [19:14:35.000] INFO: HTTP Server is running on port 3000 [19:14:35.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:14:36.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:14:40.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:14:56.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:14:57.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [19:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [19:15:04.000] ERROR: Server Error: Unknown column 'Listings.id' in 'where clause'{"status":500,"message":"Unknown column 'Listings.id' in 'where clause'","stack":"Error\n at Query.run (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/sequelize.js:315:28\n at async MySQLQueryInterface.select (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1140:21)\n at async Function.findOne (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1240:12)\n at async exports.getHostProfile (/home/aircamp/api-dev.aircamp.ph/controllers/customers/host-profile.js:10:16)","error":{"name":"SequelizeDatabaseError","parent":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;"},"original":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;"},"sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;","parameters":{}}} [19:15:05.000] ERROR: Server Error: Unknown column 'Listings.id' in 'where clause'{"status":500,"message":"Unknown column 'Listings.id' in 'where clause'","stack":"Error\n at Query.run (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/sequelize.js:315:28\n at async MySQLQueryInterface.select (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1140:21)\n at async Function.findOne (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1240:12)\n at async exports.getHostProfile (/home/aircamp/api-dev.aircamp.ph/controllers/customers/host-profile.js:10:16)","error":{"name":"SequelizeDatabaseError","parent":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;"},"original":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;"},"sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;","parameters":{}}} [19:15:08.000] ERROR: Server Error: Unknown column 'Listings.id' in 'where clause'{"status":500,"message":"Unknown column 'Listings.id' in 'where clause'","stack":"Error\n at Query.run (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/sequelize.js:315:28\n at async MySQLQueryInterface.select (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1140:21)\n at async Function.findOne (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1240:12)\n at async exports.getHostProfile (/home/aircamp/api-dev.aircamp.ph/controllers/customers/host-profile.js:10:16)","error":{"name":"SequelizeDatabaseError","parent":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;"},"original":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;"},"sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;","parameters":{}}} [19:15:13.000] ERROR: Server Error: Unknown column 'Listings.id' in 'where clause'{"status":500,"message":"Unknown column 'Listings.id' in 'where clause'","stack":"Error\n at Query.run (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/sequelize.js:315:28\n at async MySQLQueryInterface.select (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1140:21)\n at async Function.findOne (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1240:12)\n at async exports.getHostProfile (/home/aircamp/api-dev.aircamp.ph/controllers/customers/host-profile.js:10:16)","error":{"name":"SequelizeDatabaseError","parent":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;"},"original":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;"},"sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '495389e6-cb1f-4b8d-80be-29461dd4766c' AND `Users`.`is_host` = true;","parameters":{}}} [19:15:14.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:15:18.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:15:22.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:18:57.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:18:59.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:19:01.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [19:20:28.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:20:30.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:20:32.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:20:36.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:20:43.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:20:44.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:20:46.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:20:50.000] ERROR: Server Error: Not authenticated{"status":401,"message":"Not authenticated","stack":"Error: Not authenticated\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:12:14)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:149:13)\n at Route.dispatch (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/route.js:119:3)\n at Layer.handle [as handle_request] (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/layer.js:95:5)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:284:15\n at Function.process_params (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:346:12)\n at next (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:280:10)\n at Function.handle (/home/aircamp/api-dev.aircamp.ph/node_modules/express/lib/router/index.js:175:3)","error":{"statusCode":401}} [19:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [19:25:38.000] INFO: HTTP Server is running on port 3000 [19:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [19:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [19:35:00.000] INFO: No unpaid bookings found for auto-cancellation. [19:42:30.000] INFO: HTTP Server is running on port 3000 [19:46:45.000] ERROR: Server Error: Unknown column 'Listings.id' in 'where clause'{"status":500,"message":"Unknown column 'Listings.id' in 'where clause'","stack":"Error\n at Query.run (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/sequelize.js:315:28\n at processTicksAndRejections (node:internal/process/task_queues:96:5)\n at async MySQLQueryInterface.select (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1140:21)\n at async Function.findOne (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1240:12)\n at async exports.getHostProfile (/home/aircamp/api-dev.aircamp.ph/controllers/customers/host-profile.js:10:16)","error":{"name":"SequelizeDatabaseError","parent":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;"},"original":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;"},"sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;","parameters":{}}} [19:46:46.000] ERROR: Server Error: Unknown column 'Listings.id' in 'where clause'{"status":500,"message":"Unknown column 'Listings.id' in 'where clause'","stack":"Error\n at Query.run (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/sequelize.js:315:28\n at async MySQLQueryInterface.select (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1140:21)\n at async Function.findOne (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1240:12)\n at async exports.getHostProfile (/home/aircamp/api-dev.aircamp.ph/controllers/customers/host-profile.js:10:16)","error":{"name":"SequelizeDatabaseError","parent":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;"},"original":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;"},"sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;","parameters":{}}} [19:46:49.000] ERROR: Server Error: Unknown column 'Listings.id' in 'where clause'{"status":500,"message":"Unknown column 'Listings.id' in 'where clause'","stack":"Error\n at Query.run (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/sequelize.js:315:28\n at async MySQLQueryInterface.select (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1140:21)\n at async Function.findOne (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1240:12)\n at async exports.getHostProfile (/home/aircamp/api-dev.aircamp.ph/controllers/customers/host-profile.js:10:16)","error":{"name":"SequelizeDatabaseError","parent":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;"},"original":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;"},"sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;","parameters":{}}} [19:46:54.000] ERROR: Server Error: Unknown column 'Listings.id' in 'where clause'{"status":500,"message":"Unknown column 'Listings.id' in 'where clause'","stack":"Error\n at Query.run (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)\n at /home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/sequelize.js:315:28\n at async MySQLQueryInterface.select (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1140:21)\n at async Function.findOne (/home/aircamp/api-dev.aircamp.ph/node_modules/sequelize/lib/model.js:1240:12)\n at async exports.getHostProfile (/home/aircamp/api-dev.aircamp.ph/controllers/customers/host-profile.js:10:16)","error":{"name":"SequelizeDatabaseError","parent":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;"},"original":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'Listings.id' in 'where clause'","sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;"},"sql":"SELECT `Users`.`id`, `Users`.`firstname`, `Users`.`lastname`, `Users`.`image`, `Users`.`hosting_date`, `Users`.`address_city`, `Users`.`address_country`, `Users`.`work`, `Users`.`languages`, `Users`.`about_me`, `Users`.`music`, `Users`.`pets`, `Users`.`hangouts`, `Users`.`likes`, `Users`.`interests`, `Users`.`is_phone_verified`, `Users`.`is_email_verified`, (SELECT ROUND(AVG(rating),2) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `averageRating`, (SELECT COUNT(*) FROM host_reviews WHERE host_reviews.host_id = Users.id) AS `reviewsCount`, `hostReviews`.`id` AS `hostReviews.id`, `hostReviews`.`content` AS `hostReviews.content`, `hostReviews`.`createdAt` AS `hostReviews.createdAt`, `hostReviews->User`.`id` AS `hostReviews.User.id`, `hostReviews->User`.`firstName` AS `hostReviews.User.firstName`, `hostReviews->User`.`lastName` AS `hostReviews.User.lastName`, `hostReviews->User`.`image` AS `hostReviews.User.image`, `listings`.`id` AS `listings.id`, `listings`.`name` AS `listings.name`, `listings`.`description` AS `listings.description`, `listings`.`price` AS `listings.price`, `listings`.`address_city` AS `listings.address_city`, `listings`.`address_country` AS `listings.address_country`, `listings`.`location` AS `listings.location`, (SELECT COALESCE(ROUND(AVG(rating),2),0) FROM listing_reviews lr WHERE lr.listing_id = Listings.id) AS `listings.averageRating`, (SELECT image FROM listing_images li WHERE li.listing_id = Listings.id LIMIT 1) AS `listings.image` FROM `users` AS `Users` LEFT OUTER JOIN `host_reviews` AS `hostReviews` ON `Users`.`id` = `hostReviews`.`host_id` LEFT OUTER JOIN `users` AS `hostReviews->User` ON `hostReviews`.`user_id` = `hostReviews->User`.`id` INNER JOIN `listings` AS `listings` ON `Users`.`id` = `listings`.`host_id` AND (`listings`.`status` = 'Approved' OR `listings`.`status` = 'Active') AND `listings`.`is_deleted` = false WHERE `Users`.`id` = '402a69c2-bac4-49a0-a51e-f08e4a804ca3' AND `Users`.`is_host` = true;","parameters":{}}} [19:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [19:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [19:58:40.000] ERROR: Server Error: Cannot read properties of undefined (reading 'rating'){"status":500,"message":"Cannot read properties of undefined (reading 'rating')","stack":"TypeError: Cannot read properties of undefined (reading 'rating')\n at /home/aircamp/api-dev.aircamp.ph/controllers/customers/favorites.js:494:68\n at Array.reduce ()\n at calculateAverageRating (/home/aircamp/api-dev.aircamp.ph/controllers/customers/favorites.js:494:20)\n at /home/aircamp/api-dev.aircamp.ph/controllers/customers/favorites.js:393:29\n at Array.map ()\n at exports.getFolder (/home/aircamp/api-dev.aircamp.ph/controllers/customers/favorites.js:390:56)\n at runMicrotasks ()\n at processTicksAndRejections (node:internal/process/task_queues:96:5)","error":{}} [19:58:42.000] ERROR: Server Error: Cannot read properties of undefined (reading 'rating'){"status":500,"message":"Cannot read properties of undefined (reading 'rating')","stack":"TypeError: Cannot read properties of undefined (reading 'rating')\n at /home/aircamp/api-dev.aircamp.ph/controllers/customers/favorites.js:494:68\n at Array.reduce ()\n at calculateAverageRating (/home/aircamp/api-dev.aircamp.ph/controllers/customers/favorites.js:494:20)\n at /home/aircamp/api-dev.aircamp.ph/controllers/customers/favorites.js:393:29\n at Array.map ()\n at exports.getFolder (/home/aircamp/api-dev.aircamp.ph/controllers/customers/favorites.js:390:56)\n at runMicrotasks ()\n at processTicksAndRejections (node:internal/process/task_queues:96:5)","error":{}} [20:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [20:00:00.000] INFO: No unpaid bookings found for auto-cancellation. [20:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [20:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [20:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [20:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [20:15:16.000] ERROR: Server Error: You already have a listing. If already a host, use create listing or wait for approval{"status":400,"message":"You already have a listing. If already a host, use create listing or wait for approval","stack":"Error: You already have a listing. If already a host, use create listing or wait for approval\n at errorHandler (/home/aircamp/api-dev.aircamp.ph/util/errorHandler.js:2:17)\n at exports.applyHost (/home/aircamp/api-dev.aircamp.ph/controllers/host/v1.1/apply.js:98:14)\n at runMicrotasks ()\n at processTicksAndRejections (node:internal/process/task_queues:96:5)","error":{"statusCode":400}} [20:20:00.000] INFO: No unpaid bookings found for auto-cancellation.