{"date":"Wed Aug 20 2025 23:34:59 GMT+0100 (West Africa Standard Time)","error":{},"exception":true,"level":"error","message":"uncaughtException: Class extends value #<Object> is not a constructor or null\nTypeError: Class extends value #<Object> is not a constructor or null\n    at Object.<anonymous> (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\clinical\\models\\ClinicalSuggestion.js:3:34)\n    at Module._compile (node:internal/modules/cjs/loader:1554:14)\n    at Object..js (node:internal/modules/cjs/loader:1706:10)\n    at Module.load (node:internal/modules/cjs/loader:1289:32)\n    at Function._load (node:internal/modules/cjs/loader:1108:12)\n    at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n    at wrapModuleLoad (node:internal/modules/cjs/loader:220:24)\n    at Module.require (node:internal/modules/cjs/loader:1311:12)\n    at require (node:internal/modules/helpers:136:16)\n    at Object.<anonymous> (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\clinical\\controllers\\suggestions.js:1:28)\n    at Module._compile (node:internal/modules/cjs/loader:1554:14)\n    at Object..js (node:internal/modules/cjs/loader:1706:10)\n    at Module.load (node:internal/modules/cjs/loader:1289:32)\n    at Function._load (node:internal/modules/cjs/loader:1108:12)\n    at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n    at wrapModuleLoad (node:internal/modules/cjs/loader:220:24)","os":{"loadavg":[0,0,0],"uptime":280582.484},"process":{"argv":["C:\\Program Files (x86)\\nodejs\\node.exe","C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js"],"cwd":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content","execPath":"C:\\Program Files (x86)\\nodejs\\node.exe","gid":null,"memoryUsage":{"arrayBuffers":52975,"external":2367634,"heapTotal":31862784,"heapUsed":17582648,"rss":60502016},"pid":19836,"uid":null,"version":"v22.14.0"},"stack":"TypeError: Class extends value #<Object> is not a constructor or null\n    at Object.<anonymous> (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\clinical\\models\\ClinicalSuggestion.js:3:34)\n    at Module._compile (node:internal/modules/cjs/loader:1554:14)\n    at Object..js (node:internal/modules/cjs/loader:1706:10)\n    at Module.load (node:internal/modules/cjs/loader:1289:32)\n    at Function._load (node:internal/modules/cjs/loader:1108:12)\n    at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n    at wrapModuleLoad (node:internal/modules/cjs/loader:220:24)\n    at Module.require (node:internal/modules/cjs/loader:1311:12)\n    at require (node:internal/modules/helpers:136:16)\n    at Object.<anonymous> (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\clinical\\controllers\\suggestions.js:1:28)\n    at Module._compile (node:internal/modules/cjs/loader:1554:14)\n    at Object..js (node:internal/modules/cjs/loader:1706:10)\n    at Module.load (node:internal/modules/cjs/loader:1289:32)\n    at Function._load (node:internal/modules/cjs/loader:1108:12)\n    at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n    at wrapModuleLoad (node:internal/modules/cjs/loader:220:24)","timestamp":"20-08-2025 23:34:59","trace":[{"column":34,"file":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\clinical\\models\\ClinicalSuggestion.js","function":null,"line":3,"method":null,"native":false},{"column":14,"file":"node:internal/modules/cjs/loader","function":"Module._compile","line":1554,"method":"_compile","native":false},{"column":10,"file":"node:internal/modules/cjs/loader","function":"Object..js","line":1706,"method":".js","native":false},{"column":32,"file":"node:internal/modules/cjs/loader","function":"Module.load","line":1289,"method":"load","native":false},{"column":12,"file":"node:internal/modules/cjs/loader","function":"Function._load","line":1108,"method":"_load","native":false},{"column":14,"file":"node:diagnostics_channel","function":"TracingChannel.traceSync","line":322,"method":"traceSync","native":false},{"column":24,"file":"node:internal/modules/cjs/loader","function":"wrapModuleLoad","line":220,"method":null,"native":false},{"column":12,"file":"node:internal/modules/cjs/loader","function":"Module.require","line":1311,"method":"require","native":false},{"column":16,"file":"node:internal/modules/helpers","function":"require","line":136,"method":null,"native":false},{"column":28,"file":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\clinical\\controllers\\suggestions.js","function":null,"line":1,"method":null,"native":false},{"column":14,"file":"node:internal/modules/cjs/loader","function":"Module._compile","line":1554,"method":"_compile","native":false},{"column":10,"file":"node:internal/modules/cjs/loader","function":"Object..js","line":1706,"method":".js","native":false},{"column":32,"file":"node:internal/modules/cjs/loader","function":"Module.load","line":1289,"method":"load","native":false},{"column":12,"file":"node:internal/modules/cjs/loader","function":"Function._load","line":1108,"method":"_load","native":false},{"column":14,"file":"node:diagnostics_channel","function":"TracingChannel.traceSync","line":322,"method":"traceSync","native":false},{"column":24,"file":"node:internal/modules/cjs/loader","function":"wrapModuleLoad","line":220,"method":null,"native":false}]}
{"date":"Fri Aug 22 2025 10:52:50 GMT+0100 (West Africa Standard Time)","error":{"code":"MODULE_NOT_FOUND","requireStack":["C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\users.routes.js","C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js"]},"exception":true,"level":"error","message":"uncaughtException: Cannot find module './clinical/doctors/suggestedComplaints.service'\nRequire stack:\n- C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\users.routes.js\n- C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js\nError: Cannot find module './clinical/doctors/suggestedComplaints.service'\nRequire stack:\n- C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\users.routes.js\n- C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js\n    at Function._resolveFilename (node:internal/modules/cjs/loader:1225:15)\n    at Function._load (node:internal/modules/cjs/loader:1055:27)\n    at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n    at wrapModuleLoad (node:internal/modules/cjs/loader:220:24)\n    at Module.require (node:internal/modules/cjs/loader:1311:12)\n    at require (node:internal/modules/helpers:136:16)\n    at Object.<anonymous> (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\users.routes.js:82:5)\n    at Module._compile (node:internal/modules/cjs/loader:1554:14)\n    at Object..js (node:internal/modules/cjs/loader:1706:10)\n    at Module.load (node:internal/modules/cjs/loader:1289:32)\n    at Function._load (node:internal/modules/cjs/loader:1108:12)\n    at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n    at wrapModuleLoad (node:internal/modules/cjs/loader:220:24)\n    at Module.require (node:internal/modules/cjs/loader:1311:12)\n    at require (node:internal/modules/helpers:136:16)\n    at Object.<anonymous> (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js:9:20)","os":{"loadavg":[0,0,0],"uptime":16790.75},"process":{"argv":["C:\\Program Files (x86)\\nodejs\\node.exe","C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js"],"cwd":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content","execPath":"C:\\Program Files (x86)\\nodejs\\node.exe","gid":null,"memoryUsage":{"arrayBuffers":52975,"external":2367634,"heapTotal":31600640,"heapUsed":17464568,"rss":56950784},"pid":8420,"uid":null,"version":"v22.14.0"},"stack":"Error: Cannot find module './clinical/doctors/suggestedComplaints.service'\nRequire stack:\n- C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\users.routes.js\n- C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js\n    at Function._resolveFilename (node:internal/modules/cjs/loader:1225:15)\n    at Function._load (node:internal/modules/cjs/loader:1055:27)\n    at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n    at wrapModuleLoad (node:internal/modules/cjs/loader:220:24)\n    at Module.require (node:internal/modules/cjs/loader:1311:12)\n    at require (node:internal/modules/helpers:136:16)\n    at Object.<anonymous> (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\users.routes.js:82:5)\n    at Module._compile (node:internal/modules/cjs/loader:1554:14)\n    at Object..js (node:internal/modules/cjs/loader:1706:10)\n    at Module.load (node:internal/modules/cjs/loader:1289:32)\n    at Function._load (node:internal/modules/cjs/loader:1108:12)\n    at TracingChannel.traceSync (node:diagnostics_channel:322:14)\n    at wrapModuleLoad (node:internal/modules/cjs/loader:220:24)\n    at Module.require (node:internal/modules/cjs/loader:1311:12)\n    at require (node:internal/modules/helpers:136:16)\n    at Object.<anonymous> (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js:9:20)","timestamp":"22-08-2025 10:52:50","trace":[{"column":15,"file":"node:internal/modules/cjs/loader","function":"Function._resolveFilename","line":1225,"method":"_resolveFilename","native":false},{"column":27,"file":"node:internal/modules/cjs/loader","function":"Function._load","line":1055,"method":"_load","native":false},{"column":14,"file":"node:diagnostics_channel","function":"TracingChannel.traceSync","line":322,"method":"traceSync","native":false},{"column":24,"file":"node:internal/modules/cjs/loader","function":"wrapModuleLoad","line":220,"method":null,"native":false},{"column":12,"file":"node:internal/modules/cjs/loader","function":"Module.require","line":1311,"method":"require","native":false},{"column":16,"file":"node:internal/modules/helpers","function":"require","line":136,"method":null,"native":false},{"column":5,"file":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\users.routes.js","function":null,"line":82,"method":null,"native":false},{"column":14,"file":"node:internal/modules/cjs/loader","function":"Module._compile","line":1554,"method":"_compile","native":false},{"column":10,"file":"node:internal/modules/cjs/loader","function":"Object..js","line":1706,"method":".js","native":false},{"column":32,"file":"node:internal/modules/cjs/loader","function":"Module.load","line":1289,"method":"load","native":false},{"column":12,"file":"node:internal/modules/cjs/loader","function":"Function._load","line":1108,"method":"_load","native":false},{"column":14,"file":"node:diagnostics_channel","function":"TracingChannel.traceSync","line":322,"method":"traceSync","native":false},{"column":24,"file":"node:internal/modules/cjs/loader","function":"wrapModuleLoad","line":220,"method":null,"native":false},{"column":12,"file":"node:internal/modules/cjs/loader","function":"Module.require","line":1311,"method":"require","native":false},{"column":16,"file":"node:internal/modules/helpers","function":"require","line":136,"method":null,"native":false},{"column":20,"file":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js","function":null,"line":9,"method":null,"native":false}]}
{"level":"error","message":"Sales Error: Billing Error: Patient is not assigned to any valid group/family.","stack":"Error: Billing Error: Patient is not assigned to any valid group/family.\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:254:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"22-08-2025 15:53:50"}
{"level":"error","message":"Sales Error: wallet not available for this client. please make sure you enter valid patient ID","stack":"Error: wallet not available for this client. please make sure you enter valid patient ID\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:143:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"22-08-2025 16:09:21"}
{"level":"error","message":"Sales Error: ERROR! wallet not available for this client. please make sure you enter valid patient ID","stack":"Error: ERROR! wallet not available for this client. please make sure you enter valid patient ID\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:141:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"22-08-2025 16:10:25"}
{"level":"error","message":"Sales Error: Billing Error: Patient is not assigned to any valid group/family.","stack":"Error: Billing Error: Patient is not assigned to any valid group/family.\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:259:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"22-08-2025 16:10:42"}
{"level":"error","message":"Sales Error: ERROR! wallet not available for this client. please make sure you enter valid patient ID","stack":"Error: ERROR! wallet not available for this client. please make sure you enter valid patient ID\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:145:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"22-08-2025 16:15:05"}
{"level":"error","message":"Sales Error: Billing Error! Patient customer does NOT subscribe to any HMO","stack":"Error: Billing Error! Patient customer does NOT subscribe to any HMO\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:354:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"22-08-2025 16:15:15"}
{"level":"error","message":"Sales Error: ERROR! wallet not available for this client. please make sure you enter valid patient ID","stack":"Error: ERROR! wallet not available for this client. please make sure you enter valid patient ID\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:145:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"22-08-2025 16:20:00"}
{"date":"Sat Aug 23 2025 09:38:16 GMT+0100 (West Africa Standard Time)","error":{},"exception":true,"level":"error","message":"uncaughtException: Cannot read properties of undefined (reading 'once')\nTypeError: Cannot read properties of undefined (reading 'once')\n    at C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\node_modules\\mysql2\\lib\\base\\pool.js:149:29\n    at C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\node_modules\\mysql2\\lib\\base\\pool.js:43:37\n    at process.processTicksAndRejections (node:internal/process/task_queues:85:11)","os":{"loadavg":[0,0,0],"uptime":98717.75},"process":{"argv":["C:\\Program Files (x86)\\nodejs\\node.exe","C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\index.js"],"cwd":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content","execPath":"C:\\Program Files (x86)\\nodejs\\node.exe","gid":null,"memoryUsage":{"arrayBuffers":2237767,"external":5711440,"heapTotal":23887872,"heapUsed":21633864,"rss":32751616},"pid":12748,"uid":null,"version":"v22.14.0"},"stack":"TypeError: Cannot read properties of undefined (reading 'once')\n    at C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\node_modules\\mysql2\\lib\\base\\pool.js:149:29\n    at C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\node_modules\\mysql2\\lib\\base\\pool.js:43:37\n    at process.processTicksAndRejections (node:internal/process/task_queues:85:11)","timestamp":"23-08-2025 09:38:17","trace":[{"column":29,"file":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\node_modules\\mysql2\\lib\\base\\pool.js","function":null,"line":149,"method":null,"native":false},{"column":37,"file":"C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\node_modules\\mysql2\\lib\\base\\pool.js","function":null,"line":43,"method":null,"native":false},{"column":11,"file":"node:internal/process/task_queues","function":"process.processTicksAndRejections","line":85,"method":"processTicksAndRejections","native":false}]}
{"level":"error","message":"Sales Error: ERROR! wallet not available for this client. please make sure you enter valid patient ID","stack":"Error: ERROR! wallet not available for this client. please make sure you enter valid patient ID\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:145:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"23-08-2025 09:53:43"}
{"level":"error","message":"Sales Error: Billing Error: Patient is not assigned to any valid group/family.","stack":"Error: Billing Error: Patient is not assigned to any valid group/family.\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:263:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"23-08-2025 09:53:57"}
{"level":"error","message":"Sales Error: Billing Error! Patient customer does NOT subscribe to any HMO","stack":"Error: Billing Error! Patient customer does NOT subscribe to any HMO\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:354:15)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"23-08-2025 09:54:05"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:46:25"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:46:47"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:47:59"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:48:42"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:49:35"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:51:50"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:53:53"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:54:03"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:54:20"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:54:28"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:55:06"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:56:38"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:58:33"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:58:48"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:59:12"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:59:38"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 13:59:50"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:00:01"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:01:11"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:07:48"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:10:03"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:11:25"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:11:51"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:11:59"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:14:03"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:15:27"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:15:40"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:16:03"}
{"level":"error","message":"Sales Error:","timestamp":"23-08-2025 14:16:14"}
{"code":"WARN_DATA_TRUNCATED","errno":1265,"level":"error","message":"Sales Error: Data truncated for column 'payer_type' at row 1","sql":"INSERT INTO payments (\n        patient_id, rx_time, amount_paid, paid_for, payment_method, \n        payer_type, confirmed_by, rx_session, bank_name\n      ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)","sqlMessage":"Data truncated for column 'payer_type' at row 1","sqlState":"01000","stack":"Error: Data truncated for column 'payer_type' at row 1\n    at PromisePoolConnection.execute (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\node_modules\\mysql2\\lib\\promise\\connection.js:47:22)\n    at recordSale (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\sales\\sales.controller.js:252:24)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"23-08-2025 14:16:45"}
{"level":"error","message":"Database error in consult: paid is not defined","stack":"ReferenceError: paid is not defined\n    at consult (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\clinical\\doctors\\consultations.js:582:7)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"24-08-2025 14:07:12"}
{"code":"ER_TRUNCATED_WRONG_VALUE_FOR_FIELD","errno":1366,"level":"error","message":"Database error in consult: Incorrect decimal value: '' for column `hospital_db`.`tx`.`bill` at row 1","sql":"INSERT INTO tx(\n    patient_id, c_o, hx, drug_hx, o_e, lab_inv, diag, rx,\n    admission_status, dr_note, signed_by,\n    bill, paid, to_balance, bill_to, session_id\n  ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)","sqlMessage":"Incorrect decimal value: '' for column `hospital_db`.`tx`.`bill` at row 1","sqlState":"22007","stack":"Error: Incorrect decimal value: '' for column `hospital_db`.`tx`.`bill` at row 1\n    at PromisePoolConnection.execute (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\node_modules\\mysql2\\lib\\promise\\connection.js:47:22)\n    at consult (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\clinical\\doctors\\consultations.js:569:22)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"24-08-2025 14:10:26"}
{"level":"error","message":"Database error in consult:","timestamp":"28-08-2025 08:41:52"}
{"level":"error","message":"Database error in consult:","timestamp":"29-08-2025 13:54:33"}
{"level":"error","message":"Database error in consult:","timestamp":"29-08-2025 13:55:49"}
{"level":"error","message":"Database error in consult:","timestamp":"29-08-2025 15:46:29"}
{"level":"error","message":"Database error in consult:","timestamp":"29-08-2025 15:49:15"}
{"level":"error","message":"[Unknown Error]: Bad Request","timestamp":"03-09-2025 10:32:32"}
{"level":"error","message":"Database error in consult:","timestamp":"13-09-2025 12:17:53"}
{"level":"error","message":"Database error in consult:","timestamp":"13-09-2025 12:18:43"}
{"level":"error","message":"Database error in consult:","timestamp":"14-09-2025 09:26:15"}
{"level":"error","message":"Export Billing Summary Error: No billing records found for the specified criteria.","stack":"Error: No billing records found for the specified criteria.\n    at exportBillingSummary (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\billingsAndPayment\\controllers\\billingController.js:1290:13)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"16-09-2025 11:52:14"}
{"level":"error","message":"Export Billing Summary Error: No billing records found for the specified criteria.","stack":"Error: No billing records found for the specified criteria.\n    at exportBillingSummary (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\billingsAndPayment\\controllers\\billingController.js:1290:13)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"16-09-2025 12:08:01"}
{"level":"error","message":"Export Billing Summary Error: No billing records found for the specified criteria.","stack":"Error: No billing records found for the specified criteria.\n    at exportBillingSummary (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\billingsAndPayment\\controllers\\billingController.js:1290:13)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"16-09-2025 12:20:29"}
{"level":"error","message":"Export Billing Summary Error: No billing records found for the specified criteria.","stack":"Error: No billing records found for the specified criteria.\n    at exportBillingSummary (C:\\Users\\Great_Ola\\Desktop\\javaScript-Course\\NodeExpress\\practice\\content\\modules\\users\\billingsAndPayment\\controllers\\billingController.js:1291:13)\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)","timestamp":"16-09-2025 12:21:23"}