An ACEweb Error Occurred

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

[program stack][data sessions][memory variables][server vars][trace output]
            Current URL: https://ace.capetigers.com/wconnect/ace/ShowSchedule.awp?&Criteria=cocatcode=%255B414%2520%2520%2520%2520%2520%2520%2520%255D+AND+NOT+cocrse=%255B22FSIM41409%2520%255D&Title=Other+Dates
                Referer: [none: bookmark, email, or manually-typed URL]
          Error Handler: Acecode.Error()
                  Build: AW3.EXE 20230207 (12:07:54 on 02/07/2023)
            Server Time: 03/28/2024 04:24:55 PM
           VFP Error No: 1231
                Message: Missing operand.
                Program: showschedule
                Line No: 15267
                   Code: .T. 
              Client IP: 10.1.3.251
     Authenticated User: 
           Exe Identity: AWSA
                Browser: claudebot
            HTTP Method: GET
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Program Stack
No.ObjectModuleLineCode
1. .processhit wwserver.prg 720
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 15267
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
DSData Session Open Workarea Information
1
NoAliasTableRecord No.Record Count
5TSCHEDSHOWC:\WINDOWS\TEMP\00005P950289.TMP 1 32
7TSCHEDULEC:\WINDOWS\TEMP\00005P950285.TMPEOF() 32
2WWSESSIONC:\INETPUB\ACEWEB\WWSESSION.DBF 34,026 34,026
1CGILOGC:\INETPUB\ACEWEB\WWREQUESTLOG.DBF 90,446 90,446
[back to top][program stack][data sessions][memory variables][server vars][trace output]
List Memory
ModuleVariableScopeTypeValue
PUBLIC GOWCSERVERPubO ACEWEBSERVER
__TIMEZONEPubN 300.00 ( 300.00000000)
__REGEXPubO VBSCRIPT REGULAR EXPRESSION
processhit LLFILELocalL .F.
LNSECONDSLocalN 59093.872 ( 59093.87200000)
LCTIMELocalL .F.
LOHTMLLocalL .F.
acecode LOSERVERLocalO ACEWEBSERVER
LOPROCESSLocalO ACECODE
REQUEST(hid)L .NULL.
RESPONSE(hid)L .NULL.
SERVER(hid)L .NULL.
SESSION(hid)L .NULL.
PROCESS(hid)L .NULL.
process OEVALPrivO WWEVAL
OUTILPrivO AWUTILS
MAPEXTPrivC ".awp"
STANDARDPrivO AWSTANDARDTEMPLATE
MINIMALPrivO AWMINIMALTEMPLATE
PCSYSHOMEPrivC "C:\INETPUB\ACEWEB\"
OFACTORYPrivO AWFACTORY
SM71PrivL .T.
SM71BPrivL .T.
OBRIDGEPrivL .NULL.
PAGETITLEPrivC "##pcTitle## ##Request.QueryString([SubGroup])##"
OBIZPrivO AWBUSINESSOBJECT
OJQCONFIGPrivO JQUERYCONFIG
VPATHPrivC "/wconnect/"
PROCESSPrivO ACECODE
SERVERPrivO ACEWEBSERVER
REQUESTPrivO WWREQUEST
RESPONSEPrivO WWPAGERESPONSE40
SESSIONPrivO WWSESSION
CONFIGPrivO ACECODECONFIG
routerequest LLERRORLocalL .F.
LCPHYSICALLocalC "c:\inetpub\wwwroot\wconnect\ace\ShowSchedule.awp"
LCCMDLocalC "THIS.showschedule()"
showschedule LCTITLELocalL .F.
LLEXEMPTLocalL .F.
LCNPARAMSLocalL .F.
LAHEADSLocalA
LCCRITERIALocalC "(cocatcode=%5B414%20%20%20%20%20%20%20%5D AND NOT cocrse=%5B22FSIM41409%20%5D)"
LCHT1LocalC "<!DOCTYPE ..." 4342 bytes
LCHT2LocalC "<div id="t..." 2249 bytes
LCHTCONFIGLocalL .F.
LCKEYWORDSLocalL .F.
LCMODELocalC ""
LCORDERBYLocalL .F.
LCTARGETLocalC ""
LCHTLocalL .F.
LCPAGEFOOTLocalL .F.
LCDPLocalC "\\ctcapps\manager6\"
LCFLDLocalL .F.
LCFULLMSGLocalC "<STRONG> (Closed)*</strong>"
LNPOSLocalL .F.
LCFIELDSLocalC "Course_Name:Course Name;Begins:Begins;Ends:Ends;Meets:Meets;FullFee:Fee,Course_Name:Title; cotype:Type; FullFee:Fee"
LNNAMELENLocalN 95 ( 95.00000000)
LLPRELISTLocalL .F.
LLFULLFEELocalL .T.
LNCOLSLocalL .F.
LNROWSLocalL .F.
LLHASASYNCLocalL .T.
LCTEMPLocalC **********************************************************************
ILocalN ***********************************************************************************
LNOVERRIDELocalN 0 ( 0.00000000)
LCSEARCHLocalC ""
LCLIBLocalL .F.
LOIPLocalL .F.
LCTEMPLATELocalC ""
LCHTFILELocalC "C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm"
LCPRESHOWNLocalL .F.
LNLENLocalL .F.
LCSORRYLocalL .F.
LCCURSORLocalL .F.
LCSOURCELocalL .F.
LLREORDERLocalL .F.
LLSORRYLocalL .F.
LCVSQLLocalC "SELECT Cou..." 449 bytes
LCTSQLLocalC "SELECT Cou..." 578 bytes
LLEBEXPIRELocalL .F.
LLSQLLocalL .F.
LCGROUPBYLocalC "cocrse"
LCDIALOGQSLocalC ""
LNCOUNT1LocalL .F.
LLINSTRUCTLocalL .F.
LLPACKAGE2LocalL .T.
LCDAYPrivC "20240328"
__OVERRIDEPrivN 0 ( 0.00000000)
PCTESTPrivC "Logon Status Here"
PCTITLEPrivC "Other Dates"
PCDESCRIPTPrivC ""
PCGROUPPrivC ""
PCSORRYPrivC ""
PCBONUSMSGPrivC ""
PCSUBGROUPPrivC ""
PCPREVIOUSPrivC ""
PCURLPrivC "https://ace.capetigers.com/wconnect/ShowSchedule.awp?"
LCEFINIPrivC "C:\INETPUB\ACEWEB\ExpireFees.ini"
error LNERRORLocalN 1231 ( 1231.00000000)
LCMETHODLocalC "showschedule"
LNLINELocalN 15267 ( 15267.00000000)
LCBADBOTSLocalL .F.
LCBROWSERLocalC "claudebot"
LCEPILOGUELocalL .F.
LCPROLOGUELocalL .F.
LCTITLELocalL .F.
LLSENDTHISLocalL .F.
LOEXCLocalL .F.
ILocalL ***
LCBUILDLocalC "AW3.EXE 20230207 (12:07:54 on 02/07/2023)"
LLRESTLocalL .F.
LAFILESPrivA
errreport LCTXTLocalL .F.
LCUSERLocalC ""
LCIPLocalC "10.1.3.251"
LCURLLocalC "https://ace.capetigers.com/wconnect/ace/ShowSchedule.awp?&Criteria=cocatcode=%255B414%2520%2520%2520%2520%2520%2520%2520%255D+AND+NOT+cocrse=%255B22FSIM41409%2520%255D&Title=Other+Dates"
LCOLDURLLocalC "[none: bookmark, email, or manually-typed URL]"
LCTOPLINKLocalC "<a class="DebugInfoSectionLinks" href="#Top">[back to top]</a>"
LLREQUESTLocalL .F.
LCPROLOGUELocalL .F.
LCSTYLELocalL .F.
LCEPILOGUELocalL .F.
LCMSGLocalL .F.
LCPAGEMENULocalC "<a class="DebugInfoSectionLinks" href="#ProgramStack">[program stack]</a><a class="DebugInfoSectionLinks" href="#DataSessions">[data sessions]</a>"
LCMAILMENULocalC ""
LCOLDERRORLocalL .F.
LCBROWSERLocalC "claudebot"
LCTEMPLocalL ***
LCPWDFLDSLocalL .F.
LCNAMELocalL .F.
LCVALUELocalL .F.
LCIDENTITYLocalC "AWSA"
LCBUILDLocalC "AW3.EXE 20230207 (12:07:54 on 02/07/2023)"
l7showmemory LLNOHTMLLocalL .F.
LLUSEFORMLocalL .F.
LCMEMORYLocalL .F.
LCFILELocalC "C:\WINDOWS\TEMP\59094482.TXT"
LCSTYLELocalL .F.
LNATLocalL .F.
ailable16155variablesa
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Server Variables
DLLVersionWeb Connection 7.25 (ISAPI Handler)
REQUESTID2092_FDBC8B3B2CDF
wcConfigc:\inetpub\wwwroot\wconnect\wc.INI
REQUEST_METHODGET
QUERY_STRING
Criteriacocatcode=%255B414%2520%2520%2520%2520%2520%2520%2520%255D+AND+NOT+cocrse=%255B22FSIM41409%2520%255D
TitleOther+Dates
Executable Path/wconnect/ace/ShowSchedule.awp
CONTENT_LENGTH0
PATH_INFO/wconnect/ace/ShowSchedule.awp
PATH_TRANSLATEDc:\inetpub\wwwroot\wconnect\ace\ShowSchedule.awp
SCRIPT_NAME/wconnect/ace/ShowSchedule.awp
PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\ace\ShowSchedule.awp
WEBROOT_PATHC:\inetpub\wwwroot
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/8.5
SERVER_NAMEace.capetigers.com
SERVER_PORT80
SERVER_ACCOUNTSYSTEM
REMOTE_HOST10.1.3.251
REMOTE_ADDR10.1.3.251
HTTP_USER_AGENTclaudebot
HTTP_ACCEPT*/*
HTTP_ACCEPT_ENCODINGgzip, br
APPL_PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\
APPL_MD_PATH/LM/W3SVC/1/ROOT/WConnect
HTTP_CONNECTIONKeep-Alive
CACHE_URLhttp://ace.capetigers.com:80/wconnect/ace/ShowSchedule.awp?
SCRIPT_TRANSLATED\\?\c:\inetpub\wwwroot\wconnect\ace\ShowSchedule.awp
APP_POOL_IDWest Wind WebConnection
GMT_OFFSET-21600
ALL_HTTP (Variables previously displayed will not be shown below)
HTTP_HOSTace.capetigers.com
HTTP_X_FORWARDED_FOR18.206.160.129
HTTP_CF_RAY86bab0905a1d9c34-IAD
HTTP_X_FORWARDED_PROTOhttps
HTTP_CF_VISITOR{"scheme":"https"}
HTTP_CF_CONNECTING_IP18.206.160.129
HTTP_CDN_LOOPcloudflare
HTTP_CF_IPCOUNTRYUS
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Trace Output
16:24:54.53 ACECODE.ONPROCESSINIT !!showschedule
16:24:54.53 ACECODE.ONPROCESSINIT !!showschedule
16:24:54.53 ACECODE.ONPROCESSINIT !!showschedule
16:24:54.53 ACECODE.ONPROCESSINIT !!showschedule
16:24:54.55 AWBUSINESSOBJECT.INIT Biz object - VFP data.
16:24:54.55 AWBUSINESSOBJECT.INIT Biz object - VFP data.
16:24:54.55 AWBUSINESSOBJECT.INIT Biz object - VFP data.
16:24:54.55 AWBUSINESSOBJECT.INIT Biz object - VFP data.
16:24:54.55 AWBUSINESSOBJECT.INIT Biz object - VFP data.
16:24:54.55 AWBUSINESSOBJECT.INIT Biz object - VFP data.
16:24:54.55 AWBUSINESSOBJECT.INIT Biz object - VFP data.
16:24:54.55 AWBUSINESSOBJECT.INIT Biz object - VFP data.
16:24:54.58 ACECODE.SHOWSCHEDULE !!ShowSchedule .awp &Criteria=cocatcode=%255B414%2520%2520%2520%2520%2520%2520%2520%255D+AND+NOT+cocrse=%255B22FSIM41409%2520%255D&Title=Other+Dates Called by
16:24:54.60 ACECODE.SHOWSCHEDULE !Passed in Cursor Criteria=cocatcode=%5B414%20%20%20%20%20%20%20%5D AND NOT cocrse=%5B22FSIM41409%20%5D Group= Cat Criteria= Passed in SQL criteria=
16:24:54.60 ACECODE.SHOWSCHEDULE SQL Injection check
16:24:54.61 ACECODE.SHOWSCHEDULE Parameter Criteria=cocatcode=%5B414%20%20%20%20%20%20%20%5D AND NOT cocrse=%5B22FSIM41409%20%5D
16:24:54.61 ACECODE.SHOWSCHEDULE Title=Other Dates Target= URL=https://ace.capetigers.com/wconnect/ShowSchedule.awp? Mode=
16:24:54.63 ACECODE.SHOWSCHEDULE HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm
16:24:54.63 ACECODE.SHOWSCHEDULE Template INI=C:\INETPUB\wwwroot\wconnect\ace\ShowSchedule.INI
16:24:54.64 ACECODE.SHOWSCHEDULE Group=
16:24:54.64 ACECODE.SHOWSCHEDULE Ready for main query: Course_Name:Course Name;Begins:Begins;Ends:Ends;Meets:Meets;FullFee:Fee Course_Name:Title; cotype:Type; FullFee:Fee 0
16:24:54.64 ACECODE.SHOWSCHEDULE Ready for main query: Course_Name:Course Name;Begins:Begins;Ends:Ends;Meets:Meets;FullFee:Fee Course_Name:Title; cotype:Type; FullFee:Fee 0
16:24:54.66 ACECODE.SHOWSCHEDULE VFP: SELECT Course.* , Fees.* FROM Course JOIN Fees ON UPPER(fecrse) == UPPER(cocrse) AND NOT fees.fewebhide AND (fees.feauto OR (fees.feident=[F] AND feorder = 1)) WHERE ((DTOS(cobegdate) >= DTOS(DATE() - coweblag) ) OR (NOT EMPTY(coopendat) AND coopendat <= DATE()) AND (EMPTY(coenddate) OR coenddate >= DATE())) AND coactive AND NOT cocancel AND (cowebreg > 3 - __Override ) and (EMPTY(copubdate) or copubdate <= DATE()) ORDER BY cocrsenm, cobegdate SQL: SELECT Course.* , Fees.* FROM Course JOIN Fees ON UPPER(fecrse) = UPPER(cocrse) AND fees.fewebhide = 0 AND (fees.feauto=1 OR (fees.feident='F' AND fees.feorder=1)) WHERE ((cobegdate >= CONVERT(date, GETDATE() - coweblag) ) OR ((coopendat IS NOT NULL AND coopendat <> '1900-01-01') AND coopendat <= CONVERT(date, GETDATE())) AND ((coenddate IS NULL OR coenddate = '1900-01-01') OR coenddate >= CONVERT(date, GETDATE()))) AND coactive=1 AND cocancel=0 AND (cowebreg > 3 - ?__Override ) and (copubdate is null or copubdate <= CONVERT(date, GETDATE())) ORDER BY cocrsenm, cobegdate
16:24:54.99 ACECODE.SHOWSCHEDULE Finished initial Course query: 57 records Session: EDvRa0wf1nWWVDYo0
16:24:54.99 ACECODE.SHOWSCHEDULE Finished initial Course query: 57 records Session: EDvRa0wf1nWWVDYo0
16:24:55.00 ACECODE.SHOWSCHEDULE Schedule with Fullfee: 32 records, grouped by cocrse
16:24:55.02 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 32
16:24:55.02 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 32
16:24:55.02 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 32
16:24:55.02 ACECODE.SHOWSCHEDULE Cursor Criteria=cocatcode=%5B414%20%20%20%20%20%20%20%5D AND NOT cocrse=%5B22FSIM41409%20%5D Extra Criteria=
16:24:55.03 ACECODE.SHOWSCHEDULE Criteria=(cocatcode=%5B414%20%20%20%20%20%20%20%5D AND NOT cocrse=%5B22FSIM41409%20%5D) Groupmode=.F.
16:24:55.03 ACECODE.SHOWSCHEDULE Criteria applied to tSchedule. 32 records, done with Schedule queries
16:24:55.03 ACECODE.SHOWSCHEDULE Found 32 matching courses. Async? Yes Criteria to be applied=(cocatcode=%5B414%20%20%20%20%20%20%20%5D AND NOT cocrse=%5B22FSIM41409%20%5D) Mode= Target=

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