2026-07-28T11:09:07: [createMember] Error: Bind parameters must not contain undefined. To pass SQL NULL specify JS null 2026-07-28T11:09:43: [createMember] Error: Unknown column 'vehicles' in 'INSERT INTO' 2026-07-28T12:18:14: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-28T12:18:27: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-28T12:23:14: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-28T12:28:30: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-28T12:28:46: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-28T13:16:14: SyntaxError: Expected double-quoted property name in JSON at position 23 (line 4 column 1) 2026-07-28T13:16:14: at JSON.parse () 2026-07-28T13:16:14: at parse (/home/b2/public_html/society.1b2.in/node_modules/body-parser/lib/types/json.js:96:19) 2026-07-28T13:16:14: at /home/b2/public_html/society.1b2.in/node_modules/body-parser/lib/read.js:128:18 2026-07-28T13:16:14: at AsyncResource.runInAsyncScope (node:async_hooks:211:14) 2026-07-28T13:16:14: at invokeCallback (/home/b2/public_html/society.1b2.in/node_modules/raw-body/index.js:238:16) 2026-07-28T13:16:14: at done (/home/b2/public_html/society.1b2.in/node_modules/raw-body/index.js:227:7) 2026-07-28T13:16:14: at IncomingMessage.onEnd (/home/b2/public_html/society.1b2.in/node_modules/raw-body/index.js:287:7) 2026-07-28T13:16:14: at IncomingMessage.emit (node:events:524:28) 2026-07-28T13:16:14: at endReadableNT (node:internal/streams/readable:1698:12) 2026-07-28T13:16:14: at process.processTicksAndRejections (node:internal/process/task_queues:90:21) { 2026-07-28T13:16:14: expose: true, 2026-07-28T13:16:14: statusCode: 400, 2026-07-28T13:16:14: status: 400, 2026-07-28T13:16:14: body: '{\n "society_id": 1,\n \n}', 2026-07-28T13:16:14: type: 'entity.parse.failed' 2026-07-28T13:16:14: } 2026-07-28T15:19:08: [createExpense] Error: Data truncated for column 'payment_mode' at row 1 2026-07-28T15:21:36: [createExpense] Error: Data truncated for column 'payment_mode' at row 1 2026-07-28T15:24:39: [createExpense] Error: Data truncated for column 'payment_mode' at row 1 2026-07-29T10:22:30: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-29T10:34:15: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-29T10:36:53: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-30T10:03:42: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-30T10:05:36: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-07-30T10:33:44: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T14:24:51: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:52: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:53: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:54: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:54: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:55: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:56: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:57: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:57: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:58: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:24:59: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:00: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:01: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:02: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:02: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:03: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:04: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:43: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:44: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:45: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:45: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:46: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:47: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:48: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:49: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:49: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:50: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:51: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:52: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:53: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:53: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:54: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T14:25:55: Port 1701 already in use. Exiting so PM2 can manage restarts. 2026-08-01T17:21:39: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:21:39: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:28:13: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:28:13: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:30:46: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:30:46: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:30:53: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:30:53: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:31:00: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:31:00: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:31:40: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:31:40: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:31:49: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:31:49: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:33:29: [getSocietyById] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:33:40: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:33:40: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:33:59: [getPaymentById] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:34:00: [getPaymentById] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:34:11: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:34:11: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:34:41: [createAnnouncement] Error: Data truncated for column 'category' at row 1 2026-08-01T17:35:01: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:35:01: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:35:26: [getRegistrationList] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:35:26: [getRegistrationDashboardSummary] Error: Unknown column 'approval_status' in 'SELECT' 2026-08-01T17:35:29: [getRegistrationList] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:35:30: [getRegistrationList] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:35:31: [getRegistrationList] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:35:32: [getRegistrationList] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:35:32: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:35:32: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:35:35: [getRegistrationList] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:35:35: [getRegistrationDashboardSummary] Error: Unknown column 'approval_status' in 'SELECT' 2026-08-01T17:35:36: [getRegistrationList] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:35:36: [getRegistrationDashboardSummary] Error: Unknown column 'approval_status' in 'SELECT' 2026-08-01T17:35:37: [getRegistrationList] Error: Unknown column 'r.approval_status' in 'SELECT' 2026-08-01T17:35:37: [getRegistrationDashboardSummary] Error: Unknown column 'approval_status' in 'SELECT' 2026-08-01T17:47:35: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:47:35: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:50:43: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:50:43: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:51:41: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:51:41: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:51:59: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:51:59: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:52:12: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:40: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:43: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:44: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:46: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:49: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:50: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:55: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:57: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:52:59: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T17:53:40: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:53:40: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:55:05: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T17:55:05: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T18:00:45: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T18:00:45: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T18:02:56: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T18:02:56: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T18:03:24: [getPaymentById] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-01T18:03:40: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-01T18:03:40: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:14:58: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:14:58: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:18:24: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:18:24: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:40:14: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:40:14: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:40:39: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:40:39: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:42:12: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:42:12: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:47:58: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:47:58: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:51:40: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T09:51:40: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T10:02:07: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T10:02:07: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:15:06: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:15:06: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:41:34: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:41:34: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:41:41: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:41:41: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:41:44: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:41:44: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:43:16: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:43:16: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:44:47: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T11:44:47: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T12:04:54: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T12:04:54: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T12:12:23: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T12:12:23: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:37:47: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:37:47: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:45:05: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:45:05: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:48:03: [getMemberProfile] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-03T14:50:37: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:50:37: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:55:34: [getDashboardData] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:55:34: [getDashboard] Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:26: ========== Dashboard Model Error ========== 2026-08-03T14:58:26: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:26: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T14:58:26: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T14:58:26: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T14:58:26: errno: 1054, 2026-08-03T14:58:26: sqlState: '42S22', 2026-08-03T14:58:26: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T14:58:26: sql: 'SELECT \n' + 2026-08-03T14:58:26: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T14:58:26: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T14:58:26: ' FROM maintenance_payments \n' + 2026-08-03T14:58:26: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T14:58:26: } 2026-08-03T14:58:26: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:26: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:26: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T14:58:26: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: ========== Dashboard Controller Error ========== 2026-08-03T14:58:26: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:26: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T14:58:26: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T14:58:26: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T14:58:26: errno: 1054, 2026-08-03T14:58:26: sqlState: '42S22', 2026-08-03T14:58:26: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T14:58:26: sql: 'SELECT \n' + 2026-08-03T14:58:26: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T14:58:26: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T14:58:26: ' FROM maintenance_payments \n' + 2026-08-03T14:58:26: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T14:58:26: } 2026-08-03T14:58:26: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:26: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:26: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T14:58:26: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:26: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T14:58:26: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:26: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: ========== Dashboard Model Error ========== 2026-08-03T14:58:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T14:58:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T14:58:39: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T14:58:39: errno: 1054, 2026-08-03T14:58:39: sqlState: '42S22', 2026-08-03T14:58:39: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T14:58:39: sql: 'SELECT \n' + 2026-08-03T14:58:39: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T14:58:39: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T14:58:39: ' FROM maintenance_payments \n' + 2026-08-03T14:58:39: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T14:58:39: } 2026-08-03T14:58:39: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T14:58:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: ========== Dashboard Controller Error ========== 2026-08-03T14:58:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T14:58:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T14:58:39: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T14:58:39: errno: 1054, 2026-08-03T14:58:39: sqlState: '42S22', 2026-08-03T14:58:39: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T14:58:39: sql: 'SELECT \n' + 2026-08-03T14:58:39: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T14:58:39: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T14:58:39: ' FROM maintenance_payments \n' + 2026-08-03T14:58:39: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T14:58:39: } 2026-08-03T14:58:39: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T14:58:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T14:58:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T14:58:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T14:58:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T14:58:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: ========== Dashboard Model Error ========== 2026-08-03T15:01:57: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:01:57: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:01:57: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:01:57: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:01:57: errno: 1054, 2026-08-03T15:01:57: sqlState: '42S22', 2026-08-03T15:01:57: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:01:57: sql: 'SELECT \n' + 2026-08-03T15:01:57: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:01:57: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:01:57: ' FROM maintenance_payments \n' + 2026-08-03T15:01:57: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:01:57: } 2026-08-03T15:01:57: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:01:57: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:01:57: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:01:57: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: ========== Dashboard Controller Error ========== 2026-08-03T15:01:57: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:01:57: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:01:57: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:01:57: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:01:57: errno: 1054, 2026-08-03T15:01:57: sqlState: '42S22', 2026-08-03T15:01:57: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:01:57: sql: 'SELECT \n' + 2026-08-03T15:01:57: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:01:57: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:01:57: ' FROM maintenance_payments \n' + 2026-08-03T15:01:57: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:01:57: } 2026-08-03T15:01:57: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:01:57: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:01:57: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:01:57: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:01:57: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:01:57: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:01:57: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: ========== Dashboard Model Error ========== 2026-08-03T15:03:55: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:03:55: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:03:55: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:03:55: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:03:55: errno: 1054, 2026-08-03T15:03:55: sqlState: '42S22', 2026-08-03T15:03:55: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:03:55: sql: 'SELECT \n' + 2026-08-03T15:03:55: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:03:55: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:03:55: ' FROM maintenance_payments \n' + 2026-08-03T15:03:55: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:03:55: } 2026-08-03T15:03:55: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:03:55: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:03:55: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:03:55: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: ========== Dashboard Controller Error ========== 2026-08-03T15:03:55: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:03:55: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:03:55: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:03:55: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:03:55: errno: 1054, 2026-08-03T15:03:55: sqlState: '42S22', 2026-08-03T15:03:55: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:03:55: sql: 'SELECT \n' + 2026-08-03T15:03:55: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:03:55: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:03:55: ' FROM maintenance_payments \n' + 2026-08-03T15:03:55: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:03:55: } 2026-08-03T15:03:55: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:03:55: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:03:55: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:03:55: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:03:55: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:03:55: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:03:55: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: ========== Dashboard Model Error ========== 2026-08-03T15:04:05: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:05: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:05: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:04:05: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:04:05: errno: 1054, 2026-08-03T15:04:05: sqlState: '42S22', 2026-08-03T15:04:05: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:04:05: sql: 'SELECT \n' + 2026-08-03T15:04:05: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:04:05: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:04:05: ' FROM maintenance_payments \n' + 2026-08-03T15:04:05: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:04:05: } 2026-08-03T15:04:05: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:05: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:05: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:05: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: ========== Dashboard Controller Error ========== 2026-08-03T15:04:05: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:05: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:05: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:04:05: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:04:05: errno: 1054, 2026-08-03T15:04:05: sqlState: '42S22', 2026-08-03T15:04:05: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:04:05: sql: 'SELECT \n' + 2026-08-03T15:04:05: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:04:05: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:04:05: ' FROM maintenance_payments \n' + 2026-08-03T15:04:05: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:04:05: } 2026-08-03T15:04:05: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:05: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:05: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:05: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:05: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: ========== Dashboard Model Error ========== 2026-08-03T15:04:20: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:20: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:20: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:04:20: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:04:20: errno: 1054, 2026-08-03T15:04:20: sqlState: '42S22', 2026-08-03T15:04:20: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:04:20: sql: 'SELECT \n' + 2026-08-03T15:04:20: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:04:20: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:04:20: ' FROM maintenance_payments \n' + 2026-08-03T15:04:20: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:04:20: } 2026-08-03T15:04:20: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:20: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:20: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:20: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: ========== Dashboard Controller Error ========== 2026-08-03T15:04:20: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:20: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:20: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:04:20: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:04:20: errno: 1054, 2026-08-03T15:04:20: sqlState: '42S22', 2026-08-03T15:04:20: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:04:20: sql: 'SELECT \n' + 2026-08-03T15:04:20: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:04:20: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:04:20: ' FROM maintenance_payments \n' + 2026-08-03T15:04:20: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:04:20: } 2026-08-03T15:04:20: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:20: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:20: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:20: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:20: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:20: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:20: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: ========== Dashboard Model Error ========== 2026-08-03T15:04:34: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:34: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:34: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:04:34: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:04:34: errno: 1054, 2026-08-03T15:04:34: sqlState: '42S22', 2026-08-03T15:04:34: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:04:34: sql: 'SELECT \n' + 2026-08-03T15:04:34: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:04:34: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:04:34: ' FROM maintenance_payments \n' + 2026-08-03T15:04:34: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:04:34: } 2026-08-03T15:04:34: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:34: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:34: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:34: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: ========== Dashboard Controller Error ========== 2026-08-03T15:04:34: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:34: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:34: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:04:34: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:04:34: errno: 1054, 2026-08-03T15:04:34: sqlState: '42S22', 2026-08-03T15:04:34: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:04:34: sql: 'SELECT \n' + 2026-08-03T15:04:34: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:04:34: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:04:34: ' FROM maintenance_payments \n' + 2026-08-03T15:04:34: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:04:34: } 2026-08-03T15:04:34: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:34: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:04:34: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:04:34: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:04:34: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:04:34: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:04:34: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: ========== Dashboard Model Error ========== 2026-08-03T15:11:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:11:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:11:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:11:39: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:11:39: errno: 1054, 2026-08-03T15:11:39: sqlState: '42S22', 2026-08-03T15:11:39: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:11:39: sql: 'SELECT \n' + 2026-08-03T15:11:39: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:11:39: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:11:39: ' FROM maintenance_payments \n' + 2026-08-03T15:11:39: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:11:39: } 2026-08-03T15:11:39: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:11:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:11:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:11:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: ========== Dashboard Controller Error ========== 2026-08-03T15:11:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:11:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:11:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:11:39: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:11:39: errno: 1054, 2026-08-03T15:11:39: sqlState: '42S22', 2026-08-03T15:11:39: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:11:39: sql: 'SELECT \n' + 2026-08-03T15:11:39: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:11:39: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:11:39: ' FROM maintenance_payments \n' + 2026-08-03T15:11:39: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:11:39: } 2026-08-03T15:11:39: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:11:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:11:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:11:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:11:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:11:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:11:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: ========== Dashboard Model Error ========== 2026-08-03T15:12:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:12:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:12:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:12:39: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:12:39: errno: 1054, 2026-08-03T15:12:39: sqlState: '42S22', 2026-08-03T15:12:39: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:12:39: sql: 'SELECT \n' + 2026-08-03T15:12:39: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:12:39: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:12:39: ' FROM maintenance_payments \n' + 2026-08-03T15:12:39: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:12:39: } 2026-08-03T15:12:39: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:12:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:12:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:12:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: ========== Dashboard Controller Error ========== 2026-08-03T15:12:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:12:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:12:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:12:39: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:12:39: errno: 1054, 2026-08-03T15:12:39: sqlState: '42S22', 2026-08-03T15:12:39: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:12:39: sql: 'SELECT \n' + 2026-08-03T15:12:39: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:12:39: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:12:39: ' FROM maintenance_payments \n' + 2026-08-03T15:12:39: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:12:39: } 2026-08-03T15:12:39: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:12:39: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:12:39: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:12:39: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:12:39: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:12:39: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:12:39: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:13:00: [getPaymentById] Error: Unknown column 'mp.due_amount' in 'SELECT' 2026-08-03T15:25:05: ========== Dashboard Model Error ========== 2026-08-03T15:25:05: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:25:05: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:25:05: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:25:05: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:25:05: errno: 1054, 2026-08-03T15:25:05: sqlState: '42S22', 2026-08-03T15:25:05: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:25:05: sql: 'SELECT \n' + 2026-08-03T15:25:05: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:25:05: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:25:05: ' FROM maintenance_payments \n' + 2026-08-03T15:25:05: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:25:05: } 2026-08-03T15:25:05: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:25:05: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:25:05: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:25:05: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: ========== Dashboard Controller Error ========== 2026-08-03T15:25:05: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:25:05: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:25:05: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:25:05: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:25:05: errno: 1054, 2026-08-03T15:25:05: sqlState: '42S22', 2026-08-03T15:25:05: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:25:05: sql: 'SELECT \n' + 2026-08-03T15:25:05: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:25:05: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:25:05: ' FROM maintenance_payments \n' + 2026-08-03T15:25:05: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:25:05: } 2026-08-03T15:25:05: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:25:05: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:25:05: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:25:05: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:25:05: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:25:05: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:25:05: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: ========== Dashboard Model Error ========== 2026-08-03T15:31:04: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:31:04: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:31:04: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:31:04: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:31:04: errno: 1054, 2026-08-03T15:31:04: sqlState: '42S22', 2026-08-03T15:31:04: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:31:04: sql: 'SELECT \n' + 2026-08-03T15:31:04: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:31:04: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:31:04: ' FROM maintenance_payments \n' + 2026-08-03T15:31:04: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:31:04: } 2026-08-03T15:31:04: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:31:04: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:31:04: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:31:04: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: ========== Dashboard Controller Error ========== 2026-08-03T15:31:04: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:31:04: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:31:04: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) { 2026-08-03T15:31:04: code: 'ER_BAD_FIELD_ERROR', 2026-08-03T15:31:04: errno: 1054, 2026-08-03T15:31:04: sqlState: '42S22', 2026-08-03T15:31:04: sqlMessage: "Unknown column 'paid_date' in 'SELECT'", 2026-08-03T15:31:04: sql: 'SELECT \n' + 2026-08-03T15:31:04: ' COALESCE(SUM(CASE WHEN MONTH(paid_date) = MONTH(CURRENT_DATE()) AND YEAR(paid_date) = YEAR(CURRENT_DATE()) THEN amount ELSE 0 END), 0) AS thisMonth,\n' + 2026-08-03T15:31:04: ' COALESCE(SUM(amount), 0) AS lifetime\n' + 2026-08-03T15:31:04: ' FROM maintenance_payments \n' + 2026-08-03T15:31:04: " WHERE society_id = ? AND approval_status = 'approved'" 2026-08-03T15:31:04: } 2026-08-03T15:31:04: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:31:04: Error: Unknown column 'paid_date' in 'SELECT' 2026-08-03T15:31:04: at Object.getDashboardData (/home/b2/public_html/society.1b2.in/src/v1/models/dashboard.model.js:36:22) 2026-08-03T15:31:04: at getDashboard (/home/b2/public_html/society.1b2.in/src/v1/controllers/dashboard.controller.js:26:47) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: at any (/home/b2/public_html/society.1b2.in/src/v1/middlewares/rbac.middleware.js:111:16) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T15:31:04: at verifyJwt (/home/b2/public_html/society.1b2.in/src/v1/middlewares/auth.middleware.js:306:12) 2026-08-03T15:31:04: at Layer.handle [as handle_request] (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/layer.js:95:5) 2026-08-03T15:31:04: at next (/home/b2/public_html/society.1b2.in/node_modules/express/lib/router/route.js:149:13) 2026-08-03T17:39:48: [createAnnouncement] Error: Cannot add or update a child row: a foreign key constraint fails (`b2_society_db`.`announcements`, CONSTRAINT `announcements_posted_by_fkey` FOREIGN KEY (`posted_by`) REFERENCES `users` (`id`) ON UPDATE CASCADE) 2026-08-03T17:52:19: [createAnnouncement] Error: Data truncated for column 'category' at row 1 2026-08-04T09:42:46: [createExpense] Error: Data truncated for column 'payment_mode' at row 1 2026-08-04T13:27:54: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T13:27:59: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T13:28:00: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T13:28:00: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T13:28:13: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T13:28:18: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T14:28:03: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T14:28:21: [createMember] Error: Duplicate entry '1-rahul@test.com' for key 'uq_society_email' 2026-08-04T14:36:44: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T14:43:41: [createMember] Error: Data truncated for column 'role' at row 1 2026-08-04T17:57:12: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-04T18:03:01: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-05T09:08:57: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-05T09:23:52: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-05T09:25:01: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-05T10:31:23: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-05T10:54:50: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-05T11:11:34: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-05T13:14:39: [approveRegistrationRequest] Error: Field 'flat_number' doesn't have a default value 2026-08-15T15:40:34: Login Error: TypeError: memberModel.findAllSocietiesByMobile is not a function 2026-08-15T15:40:34: at loginWithPassword (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:190:52) 2026-08-15T15:40:34: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-08-15T15:42:50: Login Error: TypeError: memberModel.findAllSocietiesByMobile is not a function 2026-08-15T15:42:50: at loginWithPassword (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:190:52) 2026-08-15T15:42:50: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-08-15T15:42:53: Login Error: TypeError: memberModel.findAllSocietiesByMobile is not a function 2026-08-15T15:42:53: at loginWithPassword (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:190:52) 2026-08-15T15:42:53: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-08-15T15:54:55: Login Error: TypeError: memberModel.findAllSocietiesByMobile is not a function 2026-08-15T15:54:55: at loginWithPassword (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:190:52) 2026-08-15T15:54:55: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-08-17T16:50:55: [createDirectSociety] Error: Column 'city' cannot be null 2026-09-02T15:48:37: [approveRegistrationRequest] Admin approval email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-02T15:55:47: ❌ APPROVE REGISTRATION ERROR 2026-09-02T15:55:47: Code: ER_DUP_ENTRY 2026-09-02T15:55:47: Message: Duplicate entry 'MUM/CHS/2019/1024' for key 'uq_registration_no' 2026-09-02T15:55:47: SQL: INSERT INTO society 2026-09-02T15:55:47: ( 2026-09-02T15:55:47: name, 2026-09-02T15:55:47: registration_no, 2026-09-02T15:55:47: type, 2026-09-02T15:55:47: address, 2026-09-02T15:55:47: city, 2026-09-02T15:55:47: state, 2026-09-02T15:55:47: country, 2026-09-02T15:55:47: website, 2026-09-02T15:55:47: total_units, 2026-09-02T15:55:47: monthly_maintenance, 2026-09-02T15:55:47: maintenance_frequency, 2026-09-02T15:55:47: plan, 2026-09-02T15:55:47: plan_expires_at, 2026-09-02T15:55:47: registration_request_id, 2026-09-02T15:55:47: status 2026-09-02T15:55:47: ) 2026-09-02T15:55:47: VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'active') 2026-09-02T15:55:47: Stack: Error: Duplicate entry 'MUM/CHS/2019/1024' for key 'uq_registration_no' 2026-09-02T15:55:47: at Object.approveRegistrationRequest (/home/b2/public_html/society.1b2.in/src/v1/models/society.model.js:737:48) 2026-09-02T15:55:47: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-02T15:55:47: at async approveRegistrationRequest (/home/b2/public_html/society.1b2.in/src/v1/controllers/society.controller.js:605:17) 2026-09-02T15:56:00: ❌ APPROVE REGISTRATION ERROR 2026-09-02T15:56:00: Code: ER_DUP_ENTRY 2026-09-02T15:56:00: Message: Duplicate entry 'MUM/CHS/2019/1024' for key 'uq_registration_no' 2026-09-02T15:56:00: SQL: INSERT INTO society 2026-09-02T15:56:00: ( 2026-09-02T15:56:00: name, 2026-09-02T15:56:00: registration_no, 2026-09-02T15:56:00: type, 2026-09-02T15:56:00: address, 2026-09-02T15:56:00: city, 2026-09-02T15:56:00: state, 2026-09-02T15:56:00: country, 2026-09-02T15:56:00: website, 2026-09-02T15:56:00: total_units, 2026-09-02T15:56:00: monthly_maintenance, 2026-09-02T15:56:00: maintenance_frequency, 2026-09-02T15:56:00: plan, 2026-09-02T15:56:00: plan_expires_at, 2026-09-02T15:56:00: registration_request_id, 2026-09-02T15:56:00: status 2026-09-02T15:56:00: ) 2026-09-02T15:56:00: VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'active') 2026-09-02T15:56:00: Stack: Error: Duplicate entry 'MUM/CHS/2019/1024' for key 'uq_registration_no' 2026-09-02T15:56:00: at Object.approveRegistrationRequest (/home/b2/public_html/society.1b2.in/src/v1/models/society.model.js:737:48) 2026-09-02T15:56:00: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-02T15:56:00: at async approveRegistrationRequest (/home/b2/public_html/society.1b2.in/src/v1/controllers/society.controller.js:605:17) 2026-09-02T15:56:31: [rejectRegistrationRequest] Rejection email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-02T15:56:53: [rejectRegistrationRequest] Rejection email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-02T15:57:17: [rejectRegistrationRequest] Rejection email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-02T17:49:06: [registerSociety] Superadmin notification email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-02T17:49:27: [approveRegistrationRequest] Admin approval email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T10:41:20: [registerSociety] Superadmin notification email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T10:49:33: ❌ APPROVE REGISTRATION ERROR 2026-09-03T10:49:33: Code: ER_DUP_ENTRY 2026-09-03T10:49:33: Message: Duplicate entry 'MUM/CHS/2019/1024' for key 'uq_registration_no' 2026-09-03T10:49:33: SQL: INSERT INTO society 2026-09-03T10:49:33: ( 2026-09-03T10:49:33: name, 2026-09-03T10:49:33: registration_no, 2026-09-03T10:49:33: type, 2026-09-03T10:49:33: address, 2026-09-03T10:49:33: city, 2026-09-03T10:49:33: state, 2026-09-03T10:49:33: country, 2026-09-03T10:49:33: website, 2026-09-03T10:49:33: total_units, 2026-09-03T10:49:33: monthly_maintenance, 2026-09-03T10:49:33: maintenance_frequency, 2026-09-03T10:49:33: plan, 2026-09-03T10:49:33: plan_expires_at, 2026-09-03T10:49:33: registration_request_id, 2026-09-03T10:49:33: status 2026-09-03T10:49:33: ) 2026-09-03T10:49:33: VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'active') 2026-09-03T10:49:33: Stack: Error: Duplicate entry 'MUM/CHS/2019/1024' for key 'uq_registration_no' 2026-09-03T10:49:33: at Object.approveRegistrationRequest (/home/b2/public_html/society.1b2.in/src/v1/models/society.model.js:737:48) 2026-09-03T10:49:33: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T10:49:33: at async approveRegistrationRequest (/home/b2/public_html/society.1b2.in/src/v1/controllers/society.controller.js:605:17) 2026-09-03T10:49:59: ❌ APPROVE REGISTRATION ERROR 2026-09-03T10:49:59: Code: ER_DUP_ENTRY 2026-09-03T10:49:59: Message: Duplicate entry 'MUM/CHS/2019/1024' for key 'uq_registration_no' 2026-09-03T10:49:59: SQL: INSERT INTO society 2026-09-03T10:49:59: ( 2026-09-03T10:49:59: name, 2026-09-03T10:49:59: registration_no, 2026-09-03T10:49:59: type, 2026-09-03T10:49:59: address, 2026-09-03T10:49:59: city, 2026-09-03T10:49:59: state, 2026-09-03T10:49:59: country, 2026-09-03T10:49:59: website, 2026-09-03T10:49:59: total_units, 2026-09-03T10:49:59: monthly_maintenance, 2026-09-03T10:49:59: maintenance_frequency, 2026-09-03T10:49:59: plan, 2026-09-03T10:49:59: plan_expires_at, 2026-09-03T10:49:59: registration_request_id, 2026-09-03T10:49:59: status 2026-09-03T10:49:59: ) 2026-09-03T10:49:59: VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'active') 2026-09-03T10:49:59: Stack: Error: Duplicate entry 'MUM/CHS/2019/1024' for key 'uq_registration_no' 2026-09-03T10:49:59: at Object.approveRegistrationRequest (/home/b2/public_html/society.1b2.in/src/v1/models/society.model.js:737:48) 2026-09-03T10:49:59: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T10:49:59: at async approveRegistrationRequest (/home/b2/public_html/society.1b2.in/src/v1/controllers/society.controller.js:605:17) 2026-09-03T10:50:30: [rejectRegistrationRequest] Rejection email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T10:53:53: [registerSociety] Superadmin notification email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T10:54:27: [approveRegistrationRequest] Admin approval email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T11:41:16: [addActivityLog] Error: Data truncated for column 'activity_type' at row 1 2026-09-03T11:41:16: APPROVE PAYMENT ERROR: Error: Data truncated for column 'activity_type' at row 1 2026-09-03T11:41:16: at Object.addActivityLog (/home/b2/public_html/society.1b2.in/src/v1/models/activity.model.js:121:41) 2026-09-03T11:41:16: at approvePayment (/home/b2/public_html/society.1b2.in/src/v1/controllers/payment.controller.js:726:37) 2026-09-03T11:41:16: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) { 2026-09-03T11:41:16: code: 'WARN_DATA_TRUNCATED', 2026-09-03T11:41:16: errno: 1265, 2026-09-03T11:41:16: sqlState: '01000', 2026-09-03T11:41:16: sqlMessage: "Data truncated for column 'activity_type' at row 1", 2026-09-03T11:41:16: sql: '\n' + 2026-09-03T11:41:16: ' INSERT INTO activity_log\n' + 2026-09-03T11:41:16: ' (society_id, activity_type, reference_id, title, subtitle, amount, done_by)\n' + 2026-09-03T11:41:16: ' VALUES (?, ?, ?, ?, ?, ?, ?)' 2026-09-03T11:41:16: } 2026-09-03T11:43:18: [addActivityLog] Error: Data truncated for column 'activity_type' at row 1 2026-09-03T11:43:18: APPROVE PAYMENT ERROR: Error: Data truncated for column 'activity_type' at row 1 2026-09-03T11:43:18: at Object.addActivityLog (/home/b2/public_html/society.1b2.in/src/v1/models/activity.model.js:121:41) 2026-09-03T11:43:18: at approvePayment (/home/b2/public_html/society.1b2.in/src/v1/controllers/payment.controller.js:726:37) 2026-09-03T11:43:18: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) { 2026-09-03T11:43:18: code: 'WARN_DATA_TRUNCATED', 2026-09-03T11:43:18: errno: 1265, 2026-09-03T11:43:18: sqlState: '01000', 2026-09-03T11:43:18: sqlMessage: "Data truncated for column 'activity_type' at row 1", 2026-09-03T11:43:18: sql: '\n' + 2026-09-03T11:43:18: ' INSERT INTO activity_log\n' + 2026-09-03T11:43:18: ' (society_id, activity_type, reference_id, title, subtitle, amount, done_by)\n' + 2026-09-03T11:43:18: ' VALUES (?, ?, ?, ?, ?, ?, ?)' 2026-09-03T11:43:18: } 2026-09-03T12:55:26: [addActivityLog] Error: Data truncated for column 'activity_type' at row 1 2026-09-03T12:55:26: APPROVE PAYMENT ERROR: Error: Data truncated for column 'activity_type' at row 1 2026-09-03T12:55:26: at Object.addActivityLog (/home/b2/public_html/society.1b2.in/src/v1/models/activity.model.js:121:41) 2026-09-03T12:55:26: at approvePayment (/home/b2/public_html/society.1b2.in/src/v1/controllers/payment.controller.js:726:37) 2026-09-03T12:55:26: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) { 2026-09-03T12:55:26: code: 'WARN_DATA_TRUNCATED', 2026-09-03T12:55:26: errno: 1265, 2026-09-03T12:55:26: sqlState: '01000', 2026-09-03T12:55:26: sqlMessage: "Data truncated for column 'activity_type' at row 1", 2026-09-03T12:55:26: sql: '\n' + 2026-09-03T12:55:26: ' INSERT INTO activity_log\n' + 2026-09-03T12:55:26: ' (society_id, activity_type, reference_id, title, subtitle, amount, done_by)\n' + 2026-09-03T12:55:26: ' VALUES (?, ?, ?, ?, ?, ?, ?)' 2026-09-03T12:55:26: } 2026-09-03T12:55:36: [addActivityLog] Error: Data truncated for column 'activity_type' at row 1 2026-09-03T12:55:36: APPROVE PAYMENT ERROR: Error: Data truncated for column 'activity_type' at row 1 2026-09-03T12:55:36: at Object.addActivityLog (/home/b2/public_html/society.1b2.in/src/v1/models/activity.model.js:121:41) 2026-09-03T12:55:36: at approvePayment (/home/b2/public_html/society.1b2.in/src/v1/controllers/payment.controller.js:726:37) 2026-09-03T12:55:36: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) { 2026-09-03T12:55:36: code: 'WARN_DATA_TRUNCATED', 2026-09-03T12:55:36: errno: 1265, 2026-09-03T12:55:36: sqlState: '01000', 2026-09-03T12:55:36: sqlMessage: "Data truncated for column 'activity_type' at row 1", 2026-09-03T12:55:36: sql: '\n' + 2026-09-03T12:55:36: ' INSERT INTO activity_log\n' + 2026-09-03T12:55:36: ' (society_id, activity_type, reference_id, title, subtitle, amount, done_by)\n' + 2026-09-03T12:55:36: ' VALUES (?, ?, ?, ?, ?, ?, ?)' 2026-09-03T12:55:36: } 2026-09-03T13:01:05: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T13:01:05: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T13:01:05: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T13:01:05: at TLSSocket.emit (node:events:524:28) 2026-09-03T13:01:05: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T13:01:05: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T13:01:05: code: 'ESOCKET', 2026-09-03T13:01:05: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T13:01:05: host: 'localhost', 2026-09-03T13:01:05: cert: { 2026-09-03T13:01:05: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T13:01:05: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T13:01:05: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T13:01:05: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T13:01:05: ca: false, 2026-09-03T13:01:05: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T13:01:05: bits: 2048, 2026-09-03T13:01:05: exponent: '0x10001', 2026-09-03T13:01:05: pubkey: , 2026-09-03T13:01:05: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T13:01:05: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T13:01:05: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T13:01:05: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T13:01:05: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T13:01:05: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T13:01:05: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T13:01:05: raw: , 2026-09-03T13:01:05: issuerCertificate: { 2026-09-03T13:01:05: subject: [Object: null prototype], 2026-09-03T13:01:05: issuer: [Object: null prototype], 2026-09-03T13:01:05: infoAccess: [Object: null prototype], 2026-09-03T13:01:05: ca: true, 2026-09-03T13:01:05: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T13:01:05: bits: 2048, 2026-09-03T13:01:05: exponent: '0x10001', 2026-09-03T13:01:05: pubkey: , 2026-09-03T13:01:05: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T13:01:05: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T13:01:05: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T13:01:05: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T13:01:05: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T13:01:05: ext_key_usage: [Array], 2026-09-03T13:01:05: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T13:01:05: raw: , 2026-09-03T13:01:05: issuerCertificate: [Object] 2026-09-03T13:01:05: } 2026-09-03T13:01:05: }, 2026-09-03T13:01:05: command: 'CONN' 2026-09-03T13:01:05: } 2026-09-03T13:06:14: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T13:06:14: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T13:06:14: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T13:06:14: at TLSSocket.emit (node:events:524:28) 2026-09-03T13:06:14: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T13:06:14: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T13:06:14: code: 'ESOCKET', 2026-09-03T13:06:14: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T13:06:14: host: 'localhost', 2026-09-03T13:06:14: cert: { 2026-09-03T13:06:14: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T13:06:14: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T13:06:14: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T13:06:14: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T13:06:14: ca: false, 2026-09-03T13:06:14: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T13:06:14: bits: 2048, 2026-09-03T13:06:14: exponent: '0x10001', 2026-09-03T13:06:14: pubkey: , 2026-09-03T13:06:14: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T13:06:14: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T13:06:14: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T13:06:14: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T13:06:14: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T13:06:14: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T13:06:14: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T13:06:14: raw: , 2026-09-03T13:06:14: issuerCertificate: { 2026-09-03T13:06:14: subject: [Object: null prototype], 2026-09-03T13:06:14: issuer: [Object: null prototype], 2026-09-03T13:06:14: infoAccess: [Object: null prototype], 2026-09-03T13:06:14: ca: true, 2026-09-03T13:06:14: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T13:06:14: bits: 2048, 2026-09-03T13:06:14: exponent: '0x10001', 2026-09-03T13:06:14: pubkey: , 2026-09-03T13:06:14: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T13:06:14: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T13:06:14: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T13:06:14: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T13:06:14: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T13:06:14: ext_key_usage: [Array], 2026-09-03T13:06:14: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T13:06:14: raw: , 2026-09-03T13:06:14: issuerCertificate: [Object] 2026-09-03T13:06:14: } 2026-09-03T13:06:14: }, 2026-09-03T13:06:14: command: 'CONN' 2026-09-03T13:06:14: } 2026-09-03T13:15:39: [registerSociety] Superadmin notification email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T13:16:08: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T13:16:08: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T13:16:08: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T13:16:08: at TLSSocket.emit (node:events:524:28) 2026-09-03T13:16:08: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T13:16:08: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T13:16:08: code: 'ESOCKET', 2026-09-03T13:16:08: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T13:16:08: host: 'localhost', 2026-09-03T13:16:08: cert: { 2026-09-03T13:16:08: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T13:16:08: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T13:16:08: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T13:16:08: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T13:16:08: ca: false, 2026-09-03T13:16:08: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T13:16:08: bits: 2048, 2026-09-03T13:16:08: exponent: '0x10001', 2026-09-03T13:16:08: pubkey: , 2026-09-03T13:16:08: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T13:16:08: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T13:16:08: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T13:16:08: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T13:16:08: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T13:16:08: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T13:16:08: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T13:16:08: raw: , 2026-09-03T13:16:08: issuerCertificate: { 2026-09-03T13:16:08: subject: [Object: null prototype], 2026-09-03T13:16:08: issuer: [Object: null prototype], 2026-09-03T13:16:08: infoAccess: [Object: null prototype], 2026-09-03T13:16:08: ca: true, 2026-09-03T13:16:08: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T13:16:08: bits: 2048, 2026-09-03T13:16:08: exponent: '0x10001', 2026-09-03T13:16:08: pubkey: , 2026-09-03T13:16:08: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T13:16:08: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T13:16:08: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T13:16:08: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T13:16:08: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T13:16:08: ext_key_usage: [Array], 2026-09-03T13:16:08: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T13:16:08: raw: , 2026-09-03T13:16:08: issuerCertificate: [Object] 2026-09-03T13:16:08: } 2026-09-03T13:16:08: }, 2026-09-03T13:16:08: command: 'CONN' 2026-09-03T13:16:08: } 2026-09-03T13:17:00: [generateEmailOTP] Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T13:17:00: [sendEmailForgotPasswordOTP] Error: Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T13:17:00: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:1002:27) 2026-09-03T13:17:00: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T13:17:00: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T13:17:19: [generateEmailOTP] Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T13:17:19: [sendEmailForgotPasswordOTP] Error: Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T13:17:19: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:1002:27) 2026-09-03T13:17:19: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T13:17:19: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T13:19:01: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T13:19:01: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T13:19:01: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T13:19:01: at TLSSocket.emit (node:events:524:28) 2026-09-03T13:19:01: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T13:19:01: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T13:19:01: code: 'ESOCKET', 2026-09-03T13:19:01: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T13:19:01: host: 'localhost', 2026-09-03T13:19:01: cert: { 2026-09-03T13:19:01: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T13:19:01: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T13:19:01: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T13:19:01: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T13:19:01: ca: false, 2026-09-03T13:19:01: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T13:19:01: bits: 2048, 2026-09-03T13:19:01: exponent: '0x10001', 2026-09-03T13:19:01: pubkey: , 2026-09-03T13:19:01: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T13:19:01: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T13:19:01: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T13:19:01: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T13:19:01: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T13:19:01: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T13:19:01: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T13:19:01: raw: , 2026-09-03T13:19:01: issuerCertificate: { 2026-09-03T13:19:01: subject: [Object: null prototype], 2026-09-03T13:19:01: issuer: [Object: null prototype], 2026-09-03T13:19:01: infoAccess: [Object: null prototype], 2026-09-03T13:19:01: ca: true, 2026-09-03T13:19:01: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T13:19:01: bits: 2048, 2026-09-03T13:19:01: exponent: '0x10001', 2026-09-03T13:19:01: pubkey: , 2026-09-03T13:19:01: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T13:19:01: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T13:19:01: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T13:19:01: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T13:19:01: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T13:19:01: ext_key_usage: [Array], 2026-09-03T13:19:01: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T13:19:01: raw: , 2026-09-03T13:19:01: issuerCertificate: [Object] 2026-09-03T13:19:01: } 2026-09-03T13:19:01: }, 2026-09-03T13:19:01: command: 'CONN' 2026-09-03T13:19:01: } 2026-09-03T13:20:11: [generateEmailOTP] Error: Please wait before requesting a new OTP. You can resend it after 03 Sep 2026, 01:49 PM. 2026-09-03T13:20:11: [sendEmailForgotPasswordOTP] Error: Error: Please wait before requesting a new OTP. You can resend it after 03 Sep 2026, 01:49 PM. 2026-09-03T13:20:11: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:972:27) 2026-09-03T13:20:11: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T13:20:11: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T13:24:35: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T13:24:35: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T13:24:35: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T13:24:35: at TLSSocket.emit (node:events:524:28) 2026-09-03T13:24:35: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T13:24:35: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T13:24:35: code: 'ESOCKET', 2026-09-03T13:24:35: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T13:24:35: host: 'localhost', 2026-09-03T13:24:35: cert: { 2026-09-03T13:24:35: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T13:24:35: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T13:24:35: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T13:24:35: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T13:24:35: ca: false, 2026-09-03T13:24:35: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T13:24:35: bits: 2048, 2026-09-03T13:24:35: exponent: '0x10001', 2026-09-03T13:24:35: pubkey: , 2026-09-03T13:24:35: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T13:24:35: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T13:24:35: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T13:24:35: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T13:24:35: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T13:24:35: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T13:24:35: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T13:24:35: raw: , 2026-09-03T13:24:35: issuerCertificate: { 2026-09-03T13:24:35: subject: [Object: null prototype], 2026-09-03T13:24:35: issuer: [Object: null prototype], 2026-09-03T13:24:35: infoAccess: [Object: null prototype], 2026-09-03T13:24:35: ca: true, 2026-09-03T13:24:35: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T13:24:35: bits: 2048, 2026-09-03T13:24:35: exponent: '0x10001', 2026-09-03T13:24:35: pubkey: , 2026-09-03T13:24:35: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T13:24:35: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T13:24:35: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T13:24:35: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T13:24:35: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T13:24:35: ext_key_usage: [Array], 2026-09-03T13:24:35: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T13:24:35: raw: , 2026-09-03T13:24:35: issuerCertificate: [Object] 2026-09-03T13:24:35: } 2026-09-03T13:24:35: }, 2026-09-03T13:24:35: command: 'CONN' 2026-09-03T13:24:35: } 2026-09-03T13:25:13: [generateEmailOTP] Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T13:25:13: [sendEmailForgotPasswordOTP] Error: Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T13:25:13: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:1002:27) 2026-09-03T13:25:13: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T13:25:13: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T13:25:31: [generateEmailOTP] Error: Please wait before requesting a new OTP. You can resend it after 03 Sep 2026, 01:49 PM. 2026-09-03T13:25:31: [sendEmailForgotPasswordOTP] Error: Error: Please wait before requesting a new OTP. You can resend it after 03 Sep 2026, 01:49 PM. 2026-09-03T13:25:31: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:972:27) 2026-09-03T13:25:31: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T13:25:31: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T13:27:50: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T13:27:50: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T13:27:50: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T13:27:50: at TLSSocket.emit (node:events:524:28) 2026-09-03T13:27:50: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T13:27:50: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T13:27:50: code: 'ESOCKET', 2026-09-03T13:27:50: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T13:27:50: host: 'localhost', 2026-09-03T13:27:50: cert: { 2026-09-03T13:27:50: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T13:27:50: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T13:27:50: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T13:27:50: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T13:27:50: ca: false, 2026-09-03T13:27:50: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T13:27:50: bits: 2048, 2026-09-03T13:27:50: exponent: '0x10001', 2026-09-03T13:27:50: pubkey: , 2026-09-03T13:27:50: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T13:27:50: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T13:27:50: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T13:27:50: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T13:27:50: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T13:27:50: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T13:27:50: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T13:27:50: raw: , 2026-09-03T13:27:50: issuerCertificate: { 2026-09-03T13:27:50: subject: [Object: null prototype], 2026-09-03T13:27:50: issuer: [Object: null prototype], 2026-09-03T13:27:50: infoAccess: [Object: null prototype], 2026-09-03T13:27:50: ca: true, 2026-09-03T13:27:50: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T13:27:50: bits: 2048, 2026-09-03T13:27:50: exponent: '0x10001', 2026-09-03T13:27:50: pubkey: , 2026-09-03T13:27:50: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T13:27:50: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T13:27:50: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T13:27:50: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T13:27:50: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T13:27:50: ext_key_usage: [Array], 2026-09-03T13:27:50: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T13:27:50: raw: , 2026-09-03T13:27:50: issuerCertificate: [Object] 2026-09-03T13:27:50: } 2026-09-03T13:27:50: }, 2026-09-03T13:27:50: command: 'CONN' 2026-09-03T13:27:50: } 2026-09-03T14:53:01: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T14:53:01: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T14:53:01: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T14:53:01: at TLSSocket.emit (node:events:524:28) 2026-09-03T14:53:01: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T14:53:01: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T14:53:01: code: 'ESOCKET', 2026-09-03T14:53:01: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T14:53:01: host: 'localhost', 2026-09-03T14:53:01: cert: { 2026-09-03T14:53:01: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T14:53:01: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T14:53:01: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T14:53:01: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T14:53:01: ca: false, 2026-09-03T14:53:01: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T14:53:01: bits: 2048, 2026-09-03T14:53:01: exponent: '0x10001', 2026-09-03T14:53:01: pubkey: , 2026-09-03T14:53:01: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T14:53:01: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T14:53:01: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T14:53:01: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T14:53:01: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T14:53:01: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T14:53:01: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T14:53:01: raw: , 2026-09-03T14:53:01: issuerCertificate: { 2026-09-03T14:53:01: subject: [Object: null prototype], 2026-09-03T14:53:01: issuer: [Object: null prototype], 2026-09-03T14:53:01: infoAccess: [Object: null prototype], 2026-09-03T14:53:01: ca: true, 2026-09-03T14:53:01: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T14:53:01: bits: 2048, 2026-09-03T14:53:01: exponent: '0x10001', 2026-09-03T14:53:01: pubkey: , 2026-09-03T14:53:01: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T14:53:01: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T14:53:01: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T14:53:01: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T14:53:01: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T14:53:01: ext_key_usage: [Array], 2026-09-03T14:53:01: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T14:53:01: raw: , 2026-09-03T14:53:01: issuerCertificate: [Object] 2026-09-03T14:53:01: } 2026-09-03T14:53:01: }, 2026-09-03T14:53:01: command: 'CONN' 2026-09-03T14:53:01: } 2026-09-03T14:59:00: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T14:59:00: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T14:59:00: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T14:59:00: at TLSSocket.emit (node:events:524:28) 2026-09-03T14:59:00: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T14:59:00: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T14:59:00: code: 'ESOCKET', 2026-09-03T14:59:00: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T14:59:00: host: 'localhost', 2026-09-03T14:59:00: cert: { 2026-09-03T14:59:00: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T14:59:00: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T14:59:00: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T14:59:00: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T14:59:00: ca: false, 2026-09-03T14:59:00: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T14:59:00: bits: 2048, 2026-09-03T14:59:00: exponent: '0x10001', 2026-09-03T14:59:00: pubkey: , 2026-09-03T14:59:00: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T14:59:00: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T14:59:00: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T14:59:00: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T14:59:00: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T14:59:00: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T14:59:00: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T14:59:00: raw: , 2026-09-03T14:59:00: issuerCertificate: { 2026-09-03T14:59:00: subject: [Object: null prototype], 2026-09-03T14:59:00: issuer: [Object: null prototype], 2026-09-03T14:59:00: infoAccess: [Object: null prototype], 2026-09-03T14:59:00: ca: true, 2026-09-03T14:59:00: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T14:59:00: bits: 2048, 2026-09-03T14:59:00: exponent: '0x10001', 2026-09-03T14:59:00: pubkey: , 2026-09-03T14:59:00: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T14:59:00: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T14:59:00: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T14:59:00: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T14:59:00: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T14:59:00: ext_key_usage: [Array], 2026-09-03T14:59:00: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T14:59:00: raw: , 2026-09-03T14:59:00: issuerCertificate: [Object] 2026-09-03T14:59:00: } 2026-09-03T14:59:00: }, 2026-09-03T14:59:00: command: 'CONN' 2026-09-03T14:59:00: } 2026-09-03T14:59:09: [generateEmailOTP] Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T14:59:09: [sendEmailForgotPasswordOTP] Error: Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T14:59:09: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:1002:27) 2026-09-03T14:59:09: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T14:59:09: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T15:00:16: [generateEmailOTP] Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T15:00:16: [sendEmailForgotPasswordOTP] Error: Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T15:00:16: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:1002:27) 2026-09-03T15:00:16: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T15:00:16: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T15:01:46: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T15:01:46: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T15:01:46: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T15:01:46: at TLSSocket.emit (node:events:524:28) 2026-09-03T15:01:46: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T15:01:46: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T15:01:46: code: 'ESOCKET', 2026-09-03T15:01:46: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T15:01:46: host: 'localhost', 2026-09-03T15:01:46: cert: { 2026-09-03T15:01:46: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T15:01:46: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T15:01:46: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T15:01:46: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T15:01:46: ca: false, 2026-09-03T15:01:46: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T15:01:46: bits: 2048, 2026-09-03T15:01:46: exponent: '0x10001', 2026-09-03T15:01:46: pubkey: , 2026-09-03T15:01:46: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T15:01:46: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T15:01:46: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T15:01:46: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T15:01:46: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T15:01:46: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T15:01:46: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T15:01:46: raw: , 2026-09-03T15:01:46: issuerCertificate: { 2026-09-03T15:01:46: subject: [Object: null prototype], 2026-09-03T15:01:46: issuer: [Object: null prototype], 2026-09-03T15:01:46: infoAccess: [Object: null prototype], 2026-09-03T15:01:46: ca: true, 2026-09-03T15:01:46: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T15:01:46: bits: 2048, 2026-09-03T15:01:46: exponent: '0x10001', 2026-09-03T15:01:46: pubkey: , 2026-09-03T15:01:46: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T15:01:46: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T15:01:46: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T15:01:46: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T15:01:46: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T15:01:46: ext_key_usage: [Array], 2026-09-03T15:01:46: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T15:01:46: raw: , 2026-09-03T15:01:46: issuerCertificate: [Object] 2026-09-03T15:01:46: } 2026-09-03T15:01:46: }, 2026-09-03T15:01:46: command: 'CONN' 2026-09-03T15:01:46: } 2026-09-03T15:01:50: [generateEmailOTP] Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T15:01:50: [sendEmailForgotPasswordOTP] Error: Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T15:01:50: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:1002:27) 2026-09-03T15:01:50: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T15:01:50: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T15:02:33: [generateEmailOTP] Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T15:02:33: [sendEmailForgotPasswordOTP] Error: Error: Current OTP is still valid. Please wait until it expires. 2026-09-03T15:02:33: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:1002:27) 2026-09-03T15:02:33: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T15:02:33: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T15:14:03: [sendEmailForgotPasswordOTP] Error: Error [ERR_TLS_CERT_ALTNAME_INVALID]: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-03T15:14:03: at Object.checkServerIdentity (node:tls:316:12) 2026-09-03T15:14:03: at TLSSocket.onConnectSecure (node:_tls_wrap:1689:27) 2026-09-03T15:14:03: at TLSSocket.emit (node:events:524:28) 2026-09-03T15:14:03: at TLSSocket._finishInit (node:_tls_wrap:1078:8) 2026-09-03T15:14:03: at ssl.onhandshakedone (node:_tls_wrap:864:12) { 2026-09-03T15:14:03: code: 'ESOCKET', 2026-09-03T15:14:03: reason: "Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com", 2026-09-03T15:14:03: host: 'localhost', 2026-09-03T15:14:03: cert: { 2026-09-03T15:14:03: subject: [Object: null prototype] { CN: 'server.b2infosoft.com' }, 2026-09-03T15:14:03: issuer: [Object: null prototype] { C: 'US', O: "Let's Encrypt", CN: 'YR2' }, 2026-09-03T15:14:03: subjectaltname: 'DNS:server.b2infosoft.com', 2026-09-03T15:14:03: infoAccess: [Object: null prototype] { 'CA Issuers - URI': [Array] }, 2026-09-03T15:14:03: ca: false, 2026-09-03T15:14:03: modulus: 'C16308DDAB17692B18E93DA32296CF07B17F814CB49B64B19E5D545EA21E7DF83B0D0699A2B0AA3FF49001A16FB2C7A17E2B2CA509BFFC1099F5C9F81BDC9A90A1C41563ABD19D9BE8AB4CB58A99BDBB7503E834C2228FBE39B1A8240771EE60C95410A1DF91F6E39208CD4C7660DFFA26A13C21A1CAA8EE778A2C92037B65D0A992DE475B13FF3D0E7B0D1F49FF4B65329125F2C57BF17BB75410559A9F29AB0464ABDAF4DD4C377F2D8FA5D5F5AC327A9AEBD37FF5D6FBFA59F5D043F1E1A09F63B17D1E45D787D9E9296CB7ECFA0595B7C06B09C42268832B113229185AC840D8DA1CA01245A21A04AF70ACE5187EC4CEEEF3BADD190D86159D8DD30F42B9', 2026-09-03T15:14:03: bits: 2048, 2026-09-03T15:14:03: exponent: '0x10001', 2026-09-03T15:14:03: pubkey: , 2026-09-03T15:14:03: valid_from: 'Aug 6 03:04:43 2026 GMT', 2026-09-03T15:14:03: valid_to: 'Nov 4 03:04:42 2026 GMT', 2026-09-03T15:14:03: fingerprint: '7D:3F:3C:02:66:E2:51:B1:B3:72:AA:50:74:06:EA:B3:21:35:B1:74', 2026-09-03T15:14:03: fingerprint256: '50:27:FC:CC:D6:2D:E4:99:48:07:D9:D1:45:30:9F:FF:BB:94:42:86:D2:CA:A3:B6:99:38:91:AF:E1:23:82:1B', 2026-09-03T15:14:03: fingerprint512: '53:1C:19:29:F6:7B:3D:36:78:C5:FD:F2:71:1F:F5:18:17:A3:8F:2A:6F:5D:6E:94:49:8D:31:50:24:DF:65:55:30:6E:CC:1B:37:5D:57:29:D8:C6:65:C9:DA:6C:46:AA:A2:15:72:DF:AD:0C:83:92:A1:78:EE:25:74:F9:79:07', 2026-09-03T15:14:03: ext_key_usage: [ '1.3.6.1.5.5.7.3.1' ], 2026-09-03T15:14:03: serialNumber: '061377C8076D2B4C110701589DAB02C1AC1D', 2026-09-03T15:14:03: raw: , 2026-09-03T15:14:03: issuerCertificate: { 2026-09-03T15:14:03: subject: [Object: null prototype], 2026-09-03T15:14:03: issuer: [Object: null prototype], 2026-09-03T15:14:03: infoAccess: [Object: null prototype], 2026-09-03T15:14:03: ca: true, 2026-09-03T15:14:03: modulus: 'D9D0BC70069A6A87CE25BAA31EAD5FDE78BFDF5D0EE62D042FD4B9E958A65BCAF1A9C7AC21E807E7B2502717A7B04E470703E8123A806F9B70DF9B4E80B86885F8A46EB787C0728C2A9C0410096F7CF903CFFDE3AFFF0BA0EC8CA4E0D90EC5FD88EA0D9FE794FA9C9A0E4CB15CBA4791ABCD091901186A7F9D3C5AFD38652040ADA118A80D916F3BA5AA69B0E02E50972BA18851B79B948ACE2A6998AB7A2B1EBB7DA0CC324D04088AB6CBDDE875F8BF6E5BA6444D712FC1FC6B5CF6455B5290FED8F2CFC5D7A2DD38A6E79938B5F0045F00F6AB288F4F1AD336AEA537E00CAF983673574DAA4393C23C5E57A2F99693F5AC6898BCB9D168F94EAB26513D6FB9', 2026-09-03T15:14:03: bits: 2048, 2026-09-03T15:14:03: exponent: '0x10001', 2026-09-03T15:14:03: pubkey: , 2026-09-03T15:14:03: valid_from: 'Sep 3 00:00:00 2025 GMT', 2026-09-03T15:14:03: valid_to: 'Sep 2 23:59:59 2028 GMT', 2026-09-03T15:14:03: fingerprint: '2D:74:D6:DF:D9:6E:EA:55:AD:7B:AA:FA:0D:3C:65:52:B2:DA:DC:37', 2026-09-03T15:14:03: fingerprint256: '23:8B:85:A0:09:9C:65:B9:70:47:7D:57:24:F1:A1:D4:75:CE:50:58:CF:FE:4E:FA:87:33:89:9B:DB:86:3C:47', 2026-09-03T15:14:03: fingerprint512: 'E2:7E:24:B1:05:74:FD:1E:F9:45:05:78:CE:F8:96:AE:FD:C7:95:92:B1:40:AA:64:AF:47:F6:B9:06:76:10:26:9E:12:8E:24:BC:EA:04:49:70:24:03:77:2A:0B:2E:61:22:B2:C9:60:37:5E:3C:C8:FD:E5:89:57:8E:C1:2C:2C', 2026-09-03T15:14:03: ext_key_usage: [Array], 2026-09-03T15:14:03: serialNumber: '4EBD24947E24D394802D84A52FD5B319', 2026-09-03T15:14:03: raw: , 2026-09-03T15:14:03: issuerCertificate: [Object] 2026-09-03T15:14:03: } 2026-09-03T15:14:03: }, 2026-09-03T15:14:03: command: 'CONN' 2026-09-03T15:14:03: } 2026-09-03T15:14:04: [generateEmailOTP] Error: Please wait before requesting a new OTP. You can resend it after 03 Sep 2026, 03:44 PM. 2026-09-03T15:14:04: [sendEmailForgotPasswordOTP] Error: Error: Please wait before requesting a new OTP. You can resend it after 03 Sep 2026, 03:44 PM. 2026-09-03T15:14:04: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:972:27) 2026-09-03T15:14:04: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T15:14:04: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-03T15:14:11: [generateEmailOTP] Error: Please wait before requesting a new OTP. You can resend it after 03 Sep 2026, 03:44 PM. 2026-09-03T15:14:11: [sendEmailForgotPasswordOTP] Error: Error: Please wait before requesting a new OTP. You can resend it after 03 Sep 2026, 03:44 PM. 2026-09-03T15:14:11: at Object.generateEmailOTP (/home/b2/public_html/society.1b2.in/src/v1/models/member.model.js:972:27) 2026-09-03T15:14:11: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2026-09-03T15:14:11: at async sendEmailForgotPasswordOTP (/home/b2/public_html/society.1b2.in/src/v1/controllers/userAuth.controller.js:795:25) 2026-09-04T16:33:00: [approveRegistrationRequest] Admin approval email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-04T16:50:04: [registerSociety] Superadmin notification email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-04T16:50:31: [approveRegistrationRequest] Admin approval email failed: Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:server.b2infosoft.com 2026-09-04T17:43:38: [addActivityLog] Error: Data truncated for column 'activity_type' at row 1 2026-09-04T17:43:38: APPROVE PAYMENT ERROR: Error: Data truncated for column 'activity_type' at row 1 2026-09-04T17:43:38: at Object.addActivityLog (/home/b2/public_html/society.1b2.in/src/v1/models/activity.model.js:121:41) 2026-09-04T17:43:38: at approvePayment (/home/b2/public_html/society.1b2.in/src/v1/controllers/payment.controller.js:874:37) 2026-09-04T17:43:38: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) { 2026-09-04T17:43:38: code: 'WARN_DATA_TRUNCATED', 2026-09-04T17:43:38: errno: 1265, 2026-09-04T17:43:38: sqlState: '01000', 2026-09-04T17:43:38: sqlMessage: "Data truncated for column 'activity_type' at row 1", 2026-09-04T17:43:38: sql: '\n' + 2026-09-04T17:43:38: ' INSERT INTO activity_log\n' + 2026-09-04T17:43:38: ' (society_id, activity_type, reference_id, title, subtitle, amount, done_by)\n' + 2026-09-04T17:43:38: ' VALUES (?, ?, ?, ?, ?, ?, ?)' 2026-09-04T17:43:38: }