An ACEweb Error Occurred

Error: "SQL: Column 'DATE' is not found." in line 850 of Acecode.query

[program stack][data sessions][memory variables][server vars][trace output]
            Current URL: https://acewareuniversity.com:5000?&Mode=GROUP&Group=:FULL&groupBreak=1&AsyncTypes=None&Title=All+Courses
                Referer: [none: bookmark, email, or manually-typed URL]
          Error Handler: Acecode.Error()
                  Build: AW3.EXE 20240517 (14:57:22 on 05/17/2024)
            Server Time: 05/24/2024 09:38:51 PM
           VFP Error No: 1806
                Message: SQL: Column 'DATE' is not found.
                Program: query
                Line No: 850
                   Code:  
              Client IP: 44.211.117.197
     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. acewebmain3 acewebmain3.prg 74
2. acewebserver.tmrfiletimer.timer wcvisual.vct 39 loServer.ProcessHit(@lcCommandLine)
3. acewebserver.processhit wwserver.prg 717
4. acewebserver.process acewebmain3.prg 1790
5. acecode acecode.prg 88
6. acecode.process acecode.prg 120
7. wwprocess.process wwprocess.prg 393
8. acecode.routerequest wwprocess.prg 481
9. acecode.showschedule acecode.prg 15436
10. awbusinessobject.query awbusinessobject.prg 1307
11. wwbusinessobject.query wwbusinessobject.prg 850
12. acecode.error awprocess.prg 245
13. acecode.errreport awprocess.prg 560
[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
9CHOICESC:\AWDEMO\CHOICES.DBF 1 418
8GROUPINGC:\AWDEMO\GROUPING.DBF 1 600
7CRSEUDFSC:\AWDEMO\CRSEUDFS.DBF 1 271
6FEESC:\AWDEMO\FEES.DBF 1 721
4COURSEC:\AWDEMO\COURSE.DBF 1 271
3WWSESSIONC:\INETPUB\ACEWEB\WWSESSION.DBF 151,028 151,028
2AWDB240524C:\INETPUB\ACEWEB\AWDB240524.DBF 66,152 66,152
1CGILOGC:\INETPUB\ACEWEB\WWREQUESTLOG.DBF 209,327 209,327
[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
__GOEVALPubO WWEVAL
acewebmain3 LCSYSHOMELocalC "C:\INETPUB\ACEWEB"
LAVERLocalA
LCEXELocalL .F.
LOAPIPrivO WWAPI
timer LOSERVERLocalO ACEWEBSERVER
processhit LLFILELocalL .F.
LNSECONDSLocalN 77930.836 ( 77930.83600000)
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
LCCRITERIALocalL .F.
LCHT1LocalC "<!DOCTYPE ..." 7187 bytes
LCHT2LocalC "<div id="t..." 2108 bytes
LCHTCONFIGLocalL .F.
LCKEYWORDSLocalL .F.
LCMODELocalC "GROUP"
LCORDERBYLocalL .F.
LCTARGETLocalC ""
LCHTLocalL .F.
LCPAGEFOOTLocalL .F.
LCDPLocalC "c:\AWDemo\"
LCFLDLocalL .F.
LCFULLMSGLocalC "<STRONG> Closed</STRONG>"
LNPOSLocalL .F.
LCFIELDSLocalC "course_name:Title;cudfc4:Example;begins:Begins;fee:Fee;cudfc3:Delivery,course_name:Title;cotype:Type;[<div class="awRightText">]+iif(cotype="Donation","Make a Donation",transform(fee,[99,999.99]))+[</div>]:Fee"
LNNAMELENLocalN 95 ( 95.00000000)
LLPRELISTLocalL .F.
LLFULLFEELocalL .F.
LNCOLSLocalL .F.
LNROWSLocalL .F.
LLHASASYNCLocalL .T.
LCTEMPLocalL ***
ILocalL ***
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..." 830 bytes
LCTSQLLocalC "SELECT Cou..." 620 bytes
LLEBEXPIRELocalL .F.
LLSQLLocalL .F.
LCGROUPBYLocalL .F.
LCDIALOGQSLocalC ""
LNCOUNT1LocalL .F.
LLINSTRUCTLocalL .F.
LLPACKAGE2LocalL .T.
LCDAYPrivC "20240524"
__OVERRIDEPrivN 0 ( 0.00000000)
PCTESTPrivC "Logon Status Here"
PCTITLEPrivC "All Courses"
PCDESCRIPTPrivC ""
PCGROUPPrivC ":FULL"
PCSORRYPrivC ""
PCBONUSMSGPrivC ""
PCSUBGROUPPrivC ""
PCPREVIOUSPrivC ""
PCURLPrivC "https://studentmanager.aceware.com/wconnect/ShowSchedule.awp?"
query LCSELECTLocalC "SELECT Cou..." 830 bytes
LCCURSORLocalC "tSchedule"
LLNOFILTERLocalL .F.
LCDPLocalL .F.
LNRESULTLocalL .F.
LCERRORMSGLocalL .F.
LCSELECTLocalC "SELECT Cou..." 851 bytes
LCCURSORLocalC "tSchedule"
LNRESULTLocalL .F.
error LNERRORLocalN 1806 ( 1806.00000000)
LCMETHODLocalC "query"
LNLINELocalN 850 ( 850.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 20240517 (14:57:22 on 05/17/2024)"
LLRESTLocalL .F.
LCIPLocalC "44.211.117.197"
LCFORMVARSLocalC "&"
LAFILESPrivA
LCURLPrivC "http://acewareuniversity.com:5000/wconnect/ShowSchedule.awp?&Mode=GROUP&Group=:FULL&groupBreak=1&AsyncTypes=None&Title=All+Courses"
errreport LCTXTLocalL .F.
LCUSERLocalC ""
LCIPLocalC "44.211.117.197"
LCURLLocalC "https://acewareuniversity.com:5000?&Mode=GROUP&Group=:FULL&groupBreak=1&AsyncTypes=None&Title=All+Courses"
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 20240517 (14:57:22 on 05/17/2024)"
l7showmemory LLNOHTMLLocalL .F.
LLUSEFORMLocalL .F.
LCMEMORYLocalL .F.
LCFILELocalC "C:\WINDOWS\TEMP\77930867.TXT"
LCSTYLELocalL .F.
LNATLocalL .F.
ailable16131variablesa
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Server Variables
PHYSICAL_PATHc:\inetpub\wwwroot\wconnect\ShowSchedule.awp
QUERY_STRING
ModeGROUP
Group:FULL
groupBreak1
AsyncTypesNone
TitleAll+Courses
SCRIPT_NAME/wconnect/ShowSchedule.awp
REQUESTID353090309791116_34
DLLVERSIONWeb Connection Handler 7.32.2 (.NET Handler)
WCCONFIGc:\inetpub\wwwroot\wconnect\web.config
ADMIN_PAGE/wconnect/admin/admin.aspx
APPL_WEB_PATHhttp://acewareuniversity.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.108.2
PATH_INFO/wconnect/ShowSchedule.awp
PATH_TRANSLATEDc:\inetpub\wwwroot\wconnect\ShowSchedule.awp
REMOTE_ADDR172.31.38.186
REMOTE_HOST172.31.38.186
REMOTE_PORT25922
REQUEST_METHODGET
SERVER_NAMEacewareuniversity.com
SERVER_PORT5000
SERVER_PORT_SECURE0
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
URL/wconnect/ShowSchedule.awp
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
HTTP_HOSTacewareuniversity.com
HTTP_USER_AGENTCCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_X_FORWARDED_FOR44.211.117.197
HTTP_X_FORWARDED_PROTOhttps
HTTP_X_FORWARDED_PORT443
HTTP_X_AMZN_TRACE_IDRoot=1-66514f3a-11c8771c2df9d6925458e072
Output Filec:\temp\wc\WC_353090309791116_34.out
[back to top][program stack][data sessions][memory variables][server vars][trace output]
Trace Output
!!showschedule
! URL=http://acewareuniversity.com:5000/wconnect/ShowSchedule.awp?&Mode=GROUP&Group=:FULL&groupBreak=1&AsyncTypes=None&Ti...
! URL=http://acewareuniversity.com:5000/wconnect/ShowSchedule.awp?&Mode=GROUP&Group=:FULL&groupBreak=1&AsyncTypes=None&Ti...
! URL=http://acewareuniversity.com:5000/wconnect/ShowSchedule.awp?&Mode=GROUP&Group=:FULL&groupBreak=1&AsyncTypes=None&Ti...
Data Mode=0 Data Path=c:\AWDemo\ / c:\AWDemo\
Data Mode=0 Data Path=c:\AWDemo\ / c:\AWDemo\
Data Mode=0 Data Path=c:\AWDemo\ / c:\AWDemo\
Data Mode=0 Data Path=c:\AWDemo\ / c:\AWDemo\
Data Mode=0 Data Path=c:\AWDemo\ / c:\AWDemo\
Data Mode=0 Data Path=c:\AWDemo\ / c:\AWDemo\
Data Mode=0 Data Path=c:\AWDemo\ / c:\AWDemo\
Data Mode=0 Data Path=c:\AWDemo\ / c:\AWDemo\
!!UserID =
!!ShowSchedule .awp &Mode=GROUP&Group=:FULL&groupBreak=1&AsyncTypes=None&Title=All+Courses Called by
!Passed in Cursor Criteria= Group=:FULL Cat Criteria= Passed in SQL criteria=
Parameter Criteria=
Title=All Courses Target= URL=https://studentmanager.aceware.com/wconnect/ShowSchedule.awp? Mode=GROUP
Group Mode: 0 choices found for Group=:FULL Subgroup=
HTML Template=C:\InetPub\wwwroot\wconnect\ace\XShowSchedule.htm
Template INI=C:\InetPub\wwwroot\wconnect\ace\ShowSchedule.INI
Group=:FULL
Ready for main query: course_name:Title;cudfc4:Example;begins:Begins;fee:Fee;cudfc3:Delivery course_name:Title;cotype:Typ...
Joining Course UDFs
Joined Grouping for Group=:FULL
Joined Grouping for Group=:FULL
VFP: SELECT Course.* , Fees.* , Crseudfs.* , grcode, discript AS Group_Name FROM Course JOIN Fees ON fees.fecrse = cours...

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