Sorry, An error has occurred in this web page...

  • Back to the previous page.


  • Error Message: Variable USE2018DESIGN is undefined.
    The error occurred on line 477.


    Debugging Information
    ColdFusion Server Standard 9,0,0,251028
    Template /directory/dir_contact_edit.cfm
    Time Stamp 20-Jul-18 10:51 AM
    Locale English (US)
    User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
    Remote IP 54.162.128.159
    Host Name 54.162.128.159


    Execution Time

    Total Time Avg Time Count Template
    1253 ms 1253 ms 1 E:/www/aauapweb/aucd/directory/dir_contact_edit.cfm
    1139 ms 1139 ms 1 E:/www/aauapweb/aucd/include/dir_contact_edit.cfm
    1063 ms 1063 ms 1 E:/www/aauapweb/aucd/template/ct_lyris.cfm
    71 ms 71 ms 1 E:/www/aauapweb/aucd//error.cfm
    22 ms 22 ms 1 E:/www/aauapweb/aucd/Application.cfm
    22 ms 22 ms 1 E:/www/aauapweb/aucd/directory/Application.cfm
    15 ms 15 ms 1 E:/www/aauapweb/aucd/template/header_plain.cfm
    14 ms 14 ms 1 E:/www/aauapweb/aucd/template/header_2column.cfm
    13 ms 13 ms 1 E:/www/aauapweb/aucd/template/qry_menu.cfm
    8 ms 8 ms 1 E:/www/aauapweb/aucd/template/inc_header.cfm
    5 ms 5 ms 1 E:/www/aauapweb/aucd/template/common.cfm
    2 ms 2 ms 1 E:/www/aauapweb/aucd/include/body.cfm
    2 ms 2 ms 1 E:/www/aauapweb/aucd/template/inc_fourth.cfm
    0 ms 0 ms 1 E:/www/aauapweb/aucd/include/cmsview.cfm
    0 ms 0 ms 1 E:/www/aauapweb/aucd/template/ct_breadcrumbs.cfm
    0 ms 0 ms 1 E:/www/aauapweb/aucd/template/ct_session.cfm
    0 ms 0 ms 1 E:/www/aauapweb/aucd/template/udf.cfm
    55 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
    1401 ms  TOTAL EXECUTION TIME
    red = over 250 ms average execution time


    Exceptions

    10:51:07.007 - Application Exception - in E:/www/aauapweb/aucd/template/ct_lyris.cfm : line 56
    	    Cannot perform web service invocation EmailOnWhatLists.
    	    
    10:51:07.007 - Expression Exception - in E:/www/aauapweb/aucd/include/dir_contact_edit.cfm : line 477
    	    Variable USE2018DESIGN is undefined.
    	    


    SQL Queries

    qry_config (Datasource=aucd, Time=2ms, Records=88) in E:\www\aauapweb\aucd\template\common.cfm @ 10:51:06.006
    	SELECT name, value FROM config
    	WHERE
    		
    		host = 'remote' OR host = '' OR host is null
    		
    lang (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\common.cfm @ 10:51:06.006
    SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby
    
    page (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:51:06.006
    SELECT page.page_id, page.page_section, page.page_title, page.hide_search, page.hide_navigation,
    	page.owner, page.template, page.browser_title, page.meta_description, page.page_filename,
    	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_title
    		WHEN gparent.page_id IS NOT NULL THEN gparent.page_title
    		WHEN parent.page_id IS NOT NULL THEN parent.page_title
    		ELSE page.page_title END AS section_name,
    	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_id
    		WHEN gparent.page_id IS NOT NULL THEN gparent.page_id
    		WHEN parent.page_id IS NOT NULL THEN parent.page_id
    		ELSE page.page_id END AS section_id,
    	CASE WHEN ggparent.page_id IS NOT NULL THEN URL('',ggparent.page_filename,ggparent.page_id)
    		WHEN gparent.page_id IS NOT NULL THEN URL('',gparent.page_filename,gparent.page_id)
    		WHEN parent.page_id IS NOT NULL THEN URL('',parent.page_filename,parent.page_id)
    		ELSE URL('',page.page_filename,page.page_id) END AS section_filename,
    	CASE WHEN page.header_image IS NOT NULL THEN page.header_image
    		WHEN parent.header_image IS NOT NULL THEN parent.header_image
    		WHEN gparent.header_image IS NOT NULL THEN gparent.header_image
    		ELSE ggparent.header_image END AS header_image,
    	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
    	gparent.page_filename AS gparent_filename,
    	parent.page_title AS parent_name, parent.page_id AS parent_id,
    	parent.page_filename AS parent_filename
    FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
    	LEFT JOIN page AS gparent ON parent.page_section = gparent.page_id
    	LEFT JOIN page AS ggparent ON gparent.page_section = ggparent.page_id
    WHERE
    	
    		page.page_filename like '%directory/dir_contact_edit.cfm%' /* 5 */
    	
    	AND page.template NOT IN ('ITAC','NGSD','ECP')
    	
    		AND (page.IsTraineeSitePage = 0 or page.IsTraineeSitePage is null)
    	
    ORDER BY page_id
    
    getrole (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:51:06.006
    	SELECT code.code
    	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
    	WHERE fk_id = 0 
    parentinfo (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:51:06.006
    SELECT page.page_id, page.page_section, page.template, page.page_title,
    	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_title
    		WHEN gparent.page_id IS NOT NULL THEN gparent.page_title
    		WHEN parent.page_id IS NOT NULL THEN parent.page_title
    		ELSE page.page_title END AS section_name,
    	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_id
    		WHEN gparent.page_id IS NOT NULL THEN gparent.page_id
    		WHEN parent.page_id IS NOT NULL THEN parent.page_id
    		ELSE page.page_id END AS section_id,
    	CASE WHEN ggparent.page_id IS NOT NULL THEN URL('',ggparent.page_filename,ggparent.page_id)
    		WHEN gparent.page_id IS NOT NULL THEN URL('',gparent.page_filename,gparent.page_id)
    		WHEN parent.page_id IS NOT NULL THEN URL('',parent.page_filename,parent.page_id)
    		ELSE URL('',page.page_filename,page.page_id) END AS section_filename,
    	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
    	gparent.page_filename AS gparent_filename,
    	parent.page_title AS parent_name, parent.page_id AS parent_id,
    	parent.page_filename AS parent_filename
    FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
    	LEFT JOIN page AS gparent ON parent.page_section = gparent.page_id
    	LEFT JOIN page AS ggparent ON gparent.page_section = ggparent.page_id
    WHERE
    	
    	1=2
    	
    qry_menutop (Datasource=aucd, Time=8ms, Records=90) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:51:06.006
    	SELECT page.page_id, page.page_title, page.page_section, page.orderby, page.meta_description,
    		ifnull(parent.page_title,page.page_title) AS section_name,
    		URL('',page.page_filename,page.page_id) AS page_filename
    	FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
    	WHERE ifnull(page.hide_navigation,0) = 0 AND page.live = 1 AND
    		parent.page_section is null
    		
    		AND page.orderby <= 70000
    		AND (parent.page_id in (2,3,25,26,27,28,1,507,489) or
    			(parent.page_id is null and page.page_id <> 514))
    		AND (SELECT COUNT(*) FROM link_page_role WHERE fk_id = page.page_id AND code_id = 113) > 0
    		
    			AND (page.IsTraineeSitePage = 0 or page.IsTraineeSitePage is null)
    		
    		 
    	ORDER BY page.orderby
    
    submenu (Datasource=aucd, Time=2ms, Records=15) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:51:06.006
    SELECT page.page_id, page.page_title, page.orderby, 0 AS sub,
    	URL('',page.page_filename,page.page_id) AS page_filename
    FROM page
    WHERE page.live = 1 AND ifnull(page.hide_navigation,0)=0 
    	
    		AND ifnull(page.page_section,0) = 0 
    ORDER BY 3,2
    
    menu_network (Datasource=, Time=2ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:51:06.006
    SELECT * FROM qry_menutop
    WHERE section_name = 'Network Resources' AND page_section > 0 AND page_filename not like '%nirs%'
    ORDER BY orderby
    
    menu_home (Datasource=, Time=2ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:51:06.006
    SELECT * FROM qry_menutop
    WHERE section_name = 'Home' AND page_section > 0
    ORDER BY orderby
    
    issub (Datasource=, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:51:06.006
    	SELECT sub FROM submenu
    	WHERE page_id = 0 
    fourth (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:51:06.006
    	SELECT page.page_id, page.page_title, page.orderby,
    		CASE WHEN ifnull(page.page_filename,'') <> '' AND locate('?',page.page_filename) > 0
    		THEN concat(page.page_filename,'&parent=',page.page_section)
    		WHEN ifnull(page.page_filename,'') <> '' AND locate('?',page.page_filename) = 0
    		THEN concat(page.page_filename,'?parent=',page.page_section)
    		ELSE concat('template/page.cfm?id=',page.page_id,'&parent=',page.page_section) 
    		END AS page_filename
    	FROM page
    	WHERE
    		
    		1=2
    		
    	ORDER BY orderby
    	
    related (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\include\body.cfm @ 10:51:06.006
    SELECT page_module.link_id, page_type, page_module.title, page_module.orderby,
    	page_subtype, page_topic, page_layout, page_criteria, replace(module.type,' ','') AS type,
    	module.subtype, rssaddress, topic.topic_title, replace(page_module.custom,',',' ') as custom,
    	'' AS rss,
    	
    	concat_ws(',',page_module.detail1_id,page_module.detail2_id,page_module.detail3_id) AS detail_id
    	
    FROM page_module INNER JOIN module ON page_module.page_type = module.type AND (module.sidebar = 0 OR module.sidebar is null)
    	LEFT JOIN topic ON page_module.page_topic = topic.topic_id
    WHERE
    	
    		page_id = 0
    	
    ORDER BY page_module.orderby
    
    qry_dir (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    	SELECT
    		tbl_directory_staff.*,
    			(select group_concat(position_id)
    				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
    				where tbl_directory_staff_position.staffid = 0 and
    						tbl_directory_positions.section = "TP")
    		as lead_positions,
    			(select group_concat(position_id)
    				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
    				where tbl_directory_staff_position.staffid = 0 and
    						tbl_directory_positions.section = "PA")
    		as activ_coord_positions,
    			(select group_concat(position_id)
    				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
    				where tbl_directory_staff_position.staffid = 0 and
    						tbl_directory_positions.section = "DC")
    		as disc_coord_positions,
    			(select group_concat(code_id)
    				from crm_link_contact inner join crm_code on crm_link_contact.code_id = crm_code.id
    				where fk_id=0 and
    						crm_code.name = 'category' and crm_code.description like 'Trainees - %')
    		as categories
    	FROM tbl_directory_staff
    	WHERE tbl_directory_staff.staffid = 0 
    qry_login (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    		select 0 AS contact_id, '' AS username, '' AS password
    	
    qry_program (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    	select *
    	from tbl_directory_programs
    	where id = 0 
    qry_address (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    	select
    		address1,
    		address2,
    		city,
    		state,
    		zip
    	from tbl_directory_address
    	where program_id = 0 
    council (Datasource=aucd, Time=1ms, Records=7) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    	SELECT crm_group.group_id, crm_group.description,
    		crm_group.abbrev, link.code_id
    	FROM crm_group LEFT JOIN crm_link_contact_group AS link ON crm_group.group_id = link.code_id
    		AND link.fk_id = 0
    	WHERE public is null AND abbrev is not null
    	ORDER BY description
    
    qry_leadership (Datasource=aucd, Time=1ms, Records=21) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    		select min(id) AS id, position as description
    		from tbl_directory_positions
    		where section = 'TP'
    			
    		group by description
    		order by rank, description
    	
    qry_disc_coord (Datasource=aucd, Time=1ms, Records=27) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    	select min(id) AS id, position as description
    	from tbl_directory_positions
    	where section = 'DC'
    		
    	group by description
    	order by rank, description
    
    qry_activ_coord (Datasource=aucd, Time=1ms, Records=19) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    	select min(id) AS id, position as description
    	from tbl_directory_positions
    	where section = 'PA'
    		
    	group by description
    	order by rank, description
    
    sdhonly (Datasource=aucd, Time=1ms, Records=16) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    	select id
    	from tbl_directory_programs
    	where program_type = 'SDHG'
    
    lists (Datasource=aucd, Time=1ms, Records=19) in E:\www\aauapweb\aucd\include\dir_contact_edit.cfm @ 10:51:06.006
    	select group_id AS id, email_list, email_list as code, description
    	from crm_group
    	where public = 1
    	order by description
    


    Scope Variables

    CGI Variables:
    AUTH_PASSWORD=
    AUTH_TYPE=
    AUTH_USER=
    CERT_COOKIE=
    CERT_FLAGS=
    CERT_ISSUER=
    CERT_KEYSIZE=256
    CERT_SECRETKEYSIZE=2048
    CERT_SERIALNUMBER=
    CERT_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
    CERT_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
    CERT_SUBJECT=
    CF_TEMPLATE_PATH=E:\www\aauapweb\aucd\directory\dir_contact_edit.cfm
    CONTENT_LENGTH=
    CONTENT_TYPE=
    CONTEXT_PATH=
    GATEWAY_INTERFACE=CGI/1.1
    HTTPS=on
    HTTPS_KEYSIZE=256
    HTTPS_SECRETKEYSIZE=2048
    HTTPS_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
    HTTPS_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
    HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
    HTTP_ACCEPT_LANGUAGE=
    HTTP_CONNECTION=close
    HTTP_COOKIE=
    HTTP_HOST=www.aucd.org
    HTTP_REFERER=
    HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
    PATH_INFO=/directory/dir_contact_edit.cfm
    PATH_TRANSLATED=E:\www\aauapweb\aucd\directory\dir_contact_edit.cfm
    QUERY_STRING=staffid=0
    REMOTE_ADDR=54.162.128.159
    REMOTE_HOST=54.162.128.159
    REMOTE_USER=
    REQUEST_METHOD=GET
    SCRIPT_NAME=/directory/dir_contact_edit.cfm
    SERVER_NAME=www.aucd.org
    SERVER_PORT=443
    SERVER_PORT_SECURE=1
    SERVER_PROTOCOL=HTTP/1.1
    SERVER_SOFTWARE=Microsoft-IIS/7.5
    WEB_SERVER_API=
    
    Client Variables:
    cfid=22758146
    cftoken=40978349
    hitcount=1
    lastvisit={ts '2018-07-20 10:51:06'}
    timecreated={ts '2018-07-20 10:51:06'}
    urltoken=CFID=22758146&CFTOKEN=40978349
    
    Cookie Variables:
    CFID=22758146
    CFTOKEN=40978349
    
    Session Variables:
    cfg_admin_directory=/aucd_admin/
    cfg_article_url=../resources/digest/issue.cfm?article_id=
    cfg_authentication=HTML
    cfg_client_full_name=AUCD
    cfg_client_id=247
    cfg_client_short_name=AUCD
    cfg_database_type=mysql
    cfg_dateformat=m/d/yyyy
    cfg_doc_extension=doc,pdf,xls,txt,wpd,rtf,jpg,jpeg,gif,bmp,png,ppt,pps,mp3
    cfg_doc_path=/docs/
    cfg_ecp_feedback=bkaufman@AUCD.ORG
    cfg_ecp_share=bkaufman@AUCD.ORG
    cfg_editor_path=/tiny_mce/
    cfg_email_actearlynews_submission=agriffen@AUCD.ORG, oklimova@aucd.org
    cfg_email_council_cis=
    cfg_email_council_coca=
    cfg_email_council_core=
    cfg_email_council_mcc=oklimova@aucd.org
    cfg_email_council_ncedc=
    cfg_email_council_ntdc=
    cfg_email_developments_submission=lvaldez@aucd.org
    cfg_email_digest_submission=acostalas@AUCD.ORG
    cfg_email_hdd_submission=jminor@aucd.org
    cfg_email_lend_application_submission=jperry@AUCD.ORG
    cfg_email_pmu_submission=ynikola-lisa@aucd.org
    cfg_email_spotlight_submission=cpariseau@aucd.org
    cfg_email_stimulus=oklimova@aucd.org
    cfg_email_website_feedback=oklimova@aucd.org
    cfg_encoding=ISO-8859-1
    cfg_evaluation_review=agriffen@AUCD.ORG
    cfg_has_article_dept=Yes
    cfg_has_article_issue=Yes
    cfg_has_article_issuedept=Yes
    cfg_has_article_type=0
    cfg_has_crm=No
    cfg_has_document=0
    cfg_has_event_topic=Yes
    cfg_has_feature_home_page=0
    cfg_has_friendly_urls=No
    cfg_has_issue_number=Yes
    cfg_has_issue_summary=Yes
    cfg_has_issue_volume=Yes
    cfg_has_module_heading=Yes
    cfg_has_new_topic=Yes
    cfg_has_news_author=1
    cfg_has_news_topic=Yes
    cfg_has_person_address=0
    cfg_has_person_board=Yes
    cfg_has_person_country=0
    cfg_has_person_custom=Yes
    cfg_has_person_department=1
    cfg_has_person_fax=Yes
    cfg_has_person_photo=Yes
    cfg_has_photo_expiration=0
    cfg_has_sidebar=0
    cfg_has_topic_parent_id=0
    cfg_has_xml_import=0
    cfg_live_default=No
    cfg_log_number_of_months=4
    cfg_mail_from=aucdinfo@aucd.org
    cfg_mail_server=
    cfg_module_detail_options=3
    cfg_ngsd_about=681
    cfg_ngsd_email_notification=oklimova@aucd.org,drudolph@aucd.org,beckmanncc@umkc.edu,spalmer@ku.edu,walkerla@umkc.edu,ericecook@sbcglobal.net,gottog@umkc.edu
    cfg_ngsd_events=685
    cfg_ngsd_join_listserve=687
    cfg_ngsd_links=686
    cfg_ngsd_news=684
    cfg_ngsd_resources=683
    cfg_ngsd_topics=682
    cfg_ngsd_training=680
    cfg_paging_count_landing=3
    cfg_paging_count_list=15
    cfg_path=
    cfg_path_include=
    cfg_paths_relative_to=root
    cfg_person_notes_label=Notes
    cfg_photo_album_view=JavaScript:openNewWindow('../template/slideshow.cfm?album_id={{id}}',800,750);
    cfg_photo_path=/images2/
    cfg_remember_login=1
    cfg_rtoi_year=2012
    cfg_search_resilience=per session
    cfg_show_error_details=0
    cfg_sidebar_positions=Left,Right
    cfg_specific_items_days=730
    cfg_specific_items_sort=Name
    cfg_title=Content Management System
    cfg_type_link_to=code
    cfid=22758146
    cftoken=40978349
    sessionid=AUCDWEBSITE_22758146_40978349
    urltoken=CFID=22758146&CFTOKEN=40978349
    
    URL Parameters:
    staffid=0
    
    Debug Rendering Time: 34 ms