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://uwgagenda.westga.edu/wconnect/ace/ShowSchedule.awp?Criteria=ALLTRIM(LEFT(loclocat,40))==%2522GAIT%2522&Title=GAIT
                Referer: [none: bookmark, email, or manually-typed URL]
          Error Handler: Acecode.Error()
                  Build: AW3.EXE 20231130 (14:10:16 on 11/30/2023)
            Server Time: 04/18/2024 11:02:06 PM
           VFP Error No: 1231
                Message: Missing operand.
                Program: showschedule
                Line No: 15434
                   Code: .T. 
              Client IP: 10.10.5.7
     Authenticated User: 
           Exe Identity: acewareiis
                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.ObjectModuleLineCode
1. .processhit wwserver.prg 720
2. .process acewebmain3.prg 1750
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 15434
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
6TSCHEDSHOWC:\WINDOWS\TEMP\0000B5ZT0NU2.TMP 1 50
9TSCHEDULEC:\WINDOWS\TEMP\0000B5ZT0NTY.TMPEOF() 102
7LOCATIOND:\MANAGER7\LOCATION.DBF 521 547
3WWSESSIONC:\INETPUB\ACEWEB\WWSESSION.DBF 1,294,867 1,294,867
2AWDB240418C:\INETPUB\ACEWEB\AWDB240418.DBF 227,243 227,243
1CGILOGC:\INETPUB\ACEWEB\WWREQUESTLOG.DBF 87,087 87,087
[back to top][program stack][data sessions][memory variables][server vars][trace output]
List Memory
ModuleVariableScopeTypeValue
PUBLIC GOWCSERVERPubO ACEWEBSERVER
__TIMEZONEPubN 240.00 ( 240.00000000)
__REGEXPubO VBSCRIPT REGULAR EXPRESSION
processhit LLFILELocalL .F.
LNSECONDSLocalN 82926.175 ( 82926.17500000)
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))==%22GAIT%22 AND !EMPTY(loclocat) )"
LCHT1LocalC "<!DOCTYPE ..." 6699 bytes
LCHT2LocalC "<div id="t..." 2235 bytes
LCHTCONFIGLocalL .F.
LCKEYWORDSLocalL .F.
LCMODELocalC ""
LCORDERBYLocalL .F.
LCTARGETLocalC ""
LCHTLocalL .F.
LCPAGEFOOTLocalL .F.
LCDPLocalC "d:\manager7\"
LCFLDLocalL .F.
LCFULLMSGLocalC "<STRONG> Full</strong>"
LNPOSLocalL .F.
LCFIELDSLocalC "Course_Name:Course;loclocat:Location;Begins:Begins;Ends:Ends;Cocrsetm: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 "20240418"
__OVERRIDEPrivN 0 ( 0.00000000)
PCTESTPrivC "Logon Status Here"
PCTITLEPrivC "GAIT"
PCDESCRIPTPrivC ""
PCGROUPPrivC ""
PCSORRYPrivC ""
PCBONUSMSGPrivC ""
PCSUBGROUPPrivC ""
PCPREVIOUSPrivC ""
PCURLPrivC "https://uwgagenda.westga.edu/wconnect/ShowSchedule.awp?"
LCEFINIPrivC "C:\INETPUB\ACEWEB\ExpireFees.ini"
error LNERRORLocalN 1231 ( 1231.00000000)
LCMETHODLocalC "showschedule"
LNLINELocalN 15434 ( 15434.00000000)
LCBADBOTSLocalL .F.
LCBROWSERLocalC "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
LCEPILOGUELocalL .F.
LCPROLOGUELocalL .F.
LCTITLELocalL .F.
LLSENDTHISLocalL .F.
LOEXCLocalL .F.
ILocalL ***
LCBUILDLocalC "AW3.EXE 20231130 (14:10:16 on 11/30/2023)"
LLRESTLocalL .F.
LAFILESPrivA
errreport LCTXTLocalL .F.
LCUSERLocalC ""
LCIPLocalC "10.10.5.7"
LCURLLocalC "https://uwgagenda.westga.edu/wconnect/ace/ShowSchedule.awp?Criteria=ALLTRIM(LEFT(loclocat,40))==%2522GAIT%2522&Title=GAIT"
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 "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
LCTEMPLocalL ***
LCPWDFLDSLocalL .F.
LCNAMELocalL .F.
LCVALUELocalL .F.
LCIDENTITYLocalC "acewareiis"
LCBUILDLocalC "AW3.EXE 20231130 (14:10:16 on 11/30/2023)"
l7showmemory LLNOHTMLLocalL .F.
LLUSEFORMLocalL .F.
LCMEMORYLocalL .F.
LCFILELocalC "C:\WINDOWS\TEMP\82926539.TXT"
LCSTYLELocalL .F.
LNATLocalL .F.
ailable16154variablesa
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Server Variables
DLLVersionWeb Connection 7.25 (ISAPI Handler)
REQUESTID8068_4770E7484C65
wcConfigc:\inetpub\wwwroot\wconnect\wc.INI
REQUEST_METHODGET
QUERY_STRINGCriteria=ALLTRIM(LEFT(loclocat,40))==%2522GAIT%2522
TitleGAIT
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/10.0
SERVER_NAMEuwgagenda.westga.edu
SERVER_PORT443
SERVER_ACCOUNTacewareiis
REMOTE_HOST10.10.5.7
REMOTE_ADDR10.10.5.7
HTTP_USER_AGENTMozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT*/*
APPL_PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\
APPL_MD_PATH/LM/W3SVC/1/ROOT/WConnect
CACHE_URLhttps://uwgagenda.westga.edu:443:10.10.5.101/wconnect/ace/ShowSchedule.awp?Criteria=ALLTRIM(LEFT(loclocat,40))==%2522GAIT%2522
CERT_KEYSIZE256
CERT_SECRETKEYSIZE2048
CERT_SERVER_SUBJECTCN=ced-aceware-02.uwg.westga.edu
CERT_SERVER_ISSUERCN=ced-aceware-02.uwg.westga.edu
SCRIPT_TRANSLATED\\?\c:\inetpub\wwwroot\wconnect\ace\ShowSchedule.awp
APP_POOL_IDWest Wind Web Connection
GMT_OFFSET-18000
ALL_HTTP (Variables previously displayed will not be shown below)
HTTP_HOSTuwgagenda.westga.edu
HTTP_USER_AGENTMozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR18.117.152.251
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Trace Output
!!showschedule
! URL=https://uwgagenda.westga.edu/wconnect/ace/ShowSchedule.awp?Criteria=ALLTRIM(LEFT(loclocat,40))==%2522GAIT%2522&Titl...
! URL=https://uwgagenda.westga.edu/wconnect/ace/ShowSchedule.awp?Criteria=ALLTRIM(LEFT(loclocat,40))==%2522GAIT%2522&Titl...
! URL=https://uwgagenda.westga.edu/wconnect/ace/ShowSchedule.awp?Criteria=ALLTRIM(LEFT(loclocat,40))==%2522GAIT%2522&Titl...
Data Mode=0 Data Path=d:\manager7\ / d:\manager7\
Data Mode=0 Data Path=d:\manager7\ / d:\manager7\
Data Mode=0 Data Path=d:\manager7\ / d:\manager7\
Data Mode=0 Data Path=d:\manager7\ / d:\manager7\
Data Mode=0 Data Path=d:\manager7\ / d:\manager7\
Data Mode=0 Data Path=d:\manager7\ / d:\manager7\
Data Mode=0 Data Path=d:\manager7\ / d:\manager7\
Data Mode=0 Data Path=d:\manager7\ / d:\manager7\
!!UserID =
!!ShowSchedule .awp Criteria=ALLTRIM(LEFT(loclocat,40))==%2522GAIT%2522&Title=GAIT Called by
!Passed in Cursor Criteria=ALLTRIM(LEFT(loclocat,40))==%22GAIT%22 Group= Cat Criteria= Passed in SQL criteria=
Parameter Criteria=ALLTRIM(LEFT(loclocat,40))==%22GAIT%22 AND !EMPTY(loclocat)
Title=GAIT Target= URL=https://uwgagenda.westga.edu/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: Course_Name:Course;loclocat:Location;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee Course_Name...
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: 102 records Session: Ec1Ubrong5PJqcsx0
Finished initial Course query: 102 records Session: Ec1Ubrong5PJqcsx0
Schedule with Fullfee: 102 records, grouped by cocrse
!Finished supplemental queries. Record count= 102
!Finished supplemental queries. Record count= 102
!Finished supplemental queries. Record count= 102
Cursor Criteria=ALLTRIM(LEFT(loclocat,40))==%22GAIT%22 AND !EMPTY(loclocat) Extra Criteria=
Criteria=(ALLTRIM(LEFT(loclocat,40))==%22GAIT%22 AND !EMPTY(loclocat) ) Groupmode=.F.
Criteria applied to tSchedule. 102 records, done with Schedule queries
Found 102 matching courses. Async? No Criteria to be applied=(ALLTRIM(LEFT(loclocat,40))==%22GAIT%22 AND !EMPTY(loclocat)...

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