Ward Round Sheet search function gives error

Bug #410713 reported by ugm6hr
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Hospital Handover Database
New
Undecided
Unassigned

Bug Description

From Ward Round Sheet, using the Advanced Search does not work. Irrespective of text entry in Search box, it errors as follows:

PHP error happened
Technical information
Error type 256
Error description Unknown column 'consultants.Consultant' in 'where clause'
URL 192.168.1.200/Ward_Round_Sheet_list.php?
Error file /var/www/include/dbconnection.php
Error line 26
SQL query select `Primary`, `Patient Name`, `Date of Birth`, `Unit Number`, `Sex`, `Ward`, `Bed`, `Consultant`, `Code`, `Category`, `Admission Date`, `Diagnosis`, `Allergies`, `Notes`, `Nurses`, `Social Services`, `Team`, `Ward Round Notes` From `patients` WHERE (`Category` = "Inpatient") and (1=1 and upper(`consultants`.`Consultant`) like upper('%A%')) ORDER BY `Consultant` ASC

The column entry should be `Consultant` rather than `consultants.Consultant` but I am unable to find the string relating to the query.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.