An ACEweb Error Occurred

Error: "Missing operand." in line 15221 of Acecode.showschedule

[program stack][data sessions][memory variables][server vars][trace output]

            Current URL: http://ww2.nscc.edu/wconnect/ShowSchedule.awp1?&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse=%255B17FOAD0028-2%255D&Title=Other+Dates&Descript=Catalog+Code:+OAD0028&&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse=%255B17FOAD0028-2%255D&Title=Other+Dates&Descript=Catalog+Code:+OAD0028
                Referer: http://ww2.nscc.edu/wconnect/ShowSchedule.awp1?&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse=%255B17FOAD0028-2%255D&Title=Other+Dates&Descript=Catalog+Code:+OAD0028
          Error Handler: Acecode.Error()
                  Build: AW3.EXE 20220927 (16:05:02 on 09/27/2022)
            Server Time: 04/19/2024 04:33:52 AM
           VFP Error No: 1231
                Message: Missing operand.
                Program: showschedule
                Line No: 15221
                   Code: .F. 
              Client IP: 3.143.218.146
     Authenticated User: 
           Exe Identity: SYSTEM
                Browser: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
            HTTP Method: GET

[back to top][program stack][data sessions][memory variables][server vars][trace output]

Program Stack
No.	Object	Module	Line	Code
1.	.processhit	wwserver.prg	716
2.	.process	acewebmain3.prg	1716
3.	acecode	acecode.prg	88
4.	acecode.process	acecode.prg	120
5.	wwprocess.process	wwprocess.prg	393
6.	acecode.routerequest	wwprocess.prg	481
7.	acecode.showschedule	acecode.prg	15221
8.	acecode.error	awprocess.prg	235
9.	acecode.errreport	awprocess.prg	546

[back to top][program stack][data sessions][memory variables][server vars][trace output]

Data Sessions

Data Session Open Workarea Information

No	Alias	Table	Record No.	Record Count
6	TSCHEDSHOW	C:\WINDOWS\TEMP\0000A5UH0CPE.TMP	1	26
8	TSCHEDULE	C:\WINDOWS\TEMP\0000A5UH0CPA.TMP	EOF()	127
3	WWSESSION	G:\INETPUB2\ACEWEB\WWSESSION.DBF	1,116,491	1,116,491
2	AWDB240419	G:\INETPUB2\ACEWEB\AWDB240419.DBF	13,698	13,698
1	CGILOG	G:\INETPUB2\ACEWEB\WWREQUESTLOG.DBF	1,315,626	1,315,626

[back to top][program stack][data sessions][memory variables][server vars][trace output]

List Memory
Module	Variable	Scope	Type	Value
PUBLIC	GOWCSERVER	Pub	O	ACEWEBSERVER
	__TIMEZONE	Pub	N	300.00 ( 300.00000000)
	__REGEX	Pub	O	VBSCRIPT REGULAR EXPRESSION
processhit	LLFILE	Local	L	.F.
	LNSECONDS	Local	N	16431.119 ( 16431.11900000)
	LCTIME	Local	L	.F.
	LOHTML	Local	L	.F.
acecode	LOSERVER	Local	O	ACEWEBSERVER
	LOPROCESS	Local	O	ACECODE
	REQUEST	(hid)	L	.NULL.
	RESPONSE	(hid)	L	.NULL.
	SERVER	(hid)	L	.NULL.
	SESSION	(hid)	L	.NULL.
	PROCESS	(hid)	L	.NULL.
process	OEVAL	Priv	O	WWEVAL
	OUTIL	Priv	O	AWUTILS
	MAPEXT	Priv	C	".awp1"
	STANDARD	Priv	O	AWSTANDARDTEMPLATE
	MINIMAL	Priv	O	AWMINIMALTEMPLATE
	PCSYSHOME	Priv	C	"G:\INETPUB2\ACEWEB\"
	OFACTORY	Priv	O	AWFACTORY
	SM71	Priv	L	.T.
	SM71B	Priv	L	.T.
	OBRIDGE	Priv	L	.NULL.
	PAGETITLE	Priv	C	"##pcTitle## ##Request.QueryString([SubGroup])##"
	OBIZ	Priv	O	AWBUSINESSOBJECT
	OJQCONFIG	Priv	O	JQUERYCONFIG
	VPATH	Priv	C	"/WConnect/"
	PROCESS	Priv	O	ACECODE
	SERVER	Priv	O	ACEWEBSERVER
	REQUEST	Priv	O	WWREQUEST
	RESPONSE	Priv	O	WWPAGERESPONSE40
	SESSION	Priv	O	WWSESSION
	CONFIG	Priv	O	XCONFIG
routerequest	LLERROR	Local	L	.F.
	LCPHYSICAL	Local	C	"G:\InetPub2\wwwroot\WConnect\ShowSchedule.awp1"
	LCCMD	Local	C	"THIS.showschedule()"
showschedule	LCTITLE	Local	L	.F.
	LLEXEMPT	Local	L	.F.
	LCNPARAMS	Local	L	.F.
	LAHEADS	Local	A
	LCCRITERIA	Local	C	"(cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D)"
	LCHT1	Local	C	"<!DOCTYPE ..." 8450 bytes
	LCHT2	Local	C	"<div id="t..." 2249 bytes
	LCHTCONFIG	Local	L	.F.
	LCKEYWORDS	Local	L	.F.
	LCMODE	Local	C	""
	LCORDERBY	Local	L	.F.
	LCTARGET	Local	C	""
	LCHT	Local	L	.F.
	LCPAGEFOOT	Local	L	.F.
	LCDP	Local	C	"G:\AceWare\manager7\"
	LCFLD	Local	L	.F.
	LCFULLMSG	Local	C	"<STRONG> FULL </STRONG>"
	LNPOS	Local	L	.F.
	LCFIELDS	Local	C	"Course_Name:Title; Begins:Begins; Ends:Ends; cocrsetm:Meets; FullFee:Fee,Course_Name:Title; cotype:Type; FullFee:Fee"
	LNNAMELEN	Local	N	95 ( 95.00000000)
	LLPRELIST	Local	L	.F.
	LLFULLFEE	Local	L	.T.
	LNCOLS	Local	L	.F.
	LNROWS	Local	L	.F.
	LLHASASYNC	Local	L	.T.
	LCTEMP	Local	C	**********************************************************************
	I	Local	N	***********************************************************************************
	LNOVERRIDE	Local	N	0 ( 0.00000000)
	LCSEARCH	Local	C	""
	LCLIB	Local	L	.F.
	LOIP	Local	L	.F.
	LCTEMPLATE	Local	C	""
	LCHTFILE	Local	C	"G:\InetPub2\wwwroot\wconnect\ace1\XShowSchedule.htm"
	LCPRESHOWN	Local	L	.F.
	LNLEN	Local	L	.F.
	LCSORRY	Local	L	.F.
	LCCURSOR	Local	L	.F.
	LCSOURCE	Local	L	.F.
	LLREORDER	Local	L	.F.
	LLSORRY	Local	L	.F.
	LCVSQL	Local	C	"SELECT Cou..." 449 bytes
	LCTSQL	Local	C	"SELECT Cou..." 578 bytes
	LLEBEXPIRE	Local	L	.F.
	LLSQL	Local	L	.F.
	LCGROUPBY	Local	C	"cocrse"
	LCDIALOGQS	Local	C	""
	LNCOUNT1	Local	L	.F.
	LLINSTRUCT	Local	L	.F.
	LLPACKAGE2	Local	L	.T.
	LCDAY	Priv	C	"20240419"
	__OVERRIDE	Priv	N	0 ( 0.00000000)
	PCTEST	Priv	C	"Logon Status Here"
	PCTITLE	Priv	C	"Other Dates"
	PCDESCRIPT	Priv	C	"Catalog Code: OAD0028"
	PCGROUP	Priv	C	""
	PCSORRY	Priv	C	""
	PCBONUSMSG	Priv	C	""
	PCSUBGROUP	Priv	C	""
	PCPREVIOUS	Priv	C	""
	PCURL	Priv	C	"https://ww2.nscc.edu/wconnect/ShowSchedule.awp1?"
	LCEFINI	Priv	C	"G:\INETPUB2\ACEWEB\ExpireFees.ini"
error	LNERROR	Local	N	1231 ( 1231.00000000)
	LCMETHOD	Local	C	"showschedule"
	LNLINE	Local	N	15221 ( 15221.00000000)
	LCBADBOTS	Local	L	.F.
	LCBROWSER	Local	C	"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
	LCEPILOGUE	Local	L	.F.
	LCPROLOGUE	Local	L	.F.
	LCTITLE	Local	L	.F.
	LLSENDTHIS	Local	L	.F.
	LOEXC	Local	L	.F.
	I	Local	L	***
	LCBUILD	Local	C	"AW3.EXE 20220927 (16:05:02 on 09/27/2022)"
	LLREST	Local	L	.F.
	LAFILES	Priv	A
errreport	LCTXT	Local	L	.F.
	LCUSER	Local	C	""
	LCIP	Local	C	"3.143.218.146"
	LCURL	Local	C	"http://ww2..." 326 bytes
	LCOLDURL	Local	C	"<a href="h..." 387 bytes
	LCTOPLINK	Local	C	"<a class="DebugInfoSectionLinks" href="#Top">[back to top]</a>"
	LLREQUEST	Local	L	.F.
	LCPROLOGUE	Local	L	.F.
	LCSTYLE	Local	L	.F.
	LCEPILOGUE	Local	L	.F.
	LCMSG	Local	L	.F.
	LCPAGEMENU	Local	C	"<a class="DebugInfoSectionLinks" href="#ProgramStack">[program stack]</a><a class="DebugInfoSectionLinks" href="#DataSessions">[data sessions]</a>"
	LCMAILMENU	Local	C	""
	LCOLDERROR	Local	L	.F.
	LCBROWSER	Local	C	"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
	LCTEMP	Local	L	***
	LCPWDFLDS	Local	L	.F.
	LCNAME	Local	L	.F.
	LCVALUE	Local	L	.F.
	LCIDENTITY	Local	C	"SYSTEM"
	LCBUILD	Local	C	"AW3.EXE 20220927 (16:05:02 on 09/27/2022)"
l7showmemory	LLNOHTML	Local	L	.F.
	LLUSEFORM	Local	L	.F.
	LCMEMORY	Local	L	.F.
	LCFILE	Local	C	"C:\WINDOWS\TEMP\16431400.TXT"
	LCSTYLE	Local	L	.F.
	LNAT	Local	L	.F.
ailable	16154	variables	a

[back to top][program stack][data sessions][memory variables][server vars][trace output]

Server Variables
DLLVersion	Web Connection 7.25 (ISAPI Handler)
REQUESTID	3780_102409D73936
wcConfig	G:\InetPub2\wwwroot\WConnect\wc.INI
REQUEST_METHOD	GET
QUERY_STRING
Criteria	cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse=%255B17FOAD0028-2%255D
Title	Other+Dates
Descript	Catalog+Code:+OAD0028
Executable Path	/wconnect/ShowSchedule.awp1
CONTENT_LENGTH	0
PATH_INFO	/wconnect/ShowSchedule.awp1
PATH_TRANSLATED	G:\InetPub2\wwwroot\WConnect\ShowSchedule.awp1
SCRIPT_NAME	/wconnect/ShowSchedule.awp1
PHYSICAL_PATH	G:\InetPub2\wwwroot\WConnect\ShowSchedule.awp1
WEBROOT_PATH	G:\InetPub2\wwwroot
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	Microsoft-IIS/10.0
SERVER_NAME	ww2.nscc.edu
SERVER_PORT	443
SERVER_ACCOUNT	SYSTEM
REMOTE_HOST	3.143.218.146
REMOTE_ADDR	3.143.218.146
HTTP_REFERER	http://ww2.nscc.edu/wconnect/ShowSchedule.awp1?
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT	/
APPL_PHYSICAL_PATH	G:\InetPub2\wwwroot\WConnect\
APPL_MD_PATH	/LM/W3SVC/1/ROOT/WConnect
HTTP_CONNECTION	close
CACHE_URL	https://ww2.nscc.edu:443:192.168.212.69/wconnect/ShowSchedule.awp1?
CERT_KEYSIZE	256
CERT_SECRETKEYSIZE	2048
CERT_SERVER_SUBJECT	C=US, S=Tennessee, O=Nashville State Technical Community College, CN=*.nscc.edu
CERT_SERVER_ISSUER	C=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Organization Validation Secure Server CA
SCRIPT_TRANSLATED	\\?\G:\InetPub2\wwwroot\WConnect\ShowSchedule.awp1
APP_POOL_ID	West Wind WebConnection
GMT_OFFSET	-21600
ALL_HTTP (Variables previously displayed will not be shown below)
HTTP_HOST	ww2.nscc.edu
Criteria	cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D
Title	Other Dates
Descript	Catalog Code: OAD0028
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; claudebot@anthropic.com)

[back to top][program stack][data sessions][memory variables][server vars][trace output]

Trace Output
!!showschedule ! URL=https://ww2.nscc.edu/wconnect/ShowSchedule.awp1?&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse... ! URL=https://ww2.nscc.edu/wconnect/ShowSchedule.awp1?&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse... ! URL=https://ww2.nscc.edu/wconnect/ShowSchedule.awp1?&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse... Data Mode=0 Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\ Data Mode=0 Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\ Data Mode=0 Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\ Data Mode=0 Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\ Data Mode=0 Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\ Data Mode=0 Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\ Data Mode=0 Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\ Data Mode=0 Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\ !!ShowSchedule .awp1 &Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse=%255B17FOAD0028-2%255D&Title=Othe... !Passed in Cursor Criteria=cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D Group= Cat Criteria= Passed ... SQL Injection check Parameter Criteria=cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D Title=Other Dates Target= URL=https://ww2.nscc.edu/wconnect/ShowSchedule.awp1? Mode= HTML Template=G:\InetPub2\wwwroot\wconnect\ace1\XShowSchedule.htm Template INI=G:\InetPub2\wwwroot\wconnect\ace1\ShowSchedule.INI Group= Ready for main query: Course_Name:Title; Begins:Begins; Ends:Ends; cocrsetm:Meets; FullFee:Fee Course_Name:Title; cotype:... Ready for main query: Course_Name:Title; Begins:Begins; Ends:Ends; cocrsetm:Meets; FullFee:Fee Course_Name:Title; cotype:... VFP: SELECT Course.* , Fees.* FROM Course JOIN Fees ON UPPER(fecrse) == UPPER(cocrse) AND NOT fees.fewebhide AND (fees.f... Finished initial Course query: 129 records Session: ARkDdwSjvIhnkX6T0 Finished initial Course query: 129 records Session: ARkDdwSjvIhnkX6T0 Schedule with Fullfee: 127 records, grouped by cocrse !Finished supplemental queries. Record count= 127 !Finished supplemental queries. Record count= 127 !Finished supplemental queries. Record count= 127 Cursor Criteria=cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D Extra Criteria= Criteria=(cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D) Groupmode=.F. Criteria applied to tSchedule. 127 records, done with Schedule queries Found 127 matching courses. Async? Yes Criteria to be applied=(cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0...

Trace Output

!!showschedule
!  URL=https://ww2.nscc.edu/wconnect/ShowSchedule.awp1?&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse...
!  URL=https://ww2.nscc.edu/wconnect/ShowSchedule.awp1?&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse...
!  URL=https://ww2.nscc.edu/wconnect/ShowSchedule.awp1?&Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse...
Data Mode=0  Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\
Data Mode=0  Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\
Data Mode=0  Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\
Data Mode=0  Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\
Data Mode=0  Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\
Data Mode=0  Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\
Data Mode=0  Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\
Data Mode=0  Data Path=G:\AceWare\manager7\ / G:\AceWare\manager7\
!!ShowSchedule .awp1 &Criteria=cocatcode=%255BOAD0028%2520%2520%2520%255D+AND+NOT+cocrse=%255B17FOAD0028-2%255D&Title=Othe...
!Passed in Cursor Criteria=cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D Group= Cat Criteria= Passed ...
SQL Injection check
Parameter Criteria=cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D
Title=Other Dates Target= URL=https://ww2.nscc.edu/wconnect/ShowSchedule.awp1? Mode=
 HTML Template=G:\InetPub2\wwwroot\wconnect\ace1\XShowSchedule.htm
 Template INI=G:\InetPub2\wwwroot\wconnect\ace1\ShowSchedule.INI
 Group=
Ready for main query: Course_Name:Title; Begins:Begins; Ends:Ends; cocrsetm:Meets; FullFee:Fee  Course_Name:Title; cotype:...
Ready for main query: Course_Name:Title; Begins:Begins; Ends:Ends; cocrsetm:Meets; FullFee:Fee  Course_Name:Title; cotype:...

VFP: SELECT Course.* , Fees.* FROM Course JOIN Fees ON UPPER(fecrse) == UPPER(cocrse) AND NOT fees.fewebhide AND (fees.f...
 Finished initial Course query: 129 records  Session: ARkDdwSjvIhnkX6T0
 Finished initial Course query: 129 records  Session: ARkDdwSjvIhnkX6T0
Schedule with Fullfee: 127 records, grouped by cocrse
!Finished supplemental queries.  Record count= 127
!Finished supplemental queries.  Record count= 127
!Finished supplemental queries.  Record count= 127
Cursor Criteria=cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D Extra Criteria=
Criteria=(cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0028-2%5D) Groupmode=.F.
Criteria applied to tSchedule. 127 records, done with Schedule queries
Found 127 matching courses.  Async? Yes Criteria to be applied=(cocatcode=%5BOAD0028%20%20%20%5D AND NOT cocrse=%5B17FOAD0...

[back to top][program stack][data sessions][memory variables][server vars][trace output]