Fatal Error: PostgreSQL: ERROR: 42883: operator does not exist: integer = boolean LINE 9: WHERE ip_address_valid=true AND access_allowed=true ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. LOCATION: op_error, src\backend\parser\parse_oper.c:722 (# 42883)

SQL query: SELECT * FROM ( SELECT x.task_id, x.task_desc, x.script_id, x.pattern_id, mnu_nav_button.button_text, mnu_nav_button.context_preselect, (SELECT 1 FROM mnu_role_task WHERE task_id=mnu_nav_button.task_id_jnr AND role_id IN('H_GM') LIMIT 1) AS access_allowed, true AS ip_address_valid, mnu_nav_button.sort_seq FROM mnu_nav_button LEFT JOIN mnu_task ON (mnu_task.task_id = mnu_nav_button.task_id_snr) LEFT JOIN mnu_task AS x ON (x.task_id = mnu_nav_button.task_id_jnr) WHERE x.is_disabled='N' AND mnu_task.task_id='mnu_motd(show)' ) AS x WHERE ip_address_valid=true AND access_allowed=true ORDER BY sort_seq asc

Error in line 722 of file 'D:\Pet\PHP Full Env\UwAmp\www\radpg184\includes\dml.pgsql.class.inc'.

(SELECT 1 FROM mnu_role_task WHERE task_id=mnu_nav_button.task_id_jnr AND role_id IN('H_GM') LIMIT 1) AS access_allowed

true

EXISTS(SELECT 1 FROM mnu_role_task WHERE task_id=mnu_nav_button.task_id_jnr AND role_id IN('H_GM') LIMIT 1) AS access_allowed