[00:52:11.000] INFO: HTTP Server is running on port 3000 [00:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [01:00:00.000] INFO: No unpaid bookings found for auto-cancellation. [01:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [01:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [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. [02:30:08.000] INFO: HTTP Server is running on port 3000 [02:34:12.000] INFO: HTTP Server is running on port 3000 [02:35:00.000] INFO: No unpaid bookings found for auto-cancellation. [02:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [02:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [02:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [02:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:00:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [03:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [03:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [03:35:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [03:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [04:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [04:00:00.000] INFO: No unpaid bookings found for auto-cancellation. [04:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [04:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [04:17:08.000] INFO: HTTP Server is running on port 3000 [06:51:10.000] INFO: HTTP Server is running on port 3000 [06:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [07:00:01.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [07:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [07:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [07:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [07:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [07:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [07:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [08:37:09.000] INFO: HTTP Server is running on port 3000 [08:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [08:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [08:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [09:05:02.000] INFO: HTTP Server is running on port 3000 [09:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [09:15:01.000] INFO: No unpaid bookings found for auto-cancellation. [09:15:01.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [09:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [09:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [09:30:01.000] INFO: No unpaid bookings found for auto-cancellation. [09:30:01.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [09:35:00.000] INFO: No unpaid bookings found for auto-cancellation. [09:59:49.000] INFO: HTTP Server is running on port 3000 [10:16:40.000] INFO: HTTP Server is running on port 3000 [10:19:07.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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' 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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' 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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' AND `Users`.`is_host` = true;","parameters":{}}} [10:19:20.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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' 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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' 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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' AND `Users`.`is_host` = true;","parameters":{}}} [10:19:59.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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' 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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' 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` = '07b747f1-52bf-47d6-8dfb-711a7bfe8b65' AND `Users`.`is_host` = true;","parameters":{}}} [10:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:20:11.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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' AND `Users`.`is_host` = true;","parameters":{}}} [10:23:56.000] ERROR: Server Error: jwt expired{"status":500,"message":"jwt expired","stack":"TokenExpiredError: jwt expired\n at /home/aircamp/api-dev.aircamp.ph/node_modules/jsonwebtoken/verify.js:190:21\n at getSecret (/home/aircamp/api-dev.aircamp.ph/node_modules/jsonwebtoken/verify.js:97:14)\n at Object.module.exports [as verify] (/home/aircamp/api-dev.aircamp.ph/node_modules/jsonwebtoken/verify.js:101:10)\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/authorization.js:16:30)\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)","error":{"name":"TokenExpiredError","message":"jwt expired","expiredAt":"2025-11-20T15:59:08.000Z"}} [10:24:30.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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' AND `Users`.`is_host` = true;","parameters":{}}} [10:24:47.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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' AND `Users`.`is_host` = true;","parameters":{}}} [10:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [10:35:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:41:57.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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' AND `Users`.`is_host` = true;","parameters":{}}} [10:43:35.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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' AND `Users`.`is_host` = true;","parameters":{}}} [10:43:39.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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' AND `Users`.`is_host` = true;","parameters":{}}} [10:44:00.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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' 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` = 'e45bbc97-8a3d-4f73-853f-e915127b8874' AND `Users`.`is_host` = true;","parameters":{}}} [10:44:13.000] INFO: HTTP Server is running on port 3000 [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:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [10:56:49.000] ERROR: Server Error: Invalid request!{"status":422,"message":"Invalid request!","data":[{"type":"field","value":"googl","msg":"Provider must be google, facebook, or apple","path":"provider","location":"body"}],"stack":"Error: Invalid request!\n at module.exports (/home/aircamp/api-dev.aircamp.ph/middlewares/route-validation.js:7:19)\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 middleware (/home/aircamp/api-dev.aircamp.ph/node_modules/express-validator/lib/middlewares/check.js:16:13)\n at processTicksAndRejections (node:internal/process/task_queues:96:5)","error":{"statusCode":422,"data":[{"type":"field","value":"googl","msg":"Provider must be google, facebook, or apple","path":"provider","location":"body"}]}} [11:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [11:00:00.000] INFO: No unpaid bookings found for auto-cancellation. [11:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [11:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:06:19.000] INFO: HTTP Server is running on port 3000 [13:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [13:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [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 [13:35:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [13:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [14:00:00.000] INFO: No unpaid bookings found for auto-cancellation. [14:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [14:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [15:16:45.000] INFO: HTTP Server is running on port 3000 [15:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [15:25:00.000] INFO: No unpaid bookings found for auto-cancellation. [15:30:00.000] INFO: Bookings set to Done (past check-out, Upcoming/Ongoing): 0 [15:30:00.000] INFO: No unpaid bookings found for auto-cancellation. [15:35:22.000] INFO: HTTP Server is running on port 3000 [15:40:00.000] INFO: No unpaid bookings found for auto-cancellation. [15:45:00.000] INFO: No unpaid bookings found for auto-cancellation. [15:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [15:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [16:01:55.000] INFO: HTTP Server is running on port 3000 [16:05:00.000] INFO: No unpaid bookings found for auto-cancellation. [16:10:00.000] INFO: No unpaid bookings found for auto-cancellation. [16:15:00.000] INFO: No unpaid bookings found for auto-cancellation. [16:15:00.000] INFO: Bookings set to Ongoing (check-in started, not yet checked out): 0 [16:20:00.000] INFO: No unpaid bookings found for auto-cancellation. [16:48:04.000] INFO: HTTP Server is running on port 3000 [16:50:00.000] INFO: No unpaid bookings found for auto-cancellation. [16:55:00.000] INFO: No unpaid bookings found for auto-cancellation. [17:00:00.000] INFO: No unpaid bookings found for auto-cancellation. [17:00:00.000] INFO: Bookings cancelled (For Approval, past check-in): 0 [17:05:00.000] INFO: No unpaid bookings found for auto-cancellation.