An ACEweb Error Occurred

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

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

            Current URL: https://registration.freeu.com:5000?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+Studio%2522&Title=Woodworks+Studio
                Referer: [none: bookmark, email, or manually-typed URL]
          Error Handler: Acecode.Error()
                  Build: AW3.EXE 20240227 (16:54:54 on 02/27/2024)
            Server Time: 04/16/2024 12:58:06 PM
           VFP Error No: 1231
                Message: Missing operand.
                Program: showschedule
                Line No: 15434
                   Code: .T. 
              Client IP: 3.17.150.163
     Authenticated User: 
           Exe Identity: SYSTEM
                Browser: claudebot
            HTTP Method: GET

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

Program Stack
No.	Object	Module	Line	Code
1.	.processhitbinary	wwserver.prg	807
2.	.processhit	wwserver.prg	720
3.	.process	acewebmain3.prg	1750
4.	acecode	acecode.prg	88
5.	acecode.process	acecode.prg	120
6.	wwprocess.process	wwprocess.prg	393
7.	acecode.routerequest	wwprocess.prg	481
8.	acecode.showschedule	acecode.prg	15434
9.	acecode.error	awprocess.prg	235
10.	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\0000JUHL0607.TMP	1	348
9	TSCHEDULE	C:\WINDOWS\TEMP\0000JUHL0603.TMP	EOF()	354
7	LOCATION	C:\MANAGER8\LOCATION.DBF	938	950
3	WWSESSION	C:\INETPUB\ACEWEB\WWSESSION.DBF	311,552	311,552
2	AWDB240416	C:\INETPUB\ACEWEB\AWDB240416.DBF	55,831	55,831
1	CGILOG	C:\INETPUB\ACEWEB\WWREQUESTLOG.DBF	759,381	759,381

[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	360.00 ( 360.00000000)
	__REGEX	Pub	O	VBSCRIPT REGULAR EXPRESSION
processhitbinary	LLFILE	Local	L	.F.
processhitbinary	LCRESULT	Local	L	.F.
processhit	LLFILE	Local	L	.F.
	LNSECONDS	Local	N	46685.809 ( 46685.80900000)
	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	".awp"
	STANDARD	Priv	O	AWSTANDARDTEMPLATE
	MINIMAL	Priv	O	AWMINIMALTEMPLATE
	PCSYSHOME	Priv	C	"C:\INETPUB\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	ACECODECONFIG
routerequest	LLERROR	Local	L	.F.
	LCPHYSICAL	Local	C	"c:\inetpub\wwwroot\wconnect\ShowSchedule.awp"
	LCCMD	Local	C	"THIS.showschedule()"
showschedule	LCTITLE	Local	L	.F.
	LLEXEMPT	Local	L	.F.
	LCNPARAMS	Local	L	.F.
	LAHEADS	Local	A
	LCCRITERIA	Local	C	"(ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMPTY(loclocat) )"
	LCHT1	Local	C	"<!DOCTYPE ..." 11750 bytes
	LCHT2	Local	C	"<div id="t..." 2236 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	"c:\manager8\"
	LCFLD	Local	L	.F.
	LCFULLMSG	Local	C	"<STRONG> Full</strong>"
	LNPOS	Local	L	.F.
	LCFIELDS	Local	C	"code:Code;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	.F.
	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	"C:\INETPUB\wwwroot\wconnect\ace\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..." 573 bytes
	LCTSQL	Local	C	"SELECT Cou..." 702 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	"20240416"
	__OVERRIDE	Priv	N	0 ( 0.00000000)
	PCTEST	Priv	C	"Logon Status Here"
	PCTITLE	Priv	C	"Woodworks Studio"
	PCDESCRIPT	Priv	C	""
	PCGROUP	Priv	C	""
	PCSORRY	Priv	C	""
	PCBONUSMSG	Priv	C	""
	PCSUBGROUP	Priv	C	""
	PCPREVIOUS	Priv	C	""
	PCURL	Priv	C	"https://registration.freeu.com/wconnect/ShowSchedule.awp?"
	LCEFINI	Priv	C	"C:\INETPUB\ACEWEB\ExpireFees.ini"
error	LNERROR	Local	N	1231 ( 1231.00000000)
	LCMETHOD	Local	C	"showschedule"
	LNLINE	Local	N	15434 ( 15434.00000000)
	LCBADBOTS	Local	L	.F.
	LCBROWSER	Local	C	"claudebot"
	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 20240227 (16:54:54 on 02/27/2024)"
	LLREST	Local	L	.F.
	LAFILES	Priv	A
errreport	LCTXT	Local	L	.F.
	LCUSER	Local	C	""
	LCIP	Local	C	"3.17.150.163"
	LCURL	Local	C	"https://registration.freeu.com:5000?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+Studio%2522&Title=Woodworks+Studio"
	LCOLDURL	Local	C	"[none: bookmark, email, or manually-typed URL]"
	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	"claudebot"
	LCTEMP	Local	L	***
	LCPWDFLDS	Local	L	.F.
	LCNAME	Local	L	.F.
	LCVALUE	Local	L	.F.
	LCIDENTITY	Local	C	"SYSTEM"
	LCBUILD	Local	C	"AW3.EXE 20240227 (16:54:54 on 02/27/2024)"
l7showmemory	LLNOHTML	Local	L	.F.
	LLUSEFORM	Local	L	.F.
	LCMEMORY	Local	L	.F.
	LCFILE	Local	C	"C:\WINDOWS\TEMP\46686184.TXT"
	LCSTYLE	Local	L	.F.
	LNAT	Local	L	.F.
ailable	16148	variables	a

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

Server Variables
PHYSICAL_PATH	c:\inetpub\wwwroot\wconnect\ShowSchedule.awp
QUERY_STRING
Criteria	ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+Studio%2522
Title	Woodworks+Studio
SCRIPT_NAME	/wconnect/ShowSchedule.awp
REQUESTID	908602292731306_27
DLLVERSION	Web Connection Handler 7.32.2 (.NET Handler)
WCCONFIG	c:\inetpub\wwwroot\wconnect\web.config
ADMIN_PAGE	/wconnect/admin/admin.aspx
APPL_WEB_PATH	http://registration.freeu.com:5000/WConnect
APPL_MD_PATH	/LM/W3SVC/1/ROOT/WConnect
APPL_PHYSICAL_PATH	c:\inetpub\wwwroot\wconnect\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH	0
CONTENT_TYPE
GATEWAY_INTERFACE	CGI/1.1
HTTPS	off
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID	1
INSTANCE_META_PATH	/LM/W3SVC/1
LOCAL_ADDR	172.31.106.12
PATH_INFO	/wconnect/ShowSchedule.awp
PATH_TRANSLATED	c:\inetpub\wwwroot\wconnect\ShowSchedule.awp
REMOTE_ADDR	172.31.32.178
REMOTE_HOST	172.31.32.178
REMOTE_PORT	52982
REQUEST_METHOD	GET
SERVER_NAME	registration.freeu.com
SERVER_PORT	5000
SERVER_PORT_SECURE	0
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	Microsoft-IIS/10.0
URL	/wconnect/ShowSchedule.awp
HTTP_ACCEPT	/
HTTP_HOST	registration.freeu.com
HTTP_USER_AGENT	claudebot
HTTP_X_FORWARDED_FOR	3.17.150.163
HTTP_X_FORWARDED_PROTO	https
HTTP_X_FORWARDED_PORT	443
HTTP_X_AMZN_TRACE_ID	Root=1-661eca3e-141cc2ca2a7ef76750d18c10

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

Trace Output
!!showschedule ! URL=http://registration.freeu.com:5000/wconnect/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+S... ! URL=http://registration.freeu.com:5000/wconnect/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+S... ! URL=http://registration.freeu.com:5000/wconnect/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+S... Data Mode=0 Data Path=c:\manager8\ / c:\manager8\ Data Mode=0 Data Path=c:\manager8\ / c:\manager8\ Data Mode=0 Data Path=c:\manager8\ / c:\manager8\ Data Mode=0 Data Path=c:\manager8\ / c:\manager8\ Data Mode=0 Data Path=c:\manager8\ / c:\manager8\ Data Mode=0 Data Path=c:\manager8\ / c:\manager8\ Data Mode=0 Data Path=c:\manager8\ / c:\manager8\ Data Mode=0 Data Path=c:\manager8\ / c:\manager8\ !!UserID = !!ShowSchedule .awp &Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+Studio%2522&Title=Woodworks+Studio Called by !Passed in Cursor Criteria=ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 Group= Cat Criteria= Passed in SQL criteria= Parameter Criteria=ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMPTY(loclocat) Title=Woodworks Studio Target= URL=https://registration.freeu.com/wconnect/ShowSchedule.awp? Mode= HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm Template INI=C:\INETPUB\wwwroot\wconnect\ace\ShowSchedule.INI Group= Ready for main query: code:Code;Course_Name:Title;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee Course_Name:Title; c... Joining location table Joining location table VFP: SELECT Course.* , Fees.* , locid, loclocat, locinfo, loccity, locstate, locudf1, locudf2, loccampus FROM Course JOI... Finished initial Course query: 362 records Session: IrJIBN5my8ZiZatg0 Finished initial Course query: 362 records Session: IrJIBN5my8ZiZatg0 Schedule with Fullfee: 354 records, grouped by cocrse !Finished supplemental queries. Record count= 354 !Finished supplemental queries. Record count= 354 !Finished supplemental queries. Record count= 354 Cursor Criteria=ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMPTY(loclocat) Extra Criteria= Criteria=(ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMPTY(loclocat) ) Groupmode=.F. Criteria applied to tSchedule. 354 records, done with Schedule queries Found 354 matching courses. Async? No Criteria to be applied=(ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMP...

Trace Output

!!showschedule
!  URL=http://registration.freeu.com:5000/wconnect/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+S...
!  URL=http://registration.freeu.com:5000/wconnect/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+S...
!  URL=http://registration.freeu.com:5000/wconnect/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+S...
Data Mode=0  Data Path=c:\manager8\ / c:\manager8\
Data Mode=0  Data Path=c:\manager8\ / c:\manager8\
Data Mode=0  Data Path=c:\manager8\ / c:\manager8\
Data Mode=0  Data Path=c:\manager8\ / c:\manager8\
Data Mode=0  Data Path=c:\manager8\ / c:\manager8\
Data Mode=0  Data Path=c:\manager8\ / c:\manager8\
Data Mode=0  Data Path=c:\manager8\ / c:\manager8\
Data Mode=0  Data Path=c:\manager8\ / c:\manager8\
!!UserID =  
!!ShowSchedule .awp &Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Woodworks+Studio%2522&Title=Woodworks+Studio Called by 
!Passed in Cursor Criteria=ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 Group= Cat Criteria= Passed in SQL criteria=
Parameter Criteria=ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMPTY(loclocat) 
Title=Woodworks Studio Target= URL=https://registration.freeu.com/wconnect/ShowSchedule.awp? Mode=
 HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm
 Template INI=C:\INETPUB\wwwroot\wconnect\ace\ShowSchedule.INI
 Group=
Ready for main query: code:Code;Course_Name:Title;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee  Course_Name:Title; c...
Joining location table
Joining location table

VFP: SELECT Course.* , Fees.* , locid, loclocat, locinfo, loccity, locstate, locudf1, locudf2, loccampus FROM Course JOI...
 Finished initial Course query: 362 records  Session: IrJIBN5my8ZiZatg0
 Finished initial Course query: 362 records  Session: IrJIBN5my8ZiZatg0
Schedule with Fullfee: 354 records, grouped by cocrse
!Finished supplemental queries.  Record count= 354
!Finished supplemental queries.  Record count= 354
!Finished supplemental queries.  Record count= 354
Cursor Criteria=ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMPTY(loclocat)  Extra Criteria=
Criteria=(ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMPTY(loclocat) ) Groupmode=.F.
Criteria applied to tSchedule. 354 records, done with Schedule queries
Found 354 matching courses.  Async? No Criteria to be applied=(ALLTRIM(LEFT(loclocat,40))==%22Woodworks Studio%22 AND !EMP...

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