An ACEweb Error Occurred

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

[program stack][data sessions][memory variables][server vars][trace output]
            Current URL: https://www.freeuregistration.com/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25
                Referer: [none: bookmark, email, or manually-typed URL]
          Error Handler: Acecode.Error()
                  Build: AW3.EXE 20191125 (23:15:28 on 11/25/2019)
            Server Time: 07/06/2020 02:27:41 AM
           VFP Error No: 10
                Message: Syntax error.
                Program: showschedule
                Line No: 13849
                   Code:  
              Client IP: 18.232.186.117
     Authenticated User: 
           Exe Identity: SYSTEM
                Browser: CCBot/2.0 (https://commoncrawl.org/faq/)
            HTTP Method: GET
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Program Stack
No.ObjectModuleLineCode
1. .processhit wwserver.prg 721
2. .process acewebmain3.prg 1510
3. acecode acecode.prg 88
4. acecode.process acecode.prg 120
5. wwprocess.process wwprocess.prg 390
6. acecode.routerequest wwprocess.prg 474
7. acecode.showschedule acecode.prg 13849
8. acecode.error awprocess.prg 225
9. acecode.errreport awprocess.prg 409
[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\00007YFT0F3Y.TMP 1 643
8TSCHEDULEC:\WINDOWS\TEMP\00007YFT0F3U.TMP 1 644
3WWSESSIONC:\INETPUB\ACEWEB\WWSESSION.DBF 58,602 58,602
2AWDB200706C:\INETPUB\ACEWEB\AWDB200706.DBF 27,732 27,732
1CGILOGC:\INETPUB\ACEWEB\WWREQUESTLOG.DBF 214,661 214,661
[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
processhit LLFILELocalL .F.
LNSECONDSLocalN 8861.227 ( 8861.22700000)
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##"
OBIZPrivO AWBUSINESS
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 ..." 4117 bytes
LCHT2LocalC "<div id="t..." 2212 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 "Course_Name:Title;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee,Course_Name:Title; cotype:Type; FullFee:Fee"
LNNAMELENLocalN 95 ( 95.00000000)
LLPRELISTLocalL .F.
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..." 403 bytes
LCTSQLLocalC "SELECT Cou..." 513 bytes
LLEBEXPIRELocalL .F.
LLSQLLocalL .F.
LCDAYPrivC "20200706"
__OVERRIDEPrivN 0 ( 0.00000000)
PCTESTPrivC "Logon Status Here"
PCTITLEPrivC "Extended Listing"
PCDESCRIPTPrivC ""
PCGROUPPrivC ""
PCSORRYPrivC ""
PCBONUSMSGPrivC ""
PCSUBGROUPPrivC ""
PCPREVIOUSPrivC ""
PCURLPrivC "https://www.freeuregistration.com/wconnect/ShowSchedule.awp?"
LCEFINIPrivC "C:\INETPUB\ACEWEB\ExpireFees.ini"
error LNERRORLocalN 10 ( 10.00000000)
LCMETHODLocalC "showschedule"
LNLINELocalN 13849 ( 13849.00000000)
LCBADBOTSLocalL .F.
LCBROWSERLocalC "CCBot/2.0 (https://commoncrawl.org/faq/)"
LCEPILOGUELocalL .F.
LCPROLOGUELocalL .F.
LCTITLELocalL .F.
LLSENDTHISLocalL .F.
LOEXCLocalL .F.
ILocalL ***
LCBUILDLocalC "AW3.EXE 20191125 (23:15:28 on 11/25/2019)"
LAFILESPrivA
errreport LCTXTLocalL .F.
LCUSERLocalC ""
LCIPLocalC "18.232.186.117"
LCURLLocalC "https://www.freeuregistration.com/wconnect/ShowSchedule.awp?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 "CCBot/2.0 (https://commoncrawl.org/faq/)"
LCTEMPLocalL ***
LCPWDFLDSLocalL .F.
LCNAMELocalL .F.
LCVALUELocalL .F.
LCIDENTITYLocalC "SYSTEM"
LCBUILDLocalC "AW3.EXE 20191125 (23:15:28 on 11/25/2019)"
l7showmemory LLNOHTMLLocalL .F.
LLUSEFORMLocalL .F.
LCMEMORYLocalL .F.
LCFILELocalC "C:\WINDOWS\TEMP\8861821.TXT"
LCSTYLELocalL .F.
LNATLocalL .F.
ailable16167variablesa
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Server Variables
DLLVersionWeb Connection 7.08 (ISAPI Handler)
REQUESTID5088_116E0997D5C8
wcConfigc:\inetpub\wwwroot\wconnect\wc.INI
REQUEST_METHODGET
QUERY_STRINGCriteria=UPPER%28cocrsenm%29%20LIKE%20%25
Executable Path/wconnect/ShowSchedule.awp
CONTENT_LENGTH0
PATH_INFO/wconnect/ShowSchedule.awp
PATH_TRANSLATEDc:\inetpub\wwwroot\wconnect\ShowSchedule.awp
SCRIPT_NAME/wconnect/ShowSchedule.awp
PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\ShowSchedule.awp
WEBROOT_PATHC:\inetpub\wwwroot
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/8.5
SERVER_NAMEwww.freeuregistration.com
SERVER_PORT443
SERVER_ACCOUNTSYSTEM
REMOTE_HOST18.232.186.117
REMOTE_ADDR18.232.186.117
HTTP_USER_AGENTCCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODINGbr,gzip
HTTP_ACCEPT_LANGUAGEen-US,en;q=0.5
APPL_PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\
APPL_MD_PATH/LM/W3SVC/1/ROOT/WConnect
HTTP_CONNECTIONKeep-Alive
CACHE_URLhttps://www.freeuregistration.com:443/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25
CERT_KEYSIZE256
CERT_SECRETKEYSIZE2048
CERT_SERVER_SUBJECTOU=Domain Control Validated, CN=freeuregistration.com
CERT_SERVER_ISSUERC=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
SCRIPT_TRANSLATED\\?\c:\inetpub\wwwroot\wconnect\ShowSchedule.awp
APP_POOL_IDWest Wind Web Connection
GMT_OFFSET-25200
ALL_HTTP (Variables previously displayed will not be shown below)
HTTP_ACCEPTtext/html,application/xhtml xml,application/xml;q=0.9,*/*;q=0.8
HTTP_HOSTwww.freeuregistration.com
HTTP_IF_MODIFIED_SINCEFri, 13 Dec 2019 04:17:11 KRAT
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Trace Output
!!showschedule
! URL=https://www.freeuregistration.com/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25
! URL=https://www.freeuregistration.com/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25
! URL=https://www.freeuregistration.com/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25
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\
!!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://www.freeuregistration.com/wconnect/ShowSchedule.awp? Mode=
HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm
Group=
Ready for main query: Course_Name:Title;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee Course_Name:Title; cotype:Type...
Ready for main query: Course_Name:Title;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee Course_Name:Title; cotype:Type...
VFP: SELECT Course.* , Fees.* FROM Course JOIN Fees ON UPPER(fecrse) == UPPER(cocrse) AND NOT fees.fewebhide AND (fees.f...
Finished initial Course query: 679 records Session: TJtUvKhh1SLBuxox0
Scheduled Fullfee: 644 records
!Finished supplemental queries. Record count= 644
Cursor Criteria=UPPER(cocrsenm) LIKE % Extra Criteria=
Criteria=(UPPER(cocrsenm) LIKE %) Groupmode=.F.
Criteria applied to tSchedule. 644 records, done with Schedule queries
Found 644 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]