An ACEweb Error Occurred

Error: "Syntax error." in line 15434 of Acecode.showschedule

[program stack][data sessions][memory variables][server vars][trace output]
            Current URL: https://www.freeuregistration.com:5000?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25
                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: 07/11/2025 09:55:17 PM
           VFP Error No: 10
                Message: Syntax error.
                Program: showschedule
                Line No: 15434
                   Code:  
              Client IP: 216.73.217.2
     Authenticated User: 
           Exe Identity: SYSTEM
                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. .processhitbinary wwserver.prg 807
2. .processhit wwserver.prg 720
3. .process acewebmain3.prg 1750
4. acecode acecode.prg 88
5. acecode.process acecode.prg 120
6. wwprocess.process wwprocess.prg 393
7. acecode.routerequest wwprocess.prg 481
8. acecode.showschedule acecode.prg 15434
9. acecode.error awprocess.prg 235
10. 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
3CGILOGC:\INETPUB\ACEWEB\WWREQUESTLOG.DBF 4,107 4,107
5TSCHEDSHOWC:\WINDOWS\TEMP\000013Q10FCG.TMP 1 125
7TSCHEDULEC:\WINDOWS\TEMP\000013Q10FCC.TMP 1 131
2WWSESSIONC:\INETPUB\ACEWEB\WWSESSION.DBF 980,773 980,773
1AWDB250711C:\INETPUB\ACEWEB\AWDB250711.DBF 93,660 93,660
[back to top][program stack][data sessions][memory variables][server vars][trace output]
List Memory
ModuleVariableScopeTypeValue
PUBLIC GOWCSERVERPubO ACEWEBSERVER
__TIMEZONEPubN 360.00 ( 360.00000000)
__REGEXPubO VBSCRIPT REGULAR EXPRESSION
processhitbinary LLFILELocalL .F.
LCRESULTLocalL .F.
processhit LLFILELocalL .F.
LNSECONDSLocalN 78916.570 ( 78916.57000000)
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\ShowSchedule.awp"
LCCMDLocalC "THIS.showschedule()"
showschedule LCTITLELocalL .F.
LLEXEMPTLocalL .F.
LCNPARAMSLocalL .F.
LAHEADSLocalA
LCCRITERIALocalC "(UPPER(cocrsenm) LIKE %)"
LCHT1LocalC "<!DOCTYPE ..." 11879 bytes
LCHT2LocalC "<div id="t..." 2446 bytes
"2 LCHTCONFIGLocalC
showschedule LCKEYWORDSLocalL .F.
LCMODELocalC ""
LCORDERBYLocalL .F.
LCTARGETLocalC ""
LCHTLocalL .F.
LCPAGEFOOTLocalL .F.
LCDPLocalC "c:\manager8\"
LCFLDLocalL .F.
LCFULLMSGLocalC "<STRONG> Full</strong>"
LNPOSLocalL .F.
LCFIELDSLocalC "code:Code;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 .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 .F.
LCDAYPrivC "20250711"
__OVERRIDEPrivN 0 ( 0.00000000)
PCTESTPrivC "Logon Status Here"
PCTITLEPrivC "Extended Listing"
PCDESCRIPTPrivC ""
PCGROUPPrivC ""
PCSORRYPrivC ""
PCBONUSMSGPrivC ""
PCSUBGROUPPrivC ""
PCPREVIOUSPrivC ""
PCURLPrivC "https://registration.freeu.com/wconnect/ShowSchedule.awp?"
LCEFINIPrivC "C:\INETPUB\ACEWEB\ExpireFees.ini"
error LNERRORLocalN 10 ( 10.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 "216.73.217.2"
LCURLLocalC "https://www.freeuregistration.com:5000?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25"
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 "SYSTEM"
LCBUILDLocalC "AW3.EXE 20231130 (14:10:16 on 11/30/2023)"
l7showmemory LLNOHTMLLocalL .F.
LLUSEFORMLocalL .F.
LCMEMORYLocalL .F.
LCFILELocalC "C:\WINDOWS\TEMP\78917102.TXT"
LCSTYLELocalL .F.
LNATLocalL .F.
ailable16149variablesa
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Server Variables
PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\ShowSchedule.awp
QUERY_STRINGCriteria=UPPER%28cocrsenm%29%20LIKE%20%25
SCRIPT_NAME/wconnect/ShowSchedule.awp
REQUESTID77165856763755_58
DLLVERSIONWeb Connection Handler 7.32.2 (.NET Handler)
WCCONFIGc:\inetpub\wwwroot\wconnect\web.config
ADMIN_PAGE/wconnect/admin/admin.aspx
APPL_WEB_PATHhttp://www.freeuregistration.com:5000/WConnect
APPL_MD_PATH/LM/W3SVC/1/ROOT/WConnect
APPL_PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH0
CONTENT_TYPE
GATEWAY_INTERFACECGI/1.1
HTTPSoff
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID1
INSTANCE_META_PATH/LM/W3SVC/1
LOCAL_ADDR172.31.106.12
PATH_INFO/wconnect/ShowSchedule.awp
PATH_TRANSLATEDc:\inetpub\wwwroot\wconnect\ShowSchedule.awp
REMOTE_ADDR172.31.43.86
REMOTE_HOST172.31.43.86
REMOTE_PORT24408
REQUEST_METHODGET
SERVER_NAMEwww.freeuregistration.com
SERVER_PORT5000
SERVER_PORT_SECURE0
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
URL/wconnect/ShowSchedule.awp
HTTP_ACCEPT*/*
HTTP_ACCEPT_ENCODINGgzip, br, zstd, deflate
HTTP_HOSTwww.freeuregistration.com
HTTP_USER_AGENTMozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR216.73.217.2
HTTP_X_FORWARDED_PROTOhttps
HTTP_X_FORWARDED_PORT443
HTTP_X_AMZN_TRACE_IDRoot=1-6871dca4-3caf7152420790ac02a6c5b4
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Trace Output
!!showschedule
! URL=http://www.freeuregistration.com:5000/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25 Cookie=
! URL=http://www.freeuregistration.com:5000/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25 Cookie=
! URL=http://www.freeuregistration.com:5000/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25 Cookie=
Data Mode=0 Data Path=c:\manager8\ / c:\manager8\
Data Mode=0 Data Path=c:\manager8\ / c:\manager8\
Data Mode=0 Data Path=c:\manager8\ / c:\manager8\
Data Mode=0 Data Path=c:\manager8\ / c:\manager8\
Data Mode=0 Data Path=c:\manager8\ / c:\manager8\
Data Mode=0 Data Path=c:\manager8\ / c:\manager8\
Data Mode=0 Data Path=c:\manager8\ / c:\manager8\
Data Mode=0 Data Path=c:\manager8\ / c:\manager8\
!!UserID =
!!ShowSchedule .awp Criteria=UPPER%28cocrsenm%29%20LIKE%20%25 Called by
!Passed in Cursor Criteria=UPPER(cocrsenm) LIKE % Group= Cat Criteria= Passed in SQL criteria=
Parameter Criteria=UPPER(cocrsenm) LIKE %
Title= Target= URL=https://registration.freeu.com/wconnect/ShowSchedule.awp? Mode=
HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm
Group=
Ready for main query: code:Code;Course_Name:Title;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee Course_Name:Title; c...
Ready for main query: code:Code;Course_Name:Title;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee Course_Name:Title; c...
VFP: SELECT Course.* , Fees.* FROM Course JOIN Fees ON UPPER(fecrse) == UPPER(cocrse) AND NOT fees.fewebhide AND (fees.f...
Finished initial Course query: 132 records Session: rbOdCbkei7SZovtk0
Finished initial Course query: 132 records Session: rbOdCbkei7SZovtk0
Schedule with Fullfee: 131 records, grouped by cocrse
!Finished supplemental queries. Record count= 131
!Finished supplemental queries. Record count= 131
!Finished supplemental queries. Record count= 131
Cursor Criteria=UPPER(cocrsenm) LIKE % Extra Criteria=
Criteria=(UPPER(cocrsenm) LIKE %) Groupmode=.F.
Criteria applied to tSchedule. 131 records, done with Schedule queries
Found 131 matching courses. Async? Yes Criteria to be applied=(UPPER(cocrsenm) LIKE %) Mode= Target=

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