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://ce.ung.edu/wconnect/ace/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Cumming+-+City+Hall%2522&Title=Cumming+-+City+Hall
                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 05:30:15 PM
           VFP Error No: 1231
                Message: Missing operand.
                Program: showschedule
                Line No: 15267
                   Code: .F. 
              Client IP: 44.223.31.148
     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 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
6TSCHEDSHOWC:\WINDOWS\TEMP\00003TAX6TTJ.TMP 1 81
9TSCHEDULEC:\WINDOWS\TEMP\00003TAX6TTF.TMPEOF() 339
7LOCATIONC:\MANAGER7\LOCATION.DBF 420 441
3WWSESSIONC:\INETPUB\ACEWEB\WWSESSION.DBF 1,717,221 1,717,221
2AWDB240328C:\INETPUB\ACEWEB\AWDB240328.DBF 442,121 442,121
1CGILOGC:\INETPUB\ACEWEB\WWREQUESTLOG.DBF 2,939,731 2,939,731
[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 63013.595 ( 63013.59500000)
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))==%22Cumming - City Hall%22 AND !EMPTY(loclocat) )"
LCHT1LocalC "<!DOCTYPE ..." 7783 bytes
LCHT2LocalC "<div id="t..." 2217 bytes
LCHTCONFIGLocalL .F.
LCKEYWORDSLocalL .F.
LCMODELocalC ""
LCORDERBYLocalL .F.
LCTARGETLocalC ""
LCHTLocalL .F.
LCPAGEFOOTLocalL .F.
LCDPLocalC "c:\manager7\"
LCFLDLocalL .F.
LCFULLMSGLocalC "<STRONG> Full</strong>"
LNPOSLocalL .F.
LCFIELDSLocalC "Course_Name:Course;loclocat:Location;Begins:Start Date;Ends:End Date;Cocrsetm:Meets;Fee:Course Fee,codept:Online Type;Course_Name:Course;cobegdate:Begin Date;coenddate:End Date;cocrsetm:Meets;fullfee:Course 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 "20240328"
__OVERRIDEPrivN 0 ( 0.00000000)
PCTESTPrivC "Logon Status Here"
PCTITLEPrivC "Cumming - City Hall"
PCDESCRIPTPrivC ""
PCGROUPPrivC ""
PCSORRYPrivC ""
PCBONUSMSGPrivC ""
PCSUBGROUPPrivC ""
PCPREVIOUSPrivC ""
PCURLPrivC "https://ce.ung.edu/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 "44.223.31.148"
LCURLLocalC "https://ce.ung.edu/wconnect/ace/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Cumming+-+City+Hall%2522&Title=Cumming+-+City+Hall"
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 "SYSTEM"
LCBUILDLocalC "AW3.EXE 20230207 (12:07:54 on 02/07/2023)"
l7showmemory LLNOHTMLLocalL .F.
LLUSEFORMLocalL .F.
LCMEMORYLocalL .F.
LCFILELocalC "C:\WINDOWS\TEMP\63013959.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)
REQUESTID1500_A31F09F5BE93
wcConfigc:\inetpub\wwwroot\wconnect\wc.INI
REQUEST_METHODGET
QUERY_STRING
CriteriaALLTRIM(LEFT(loclocat,40))==%2522Cumming+-+City+Hall%2522
TitleCumming+-+City+Hall
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_NAMEce.ung.edu
SERVER_PORT443
SERVER_ACCOUNTSYSTEM
REMOTE_HOST44.223.31.148
REMOTE_ADDR44.223.31.148
HTTP_USER_AGENTclaudebot
HTTP_ACCEPT*/*
APPL_PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\
APPL_MD_PATH/LM/W3SVC/1/ROOT/WConnect
HTTP_CONNECTIONclose
CACHE_URLhttps://ce.ung.edu:443/wconnect/ace/ShowSchedule.awp?
CERT_KEYSIZE256
CERT_SECRETKEYSIZE2048
CERT_SERVER_SUBJECTC=US, S=Georgia, O=University of North Georgia, CN=*.ung.edu
CERT_SERVER_ISSUERC=US, S=MI, L=Ann Arbor, O=Internet2, OU=InCommon, CN=InCommon RSA Server CA
SCRIPT_TRANSLATED\\?\c:\inetpub\wwwroot\wconnect\ace\ShowSchedule.awp
APP_POOL_IDWest Wind WebConnection
GMT_OFFSET-18000
ALL_HTTP (Variables previously displayed will not be shown below)
HTTP_HOSTce.ung.edu
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Trace Output
!!showschedule
! URL=https://ce.ung.edu/wconnect/ace/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Cumming+-+City+Hall%252...
! URL=https://ce.ung.edu/wconnect/ace/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Cumming+-+City+Hall%252...
! URL=https://ce.ung.edu/wconnect/ace/ShowSchedule.awp?&Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Cumming+-+City+Hall%252...
Data Mode=0 Data Path=c:\manager7\ / c:\manager7\
Data Mode=0 Data Path=c:\manager7\ / c:\manager7\
Data Mode=0 Data Path=c:\manager7\ / c:\manager7\
Data Mode=0 Data Path=c:\manager7\ / c:\manager7\
Data Mode=0 Data Path=c:\manager7\ / c:\manager7\
Data Mode=0 Data Path=c:\manager7\ / c:\manager7\
Data Mode=0 Data Path=c:\manager7\ / c:\manager7\
Data Mode=0 Data Path=c:\manager7\ / c:\manager7\
!!ShowSchedule .awp &Criteria=ALLTRIM(LEFT(loclocat,40))==%2522Cumming+-+City+Hall%2522&Title=Cumming+-+City+Hall Called b...
!Passed in Cursor Criteria=ALLTRIM(LEFT(loclocat,40))==%22Cumming - City Hall%22 Group= Cat Criteria= Passed in SQL criter...
Parameter Criteria=ALLTRIM(LEFT(loclocat,40))==%22Cumming - City Hall%22 AND !EMPTY(loclocat)
Title=Cumming - City Hall Target= URL=https://ce.ung.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:Start Date;Ends:End Date;Cocrsetm:Meets;Fee:Course Fee ...
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: 339 records Session: hh1f9EejXUMZe7i30
Finished initial Course query: 339 records Session: hh1f9EejXUMZe7i30
Schedule with Fullfee: 339 records, grouped by cocrse
!Finished supplemental queries. Record count= 339
!Finished supplemental queries. Record count= 339
!Finished supplemental queries. Record count= 339
Cursor Criteria=ALLTRIM(LEFT(loclocat,40))==%22Cumming - City Hall%22 AND !EMPTY(loclocat) Extra Criteria=
Criteria=(ALLTRIM(LEFT(loclocat,40))==%22Cumming - City Hall%22 AND !EMPTY(loclocat) ) Groupmode=.F.
Criteria applied to tSchedule. 339 records, done with Schedule queries
Found 339 matching courses. Async? No Criteria to be applied=(ALLTRIM(LEFT(loclocat,40))==%22Cumming - City Hall%22 AND !...

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