| Sl No | Subject | Log | Status type | Status code | Url | Method |
|---|---|---|---|---|---|---|
| 1 | SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'sonologist' at row 1 (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: hospital_management_test, SQL: insert into `proctology` (`consultation_id`, `dre`, `tests`, `amount`, `abscess`, `diet_plan`, `medicines`, `combination_medicines`, `sonologist`, `anal_valve`, `proctoscopy`, `managements`, `additional_cost`, `no_of_fistula`, `fistula_recurrence`, `fistula_recurrence_surgery_count`, `fistula_remark`, `previous_scar`, `diagnosis_summary`, `co_morbidities`, `on_examination`, `treatment_plan`, `discount_amount`, `chief_complaints`, `abscess_position`, `managements_date`, `surgical_history`, `dre_induration_at`, `secondary_anal_valve`, `consultation_discount`, `dre_secondary_position`, `previous_scar_position`, `type_of_fistula_position`, `type_of_fistula_sphincter`, `posterior_fistulous_angle`, `proctoscopy_anal_polyp_at`, `internal_opening_position`, `secondary_opening_position`, `co_morbidities_description`, `no_of_tracks_in_one_fistula`, `proctoscopy_secondary_position`, `external_opening_position`, `pfa`, `sonologist_findings`, `other_investigation`, `id`, `updated_at`, `created_at`) values (019bdf3e-491c-7074-a2c7-8b0da05517d6, [{"id":24,"value":"LARGE POLYP ANUS","label":"LARGE POLYP ANUS"},{"id":23,"value":"Induration at 6 o' clock","label":"Induration at 6 o' clock"},{"id":22,"value":"scar at anal mucosa","label":"scar at anal mucosa"}], [{"id":9,"value":9,"label":"CBC, ESR, RBS, BT, CT, Hbsag HIV 1 and 2, Blood group, Blood urea, Sr creatinine, Chest Xray PA view, ECG"}], 10000, Yes, [{"id":3,"value":3,"label":"Diet in Kannada (ದಿನನಿತ್ಯದ ಸೇವನೆಯಲ್ಲಿ ಕಡಿಮೆ ಬಳಸಿ\nಶುಂಠಿ, ಬೆಳ್ಳುಳ್ಳಿ, ಜೇನುತುಪ್ಪ, ನಿಂಬೆಹಣ್ಣಿನ ಶರಬತ್ತು,\nಅಡುಗೆ ಸೋಡಾ, ಶುಂಠಿ-ಬೆಳ್ಳುಳ್ಳಿ ಪೇಸ್ಟ್, ಬಾದಾಮಿ,\nಗೋಡಂಬಿ, ಪಿಸ್ತಾ, ಗರಮ್ ಮಸಾಲಾ, ಕಾಳು ಮೆಣಸು,\nಮಸಾಲಾ ಟೀ, ಲೆಮನ್ ಟೀ.\n(ಸ್ವಲ್ಪ ಪ್ರಮಾಣದಲ್ಲಿ ಅಡುಗೆಗೆ ಬಳಸಬಹುದು))"},{"id":13,"value":13,"label":"VATA AGGRAVATING FOODS (PULSES, TUBERS, BEANS)"}], Dhanwantaram#Tablet#2-0-2#before-food#Warm water#14,AMLOGEST#Tablet#2-0-2#before-food#Warm water#14, [{"id":"1","combination_ingredients":[{"id":"1-1","combination_medicine":"DYALIL","combination_quantity":"4","combination_unit":"g"},{"id":"1-2","combination_medicine":"PROSTOMAP","combination_quantity":"1","combination_unit":"g"}],"combination_dosage":"2-0-2","combination_timing":"before-food","combination_take_with":"Warm water","combination_medicine_days":"14"}], Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis mollis semper odio ut egestas. Nam tincidunt diam augue, a consequat ante aliquam nec. Nulla tempus ante eu sollicitudin rutrum. Sed ut venenatis nunc. Duis ut condimentum ipsum. Ut eleifend posuere ex sed lacinia. Cras laoreet odio lectus, vitae gravida ante consequat in., ?, [{"id":55,"value":"PROCTOSCOPY- PENDING","label":"PROCTOSCOPY- PENDING"},{"id":54,"value":"3RD DEGREE INTERNAL HEMORRHOID AT 3 O' CLOCK","label":"3RD DEGREE INTERNAL HEMORRHOID AT 3 O' CLOCK"},{"id":53,"value":"3 O CLOCK INTERNAL EXTERNAL HEMORRHOIDS","label":"3 O CLOCK INTERNAL EXTERNAL HEMORRHOIDS"}], [{"id":8,"value":"Primary threading","label":"Primary threading"},{"id":9,"value":"Ksharakarma","label":"Ksharakarma"},{"id":10,"value":"IFTAK","label":"IFTAK"}], EGC#150.00,Complete lay opening of fistula track#1000.00,Anal dilatation#400.00, 2, new_case, ?, Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis mollis semper odio ut egestas. Nam tincidunt diam augue, a consequat ante aliquam nec. Nulla tempus ante eu sollicitudin rutrum. Sed ut venenatis nunc. Duis ut condimentum ipsum. Ut eleifend posuere ex sed lacinia. Cras laoreet odio lectus, vitae gravida ante consequat in., Yes, Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis mollis semper odio ut egestas. Nam tincidunt diam augue, a consequat ante aliquam nec. Nulla tempus ante eu sollicitudin rutrum. Sed ut venenatis nunc. Duis ut condimentum ipsum. Ut eleifend posuere ex sed lacinia. Cras laoreet odio lectus, vitae gravida ante consequat in., [{"id":63,"value":"K/C/O BPH GRADE 1","label":"K/C/O BPH GRADE 1"},{"id":62,"value":"K/C/O VARICOSE VEINS.","label":"K/C/O VARICOSE VEINS."},{"id":56,"value":"K/C/O UMBILICAL HERNIA","label":"K/C/O UMBILICAL HERNIA"},{"id":42,"value":"No other Co morbidities","label":"No other Co morbidities"}], [{"id":294,"value":294,"label":"1ST DEGREE HEMORRHOID AT 3 O' CLOCK"},{"id":293,"value":293,"label":"ANAL MUCOSA CONGESTION"},{"id":291,"value":291,"label":"7 AND 1 O' CLOCK"},{"id":290,"value":290,"label":"MULTIPLE SMALL SUBCUTANEOUS ABSCESS"}], <p class="text-left">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis mollis semper odio ut egestas. Nam tincidunt diam augue, a consequat ante aliquam nec. Nulla tempus ante eu sollicitudin rutrum. Sed ut venenatis nunc. Duis ut condimentum ipsum. Ut eleifend posuere ex sed lacinia. Cras laoreet odio lectus, vitae gravida ante consequat in.</p>, 2350, [{"id":461,"value":"FOLLOWUP CASE OF KSHARAKARMA","label":"FOLLOWUP CASE OF KSHARAKARMA"},{"id":458,"value":"BLEEDING PERSISTING (FOLLOW UP CASE OF HEMORRHOIDS \nLAST VISIT 21.3.25\nRECTAL MUCOSAL PROLAPSE)","label":"BLEEDING PERSISTING"},{"id":457,"value":"C/O SAME SYMPTOMS","label":"C/O SAME SYMPTOMS"}], 5 o'clock, 2026-01-22, [{"id":"019b8c54-896e-733e-a09f-35d2cd5c4958","value":"H/O SURGERY FOR FISTULA IN ANO - 3 TIMES","label":"H/O SURGERY FOR FISTULA IN ANO - 3 TIMES"},{"id":"019b83ee-71c7-724e-9c24-dda5b9b98883","value":"H/O INCISION AND DRAINAGE","label":"H/O INCISION AND DRAINAGE"},{"id":"019b5085-80d5-73d4-badf-80303c7108e0","value":"H/O CIRCUMCISION","label":"H/O CIRCUMCISION"}], 4 o'clock, 23#5, ?, ?, 4 o'clock, Posterior Midline, Intersphincteric, 32 degree, 9 o'clock, 6cm#At the level of anal verge, 1#3, Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis mollis semper odio ut egestas. Nam tincidunt diam augue, a consequat ante aliquam nec. Nulla tempus ante eu sollicitudin rutrum. Sed ut venenatis nunc. Duis ut condimentum ipsum. Ut eleifend posuere ex sed lacinia. Cras laoreet odio lectus, vitae gravida ante consequat in., 2, 3 o'clock, 2#4, 43, Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis mollis semper odio ut egestas. Nam tincidunt diam augue, a consequat ante aliquam nec. Nulla tempus ante eu sollicitudin rutrum. Sed ut venenatis nunc. Duis ut condimentum ipsum. Ut eleifend posuere ex sed lacinia. Cras laoreet odio lectus, vitae gravida ante consequat in., Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis mollis semper odio ut egestas. Nam tincidunt diam augue, a consequat ante aliquam nec. Nulla tempus ante eu sollicitudin rutrum. Sed ut venenatis nunc. Duis ut condimentum ipsum. Ut eleifend posuere ex sed lacinia. Cras laoreet odio lectus, vitae gravida ante consequat in., 019be030-db89-719b-bd2b-6bd896e8223c, 2026-01-21 16:24:16, 2026-01-21 16:24:16)) | t.intellispiders.in/releases/2... | Error | 22001 | https://hospitalapitest.intellispiders.in/api/consultations_update/019bdf3e-491c-7074-a2c7-8b0da05517d6 | PUT |
| 2 | Undefined variable $discountIncludeInvoiceAmount | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/reports/invoice_list?from_date=2026-01-21&page=1&to_date=2026-01-21 | GET |
| 3 | Undefined variable $discountIncludeInvoiceAmount | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/reports/invoice_list?from_date=2026-01-21&page=1&to_date=2026-01-21 | GET |
| 4 | Call to undefined method Illuminate\Database\Eloquent\Builder::orderBySub() | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=desc | GET |
| 5 | Call to undefined method Illuminate\Database\Eloquent\Builder::orderBySub() | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=asc | GET |
| 6 | Call to undefined method Illuminate\Database\Eloquent\Builder::orderBySub() | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=asc | GET |
| 7 | Call to undefined method Illuminate\Database\Eloquent\Builder::orderBySub() | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=asc | GET |
| 8 | Call to undefined method Illuminate\Database\Eloquent\Builder::orderBySub() | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=desc | GET |
| 9 | Attempt to read property "type" on array | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/invoice_details/019bd9f3-bf23-7028-abe3-55aeec37eb4f | GET |
| 10 | Attempt to read property "type" on array | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/invoice_details/019bd9f3-bf23-7028-abe3-55aeec37eb4f | GET |
| 11 | Attempt to read property "id" on null | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/prescription_download/019bdc32-f2ea-7383-b710-fef90d6bf615 | GET |
| 12 | Call to undefined method Illuminate\Database\Eloquent\Builder::orderBySub() | t.intellispiders.in/releases/2... | Error | 0 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=desc | GET |
| 13 | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoiceNumber' in 'ORDER BY' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: hospital_management_test, SQL: select `consultations`.`id`, `consultations`.`status`, `consultations`.`doctor_name`, `consultations`.`payment_status`, `consultations`.`patient_number`, `consultations`.`next_visit_date`, `consultations`.`appointment_number` from `consultations` where exists (select 1 from `invoice` where `invoice`.`consultation_id` = `consultations`.`id` and `invoice`.`invoice_number` is not null) order by `invoiceNumber` desc limit 25 offset 0) | t.intellispiders.in/releases/2... | Error | 500 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=desc | GET |
| 14 | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoice.invoice_number' in 'ORDER BY' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: hospital_management_test, SQL: select `consultations`.`id`, `consultations`.`status`, `consultations`.`doctor_name`, `consultations`.`payment_status`, `consultations`.`patient_number`, `consultations`.`next_visit_date`, `consultations`.`appointment_number` from `consultations` where exists (select 1 from `invoice` where `invoice`.`consultation_id` = `consultations`.`id` and `invoice`.`invoice_number` is not null) order by `invoice`.`invoice_number` desc limit 25 offset 0) | t.intellispiders.in/releases/2... | Error | 500 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=desc | GET |
| 15 | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoice_number' in 'ORDER BY' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: hospital_management_test, SQL: select `consultations`.`id`, `consultations`.`status`, `consultations`.`doctor_name`, `consultations`.`payment_status`, `consultations`.`patient_number`, `consultations`.`next_visit_date`, `consultations`.`appointment_number` from `consultations` where exists (select 1 from `invoice` where `invoice`.`consultation_id` = `consultations`.`id` and `invoice`.`invoice_number` is not null) order by `invoice_number` desc limit 25 offset 0) | t.intellispiders.in/releases/2... | Error | 500 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=desc | GET |
| 16 | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoice_number' in 'ORDER BY' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: hospital_management_test, SQL: select `consultations`.`id`, `consultations`.`status`, `consultations`.`doctor_name`, `consultations`.`payment_status`, `consultations`.`patient_number`, `consultations`.`next_visit_date`, `consultations`.`appointment_number` from `consultations` where exists (select 1 from `invoice` where `invoice`.`consultation_id` = `consultations`.`id` and `invoice`.`invoice_number` is not null) order by `invoice_number` desc limit 25 offset 0) | t.intellispiders.in/releases/2... | Error | 500 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=desc | GET |
| 17 | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoice_number' in 'ORDER BY' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: hospital_management_test, SQL: select `consultations`.`id`, `consultations`.`status`, `consultations`.`doctor_name`, `consultations`.`payment_status`, `consultations`.`patient_number`, `consultations`.`next_visit_date`, `consultations`.`appointment_number` from `consultations` where exists (select 1 from `invoice` where `invoice`.`consultation_id` = `consultations`.`id` and `invoice`.`invoice_number` is not null) order by `invoice_number` desc limit 25 offset 0) | t.intellispiders.in/releases/2... | Error | 500 | https://hospitalapitest.intellispiders.in/api/invoice_list?page=1&sort_by=invoice_number&sort_order=desc | GET |
| 18 | Validation error | field must be a valid UUID."]... | Error | 422 | https://hospitalapi.intellispiders.in/api/appointments_add | POST |
| 19 | Wrong number of segments | tellispiders.in/releases/20260... | Error | 0 | https://hospitalapi.intellispiders.in/api/logout | GET |
| 20 | Validation error | field must be a valid UUID."]... | Error | 422 | https://hospitalapi.intellispiders.in/api/appointments_add | POST |
| 21 | Validation error | e name has already been taken.... | Error | 422 | https://hospitalapi.intellispiders.in/api/medicines_add | POST |
| 22 | Validation error | field must be a valid UUID."]... | Error | 422 | https://hospitalapi.intellispiders.in/api/appointments_add | POST |
| 23 | Validation error | field must be a valid UUID."]... | Error | 422 | https://hospitalapi.intellispiders.in/api/appointments_add | POST |
| 24 | Invalid credentials | tellispiders.in/releases/20260... | Error | 0 | https://hospitalapi.intellispiders.in/api/login | POST |
| 25 | Invalid credentials | tellispiders.in/releases/20260... | Error | 0 | https://hospitalapi.intellispiders.in/api/login | POST |