Untitled
unknown
plain_text
a year ago
54 kB
6
Indexable
2|CMS | code: 'MODULE_NOT_FOUND',
2|CMS | requireStack: []
2|CMS | }
2|CMS | node:internal/modules/cjs/loader:1029
2|CMS | throw err;
2|CMS | ^
2|CMS |
2|CMS | Error: Cannot find module '/home/ubuntu/be-cms/dist/index.js'
2|CMS | at Function.Module._resolveFilename (node:internal/modules/cjs/loader:1026:15)
2|CMS | at Function.Module._load (node:internal/modules/cjs/loader:871:27)
2|CMS | at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:81:12)
2|CMS | at node:internal/main/run_main_module:22:47 {
2|CMS | code: 'MODULE_NOT_FOUND',
2|CMS | requireStack: []
2|CMS | }
/home/ubuntu/.pm2/logs/CMS-out.log last 15 lines:
2|CMS | rent_id" AS "permissions.menu_role.parent_id", "permissions->menu_role"."icon" AS "permissions.menu_role.icon", "permissions->menu_role"."link" AS "permissions.menu_role.link", "permissions->menu_role"."sort" AS "permissions.menu_role.sort", "permissions->menu_role"."createdAt" AS "permissions.menu_role.createdAt", "permissions->menu_role"."updatedAt" AS "permissions.menu_role.updatedAt" FROM "roles" AS "roles" LEFT OUTER JOIN "permissions" AS "permissions" ON "roles"."id" = "permissions"."role_id" LEFT OUTER JOIN "menu_roles" AS "permissions->menu_role" ON "permissions"."menu_id" = "permissions->menu_role"."id" WHERE ("roles"."id" = 6);
2|CMS | Executing (default): SELECT count("advertises"."id") AS "count" FROM "advertises" AS "advertises" INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id" AND "agent"."type_agent" IN (0, 3) WHERE "advertises"."deletedAt" IS NULL;
2|CMS | GET /api/company/1 200 6.076 ms - -
2|CMS | GET /api/company/1 200 4.247 ms - -
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "highlights" AS "highlights";
2|CMS | Executing (default): SELECT "roles"."id", "roles"."name", "roles"."createdAt", "roles"."updatedAt", "permissions"."id" AS "permissions.id", "permissions"."role_id" AS "permissions.role_id", "permissions"."menu_id" AS "permissions.menu_id", "permissions"."createdAt" AS "permissions.createdAt", "permissions"."updatedAt" AS "permissions.updatedAt", "permissions->menu_role"."id" AS "permissions.menu_role.id", "permissions->menu_role"."name" AS "permissions.menu_role.name", "permissions->menu_role"."type" AS "permissions.menu_role.type", "permissions->menu_role"."position" AS "permissions.menu_role.position", "permissions->menu_role"."parent_id" AS "permissions.menu_role.parent_id", "permissions->menu_role"."icon" AS "permissions.menu_role.icon", "permissions->menu_role"."link" AS "permissions.menu_role.link", "permissions->menu_role"."sort" AS "permissions.menu_role.sort", "permissions->menu_role"."createdAt" AS "permissions.menu_role.createdAt", "permissions->menu_role"."updatedAt" AS "permissions.menu_role.updatedAt" FROM "roles" AS "roles" LEFT OUTER JOIN "permissions" AS "permissions" ON "roles"."id" = "permissions"."role_id" LEFT OUTER JOIN "menu_roles" AS "permissions->menu_role" ON "permissions"."menu_id" = "permissions->menu_role"."id" WHERE ("roles"."id" = 6);
2|CMS | GET /api/permission/?role=6 200 23.741 ms - -
2|CMS | Executing (default): SELECT "id", "name", "icon", "price", "duration", "createdAt", "updatedAt" FROM "highlights" AS "highlights" ORDER BY "highlights"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS | GET /api/highlight?page=1&size=500 200 26.717 ms - 631
2|CMS | GET /api/permission/?role=6 200 23.302 ms - -
2|CMS | Executing (default): SELECT count("advertises"."id") AS "count" FROM "advertises" AS "advertises" INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id" AND "agent"."type_agent" IN (0, 3) WHERE "advertises"."deletedAt" IS NULL;
2|CMS | Executing (default): SELECT "advertises".*, "advertises_media"."id" AS "advertises_media.id", "advertises_media"."agent_id" AS "advertises_media.agent_id", "advertises_media"."is_cover" AS "advertises_media.is_cover", "advertises_media"."advertises_id" AS "advertises_media.advertises_id", "advertises_media"."image" AS "advertises_media.image", "advertises_media"."project_id" AS "advertises_media.project_id", "advertises_media"."createdAt" AS "advertises_media.createdAt", "advertises_media"."updatedAt" AS "advertises_media.updatedAt", "advertise_facilities"."id" AS "advertise_facilities.id", "advertise_facilities"."agent_id" AS "advertise_facilities.agent_id", "advertise_facilities"."advertise_id" AS "advertise_facilities.advertise_id", "advertise_facilities"."facility_id" AS "advertise_facilities.facility_id", "advertise_facilities"."createdAt" AS "advertise_facilities.createdAt", "advertise_facilities"."updatedAt" AS "advertise_facilities.updatedAt", "agent->office_agent"."id" AS "agent.office_agent.id", "agent->office_agent"."nib" AS "agent.office_agent.nib", "agent->office_agent"."type" AS "agent.office_agent.type", "agent->office_agent"."tagline" AS "agent.office_agent.tagline", "agent->office_agent"."name" AS "agent.office_agent.name", "agent->office_agent"."address" AS "agent.office_agent.address", "agent->office_agent"."pic" AS "agent.office_agent.pic", "agent->office_agent"."phone" AS "agent.office_agent.phone", "agent->office_agent"."npwp" AS "agent.office_agent.npwp", "agent->office_agent"."email" AS "agent.office_agent.email", "agent->office_agent"."image" AS "agent.office_agent.image", "agent->office_agent"."desc" AS "agent.office_agent.desc", "agent->office_agent"."is_official_developer" AS "agent.office_agent.is_official_developer", "agent->office_agent"."is_trusted_developer" AS "agent.office_agent.is_trusted_developer", "agent->office_agent"."is_trusted_prop_agency" AS "agent.office_agent.is_trusted_prop_agency", "agent->office_agent"."link" AS "agent.office_agent.link", "agent->office_agent"."twitter" AS "agent.office_agent.twitter", "agent->office_agent"."ig" AS "agent.office_agent.ig", "agent->office_agent"."yt" AS "agent.office_agent.yt", "agent->office_agent"."fb" AS "agent.office_agent.fb", "agent->office_agent"."createdAt" AS "agent.office_agent.createdAt", "agent->office_agent"."updatedAt" AS "agent.office_agent.updatedAt" FROM (SELECT "advertises"."id", "advertises"."office_id", "advertises"."ads_id", "advertises"."agent_id", "advertises"."project_id", "advertises"."rental_type", "advertises"."is_publish", "advertises"."is_highlights", "advertises"."province_id", "advertises"."city_id", "advertises"."district_id", "advertises"."nib", "advertises"."location", "advertises"."lat", "advertises"."long", "advertises"."zip", "advertises"."regency", "advertises"."subdistrict", "advertises"."province", "advertises"."property_type", "advertises"."ownership_certificate", "advertises"."listing_type", "advertises"."name", "advertises"."desc", "advertises"."price", "advertises"."building_type_id", "advertises"."size_land", "advertises"."size_building", "advertises"."rooms", "advertises"."bathroom", "advertises"."carport", "advertises"."garage", "advertises"."electricity", "advertises"."highlight_id", "advertises"."report_desc", "advertises"."user_report", "advertises"."unit", "advertises"."deletedAt", "advertises"."reason", "advertises"."exp_heighlight", "advertises"."created_by", "advertises"."updated_by", "advertises"."createdAt", "advertises"."updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt" FROM "advertises" AS "advertises" INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id" AND "agent"."type_agent" IN (0, 3) WHERE "advertises"."deletedAt" IS NULL ORDER BY "advertises"."createdAt" DESC LIMIT 10 OFFSET 0) AS "advertises" LEFT OUTER JOIN "advertises_media" AS "advertises_media" ON "advertises"."id" = "advertises_media"."advertises_id" LEFT OUTER JOIN "advertise_facilities" AS "advertise_facilities" ON "advertises"."id" = "advertise_facilities"."advertise_id" LEFT OUTER JOIN "office_agents" AS "agent->office_agent" ON "agent.office_id" = "agent->office_agent"."id" ORDER BY "advertises"."createdAt" DESC;
2|CMS | Executing (default): SELECT "advertises".*, "advertises_media"."id" AS "advertises_media.id", "advertises_media"."agent_id" AS "advertises_media.agent_id", "advertises_media"."is_cover" AS "advertises_media.is_cover", "advertises_media"."advertises_id" AS "advertises_media.advertises_id", "advertises_media"."image" AS "advertises_media.image", "advertises_media"."project_id" AS "advertises_media.project_id", "advertises_media"."createdAt" AS "advertises_media.createdAt", "advertises_media"."updatedAt" AS "advertises_media.updatedAt", "advertise_facilities"."id" AS "advertise_facilities.id", "advertise_facilities"."agent_id" AS "advertise_facilities.agent_id", "advertise_facilities"."advertise_id" AS "advertise_facilities.advertise_id", "advertise_facilities"."facility_id" AS "advertise_facilities.facility_id", "advertise_facilities"."createdAt" AS "advertise_facilities.createdAt", "advertise_facilities"."updatedAt" AS "advertise_facilities.updatedAt", "agent->office_agent"."id" AS "agent.office_agent.id", "agent->office_agent"."nib" AS "agent.office_agent.nib", "agent->office_agent"."type" AS "agent.office_agent.type", "agent->office_agent"."tagline" AS "agent.office_agent.tagline", "agent->office_agent"."name" AS "agent.office_agent.name", "agent->office_agent"."address" AS "agent.office_agent.address", "agent->office_agent"."pic" AS "agent.office_agent.pic", "agent->office_agent"."phone" AS "agent.office_agent.phone", "agent->office_agent"."npwp" AS "agent.office_agent.npwp", "agent->office_agent"."email" AS "agent.office_agent.email", "agent->office_agent"."image" AS "agent.office_agent.image", "agent->office_agent"."desc" AS "agent.office_agent.desc", "agent->office_agent"."is_official_developer" AS "agent.office_agent.is_official_developer", "agent->office_agent"."is_trusted_developer" AS "agent.office_agent.is_trusted_developer", "agent->office_agent"."is_trusted_prop_agency" AS "agent.office_agent.is_trusted_prop_agency", "agent->office_agent"."link" AS "agent.office_agent.link", "agent->office_agent"."twitter" AS "agent.office_agent.twitter", "agent->office_agent"."ig" AS "agent.office_agent.ig", "agent->office_agent"."yt" AS "agent.office_agent.yt", "agent->office_agent"."fb" AS "agent.office_agent.fb", "agent->office_agent"."createdAt" AS "agent.office_agent.createdAt", "agent->office_agent"."updatedAt" AS "agent.office_agent.updatedAt" FROM (SELECT "advertises"."id", "advertises"."office_id", "advertises"."ads_id", "advertises"."agent_id", "advertises"."project_id", "advertises"."rental_type", "advertises"."is_publish", "advertises"."is_highlights", "advertises"."province_id", "advertises"."city_id", "advertises"."district_id", "advertises"."nib", "advertises"."location", "advertises"."lat", "advertises"."long", "advertises"."zip", "advertises"."regency", "advertises"."subdistrict", "advertises"."province", "advertises"."property_type", "advertises"."ownership_certificate", "advertises"."listing_type", "advertises"."name", "advertises"."desc", "advertises"."price", "advertises"."building_type_id", "advertises"."size_land", "advertises"."size_building", "advertises"."rooms", "advertises"."bathroom", "advertises"."carport", "advertises"."garage", "advertises"."electricity", "advertises"."highlight_id", "advertises"."report_desc", "advertises"."user_report", "advertises"."unit", "advertises"."deletedAt", "advertises"."reason", "advertises"."exp_heighlight", "advertises"."created_by", "advertises"."updated_by", "advertises"."createdAt", "advertises"."updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt" FROM "advertises" AS "advertises" INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id" AND "agent"."type_agent" IN (0, 3) WHERE "advertises"."deletedAt" IS NULL ORDER BY "advertises"."createdAt" DESC LIMIT 10 OFFSET 0) AS "advertises" LEFT OUTER JOIN "advertises_media" AS "advertises_media" ON "advertises"."id" = "advertises_media"."advertises_id" LEFT OUTER JOIN "advertise_facilities" AS "advertise_facilities" ON "advertises"."id" = "advertise_facilities"."advertise_id" LEFT OUTER JOIN "office_agents" AS "agent->office_agent" ON "agent.office_id" = "agent->office_agent"."id" ORDER BY "advertises"."createdAt" DESC;
2|CMS | error: Error: column agent.tmp_pwd does not exist {"name":"SequelizeDatabaseError","original":{"code":"42703","file":"parse_relation.c","length":113,"line":"3638","name":"error","position":"4626","routine":"errorMissingColumn","severity":"ERROR","sql":"SELECT \"advertises\".*, \"advertises_media\".\"id\" AS \"advertises_media.id\", \"advertises_media\".\"agent_id\" AS \"advertises_media.agent_id\", \"advertises_media\".\"is_cover\" AS \"advertises_media.is_cover\", \"advertises_media\".\"advertises_id\" AS \"advertises_media.advertises_id\", \"advertises_media\".\"image\" AS \"advertises_media.image\", \"advertises_media\".\"project_id\" AS \"advertises_media.project_id\", \"advertises_media\".\"createdAt\" AS \"advertises_media.createdAt\", \"advertises_media\".\"updatedAt\" AS \"advertises_media.updatedAt\", \"advertise_facilities\".\"id\" AS \"advertise_facilities.id\", \"advertise_facilities\".\"agent_id\" AS \"advertise_facilities.agent_id\", \"advertise_facilities\".\"advertise_id\" AS \"advertise_facilities.advertise_id\", \"advertise_facilities\".\"facility_id\" AS \"advertise_facilities.facility_id\", \"advertise_facilities\".\"createdAt\" AS \"advertise_facilities.createdAt\", \"advertise_facilities\".\"updatedAt\" AS \"advertise_facilities.updatedAt\", \"agent->office_agent\".\"id\" AS \"agent.office_agent.id\", \"agent->office_agent\".\"nib\" AS \"agent.office_agent.nib\", \"agent->office_agent\".\"type\" AS \"agent.office_agent.type\", \"agent->office_agent\".\"tagline\" AS \"agent.office_agent.tagline\", \"agent->office_agent\".\"name\" AS \"agent.office_agent.name\", \"agent->office_agent\".\"address\" AS \"agent.office_agent.address\", \"agent->office_agent\".\"pic\" AS \"agent.office_agent.pic\", \"agent->office_agent\".\"phone\" AS \"agent.office_agent.phone\", \"agent->office_agent\".\"npwp\" AS \"agent.office_agent.npwp\", \"agent->office_agent\".\"email\" AS \"agent.office_agent.email\", \"agent->office_agent\".\"image\" AS \"agent.office_agent.image\", \"agent->office_agent\".\"desc\" AS \"agent.office_agent.desc\", \"agent->office_agent\".\"is_official_developer\" AS \"agent.office_agent.is_official_developer\", \"agent->office_agent\".\"is_trusted_developer\" AS \"agent.office_agent.is_trusted_developer\", \"agent->office_agent\".\"is_trusted_prop_agency\" AS \"agent.office_agent.is_trusted_prop_agency\", \"agent->office_agent\".\"link\" AS \"agent.office_agent.link\", \"agent->office_agent\".\"twitter\" AS \"agent.office_agent.twitter\", \"agent->office_agent\".\"ig\" AS \"agent.office_agent.ig\", \"agent->office_agent\".\"yt\" AS \"agent.office_agent.yt\", \"agent->office_agent\".\"fb\" AS \"agent.office_agent.fb\", \"agent->office_agent\".\"createdAt\" AS \"agent.office_agent.createdAt\", \"agent->office_agent\".\"updatedAt\" AS \"agent.office_agent.updatedAt\" FROM (SELECT \"advertises\".\"id\", \"advertises\".\"office_id\", \"advertises\".\"ads_id\", \"advertises\".\"agent_id\", \"advertises\".\"project_id\", \"advertises\".\"rental_type\", \"advertises\".\"is_publish\", \"advertises\".\"is_highlights\", \"advertises\".\"province_id\", \"advertises\".\"city_id\", \"advertises\".\"district_id\", \"advertises\".\"nib\", \"advertises\".\"location\", \"advertises\".\"lat\", \"advertises\".\"long\", \"advertises\".\"zip\", \"advertises\".\"regency\", \"advertises\".\"subdistrict\", \"advertises\".\"province\", \"advertises\".\"property_type\", \"advertises\".\"ownership_certificate\", \"advertises\".\"listing_type\", \"advertises\".\"name\", \"advertises\".\"desc\", \"advertises\".\"price\", \"advertises\".\"building_type_id\", \"advertises\".\"size_land\", \"advertises\".\"size_building\", \"advertises\".\"rooms\", \"advertises\".\"bathroom\", \"advertises\".\"carport\", \"advertises\".\"garage\", \"advertises\".\"electricity\", \"advertises\".\"highlight_id\", \"advertises\".\"report_desc\", \"advertises\".\"user_report\", \"advertises\".\"unit\", \"advertises\".\"deletedAt\", \"advertises\".\"reason\", \"advertises\".\"exp_heighlight\", \"advertises\".\"created_by\", \"advertises\".\"updated_by\", \"advertises\".\"createdAt\", \"advertises\".\"updatedAt\", \"agent\".\"id\" AS \"agent.id\", \"agent\".\"office_id\" AS \"agent.office_id\", \"agent\".\"duration_qouta\" AS \"agent.duration_qouta\", \"agent\".\"office\" AS \"agent.office\", \"agent\".\"image\" AS \"agent.image\", \"agent\".\"pic_name\" AS \"agent.pic_name\", \"agent\".\"phone\" AS \"agent.phone\", \"agent\".\"province_id\" AS \"agent.province_id\", \"agent\".\"city_id\" AS \"agent.city_id\", \"agent\".\"district_id\" AS \"agent.district_id\", \"agent\".\"city\" AS \"agent.city\", \"agent\".\"province\" AS \"agent.province\", \"agent\".\"district\" AS \"agent.district\", \"agent\".\"is_priority\" AS \"agent.is_priority\", \"agent\".\"desc\" AS \"agent.desc\", \"agent\".\"email\" AS \"agent.email\", \"agent\".\"type_agent\" AS \"agent.type_agent\", \"agent\".\"user_id\" AS \"agent.user_id\", \"agent\".\"quota\" AS \"agent.quota\", \"agent\".\"is_active\" AS \"agent.is_active\", \"agent\".\"is_trusted\" AS \"agent.is_trusted\", \"agent\".\"is_spesialis\" AS \"agent.is_spesialis\", \"agent\".\"is_gold_seller\" AS \"agent.is_gold_seller\", \"agent\".\"reason\" AS \"agent.reason\", \"agent\".\"link\" AS \"agent.link\", \"agent\".\"twitter\" AS \"agent.twitter\", \"agent\".\"ig\" AS \"agent.ig\", \"agent\".\"yt\" AS \"agent.yt\", \"agent\".\"fb\" AS \"agent.fb\", \"agent\".\"tmp_pwd\" AS \"agent.tmp_pwd\", \"agent\".\"createdAt\" AS \"agent.createdAt\", \"agent\".\"updatedAt\" AS \"agent.updatedAt\" FROM \"advertises\" AS \"advertises\" INNER JOIN \"agents\" AS \"agent\" ON \"advertises\".\"agent_id\" = \"agent\".\"id\" AND \"agent\".\"type_agent\" IN (0, 3) WHERE \"advertises\".\"deletedAt\" IS NULL ORDER BY \"advertises\".\"createdAt\" DESC LIMIT 10 OFFSET 0) AS \"advertises\" LEFT OUTER JOIN \"advertises_media\" AS \"advertises_media\" ON \"advertises\".\"id\" = \"advertises_media\".\"advertises_id\" LEFT OUTER JOIN \"advertise_facilities\" AS \"advertise_facilities\" ON \"advertises\".\"id\" = \"advertise_facilities\".\"advertise_id\" LEFT OUTER JOIN \"office_agents\" AS \"agent->office_agent\" ON \"agent.office_id\" = \"agent->office_agent\".\"id\" ORDER BY \"advertises\".\"createdAt\" DESC;"},"parameters":{},"parent":{"code":"42703","file":"parse_relation.c","length":113,"line":"3638","name":"error","position":"4626","routine":"errorMissingColumn","severity":"ERROR","sql":"SELECT \"advertises\".*, \"advertises_media\".\"id\" AS \"advertises_media.id\", \"advertises_media\".\"agent_id\" AS \"advertises_media.agent_id\", \"advertises_media\".\"is_cover\" AS \"advertises_media.is_cover\", \"advertises_media\".\"advertises_id\" AS \"advertises_media.advertises_id\", \"advertises_media\".\"image\" AS \"advertises_media.image\", \"advertises_media\".\"project_id\" AS \"advertises_media.project_id\", \"advertises_media\".\"createdAt\" AS \"advertises_media.createdAt\", \"advertises_media\".\"updatedAt\" AS \"advertises_media.updatedAt\", \"advertise_facilities\".\"id\" AS \"advertise_facilities.id\", \"advertise_facilities\".\"agent_id\" AS \"advertise_facilities.agent_id\", \"advertise_facilities\".\"advertise_id\" AS \"advertise_facilities.advertise_id\", \"advertise_facilities\".\"facility_id\" AS \"advertise_facilities.facility_id\", \"advertise_facilities\".\"createdAt\" AS \"advertise_facilities.createdAt\", \"advertise_facilities\".\"updatedAt\" AS \"advertise_facilities.updatedAt\", \"agent->office_agent\".\"id\" AS \"agent.office_agent.id\", \"agent->office_agent\".\"nib\" AS \"agent.office_agent.nib\", \"agent->office_agent\".\"type\" AS \"agent.office_agent.type\", \"agent->office_agent\".\"tagline\" AS \"agent.office_agent.tagline\", \"agent->office_agent\".\"name\" AS \"agent.office_agent.name\", \"agent->office_agent\".\"address\" AS \"agent.office_agent.address\", \"agent->office_agent\".\"pic\" AS \"agent.office_agent.pic\", \"agent->office_agent\".\"phone\" AS \"agent.office_agent.phone\", \"agent->office_agent\".\"npwp\" AS \"agent.office_agent.npwp\", \"agent->office_agent\".\"email\" AS \"agent.office_agent.email\", \"agent->office_agent\".\"image\" AS \"agent.office_agent.image\", \"agent->office_agent\".\"desc\" AS \"agent.office_agent.desc\", \"agent->office_agent\".\"is_official_developer\" AS \"agent.office_agent.is_official_developer\", \"agent->office_agent\".\"is_trusted_developer\" AS \"agent.office_agent.is_trusted_developer\", \"agent->office_agent\".\"is_trusted_prop_agency\" AS \"agent.office_agent.is_trusted_prop_agency\", \"agent->office_agent\".\"link\" AS \"agent.office_agent.link\", \"agent->office_agent\".\"twitter\" AS \"agent.office_agent.twitter\", \"agent->office_agent\".\"ig\" AS \"agent.office_agent.ig\", \"agent->office_agent\".\"yt\" AS \"agent.office_agent.yt\", \"agent->office_agent\".\"fb\" AS \"agent.office_agent.fb\", \"agent->office_agent\".\"createdAt\" AS \"agent.office_agent.createdAt\", \"agent->office_agent\".\"updatedAt\" AS \"agent.office_agent.updatedAt\" FROM (SELECT \"advertises\".\"id\", \"advertises\".\"office_id\", \"advertises\".\"ads_id\", \"advertises\".\"agent_id\", \"advertises\".\"project_id\", \"advertises\".\"rental_type\", \"advertises\".\"is_publish\", \"advertises\".\"is_highlights\", \"advertises\".\"province_id\", \"advertises\".\"city_id\", \"advertises\".\"district_id\", \"advertises\".\"nib\", \"advertises\".\"location\", \"advertises\".\"lat\", \"advertises\".\"long\", \"advertises\".\"zip\", \"advertises\".\"regency\", \"advertises\".\"subdistrict\", \"advertises\".\"province\", \"advertises\".\"property_type\", \"advertises\".\"ownership_certificate\", \"advertises\".\"listing_type\", \"advertises\".\"name\", \"advertises\".\"desc\", \"advertises\".\"price\", \"advertises\".\"building_type_id\", \"advertises\".\"size_land\", \"advertises\".\"size_building\", \"advertises\".\"rooms\", \"advertises\".\"bathroom\", \"advertises\".\"carport\", \"advertises\".\"garage\", \"advertises\".\"electricity\", \"advertises\".\"highlight_id\", \"advertises\".\"report_desc\", \"advertises\".\"user_report\", \"advertises\".\"unit\", \"advertises\".\"deletedAt\", \"advertises\".\"reason\", \"advertises\".\"exp_heighlight\", \"advertises\".\"created_by\", \"advertises\".\"updated_by\", \"advertises\".\"createdAt\", \"advertises\".\"updatedAt\", \"agent\".\"id\" AS \"agent.id\", \"agent\".\"office_id\" AS \"agent.office_id\", \"agent\".\"duration_qouta\" AS \"agent.duration_qouta\", \"agent\".\"office\" AS \"agent.office\", \"agent\".\"image\" AS \"agent.image\", \"agent\".\"pic_name\" AS \"agent.pic_name\", \"agent\".\"phone\" AS \"agent.phone\", \"agent\".\"province_id\" AS \"agent.province_id\", \"agent\".\"city_id\" AS \"agent.city_id\", \"agent\".\"district_id\" AS \"agent.district_id\", \"agent\".\"city\" AS \"agent.city\", \"agent\".\"province\" AS \"agent.province\", \"agent\".\"district\" AS \"agent.district\", \"agent\".\"is_priority\" AS \"agent.is_priority\", \"agent\".\"desc\" AS \"agent.desc\", \"agent\".\"email\" AS \"agent.email\", \"agent\".\"type_agent\" AS \"agent.type_agent\", \"agent\".\"user_id\" AS \"agent.user_id\", \"agent\".\"quota\" AS \"agent.quota\", \"agent\".\"is_active\" AS \"agent.is_active\", \"agent\".\"is_trusted\" AS \"agent.is_trusted\", \"agent\".\"is_spesialis\" AS \"agent.is_spesialis\", \"agent\".\"is_gold_seller\" AS \"agent.is_gold_seller\", \"agent\".\"reason\" AS \"agent.reason\", \"agent\".\"link\" AS \"agent.link\", \"agent\".\"twitter\" AS \"agent.twitter\", \"agent\".\"ig\" AS \"agent.ig\", \"agent\".\"yt\" AS \"agent.yt\", \"agent\".\"fb\" AS \"agent.fb\", \"agent\".\"tmp_pwd\" AS \"agent.tmp_pwd\", \"agent\".\"createdAt\" AS \"agent.createdAt\", \"agent\".\"updatedAt\" AS \"agent.updatedAt\" FROM \"advertises\" AS \"advertises\" INNER JOIN \"agents\" AS \"agent\" ON \"advertises\".\"agent_id\" = \"agent\".\"id\" AND \"agent\".\"type_agent\" IN (0, 3) WHERE \"advertises\".\"deletedAt\" IS NULL ORDER BY \"advertises\".\"createdAt\" DESC LIMIT 10 OFFSET 0) AS \"advertises\" LEFT OUTER JOIN \"advertises_media\" AS \"advertises_media\" ON \"advertises\".\"id\" = \"advertises_media\".\"advertises_id\" LEFT OUTER JOIN \"advertise_facilities\" AS \"advertise_facilities\" ON \"advertises\".\"id\" = \"advertise_facilities\".\"advertise_id\" LEFT OUTER JOIN \"office_agents\" AS \"agent->office_agent\" ON \"agent.office_id\" = \"agent->office_agent\".\"id\" ORDER BY \"advertises\".\"createdAt\" DESC;"},"sql":"SELECT \"advertises\".*, \"advertises_media\".\"id\" AS \"advertises_media.id\", \"advertises_media\".\"agent_id\" AS \"advertises_media.agent_id\", \"advertises_media\".\"is_cover\" AS \"advertises_media.is_cover\", \"advertises_media\".\"advertises_id\" AS \"advertises_media.advertises_id\", \"advertises_media\".\"image\" AS \"advertises_media.image\", \"advertises_media\".\"project_id\" AS \"advertises_media.project_id\", \"advertises_media\".\"createdAt\" AS \"advertises_media.createdAt\", \"advertises_media\".\"updatedAt\" AS \"advertises_media.updatedAt\", \"advertise_facilities\".\"id\" AS \"advertise_facilities.id\", \"advertise_facilities\".\"agent_id\" AS \"advertise_facilities.agent_id\", \"advertise_facilities\".\"advertise_id\" AS \"advertise_facilities.advertise_id\", \"advertise_facilities\".\"facility_id\" AS \"advertise_facilities.facility_id\", \"advertise_facilities\".\"createdAt\" AS \"advertise_facilities.createdAt\", \"advertise_facilities\".\"updatedAt\" AS \"advertise_facilities.updatedAt\", \"agent->office_agent\".\"id\" AS \"agent.office_agent.id\", \"agent->office_agent\".\"nib\" AS \"agent.office_agent.nib\", \"agent->office_agent\".\"type\" AS \"agent.office_agent.type\", \"agent->office_agent\".\"tagline\" AS \"agent.office_agent.tagline\", \"agent->office_agent\".\"name\" AS \"agent.office_agent.name\", \"agent->office_agent\".\"address\" AS \"agent.office_agent.address\", \"agent->office_agent\".\"pic\" AS \"agent.office_agent.pic\", \"agent->office_agent\".\"phone\" AS \"agent.office_agent.phone\", \"agent->office_agent\".\"npwp\" AS \"agent.office_agent.npwp\", \"agent->office_agent\".\"email\" AS \"agent.office_agent.email\", \"agent->office_agent\".\"image\" AS \"agent.office_agent.image\", \"agent->office_agent\".\"desc\" AS \"agent.office_agent.desc\", \"agent->office_agent\".\"is_official_developer\" AS \"agent.office_agent.is_official_developer\", \"agent->office_agent\".\"is_trusted_developer\" AS \"agent.office_agent.is_trusted_developer\", \"agent->office_agent\".\"is_trusted_prop_agency\" AS \"agent.office_agent.is_trusted_prop_agency\", \"agent->office_agent\".\"link\" AS \"agent.office_agent.link\", \"agent->office_agent\".\"twitter\" AS \"agent.office_agent.twitter\", \"agent->office_agent\".\"ig\" AS \"agent.office_agent.ig\", \"agent->office_agent\".\"yt\" AS \"agent.office_agent.yt\", \"agent->office_agent\".\"fb\" AS \"agent.office_agent.fb\", \"agent->office_agent\".\"createdAt\" AS \"agent.office_agent.createdAt\", \"agent->office_agent\".\"updatedAt\" AS \"agent.office_agent.updatedAt\" FROM (SELECT \"advertises\".\"id\", \"advertises\".\"office_id\", \"advertises\".\"ads_id\", \"advertises\".\"agent_id\", \"advertises\".\"project_id\", \"advertises\".\"rental_type\", \"advertises\".\"is_publish\", \"advertises\".\"is_highlights\", \"advertises\".\"province_id\", \"advertises\".\"city_id\", \"advertises\".\"district_id\", \"advertises\".\"nib\", \"advertises\".\"location\", \"advertises\".\"lat\", \"advertises\".\"long\", \"advertises\".\"zip\", \"advertises\".\"regency\", \"advertises\".\"subdistrict\", \"advertises\".\"province\", \"advertises\".\"property_type\", \"advertises\".\"ownership_certificate\", \"advertises\".\"listing_type\", \"advertises\".\"name\", \"advertises\".\"desc\", \"advertises\".\"price\", \"advertises\".\"building_type_id\", \"advertises\".\"size_land\", \"advertises\".\"size_building\", \"advertises\".\"rooms\", \"advertises\".\"bathroom\", \"advertises\".\"carport\", \"advertises\".\"garage\", \"advertises\".\"electricity\", \"advertises\".\"highlight_id\", \"advertises\".\"report_desc\", \"advertises\".\"user_report\", \"advertises\".\"unit\", \"advertises\".\"deletedAt\", \"advertises\".\"reason\", \"advertises\".\"exp_heighlight\", \"advertises\".\"created_by\", \"advertises\".\"updated_by\", \"advertises\".\"createdAt\", \"advertises\".\"updatedAt\", \"agent\".\"id\" AS \"agent.id\", \"agent\".\"office_id\" AS \"agent.office_id\", \"agent\".\"duration_qouta\" AS \"agent.duration_qouta\", \"agent\".\"office\" AS \"agent.office\", \"agent\".\"image\" AS \"agent.image\", \"agent\".\"pic_name\" AS \"agent.pic_name\", \"agent\".\"phone\" AS \"agent.phone\", \"agent\".\"province_id\" AS \"agent.province_id\", \"agent\".\"city_id\" AS \"agent.city_id\", \"agent\".\"district_id\" AS \"agent.district_id\", \"agent\".\"city\" AS \"agent.city\", \"agent\".\"province\" AS \"agent.province\", \"agent\".\"district\" AS \"agent.district\", \"agent\".\"is_priority\" AS \"agent.is_priority\", \"agent\".\"desc\" AS \"agent.desc\", \"agent\".\"email\" AS \"agent.email\", \"agent\".\"type_agent\" AS \"agent.type_agent\", \"agent\".\"user_id\" AS \"agent.user_id\", \"agent\".\"quota\" AS \"agent.quota\", \"agent\".\"is_active\" AS \"agent.is_active\", \"agent\".\"is_trusted\" AS \"agent.is_trusted\", \"agent\".\"is_spesialis\" AS \"agent.is_spesialis\", \"agent\".\"is_gold_seller\" AS \"agent.is_gold_seller\", \"agent\".\"reason\" AS \"agent.reason\", \"agent\".\"link\" AS \"agent.link\", \"agent\".\"twitter\" AS \"agent.twitter\", \"agent\".\"ig\" AS \"agent.ig\", \"agent\".\"yt\" AS \"agent.yt\", \"agent\".\"fb\" AS \"agent.fb\", \"agent\".\"tmp_pwd\" AS \"agent.tmp_pwd\", \"agent\".\"createdAt\" AS \"agent.createdAt\", \"agent\".\"updatedAt\" AS \"agent.updatedAt\" FROM \"advertises\" AS \"advertises\" INNER JOIN \"agents\" AS \"agent\" ON \"advertises\".\"agent_id\" = \"agent\".\"id\" AND \"agent\".\"type_agent\" IN (0, 3) WHERE \"advertises\".\"deletedAt\" IS NULL ORDER BY \"advertises\".\"createdAt\" DESC LIMIT 10 OFFSET 0) AS \"advertises\" LEFT OUTER JOIN \"advertises_media\" AS \"advertises_media\" ON \"advertises\".\"id\" = \"advertises_media\".\"advertises_id\" LEFT OUTER JOIN \"advertise_facilities\" AS \"advertise_facilities\" ON \"advertises\".\"id\" = \"advertise_facilities\".\"advertise_id\" LEFT OUTER JOIN \"office_agents\" AS \"agent->office_agent\" ON \"agent.office_id\" = \"agent->office_agent\".\"id\" ORDER BY \"advertises\".\"createdAt\" DESC;","stack":"Error\n at Query.run (/home/ubuntu/be-cms/node_modules/sequelize/lib/dialects/postgres/query.js:50:25)\n at /home/ubuntu/be-cms/node_modules/sequelize/lib/sequelize.js:315:28\n at runMicrotasks (<anonymous>)\n at processTicksAndRejections (node:internal/process/task_queues:96:5)\n at async PostgresQueryInterface.select (/home/ubuntu/be-cms/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/ubuntu/be-cms/node_modules/sequelize/lib/model.js:1140:21)","time":"2024-02-05T06:27:21.837Z"}
2|CMS | GET /api/advertises?page=1&size=10&agentType=3 500 1382.375 ms - 93
2|CMS | error: Error: column agent.tmp_pwd does not exist {"name":"SequelizeDatabaseError","original":{"code":"42703","file":"parse_relation.c","length":113,"line":"3638","name":"error","position":"4626","routine":"errorMissingColumn","severity":"ERROR","sql":"SELECT \"advertises\".*, \"advertises_media\".\"id\" AS \"advertises_media.id\", \"advertises_media\".\"agent_id\" AS \"advertises_media.agent_id\", \"advertises_media\".\"is_cover\" AS \"advertises_media.is_cover\", \"advertises_media\".\"advertises_id\" AS \"advertises_media.advertises_id\", \"advertises_media\".\"image\" AS \"advertises_media.image\", \"advertises_media\".\"project_id\" AS \"advertises_media.project_id\", \"advertises_media\".\"createdAt\" AS \"advertises_media.createdAt\", \"advertises_media\".\"updatedAt\" AS \"advertises_media.updatedAt\", \"advertise_facilities\".\"id\" AS \"advertise_facilities.id\", \"advertise_facilities\".\"agent_id\" AS \"advertise_facilities.agent_id\", \"advertise_facilities\".\"advertise_id\" AS \"advertise_facilities.advertise_id\", \"advertise_facilities\".\"facility_id\" AS \"advertise_facilities.facility_id\", \"advertise_facilities\".\"createdAt\" AS \"advertise_facilities.createdAt\", \"advertise_facilities\".\"updatedAt\" AS \"advertise_facilities.updatedAt\", \"agent->office_agent\".\"id\" AS \"agent.office_agent.id\", \"agent->office_agent\".\"nib\" AS \"agent.office_agent.nib\", \"agent->office_agent\".\"type\" AS \"agent.office_agent.type\", \"agent->office_agent\".\"tagline\" AS \"agent.office_agent.tagline\", \"agent->office_agent\".\"name\" AS \"agent.office_agent.name\", \"agent->office_agent\".\"address\" AS \"agent.office_agent.address\", \"agent->office_agent\".\"pic\" AS \"agent.office_agent.pic\", \"agent->office_agent\".\"phone\" AS \"agent.office_agent.phone\", \"agent->office_agent\".\"npwp\" AS \"agent.office_agent.npwp\", \"agent->office_agent\".\"email\" AS \"agent.office_agent.email\", \"agent->office_agent\".\"image\" AS \"agent.office_agent.image\", \"agent->office_agent\".\"desc\" AS \"agent.office_agent.desc\", \"agent->office_agent\".\"is_official_developer\" AS \"agent.office_agent.is_official_developer\", \"agent->office_agent\".\"is_trusted_developer\" AS \"agent.office_agent.is_trusted_developer\", \"agent->office_agent\".\"is_trusted_prop_agency\" AS \"agent.office_agent.is_trusted_prop_agency\", \"agent->office_agent\".\"link\" AS \"agent.office_agent.link\", \"agent->office_agent\".\"twitter\" AS \"agent.office_agent.twitter\", \"agent->office_agent\".\"ig\" AS \"agent.office_agent.ig\", \"agent->office_agent\".\"yt\" AS \"agent.office_agent.yt\", \"agent->office_agent\".\"fb\" AS \"agent.office_agent.fb\", \"agent->office_agent\".\"createdAt\" AS \"agent.office_agent.createdAt\", \"agent->office_agent\".\"updatedAt\" AS \"agent.office_agent.updatedAt\" FROM (SELECT \"advertises\".\"id\", \"advertises\".\"office_id\", \"advertises\".\"ads_id\", \"advertises\".\"agent_id\", \"advertises\".\"project_id\", \"advertises\".\"rental_type\", \"advertises\".\"is_publish\", \"advertises\".\"is_highlights\", \"advertises\".\"province_id\", \"advertises\".\"city_id\", \"advertises\".\"district_id\", \"advertises\".\"nib\", \"advertises\".\"location\", \"advertises\".\"lat\", \"advertises\".\"long\", \"advertises\".\"zip\", \"advertises\".\"regency\", \"advertises\".\"subdistrict\", \"advertises\".\"province\", \"advertises\".\"property_type\", \"advertises\".\"ownership_certificate\", \"advertises\".\"listing_type\", \"advertises\".\"name\", \"advertises\".\"desc\", \"advertises\".\"price\", \"advertises\".\"building_type_id\", \"advertises\".\"size_land\", \"advertises\".\"size_building\", \"advertises\".\"rooms\", \"advertises\".\"bathroom\", \"advertises\".\"carport\", \"advertises\".\"garage\", \"advertises\".\"electricity\", \"advertises\".\"highlight_id\", \"advertises\".\"report_desc\", \"advertises\".\"user_report\", \"advertises\".\"unit\", \"advertises\".\"deletedAt\", \"advertises\".\"reason\", \"advertises\".\"exp_heighlight\", \"advertises\".\"created_by\", \"advertises\".\"updated_by\", \"advertises\".\"createdAt\", \"advertises\".\"updatedAt\", \"agent\".\"id\" AS \"agent.id\", \"agent\".\"office_id\" AS \"agent.office_id\", \"agent\".\"duration_qouta\" AS \"agent.duration_qouta\", \"agent\".\"office\" AS \"agent.office\", \"agent\".\"image\" AS \"agent.image\", \"agent\".\"pic_name\" AS \"agent.pic_name\", \"agent\".\"phone\" AS \"agent.phone\", \"agent\".\"province_id\" AS \"agent.province_id\", \"agent\".\"city_id\" AS \"agent.city_id\", \"agent\".\"district_id\" AS \"agent.district_id\", \"agent\".\"city\" AS \"agent.city\", \"agent\".\"province\" AS \"agent.province\", \"agent\".\"district\" AS \"agent.district\", \"agent\".\"is_priority\" AS \"agent.is_priority\", \"agent\".\"desc\" AS \"agent.desc\", \"agent\".\"email\" AS \"agent.email\", \"agent\".\"type_agent\" AS \"agent.type_agent\", \"agent\".\"user_id\" AS \"agent.user_id\", \"agent\".\"quota\" AS \"agent.quota\", \"agent\".\"is_active\" AS \"agent.is_active\", \"agent\".\"is_trusted\" AS \"agent.is_trusted\", \"agent\".\"is_spesialis\" AS \"agent.is_spesialis\", \"agent\".\"is_gold_seller\" AS \"agent.is_gold_seller\", \"agent\".\"reason\" AS \"agent.reason\", \"agent\".\"link\" AS \"agent.link\", \"agent\".\"twitter\" AS \"agent.twitter\", \"agent\".\"ig\" AS \"agent.ig\", \"agent\".\"yt\" AS \"agent.yt\", \"agent\".\"fb\" AS \"agent.fb\", \"agent\".\"tmp_pwd\" AS \"agent.tmp_pwd\", \"agent\".\"createdAt\" AS \"agent.createdAt\", \"agent\".\"updatedAt\" AS \"agent.updatedAt\" FROM \"advertises\" AS \"advertises\" INNER JOIN \"agents\" AS \"agent\" ON \"advertises\".\"agent_id\" = \"agent\".\"id\" AND \"agent\".\"type_agent\" IN (0, 3) WHERE \"advertises\".\"deletedAt\" IS NULL ORDER BY \"advertises\".\"createdAt\" DESC LIMIT 10 OFFSET 0) AS \"advertises\" LEFT OUTER JOIN \"advertises_media\" AS \"advertises_media\" ON \"advertises\".\"id\" = \"advertises_media\".\"advertises_id\" LEFT OUTER JOIN \"advertise_facilities\" AS \"advertise_facilities\" ON \"advertises\".\"id\" = \"advertise_facilities\".\"advertise_id\" LEFT OUTER JOIN \"office_agents\" AS \"agent->office_agent\" ON \"agent.office_id\" = \"agent->office_agent\".\"id\" ORDER BY \"advertises\".\"createdAt\" DESC;"},"parameters":{},"parent":{"code":"42703","file":"parse_relation.c","length":113,"line":"3638","name":"error","position":"4626","routine":"errorMissingColumn","severity":"ERROR","sql":"SELECT \"advertises\".*, \"advertises_media\".\"id\" AS \"advertises_media.id\", \"advertises_media\".\"agent_id\" AS \"advertises_media.agent_id\", \"advertises_media\".\"is_cover\" AS \"advertises_media.is_cover\", \"advertises_media\".\"advertises_id\" AS \"advertises_media.advertises_id\", \"advertises_media\".\"image\" AS \"advertises_media.image\", \"advertises_media\".\"project_id\" AS \"advertises_media.project_id\", \"advertises_media\".\"createdAt\" AS \"advertises_media.createdAt\", \"advertises_media\".\"updatedAt\" AS \"advertises_media.updatedAt\", \"advertise_facilities\".\"id\" AS \"advertise_facilities.id\", \"advertise_facilities\".\"agent_id\" AS \"advertise_facilities.agent_id\", \"advertise_facilities\".\"advertise_id\" AS \"advertise_facilities.advertise_id\", \"advertise_facilities\".\"facility_id\" AS \"advertise_facilities.facility_id\", \"advertise_facilities\".\"createdAt\" AS \"advertise_facilities.createdAt\", \"advertise_facilities\".\"updatedAt\" AS \"advertise_facilities.updatedAt\", \"agent->office_agent\".\"id\" AS \"agent.office_agent.id\", \"agent->office_agent\".\"nib\" AS \"agent.office_agent.nib\", \"agent->office_agent\".\"type\" AS \"agent.office_agent.type\", \"agent->office_agent\".\"tagline\" AS \"agent.office_agent.tagline\", \"agent->office_agent\".\"name\" AS \"agent.office_agent.name\", \"agent->office_agent\".\"address\" AS \"agent.office_agent.address\", \"agent->office_agent\".\"pic\" AS \"agent.office_agent.pic\", \"agent->office_agent\".\"phone\" AS \"agent.office_agent.phone\", \"agent->office_agent\".\"npwp\" AS \"agent.office_agent.npwp\", \"agent->office_agent\".\"email\" AS \"agent.office_agent.email\", \"agent->office_agent\".\"image\" AS \"agent.office_agent.image\", \"agent->office_agent\".\"desc\" AS \"agent.office_agent.desc\", \"agent->office_agent\".\"is_official_developer\" AS \"agent.office_agent.is_official_developer\", \"agent->office_agent\".\"is_trusted_developer\" AS \"agent.office_agent.is_trusted_developer\", \"agent->office_agent\".\"is_trusted_prop_agency\" AS \"agent.office_agent.is_trusted_prop_agency\", \"agent->office_agent\".\"link\" AS \"agent.office_agent.link\", \"agent->office_agent\".\"twitter\" AS \"agent.office_agent.twitter\", \"agent->office_agent\".\"ig\" AS \"agent.office_agent.ig\", \"agent->office_agent\".\"yt\" AS \"agent.office_agent.yt\", \"agent->office_agent\".\"fb\" AS \"agent.office_agent.fb\", \"agent->office_agent\".\"createdAt\" AS \"agent.office_agent.createdAt\", \"agent->office_agent\".\"updatedAt\" AS \"agent.office_agent.updatedAt\" FROM (SELECT \"advertises\".\"id\", \"advertises\".\"office_id\", \"advertises\".\"ads_id\", \"advertises\".\"agent_id\", \"advertises\".\"project_id\", \"advertises\".\"rental_type\", \"advertises\".\"is_publish\", \"advertises\".\"is_highlights\", \"advertises\".\"province_id\", \"advertises\".\"city_id\", \"advertises\".\"district_id\", \"advertises\".\"nib\", \"advertises\".\"location\", \"advertises\".\"lat\", \"advertises\".\"long\", \"advertises\".\"zip\", \"advertises\".\"regency\", \"advertises\".\"subdistrict\", \"advertises\".\"province\", \"advertises\".\"property_type\", \"advertises\".\"ownership_certificate\", \"advertises\".\"listing_type\", \"advertises\".\"name\", \"advertises\".\"desc\", \"advertises\".\"price\", \"advertises\".\"building_type_id\", \"advertises\".\"size_land\", \"advertises\".\"size_building\", \"advertises\".\"rooms\", \"advertises\".\"bathroom\", \"advertises\".\"carport\", \"advertises\".\"garage\", \"advertises\".\"electricity\", \"advertises\".\"highlight_id\", \"advertises\".\"report_desc\", \"advertises\".\"user_report\", \"advertises\".\"unit\", \"advertises\".\"deletedAt\", \"advertises\".\"reason\", \"advertises\".\"exp_heighlight\", \"advertises\".\"created_by\", \"advertises\".\"updated_by\", \"advertises\".\"createdAt\", \"advertises\".\"updatedAt\", \"agent\".\"id\" AS \"agent.id\", \"agent\".\"office_id\" AS \"agent.office_id\", \"agent\".\"duration_qouta\" AS \"agent.duration_qouta\", \"agent\".\"office\" AS \"agent.office\", \"agent\".\"image\" AS \"agent.image\", \"agent\".\"pic_name\" AS \"agent.pic_name\", \"agent\".\"phone\" AS \"agent.phone\", \"agent\".\"province_id\" AS \"agent.province_id\", \"agent\".\"city_id\" AS \"agent.city_id\", \"agent\".\"district_id\" AS \"agent.district_id\", \"agent\".\"city\" AS \"agent.city\", \"agent\".\"province\" AS \"agent.province\", \"agent\".\"district\" AS \"agent.district\", \"agent\".\"is_priority\" AS \"agent.is_priority\", \"agent\".\"desc\" AS \"agent.desc\", \"agent\".\"email\" AS \"agent.email\", \"agent\".\"type_agent\" AS \"agent.type_agent\", \"agent\".\"user_id\" AS \"agent.user_id\", \"agent\".\"quota\" AS \"agent.quota\", \"agent\".\"is_active\" AS \"agent.is_active\", \"agent\".\"is_trusted\" AS \"agent.is_trusted\", \"agent\".\"is_spesialis\" AS \"agent.is_spesialis\", \"agent\".\"is_gold_seller\" AS \"agent.is_gold_seller\", \"agent\".\"reason\" AS \"agent.reason\", \"agent\".\"link\" AS \"agent.link\", \"agent\".\"twitter\" AS \"agent.twitter\", \"agent\".\"ig\" AS \"agent.ig\", \"agent\".\"yt\" AS \"agent.yt\", \"agent\".\"fb\" AS \"agent.fb\", \"agent\".\"tmp_pwd\" AS \"agent.tmp_pwd\", \"agent\".\"createdAt\" AS \"agent.createdAt\", \"agent\".\"updatedAt\" AS \"agent.updatedAt\" FROM \"advertises\" AS \"advertises\" INNER JOIN \"agents\" AS \"agent\" ON \"advertises\".\"agent_id\" = \"agent\".\"id\" AND \"agent\".\"type_agent\" IN (0, 3) WHERE \"advertises\".\"deletedAt\" IS NULL ORDER BY \"advertises\".\"createdAt\" DESC LIMIT 10 OFFSET 0) AS \"advertises\" LEFT OUTER JOIN \"advertises_media\" AS \"advertises_media\" ON \"advertises\".\"id\" = \"advertises_media\".\"advertises_id\" LEFT OUTER JOIN \"advertise_facilities\" AS \"advertise_facilities\" ON \"advertises\".\"id\" = \"advertise_facilities\".\"advertise_id\" LEFT OUTER JOIN \"office_agents\" AS \"agent->office_agent\" ON \"agent.office_id\" = \"agent->office_agent\".\"id\" ORDER BY \"advertises\".\"createdAt\" DESC;"},"sql":"SELECT \"advertises\".*, \"advertises_media\".\"id\" AS \"advertises_media.id\", \"advertises_media\".\"agent_id\" AS \"advertises_media.agent_id\", \"advertises_media\".\"is_cover\" AS \"advertises_media.is_cover\", \"advertises_media\".\"advertises_id\" AS \"advertises_media.advertises_id\", \"advertises_media\".\"image\" AS \"advertises_media.image\", \"advertises_media\".\"project_id\" AS \"advertises_media.project_id\", \"advertises_media\".\"createdAt\" AS \"advertises_media.createdAt\", \"advertises_media\".\"updatedAt\" AS \"advertises_media.updatedAt\", \"advertise_facilities\".\"id\" AS \"advertise_facilities.id\", \"advertise_facilities\".\"agent_id\" AS \"advertise_facilities.agent_id\", \"advertise_facilities\".\"advertise_id\" AS \"advertise_facilities.advertise_id\", \"advertise_facilities\".\"facility_id\" AS \"advertise_facilities.facility_id\", \"advertise_facilities\".\"createdAt\" AS \"advertise_facilities.createdAt\", \"advertise_facilities\".\"updatedAt\" AS \"advertise_facilities.updatedAt\", \"agent->office_agent\".\"id\" AS \"agent.office_agent.id\", \"agent->office_agent\".\"nib\" AS \"agent.office_agent.nib\", \"agent->office_agent\".\"type\" AS \"agent.office_agent.type\", \"agent->office_agent\".\"tagline\" AS \"agent.office_agent.tagline\", \"agent->office_agent\".\"name\" AS \"agent.office_agent.name\", \"agent->office_agent\".\"address\" AS \"agent.office_agent.address\", \"agent->office_agent\".\"pic\" AS \"agent.office_agent.pic\", \"agent->office_agent\".\"phone\" AS \"agent.office_agent.phone\", \"agent->office_agent\".\"npwp\" AS \"agent.office_agent.npwp\", \"agent->office_agent\".\"email\" AS \"agent.office_agent.email\", \"agent->office_agent\".\"image\" AS \"agent.office_agent.image\", \"agent->office_agent\".\"desc\" AS \"agent.office_agent.desc\", \"agent->office_agent\".\"is_official_developer\" AS \"agent.office_agent.is_official_developer\", \"agent->office_agent\".\"is_trusted_developer\" AS \"agent.office_agent.is_trusted_developer\", \"agent->office_agent\".\"is_trusted_prop_agency\" AS \"agent.office_agent.is_trusted_prop_agency\", \"agent->office_agent\".\"link\" AS \"agent.office_agent.link\", \"agent->office_agent\".\"twitter\" AS \"agent.office_agent.twitter\", \"agent->office_agent\".\"ig\" AS \"agent.office_agent.ig\", \"agent->office_agent\".\"yt\" AS \"agent.office_agent.yt\", \"agent->office_agent\".\"fb\" AS \"agent.office_agent.fb\", \"agent->office_agent\".\"createdAt\" AS \"agent.office_agent.createdAt\", \"agent->office_agent\".\"updatedAt\" AS \"agent.office_agent.updatedAt\" FROM (SELECT \"advertises\".\"id\", \"advertises\".\"office_id\", \"advertises\".\"ads_id\", \"advertises\".\"agent_id\", \"advertises\".\"project_id\", \"advertises\".\"rental_type\", \"advertises\".\"is_publish\", \"advertises\".\"is_highlights\", \"advertises\".\"province_id\", \"advertises\".\"city_id\", \"advertises\".\"district_id\", \"advertises\".\"nib\", \"advertises\".\"location\", \"advertises\".\"lat\", \"advertises\".\"long\", \"advertises\".\"zip\", \"advertises\".\"regency\", \"advertises\".\"subdistrict\", \"advertises\".\"province\", \"advertises\".\"property_type\", \"advertises\".\"ownership_certificate\", \"advertises\".\"listing_type\", \"advertises\".\"name\", \"advertises\".\"desc\", \"advertises\".\"price\", \"advertises\".\"building_type_id\", \"advertises\".\"size_land\", \"advertises\".\"size_building\", \"advertises\".\"rooms\", \"advertises\".\"bathroom\", \"advertises\".\"carport\", \"advertises\".\"garage\", \"advertises\".\"electricity\", \"advertises\".\"highlight_id\", \"advertises\".\"report_desc\", \"advertises\".\"user_report\", \"advertises\".\"unit\", \"advertises\".\"deletedAt\", \"advertises\".\"reason\", \"advertises\".\"exp_heighlight\", \"advertises\".\"created_by\", \"advertises\".\"updated_by\", \"advertises\".\"createdAt\", \"advertises\".\"updatedAt\", \"agent\".\"id\" AS \"agent.id\", \"agent\".\"office_id\" AS \"agent.office_id\", \"agent\".\"duration_qouta\" AS \"agent.duration_qouta\", \"agent\".\"office\" AS \"agent.office\", \"agent\".\"image\" AS \"agent.image\", \"agent\".\"pic_name\" AS \"agent.pic_name\", \"agent\".\"phone\" AS \"agent.phone\", \"agent\".\"province_id\" AS \"agent.province_id\", \"agent\".\"city_id\" AS \"agent.city_id\", \"agent\".\"district_id\" AS \"agent.district_id\", \"agent\".\"city\" AS \"agent.city\", \"agent\".\"province\" AS \"agent.province\", \"agent\".\"district\" AS \"agent.district\", \"agent\".\"is_priority\" AS \"agent.is_priority\", \"agent\".\"desc\" AS \"agent.desc\", \"agent\".\"email\" AS \"agent.email\", \"agent\".\"type_agent\" AS \"agent.type_agent\", \"agent\".\"user_id\" AS \"agent.user_id\", \"agent\".\"quota\" AS \"agent.quota\", \"agent\".\"is_active\" AS \"agent.is_active\", \"agent\".\"is_trusted\" AS \"agent.is_trusted\", \"agent\".\"is_spesialis\" AS \"agent.is_spesialis\", \"agent\".\"is_gold_seller\" AS \"agent.is_gold_seller\", \"agent\".\"reason\" AS \"agent.reason\", \"agent\".\"link\" AS \"agent.link\", \"agent\".\"twitter\" AS \"agent.twitter\", \"agent\".\"ig\" AS \"agent.ig\", \"agent\".\"yt\" AS \"agent.yt\", \"agent\".\"fb\" AS \"agent.fb\", \"agent\".\"tmp_pwd\" AS \"agent.tmp_pwd\", \"agent\".\"createdAt\" AS \"agent.createdAt\", \"agent\".\"updatedAt\" AS \"agent.updatedAt\" FROM \"advertises\" AS \"advertises\" INNER JOIN \"agents\" AS \"agent\" ON \"advertises\".\"agent_id\" = \"agent\".\"id\" AND \"agent\".\"type_agent\" IN (0, 3) WHERE \"advertises\".\"deletedAt\" IS NULL ORDER BY \"advertises\".\"createdAt\" DESC LIMIT 10 OFFSET 0) AS \"advertises\" LEFT OUTER JOIN \"advertises_media\" AS \"advertises_media\" ON \"advertises\".\"id\" = \"advertises_media\".\"advertises_id\" LEFT OUTER JOIN \"advertise_facilities\" AS \"advertise_facilities\" ON \"advertises\".\"id\" = \"advertise_facilities\".\"advertise_id\" LEFT OUTER JOIN \"office_agents\" AS \"agent->office_agent\" ON \"agent.office_id\" = \"agent->office_agent\".\"id\" ORDER BY \"advertises\".\"createdAt\" DESC;","stack":"Error\n at Query.run (/home/ubuntu/be-cms/node_modules/sequelize/lib/dialects/postgres/query.js:50:25)\n at /home/ubuntu/be-cms/node_modules/sequelize/lib/sequelize.js:315:28\n at runMicrotasks (<anonymous>)\n at processTicksAndRejections (node:internal/process/task_queues:96:5)\n at async PostgresQueryInterface.select (/home/ubuntu/be-cms/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)\n at async Function.findAll (/home/ubuntu/be-cms/node_modules/sequelize/lib/model.js:1140:21)","time":"2024-02-05T06:27:21.837Z"}
2|CMS | GET /api/advertises?page=1&size=10&agentType=3 500 1343.039 ms - 93
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
2|CMS | Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" ORDER BY "master_kabko"."sort" ASC LIMIT 1000 OFFSET 0;
2|CMS | GET /api/getCityAll?page=1&size=1000 200 20.855 ms - -
Editor is loading...
Leave a Comment