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=ALLTRIM(LEFT(loclocat,40))=%2522Harley-Davidson+of+Scott+City+-+2100+E.%2522&Title=Harley-Davidson+of+Scott+City+-+2100+E.
                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: 04/16/2024 05:30:46 AM
           VFP Error No: 1231
                Message: Missing operand.
                Program: showschedule
                Line No: 15267
                   Code:  
              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\0000B09L000X.TMP 1 89
8TSCHEDULEC:\WINDOWS\TEMP\0000B09L000T.TMPEOF() 89
6LOCATION\\CTCAPPS\MANAGER6\LOCATION.DBF 31 128
2WWSESSIONC:\INETPUB\ACEWEB\WWSESSION.DBF 36,720 36,720
1CGILOGC:\INETPUB\ACEWEB\WWREQUESTLOG.DBF 97,252 97,252
[back to top][program stack][data sessions][memory variables][server vars][trace output]
List Memory
ModuleVariableScopeTypeValue
PUBLIC GOWCSERVERPubO ACEWEBSERVER
__TIMEZONEPubN 300.00 ( 300.00000000)
processhit LLFILELocalL .F.
LNSECONDSLocalN 19846.137 ( 19846.13700000)
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 "(ALLTRIM(LEFT(loclocat,40))=%22Harley-Davidson of Scott City - 2100 E.%22 AND !EMPTY(loclocat) )"
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 .F.
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..." 573 bytes
LCTSQLLocalC "SELECT Cou..." 702 bytes
LLEBEXPIRELocalL .F.
LLSQLLocalL .F.
LCGROUPBYLocalC "cocrse"
LCDIALOGQSLocalC ""
LNCOUNT1LocalL .F.
LLINSTRUCTLocalL .F.
LLPACKAGE2LocalL .T.
LCDAYPrivC "20240416"
__OVERRIDEPrivN 0 ( 0.00000000)
PCTESTPrivC "Logon Status Here"
PCTITLEPrivC "Harley-Davidson of Scott City - 2100 E."
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=ALLTRIM(LEFT(loclocat,40))=%2522Harley-Davidson+of+Scott+City+-+2100+E.%2522&Title=Harley-Davidson+of+Scott+City+-+2100+E."
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\19846794.TXT"
LCSTYLELocalL .F.
LNATLocalL .F.
ailable16156variablesa
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Server Variables
DLLVersionWeb Connection 7.25 (ISAPI Handler)
REQUESTID5824_1AE2E90B7EE5
wcConfigc:\inetpub\wwwroot\wconnect\wc.INI
REQUEST_METHODGET
QUERY_STRING
CriteriaALLTRIM(LEFT(loclocat,40))=%2522Harley-Davidson+of+Scott+City+-+2100+E.%2522
TitleHarley-Davidson+of+Scott+City+-+2100+E.
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_FOR3.144.42.196
HTTP_CF_RAY8753807a3f9de137-ORD
HTTP_X_FORWARDED_PROTOhttps
HTTP_CF_VISITOR{"scheme":"https"}
HTTP_CF_CONNECTING_IP3.144.42.196
HTTP_CDN_LOOPcloudflare
HTTP_CF_IPCOUNTRYUS
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Trace Output
05:30:46.24 ACECODE.ONPROCESSINIT !!showschedule
05:30:46.24 ACECODE.ONPROCESSINIT !!showschedule
05:30:46.24 ACECODE.ONPROCESSINIT !!showschedule
05:30:46.24 ACECODE.ONPROCESSINIT !!showschedule
05:30:46.26 AWBUSINESSOBJECT.INIT Biz object - VFP data.
05:30:46.26 AWBUSINESSOBJECT.INIT Biz object - VFP data.
05:30:46.26 AWBUSINESSOBJECT.INIT Biz object - VFP data.
05:30:46.26 AWBUSINESSOBJECT.INIT Biz object - VFP data.
05:30:46.26 AWBUSINESSOBJECT.INIT Biz object - VFP data.
05:30:46.26 AWBUSINESSOBJECT.INIT Biz object - VFP data.
05:30:46.26 AWBUSINESSOBJECT.INIT Biz object - VFP data.
05:30:46.26 AWBUSINESSOBJECT.INIT Biz object - VFP data.
05:30:46.29 ACECODE.SHOWSCHEDULE !!ShowSchedule .awp &Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Harley-Davidson+of+Scott+City+-+2100+E.%2522&Title=Harley-Davidson+of+Scott+City+-+2100+E. Called by
05:30:46.31 ACECODE.SHOWSCHEDULE !Passed in Cursor Criteria=ALLTRIM(LEFT(loclocat,40))=%22Harley-Davidson of Scott City - 2100 E.%22 Group= Cat Criteria= Passed in SQL criteria=
05:30:46.32 ACECODE.SHOWSCHEDULE Parameter Criteria=ALLTRIM(LEFT(loclocat,40))=%22Harley-Davidson of Scott City - 2100 E.%22 AND !EMPTY(loclocat)
05:30:46.32 ACECODE.SHOWSCHEDULE Title=Harley-Davidson of Scott City - 2100 E. Target= URL=https://ace.capetigers.com/wconnect/ShowSchedule.awp? Mode=
05:30:46.34 ACECODE.SHOWSCHEDULE HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm
05:30:46.35 ACECODE.SHOWSCHEDULE Template INI=C:\INETPUB\wwwroot\wconnect\ace\ShowSchedule.INI
05:30:46.35 ACECODE.SHOWSCHEDULE Group=
05:30:46.37 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
05:30:46.37 ACECODE.SHOWSCHEDULE Joining location table
05:30:46.37 ACECODE.SHOWSCHEDULE Joining location table
05:30:46.39 ACECODE.SHOWSCHEDULE VFP: SELECT Course.* , Fees.* , locid, loclocat, locinfo, loccity, locstate, locudf1, locudf2, loccampus FROM Course JOIN Fees ON UPPER(fecrse) == UPPER(cocrse) AND NOT fees.fewebhide AND (fees.feauto OR (fees.feident=[F] AND feorder = 1)) JOIN Location ON Course.colocid = Location.locid 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.* , locid, loclocat, locinfo, loccity, locstate, locudf1, locudf2, loccampus 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)) JOIN Location ON Course.colocid = Location.locid 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
05:30:46.70 ACECODE.SHOWSCHEDULE Finished initial Course query: 245 records Session: VY4mKGHe1qraefXf0
05:30:46.70 ACECODE.SHOWSCHEDULE Finished initial Course query: 245 records Session: VY4mKGHe1qraefXf0
05:30:46.71 ACECODE.SHOWSCHEDULE Schedule with Fullfee: 89 records, grouped by cocrse
05:30:46.73 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 89
05:30:46.73 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 89
05:30:46.73 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 89
05:30:46.74 ACECODE.SHOWSCHEDULE Cursor Criteria=ALLTRIM(LEFT(loclocat,40))=%22Harley-Davidson of Scott City - 2100 E.%22 AND !EMPTY(loclocat) Extra Criteria=
05:30:46.76 ACECODE.SHOWSCHEDULE Criteria=(ALLTRIM(LEFT(loclocat,40))=%22Harley-Davidson of Scott City - 2100 E.%22 AND !EMPTY(loclocat) ) Groupmode=.F.
05:30:46.76 ACECODE.SHOWSCHEDULE Criteria applied to tSchedule. 89 records, done with Schedule queries
05:30:46.78 ACECODE.SHOWSCHEDULE Found 89 matching courses. Async? No Criteria to be applied=(ALLTRIM(LEFT(loclocat,40))=%22Harley-Davidson of Scott City - 2100 E.%22 AND !EMPTY(loclocat) ) Mode= Target=

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