Wed Apr 24 07:32:51 2024
An unhandled problem occurred in /var/www/html/dt_lib5/ManageDataInterface/MysqliWrapper.php on line 344
Error Message: mysqli_error() Unknown column 'distance' in 'order clause'
mysqli_errno is 1054
Trace Output: Array
(
[0] => Array
(
[file] => /var/www/html/dt_lib5/ManageDataInterface/MysqliWrapper.php
[line] => 257
[function] => resultCheck
[class] => dt_lib5\ManageDataInterface\MysqliWrapper
[type] => ->
[args] => Array
(
[0] =>
)
)
[1] => Array
(
[file] => /var/www/html/data_access/mysqli/Doctor/DoctorSearchRevisedDal.php
[line] => 327
[function] => prepare
[class] => dt_lib5\ManageDataInterface\MysqliWrapper
[type] => ->
[args] => Array
(
[0] => SELECT
d.doctor_id, d.doctor_uuid, d.doctor_display , d.created_timestamp, d.updated_timestamp,
dat_fn.doctor_attribute_to_doctor_value as first_name,
dat_ln.doctor_attribute_to_doctor_value as last_name , dat_dv.doctor_attribute_to_doctor_value as data_verified, dat_pfn.doctor_attribute_to_doctor_value as profile_file_name, dat_tc.doctor_attribute_to_doctor_value as title_code , s.specialty_label, dadd.* FROM
doctor d
INNER JOIN doctor_attribute_to_doctor dat_tc
ON d.doctor_id = dat_tc.doctor_id and dat_tc.doctor_attribute_id = 2
INNER JOIN doctor_address dadd ON d.doctor_id = dadd.doctor_id AND dadd.doctor_address_is_primary = 'yes' INNER JOIN doctor_attribute_to_doctor dat_fn
ON d.doctor_id = dat_fn.doctor_id and dat_fn.doctor_attribute_id = 3 INNER JOIN doctor_attribute_to_doctor dat_ln
ON d.doctor_id = dat_ln.doctor_id and dat_ln.doctor_attribute_id = 4 INNER JOIN doctor_attribute_to_doctor dat_dv
ON d.doctor_id = dat_dv.doctor_id and dat_dv.doctor_attribute_id = 43 INNER JOIN
(
specialty s
INNER JOIN specialty_to_doctor std ON s.specialty_id = std.specialty_id
)
ON d.doctor_id = std.doctor_id INNER JOIN doctor_attribute_to_doctor dat_ps ON d.doctor_id = dat_ps.doctor_id
and dat_ps.doctor_attribute_id = 52
AND
(
dat_ps.doctor_attribute_to_doctor_value = s.specialty_id
OR
dat_ps.doctor_attribute_to_doctor_value like CONCAT(s.specialty_id, ',%')
OR
dat_ps.doctor_attribute_to_doctor_value like CONCAT('%,',s.specialty_id, ',%')
OR
dat_ps.doctor_attribute_to_doctor_value like CONCAT('%,',s.specialty_id)
)
LEFT JOIN doctor_attribute_to_doctor dat_pfn
ON d.doctor_id = dat_pfn.doctor_id and dat_pfn.doctor_attribute_id = 34 WHERE d.doctor_display = 'show' ORDER BY distance asc LIMIT 0,10
)
)
[2] => Array
(
[file] => /var/www/html/search_results.php
[line] => 99
[function] => searchDoctor
[class] => DoctorSearchRevisedDal
[type] => ->
[args] => Array
(
[0] => Array
(
[title_code] => title_code
[specialty_label] => specialty_label
[profile_file_name] => profile_file_name
[data_verified] => data_verified
)
[1] => Array
(
[location] => Danforth, ME
[postal_code] =>
[specialty_label] =>
[insurance_company_label] =>
[gender] =>
[language] =>
[board_certified] =>
[data_verified] =>
[doctor_display] => show
[latitude] =>
[longitude] =>
)
[2] => distance
[3] => asc
[4] => 1
[5] => 10
[6] => Array
(
[language] => language
[gender] => gender
[board_certified] => board_certified
[data_verified] => data_verified
)
)
)
)
Error Code: 600100