Fatal error: Uncaught Exception: ERROR: oci_execute failed; message: ORA-00904: "CONCOM"."TERM": invalid identifier; query: SELECT con.contact_id,
last_name as lastname,
first_name as firstname,
middle_name as middlename,
suffix_name,
phone as office_phone,
street1,
street2,
city,
state,
zip,
replace(bio,'
','
') as bio,
class,
email,
hi_res_img_url,
display_class_as,
class as class_orig,
thumbnail as unc_search_img,
con.title as working_title,
concom.term as bog_committee_term,
com.committee_name as committee_name,
concom.title as bog_committee_title,
com.bog_committee_id as bog_committee_id,
com.tag as bog_committee_tag,
is_emeriti,
is_exofficio,
decode(concom.title, 'Chair', 'A', 'Vice Chair', 'B', 'Secretary','C') member_order,
decode(con.title, 'Chair', 'A', 'Vice Chair', 'B', 'Secretary','C') bog_member in /misc/osdatadev/dev/devwww2.northcarolina.edu/apps/system/functions/db_connectors/OracleDBDriver.php on line 259
Exception: ERROR: oci_execute failed; message: ORA-00904: "CONCOM"."TERM": invalid identifier; query: SELECT con.contact_id,
last_name as lastname,
first_name as firstname,
middle_name as middlename,
suffix_name,
phone as office_phone,
street1,
street2,
city,
state,
zip,
replace(bio,'
','
') as bio,
class,
email,
hi_res_img_url,
display_class_as,
class as class_orig,
thumbnail as unc_search_img,
con.title as working_title,
concom.term as bog_committee_term,
com.committee_name as committee_name,
concom.title as bog_committee_title,
com.bog_committee_id as bog_committee_id,
com.tag as bog_committee_tag,
is_emeriti,
is_exofficio,
decode(concom.title, 'Chair', 'A', 'Vice Chair', 'B', 'Secretary','C') member_order,
decode(con.title, 'Chair', 'A', 'Vice Chair', 'B', 'Secretary','C') bog_member_order
FROM
cp_contact con
left outer join cp_contact_bog_committee concom on con.contact_id=concom.contact_id
left outer join cp_bog_committee com on concom.bog_committee_id = com.bog_committee_id
WHERE
con.first_name is not null
and con.contact_role_id = 32
and con.is_active = 'Y' and con.class >= TO_CHAR(sysdate, 'YYYY') and con.contact_id = 7879 order by bog_member_order asc, sort_order,last_name,first_name in /misc/osdatadev/dev/devwww2.northcarolina.edu/apps/system/functions/db_connectors/OracleDBDriver.php on line 259
Call Stack:
0.0001 424888 1. {main}() /misc/osdatadev/dev/devwww2.northcarolina.edu/apps/content.php:0
0.5058 510968 2. cms_process_php() /misc/osdatadev/dev/devwww2.northcarolina.edu/apps/content.php:304
0.5059 529152 3. include('/misc/osdatadev/dev/devwww2.northcarolina.edu/apps/root/unc/campus_profiles/member.php') /misc/osdatadev/dev/devwww2.northcarolina.edu/apps/system/functions/cms_core.php:1006
0.5398 628752 4. bog_dirSearch->search() /misc/osdatadev/dev/devwww2.northcarolina.edu/apps/root/unc/campus_profiles/member.php:43
0.5399 630288 5. dbquery() /misc/osdatadev/dev/devwww2.northcarolina.edu/apps/root/unc/campus_profiles/bog_dirSearch.php:74