Debugging Information
ColdFusion Server Standard |
2016,0,16,320445 |
Template |
/officials.cfm |
Time Stamp |
24-Apr-24 04:57 PM |
Locale |
English (US) |
User Agent |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote IP |
10.20.230.5 |
Host Name |
10.20.230.5 |
Execution Time
Total Time |
Avg Time |
Count |
Template |
156 ms |
156 ms |
1 |
D:\inetpub\PublicPages\officials.cfm |
109 ms |
109 ms |
1 |
D:/inetpub/PublicPages/meetingOfficials.cfm |
31 ms |
31 ms |
1 |
D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm |
16 ms |
8 ms |
2 |
D:/inetpub/PublicPages/agpub_client_defines.cfm |
0 ms |
0 ms |
1 |
D:/inetpub/PublicPages/Application.cfm |
0 ms |
0 ms |
1 |
D:/inetpub/PublicPages/blueMenu.cfm |
0 ms |
0 ms |
1 |
D:/inetpub/PublicPages/menu_tabs.cfm |
0 ms |
0 ms |
1 |
D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm |
0 ms |
0 ms |
1 |
D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm |
0 ms |
0 ms |
1 |
D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm |
0 ms |
0 ms |
1 |
D:/inetpub/PublicPages/public/publish/customHeader.cfm |
0 ms |
0 ms |
1 |
D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm |
0 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
156 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
Exceptions
16:57:31.031 - Database Exception - in D:/inetpub/PublicPages/meetingOfficials.cfm : line 598
Error Executing Database Query.
SQL Queries
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 16:57:31.031
select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 16:57:31.031
select c.misc_alpha9 tz, c2.misc_alpha tz_offset
from codes c
left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 16:57:31.031
select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 16:57:31.031
select c.misc_alpha9 tz, c2.misc_alpha tz_offset
from codes c
left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\officials.cfm @ 16:57:31.031
SELECT dist_name FROM fasinfo
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 16:57:31.031
select top 1 * from codes
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
FROM meeting_type mt
LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
WHERE mt.show_public = 'Y'
ORDER BY mt.descr
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
select text_value1 notify_public_contact, long_descr confLink
from codes
where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT c.*,
c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
from codes c
LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
select text_value1 notify_public_contact, long_descr confLink
from codes
where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
select valid_code
from codes
where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
select fasinfo.*,
c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
from fasinfo
left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
select text_value1, misc_alpha public_window, loc_code allowExtNotes
from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT MIN(fis_yr) fis_yr FROM fas
WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT MAX(fis_yr) fis_yr
FROM fas
WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT MIN(coll_name) coll_name FROM verity_collections
ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
FROM codes c
WHERE c.code_type = 'AG TIME'
OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
AND (opt_form_id = '' OR opt_form_id IS NULL)
get_agendas (Datasource=frsRO, Time=16ms, Records=12) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:57:31.031
SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
minutes.minutes_published, a.agenda_published,
a.minutes_doc_name, a.minutes_doc_link, a.default_doc_dir,
minutes.default_doc_dir minutes_default_doc_dir,
a.packet_doc_name, a.packet_published,
minutes.form_num as min_form_num, minutes.minutes_packet_published,
minutes.minutes_packet_name,
ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
min_links.link_label as min_link_label, min_links.link_url as min_link_url,
rel.large_misc_alpha as release_date, agt.meeting_type
FROM meetings AS m
INNER JOIN agenda AS a ON (
a.meeting_id = m.meeting_id AND
(a.agenda_published = 'Y' OR a.packet_published = 'Y')
)
LEFT OUTER JOIN minutes ON (
minutes.meeting_id = m.meeting_id AND
(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
)
INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
)
LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
LEFT OUTER JOIN form_links AS ag_links ON (
ag_links.form_id = 'AGENDA' AND
ag_links.form_num = a.form_num AND
ag_links.link_seq = 1
)
LEFT OUTER JOIN form_links AS min_links ON (
min_links.form_id = 'MINUTES' AND
min_links.form_num = minutes.form_num AND
min_links.rev_num = minutes.rev_num AND
min_links.link_seq = 1
)
WHERE m.meeting_dt >= ?
AND m.meeting_dt <= ?
ORDER BY m.meeting_dt DESC, m.meeting_name
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2020-01-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2020-01-31 00:00:00.0
pageTitle (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
SELECT menu_label FROM fas_menu WHERE web_page = '../fas/term_report.cfm'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
SELECT * FROM fasinfo
get_fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
SELECT use_minutes, use_agendaquick, term_remind_days, c.misc_alpha4 hosted
FROM fasinfo
LEFT OUTER JOIN codes c ON (c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup')
checkCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
SELECT * from codes WHERE code_type = 'FORM_ID' AND valid_code = 'AG_MEMO'
OfficialsMeetingTypes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
SELECT mt.meeting_type, mt.descr, c.long_descr notify_public, c.misc_alpha15 meetingOfficials
FROM meeting_type mt
INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
WHERE mt.show_public = 'Y' and c.misc_alpha15 = 'Y'
ORDER BY mt.descr
getRecs (Datasource=frsRO, Time=0ms, Records=53) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
select tt._rowid tt_rowid, tt.*, codes.valid_code, codes.long_descr, codes.dataSortOrder, mt.descr
from codes, term_tracker tt
INNER JOIN meeting_type mt ON (mt.meeting_type = tt.meeting_type AND mt.obsolete <> 'Y')
INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = tt.meeting_type AND c.misc_alpha15 = 'Y')
where codes._rowid = tt.code_rowid and
codes.code_type = 'AG_OFF'
and (tt.term_end >= ? )
order by
tt.meeting_type, tt.lname, tt.fname
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2024-04-24 16:57:31.659
getRecsCount (Datasource=, Time=0ms, Records=53) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
SELECT * from getRecs
getRecs2 (Datasource=, Time=0ms, Records=53) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
SELECT * from getRecs
getMeetingTypes (Datasource=frsRO, Time=15ms, Records=8) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 16:57:31.031
SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
FROM meeting_type mt
LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
WHERE mt.show_public = 'Y' and c.misc_alpha15 = 'Y'
AND CAST(mt.pdf_header as varchar) <> 'N'
ORDER BY mt.descr
Scope Variables
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\officials.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//officials.cfm?seq=379&report=OFFICIAL&rowid=&off=CE3583&MT=ALL&GET_MONTH=1&SSTR=&LOGIN=&FP=&DSP=&id=&SUB=&LOC=&GET_YEAR=2020&ln=0&StartRow=1
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\officials.cfm
QUERY_STRING=seq=379&report=OFFICIAL&rowid=&off=CE3583&MT=ALL&GET_MONTH=1&SSTR=&LOGIN=&FP=&DSP=&id=&SUB=&LOC=&GET_YEAR=2020&ln=0&StartRow=1
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/officials.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=9262392
cftoken=b8d8632397dbdb1-B9433A36-E73F-1368-17281F9F1CB34D7D
hitcount=4
lastvisit={ts '2024-04-24 16:57:31'}
timecreated={ts '2024-04-24 16:57:31'}
urltoken=CFID=9262392&CFTOKEN=b8d8632397dbdb1-B9433A36-E73F-1368-17281F9F1CB34D7D
Cookie Variables:
CFID=9262392
CFTOKEN=b8d8632397dbdb1-B9433A36-E73F-1368-17281F9F1CB34D7D
Form Fields:
FROMDATE={ts '2023-04-24 16:57:31'}
FROMVOTEDATE={ts '2023-04-24 16:57:31'}
FROMVOTEYEAR=2023
MODE=
TODATE={ts '2024-04-24 16:57:31'}
TOVOTEDATE={ts '2024-04-24 16:57:31'}
Session Variables:
cfid=9262392
cftoken=b8d8632397dbdb1-B9433A36-E73F-1368-17281F9F1CB34D7D
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9262392_b8d8632397dbdb1-B9433A36-E73F-1368-17281F9F1CB34D7D
subdir=/public/
tzoffset=0
urltoken=CFID=9262392&CFTOKEN=b8d8632397dbdb1-B9433A36-E73F-1368-17281F9F1CB34D7D
URL Parameters:
DSP=
FP=
GET_MONTH=1
GET_YEAR=2020
LOC=
LOGIN=
MT=ALL
SSTR=
SUB=
StartRow=1
id=
ln=0
off=CE3583
report=OFFICIAL
rowid=
seq=379
Debug Rendering Time: 0 ms
|