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/ace1/ShowSchedule.awp1?&Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&Title=Clement+Bldg.&&Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&Title=Clement+Bldg.
                Referer: http://ww2.nscc.edu/wconnect/ace1/ShowSchedule.awp1?&Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&Title=Clement+Bldg.
          Error Handler: Acecode.Error()
                  Build: AW3.EXE 20220927 (16:05:02 on 09/27/2022)
            Server Time: 03/28/2024 08:34:00 PM
           VFP Error No: 1231
                Message: Missing operand.
                Program: showschedule
                Line No: 15221
                   Code: .F. 
              Client IP: 3.90.33.254
     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.ObjectModuleLineCode
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
DSData Session Open Workarea Information
1
NoAliasTableRecord No.Record Count
6TSCHEDSHOWC:\WINDOWS\TEMP\0000B9QX119S.TMP 1 25
9TSCHEDULEC:\WINDOWS\TEMP\0000B9QX119O.TMPEOF() 126
7LOCATIONG:\ACEWARE\MANAGER7\LOCATION.DBF 2 325
3WWSESSIONG:\INETPUB2\ACEWEB\WWSESSION.DBF 1,090,405 1,090,405
2AWDB240328G:\INETPUB2\ACEWEB\AWDB240328.DBF 94,445 94,445
1CGILOGG:\INETPUB2\ACEWEB\WWREQUESTLOG.DBF 1,173,312 1,173,312
[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 74040.674 ( 74040.67400000)
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 ".awp1"
STANDARDPrivO AWSTANDARDTEMPLATE
MINIMALPrivO AWMINIMALTEMPLATE
PCSYSHOMEPrivC "G:\INETPUB2\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 XCONFIG
routerequest LLERRORLocalL .F.
LCPHYSICALLocalC "G:\InetPub2\wwwroot\WConnect\ace1\ShowSchedule.awp1"
LCCMDLocalC "THIS.showschedule()"
showschedule LCTITLELocalL .F.
LLEXEMPTLocalL .F.
LCNPARAMSLocalL .F.
LAHEADSLocalA
LCCRITERIALocalC "(ALLTRIM(LEFT(loclocat,40))=%22Clement Bldg.%22 AND !EMPTY(loclocat) )"
LCHT1LocalC "<!DOCTYPE ..." 8450 bytes
LCHT2LocalC "<div id="t..." 2249 bytes
LCHTCONFIGLocalL .F.
LCKEYWORDSLocalL .F.
LCMODELocalC ""
LCORDERBYLocalL .F.
LCTARGETLocalC ""
LCHTLocalL .F.
LCPAGEFOOTLocalL .F.
LCDPLocalC "G:\AceWare\manager7\"
LCFLDLocalL .F.
LCFULLMSGLocalC "<STRONG>** FULL **</STRONG>"
LNPOSLocalL .F.
LCFIELDSLocalC "Course_Name:Title; 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 "G:\InetPub2\wwwroot\wconnect\ace1\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 "20240328"
__OVERRIDEPrivN 0 ( 0.00000000)
PCTESTPrivC "Logon Status Here"
PCTITLEPrivC "Clement Bldg."
PCDESCRIPTPrivC ""
PCGROUPPrivC ""
PCSORRYPrivC ""
PCBONUSMSGPrivC ""
PCSUBGROUPPrivC ""
PCPREVIOUSPrivC ""
PCURLPrivC "https://ww2.nscc.edu/wconnect/ShowSchedule.awp1?"
LCEFINIPrivC "G:\INETPUB2\ACEWEB\ExpireFees.ini"
error LNERRORLocalN 1231 ( 1231.00000000)
LCMETHODLocalC "showschedule"
LNLINELocalN 15221 ( 15221.00000000)
LCBADBOTSLocalL .F.
LCBROWSERLocalC "claudebot"
LCEPILOGUELocalL .F.
LCPROLOGUELocalL .F.
LCTITLELocalL .F.
LLSENDTHISLocalL .F.
LOEXCLocalL .F.
ILocalL ***
LCBUILDLocalC "AW3.EXE 20220927 (16:05:02 on 09/27/2022)"
LLRESTLocalL .F.
LAFILESPrivA
errreport LCTXTLocalL .F.
LCUSERLocalC ""
LCIPLocalC "3.90.33.254"
LCURLLocalC "http://ww2.nscc.edu/wconnect/ace1/ShowSchedule.awp1?&Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&Title=Clement+Bldg.&&Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&Title=Clement+Bldg."
LCOLDURLLocalC "<a href="h..." 279 bytes
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 "SYSTEM"
LCBUILDLocalC "AW3.EXE 20220927 (16:05:02 on 09/27/2022)"
l7showmemory LLNOHTMLLocalL .F.
LLUSEFORMLocalL .F.
LCMEMORYLocalL .F.
LCFILELocalC "C:\WINDOWS\TEMP\74040940.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)
REQUESTID7552_43357080E0CF
wcConfigG:\InetPub2\wwwroot\WConnect\wc.INI
REQUEST_METHODGET
QUERY_STRING
CriteriaALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522
TitleClement+Bldg.
Executable Path/wconnect/ace1/ShowSchedule.awp1
CONTENT_LENGTH0
PATH_INFO/wconnect/ace1/ShowSchedule.awp1
PATH_TRANSLATEDG:\InetPub2\wwwroot\WConnect\ace1\ShowSchedule.awp1
SCRIPT_NAME/wconnect/ace1/ShowSchedule.awp1
PHYSICAL_PATHG:\InetPub2\wwwroot\WConnect\ace1\ShowSchedule.awp1
WEBROOT_PATHG:\InetPub2\wwwroot
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
SERVER_NAMEww2.nscc.edu
SERVER_PORT443
SERVER_ACCOUNTSYSTEM
REMOTE_HOST3.90.33.254
REMOTE_ADDR3.90.33.254
HTTP_REFERERhttp://ww2.nscc.edu/wconnect/ace1/ShowSchedule.awp1?
HTTP_USER_AGENTclaudebot
HTTP_ACCEPT*/*
APPL_PHYSICAL_PATHG:\InetPub2\wwwroot\WConnect\
APPL_MD_PATH/LM/W3SVC/1/ROOT/WConnect
HTTP_CONNECTIONclose
CACHE_URLhttps://ww2.nscc.edu:443:192.168.212.69/wconnect/ace1/ShowSchedule.awp1?
CERT_KEYSIZE256
CERT_SECRETKEYSIZE2048
CERT_SERVER_SUBJECTC=US, S=Tennessee, O=Nashville State Technical Community College, CN=*.nscc.edu
CERT_SERVER_ISSUERC=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Organization Validation Secure Server CA
SCRIPT_TRANSLATED\\?\G:\InetPub2\wwwroot\WConnect\ace1\ShowSchedule.awp1
APP_POOL_IDWest Wind WebConnection
GMT_OFFSET-21600
ALL_HTTP (Variables previously displayed will not be shown below)
HTTP_HOSTww2.nscc.edu
CriteriaALLTRIM(LEFT(loclocat,40))=%22Clement Bldg.%22
TitleClement Bldg.
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Trace Output
!!showschedule
! URL=https://ww2.nscc.edu/wconnect/ace1/ShowSchedule.awp1?&Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&T...
! URL=https://ww2.nscc.edu/wconnect/ace1/ShowSchedule.awp1?&Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&T...
! URL=https://ww2.nscc.edu/wconnect/ace1/ShowSchedule.awp1?&Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&T...
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=ALLTRIM(LEFT(loclocat,40))=%2522Clement+Bldg.%2522&Title=Clement+Bldg.&&Criteria=ALLTRIM(LE...
!Passed in Cursor Criteria=ALLTRIM(LEFT(loclocat,40))=%22Clement Bldg.%22 Group= Cat Criteria= Passed in SQL criteria=
Parameter Criteria=ALLTRIM(LEFT(loclocat,40))=%22Clement Bldg.%22 AND !EMPTY(loclocat)
Title=Clement Bldg. 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:...
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: 128 records Session: imekiGrgKzYJAWdx0
Finished initial Course query: 128 records Session: imekiGrgKzYJAWdx0
Schedule with Fullfee: 126 records, grouped by cocrse
!Finished supplemental queries. Record count= 126
!Finished supplemental queries. Record count= 126
!Finished supplemental queries. Record count= 126
Cursor Criteria=ALLTRIM(LEFT(loclocat,40))=%22Clement Bldg.%22 AND !EMPTY(loclocat) Extra Criteria=
Criteria=(ALLTRIM(LEFT(loclocat,40))=%22Clement Bldg.%22 AND !EMPTY(loclocat) ) Groupmode=.F.
Criteria applied to tSchedule. 126 records, done with Schedule queries
Found 126 matching courses. Async? No Criteria to be applied=(ALLTRIM(LEFT(loclocat,40))=%22Clement Bldg.%22 AND !EMPTY(l...

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