An ACEweb Error Occurred

Error: "Syntax error." in line 13517 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 20180321 ( 8:12:34 on 03/21/2018)
            Server Time: 12/12/2019 02:17:32 PM
           VFP Error No: 10
                Message: Syntax error.
                Program: showschedule
                Line No: 13517
                   Code:  
              Client IP: 3.234.214.179
     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.	Object	Module	Line	Code
1.	.processhit	wwserver.prg	743
2.	.process	acewebmain3.prg	1449
3.	acecode	acecode.prg	85
4.	acecode.process	acecode.prg	116
5.	wwprocess.process	wwprocess.prg	356
6.	acecode.routerequest	wwprocess.prg	438
7.	acecode.showschedule	acecode.prg	13517
8.	acecode.error	awprocess.prg	223
9.	acecode.errreport	awprocess.prg	406

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

Data Sessions

Data Session Open Workarea Information

No	Alias	Table	Record No.	Record Count
6	TSCHEDSHOW	C:\WINDOWS\TEMP\00005HJT0CZV.TMP	1	236
8	TSCHEDULE	C:\WINDOWS\TEMP\00005HJT0CZR.TMP	1	237
3	WWSESSION	C:\INETPUB\ACEWEB\WWSESSION.DBF	57,420	57,420
2	AWDB191212	C:\INETPUB\ACEWEB\AWDB191212.DBF	87,130	87,130
1	CGILOG	C:\INETPUB\ACEWEB\WWREQUESTLOG.DBF	579,435	579,435

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

List Memory
Module	Variable	Scope	Type	Value
PUBLIC	GOWCSERVER	Pub	O	ACEWEBSERVER
PUBLIC	__REGEX	Pub	O	VBSCRIPT REGULAR EXPRESSION
processhit	LLFILE	Local	L	.F.
	LNSECONDS	Local	N	51451.872 ( 51451.87200000)
	LCTIME	Local	L	.F.
	LOHTML	Local	L	.F.
acecode	LOSERVER	Local	O	ACEWEBSERVER
	LOPROCESS	Local	O	ACECODE
	REQUEST	(hid)	L	.NULL.
	RESPONSE	(hid)	L	.NULL.
	SERVER	(hid)	L	.NULL.
	SESSION	(hid)	L	.NULL.
	PROCESS	(hid)	L	.NULL.
process	OEVAL	Priv	O	WWEVAL
	OUTIL	Priv	O	AWUTILS
	MAPEXT	Priv	C	".awp"
	STANDARD	Priv	O	AWSTANDARDTEMPLATE
	MINIMAL	Priv	O	AWMINIMALTEMPLATE
	PCSYSHOME	Priv	C	"C:\INETPUB\ACEWEB\"
	OFACTORY	Priv	O	AWFACTORY
	SM71	Priv	L	.T.
	SM71B	Priv	L	.T.
	OBRIDGE	Priv	L	.NULL.
	PAGETITLE	Priv	C	"##pcTitle##"
	OBIZ	Priv	O	AWBUSINESS
	OJQCONFIG	Priv	O	JQUERYCONFIG
	PROCESS	Priv	O	ACECODE
	SERVER	Priv	O	ACEWEBSERVER
	REQUEST	Priv	O	WWREQUEST
	RESPONSE	Priv	O	WWPAGERESPONSE40
	SESSION	Priv	O	WWSESSION
	CONFIG	Priv	O	ACECODECONFIG
routerequest	LLERROR	Local	L	.F.
	LCPHYSICAL	Local	C	"c:\inetpub\wwwroot\wconnect\ShowSchedule.awp"
	LCCMD	Local	C	"THIS.showschedule()"
showschedule	LCTITLE	Local	L	.F.
	LLEXEMPT	Local	L	.F.
	LCNPARAMS	Local	L	.F.
	LAHEADS	Local	A
	LCCRITERIA	Local	C	"(UPPER(cocrsenm) LIKE %)"
	LCHT1	Local	C	"<!DOCTYPE ..." 4117 bytes
	LCHT2	Local	C	"<div id="t..." 2212 bytes
"2	LCHTCONFIG	Local	C
showschedule	LCKEYWORDS	Local	L	.F.
	LCMODE	Local	C	""
	LCORDERBY	Local	L	.F.
	LCTARGET	Local	C	""
	LCHT	Local	L	.F.
	LCPAGEFOOT	Local	L	.F.
	LCDP	Local	C	"c:\manager8\"
	LCFLD	Local	L	.F.
	LCFULLMSG	Local	C	"<STRONG> Full</strong>"
	LNPOS	Local	L	.F.
	LCFIELDS	Local	C	"Course_Name:Title;Begins:Begins;Ends:Ends;Cocrsetm:Meets;FullFee:Fee,Course_Name:Title; cotype:Type; FullFee:Fee"
	LNNAMELEN	Local	N	95 ( 95.00000000)
	LLPRELIST	Local	L	.F.
	LNCOLS	Local	L	.F.
	LNROWS	Local	L	.F.
	LLHASASYNC	Local	L	.T.
	LCTEMP	Local	C	************************************************************
	I	Local	N	***********************************************************************************
	LNOVERRIDE	Local	N	0 ( 0.00000000)
	LCSEARCH	Local	C	""
	LCLIB	Local	L	.F.
	LOIP	Local	L	.F.
	LCTEMPLATE	Local	C	""
	LCHTFILE	Local	C	"C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm"
	LCPRESHOWN	Local	L	.F.
	LNLEN	Local	L	.F.
	LCSORRY	Local	L	.F.
	LCCURSOR	Local	L	.F.
	LCSOURCE	Local	L	.F.
	LLREORDER	Local	L	.F.
	LLSORRY	Local	L	.F.
	LCVSQL	Local	C	"SELECT Cou..." 409 bytes
	LCTSQL	Local	C	"SELECT Cou..." 518 bytes
	LLEBEXPIRE	Local	L	.F.
	LLSQL	Local	L	.F.
	LCDAY	Priv	C	"20191212"
	__OVERRIDE	Priv	N	0 ( 0.00000000)
	PCTEST	Priv	C	"Logon Status Here"
	PCTITLE	Priv	C	"Extended Listing"
	PCDESCRIPT	Priv	C	""
	PCGROUP	Priv	C	""
	PCSORRY	Priv	C	""
	PCBONUSMSG	Priv	C	""
	PCSUBGROUP	Priv	C	""
	PCPREVIOUS	Priv	C	""
	PCURL	Priv	C	"https://www.freeuregistration.com/wconnect/ShowSchedule.awp?"
	LCEFINI	Priv	C	"C:\INETPUB\ACEWEB\ExpireFees.ini"
error	LNERROR	Local	N	10 ( 10.00000000)
	LCMETHOD	Local	C	"showschedule"
	LNLINE	Local	N	13517 ( 13517.00000000)
	LCBADBOTS	Local	L	.F.
	LCBROWSER	Local	C	"CCBot/2.0 (https://commoncrawl.org/faq/)"
	LCEPILOGUE	Local	L	.F.
	LCPROLOGUE	Local	L	.F.
	LCTITLE	Local	L	.F.
	LLSENDTHIS	Local	L	.F.
	LOEXC	Local	L	.F.
	I	Local	L	***
	LCBUILD	Local	C	"AW3.EXE 20180321 ( 8:12:34 on 03/21/2018)"
	LAFILES	Priv	A
errreport	LCTXT	Local	L	.F.
	LCUSER	Local	C	""
	LCIP	Local	C	"3.234.214.179"
	LCURL	Local	C	"https://www.freeuregistration.com/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25"
	LCOLDURL	Local	C	"[none: bookmark, email, or manually-typed URL]"
	LCTOPLINK	Local	C	"<a class="DebugInfoSectionLinks" href="#Top">[back to top]</a>"
	LLREQUEST	Local	L	.F.
	LCPROLOGUE	Local	L	.F.
	LCSTYLE	Local	L	.F.
	LCEPILOGUE	Local	L	.F.
	LCMSG	Local	L	.F.
	LCPAGEMENU	Local	C	"<a class="DebugInfoSectionLinks" href="#ProgramStack">[program stack]</a><a class="DebugInfoSectionLinks" href="#DataSessions">[data sessions]</a>"
	LCMAILMENU	Local	C	""
	LCOLDERROR	Local	L	.F.
	LCBROWSER	Local	C	"CCBot/2.0 (https://commoncrawl.org/faq/)"
	LCTEMP	Local	L	***
	LCPWDFLDS	Local	L	.F.
	LCNAME	Local	L	.F.
	LCVALUE	Local	L	.F.
	LCIDENTITY	Local	C	"SYSTEM"
	LCBUILD	Local	C	"AW3.EXE 20180321 ( 8:12:34 on 03/21/2018)"
l7showmemory	LLNOHTML	Local	L	.F.
	LLUSEFORM	Local	L	.F.
	LCMEMORY	Local	L	.F.
	LCFILE	Local	C	"C:\WINDOWS\TEMP\51452388.TXT"
	LCSTYLE	Local	L	.F.
	LNAT	Local	L	.F.
ailable	16176	variables	a

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

Server Variables
DLLVersion	Web Connection 6.18 (ISAPI Handler)
REQUESTID	1144_844D719C5675
wcConfig	c:\inetpub\wwwroot\wconnect\wc.INI
REQUEST_METHOD	GET
QUERY_STRING	Criteria=UPPER%28cocrsenm%29%20LIKE%20%25
Executable Path	/wconnect/ShowSchedule.awp
CONTENT_LENGTH	0
PATH_INFO	/wconnect/ShowSchedule.awp
PATH_TRANSLATED	c:\inetpub\wwwroot\wconnect\ShowSchedule.awp
SCRIPT_NAME	/wconnect/ShowSchedule.awp
PHYSICAL_PATH	c:\inetpub\wwwroot\wconnect\ShowSchedule.awp
WEBROOT_PATH	C:\inetpub\wwwroot
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	Microsoft-IIS/8.5
SERVER_NAME	www.freeuregistration.com
SERVER_PORT	443
SERVER_ACCOUNT	SYSTEM
REMOTE_HOST	3.234.214.179
REMOTE_ADDR	3.234.214.179
HTTP_USER_AGENT	CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_ACCEPT	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
HTTP_ACCEPT_ENCODING	gzip
HTTP_ACCEPT_LANGUAGE	en-US,en;q=0.5
APPL_PHYSICAL_PATH	c:\inetpub\wwwroot\wconnect\
APPL_MD_PATH	/LM/W3SVC/1/ROOT/WConnect
HTTP_CONNECTION	Keep-Alive
CACHE_URL	https://www.freeuregistration.com:443/wconnect/ShowSchedule.awp?Criteria=UPPER%28cocrsenm%29%20LIKE%20%25
CERT_KEYSIZE	256
CERT_SECRETKEYSIZE	2048
CERT_SERVER_SUBJECT	OU=Domain Control Validated, CN=freeuregistration.com
CERT_SERVER_ISSUER	C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
GMT_OFFSET	-25200
ALL_HTTP (Variables previously displayed will not be shown below)
HTTP_ACCEPT	text/html,application/xhtml xml,application/xml;q=0.9,/;q=0.8
HTTP_HOST	www.freeuregistration.com
HTTP_IF_MODIFIED_SINCE	Sat, 21 Sep 2019 17:13:42 CEST

[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 Data Mode=0 Data Path=c:\manager8\ Data Mode=0 Data Path=c:\manager8\ Data Mode=0 Data Path=c:\manager8\ Data Mode=0 Data Path=c:\manager8\ Data Mode=0 Data Path=c:\manager8\ Data Mode=0 Data Path=c:\manager8\ Data Mode=0 Data Path=c:\manager8\ Data Mode=0 Data Path=c:\manager8\ !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... Finished initial Course query: 261 records Session: kYdWtkDnVffeneFz_ Scheduled Fullfee: 237 records !Finished supplemental queries. Record count= 237 Cursor Criteria=UPPER(cocrsenm) LIKE % Extra Criteria= Criteria=(UPPER(cocrsenm) LIKE %) Groupmode=.F. Criteria applied to tSchedule. 237 records, done with Schedule queries Found 237 matching courses. Async? Yes Criteria to be applied=(UPPER(cocrsenm) LIKE %) Mode= Target=

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
Data Mode=0  Data Path=c:\manager8\
Data Mode=0  Data Path=c:\manager8\
Data Mode=0  Data Path=c:\manager8\
Data Mode=0  Data Path=c:\manager8\
Data Mode=0  Data Path=c:\manager8\
Data Mode=0  Data Path=c:\manager8\
Data Mode=0  Data Path=c:\manager8\
Data Mode=0  Data Path=c:\manager8\
!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...
 Finished initial Course query: 261 records  Session: kYdWtkDnVffeneFz_
Scheduled Fullfee: 237 records
!Finished supplemental queries.  Record count= 237
Cursor Criteria=UPPER(cocrsenm) LIKE % Extra Criteria=
Criteria=(UPPER(cocrsenm) LIKE %) Groupmode=.F.
Criteria applied to tSchedule. 237 records, done with Schedule queries
Found 237 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]