Catch
Entries: 15 |
| additional | | Struct (ordered) | | SQL | | string | SELECT SQL_CALC_FOUND_ROWS
blog.websiteID,
blog.blogID,
blog.title,
blog.content,
blog.imageAltText,
blog.thumnail as largeImage,
blog.thumnail,
blog.code,
blog.author,
blog.isActive,
ifNull(blog.datePublish,blog.dateCreated) AS datePublish,
blog.metaDescription,
blog.metaKeywords,
blog.isCopyScapeEnabled,
blog.isCopyScapeProcessed,
blog.isCopyScapePass,
blog.readabilityScore,
blog.isReviewed,
ifNull(blog.dateUpdated,blog.dateCreated) AS dateUpdated,
blog.dateCreated
FROM
blogs blog
WHERE
blog.websiteID = 6
AND
blog.isActive=1
AND
blog.blogID IN (
SELECT
blog.blogID
FROM
blogs blog
INNER JOIN blogCategoryMX blogCategoryMX ON blog.blogID = blogCategoryMX.blogID
INNER JOIN blogCategories blogCategories ON blogCategoryMX.blogCategoryID = blogCategories.blogCategoryID
WHERE
blogCategories.blogCategoryCode = 'citizenship'
AND
blogCategories.websiteID = 6
)
AND
(blog.datePublish <= now() OR blog.datePublish IS NULL)
GROUP BY
blog.blogID,
blog.title,
blog.author,
blog.isActive
ORDER BY
blog.datePublish
DESC
LIMIT 0
,
6 |
|
|
| DataSource | |
| Detail | | string | available columns are [WEBSITEID, BLOGID, TITLE, CONTENT, IMAGEALTTEXT, LARGEIMAGE, THUMNAIL, CODE, AUTHOR, ISACTIVE, DATEPUBLISH, METADESCRIPTION, METAKEYWORDS, ISCOPYSCAPEENABLED, ISCOPYSCAPEPROCESSED, ISCOPYSCAPEPASS, READABILITYSCORE, ISREVIEWED, DATEUPDATED, DATECREATED] |
|
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | Column [BLOGCATEGORIES] not found in query |
|
| NativeErrorCode | |
| queryError | | string | SELECT SQL_CALC_FOUND_ROWS
blog.websiteID,
blog.blogID,
blog.title,
blog.content,
blog.imageAltText,
blog.thumnail as largeImage,
blog.thumnail,
blog.code,
blog.author,
blog.isActive,
ifNull(blog.datePublish,blog.dateCreated) AS datePublish,
blog.metaDescription,
blog.metaKeywords,
blog.isCopyScapeEnabled,
blog.isCopyScapeProcessed,
blog.isCopyScapePass,
blog.readabilityScore,
blog.isReviewed,
ifNull(blog.dateUpdated,blog.dateCreated) AS dateUpdated,
blog.dateCreated
FROM
blogs blog
WHERE
blog.websiteID = 6
AND
blog.isActive=1
AND
blog.blogID IN (
SELECT
blog.blogID
FROM
blogs blog
INNER JOIN blogCategoryMX blogCategoryMX ON blog.blogID = blogCategoryMX.blogID
INNER JOIN blogCategories blogCategories ON blogCategoryMX.blogCategoryID = blogCategories.blogCategoryID
WHERE
blogCategories.blogCategoryCode = 'citizenship'
AND
blogCategories.websiteID = 6
)
AND
(blog.datePublish <= now() OR blog.datePublish IS NULL)
GROUP BY
blog.blogID,
blog.title,
blog.author,
blog.isActive
ORDER BY
blog.datePublish
DESC
LIMIT 0
,
6 |
|
| Sql | | string | SELECT SQL_CALC_FOUND_ROWS
blog.websiteID,
blog.blogID,
blog.title,
blog.content,
blog.imageAltText,
blog.thumnail as largeImage,
blog.thumnail,
blog.code,
blog.author,
blog.isActive,
ifNull(blog.datePublish,blog.dateCreated) AS datePublish,
blog.metaDescription,
blog.metaKeywords,
blog.isCopyScapeEnabled,
blog.isCopyScapeProcessed,
blog.isCopyScapePass,
blog.readabilityScore,
blog.isReviewed,
ifNull(blog.dateUpdated,blog.dateCreated) AS dateUpdated,
blog.dateCreated
FROM
blogs blog
WHERE
blog.websiteID = 6
AND
blog.isActive=1
AND
blog.blogID IN (
SELECT
blog.blogID
FROM
blogs blog
INNER JOIN blogCategoryMX blogCategoryMX ON blog.blogID = blogCategoryMX.blogID
INNER JOIN blogCategories blogCategories ON blogCategoryMX.blogCategoryID = blogCategories.blogCategoryID
WHERE
blogCategories.blogCategoryCode = 'citizenship'
AND
blogCategories.websiteID = 6
)
AND
(blog.datePublish <= now() OR blog.datePublish IS NULL)
GROUP BY
blog.blogID,
blog.title,
blog.author,
blog.isActive
ORDER BY
blog.datePublish
DESC
LIMIT 0
,
6 |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: Column [BLOGCATEGORIES] not found in query
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1152)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2071)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:278)
at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1569)
at __138.__138.australiacitizenshiptest_com_au2484.pages.blog.inc_lstblogs_cfm$cf.call(../../australiacitizenshiptest.com.au/pages/blog/inc_lstBlogs.cfm:9)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931)
at __138.__138.australiacitizenshiptest_com_au2484.pages.inc_blog_cfm$cf.call(../../australiacitizenshiptest.com.au/pages/inc_blog.cfm:49)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931)
at __138.__138.australiacitizenshiptest_com_au2484.pages.blog_cfm$cf.call(../../australiacitizenshiptest.com.au/pages/blog.cfm:1)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931)
at __138.__138._shared.au_ctz._404_cfm$cf$36c.call(../../_shared/au_ctz/404.cfm:214)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931)
at _404_cfm$cf$2uh.call(/404.cfm:2)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931)
at application_cfc$cf.udfCall(/drivingschoolwebsites/Application.cfc:110)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:356)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:701)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:589)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:446)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:220)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2494)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2480)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2451)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1219)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1165)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:836)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1839)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 7: <cfoutput><br>
8: <cfif len(url.category) gt 0><br>
<b>9: <h1 class="mt-0">#listFirst(variables.qryBlogs.blogCategories,",")#</h1></b><br>
10: <cfelseif not (left(Request.pageURL,4) neq "blog")><br>
11: <h1 class="mt-0">Blogs</h1><br>
|
| | codePrintPlain | | string | 7: <cfoutput>
8: <cfif len(url.category) gt 0>
9: <h1 class="mt-0">#listFirst(variables.qryBlogs.blogCategories,",")#</h1>
10: <cfelseif not (left(Request.pageURL,4) neq "blog")>
11: <h1 class="mt-0">Blogs</h1>
|
| | column | | | id | | | line | | | Raw_Trace | | string | __138.__138.australiacitizenshiptest_com_au2484.pages.blog.inc_lstblogs_cfm$cf.call(../../australiacitizenshiptest.com.au/pages/blog/inc_lstBlogs.cfm:9) |
| | template | | string | C:\eprotech\drivingSchoolApp\_websites\australiacitizenshiptest.com.au\pages\blog\inc_lstBlogs.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 47: <cfif url.contenttype eq "listing"><br>
48: <cfif variables.qryBlogs.recordcount gt 0><br>
<b>49: <cfinclude template="./blog/inc_lstBlogs.cfm"/></b><br>
50: <cfelse><br>
51: <cfheader statuscode="404" statustext="Not Found" /><br>
|
| | codePrintPlain | | string | 47: <cfif url.contenttype eq "listing">
48: <cfif variables.qryBlogs.recordcount gt 0>
49: <cfinclude template="./blog/inc_lstBlogs.cfm"/>
50: <cfelse>
51: <cfheader statuscode="404" statustext="Not Found" />
|
| | column | | | id | | | line | | | Raw_Trace | | string | __138.__138.australiacitizenshiptest_com_au2484.pages.inc_blog_cfm$cf.call(../../australiacitizenshiptest.com.au/pages/inc_blog.cfm:49) |
| | template | | string | C:\eprotech\drivingSchoolApp\_websites\australiacitizenshiptest.com.au\pages\inc_blog.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="inc_blog.cfm"/></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="inc_blog.cfm"/>
|
| | column | | | id | | | line | | | Raw_Trace | | string | __138.__138.australiacitizenshiptest_com_au2484.pages.blog_cfm$cf.call(../../australiacitizenshiptest.com.au/pages/blog.cfm:1) |
| | template | | string | C:\eprotech\drivingSchoolApp\_websites\australiacitizenshiptest.com.au\pages\blog.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 212: </cfsavecontent><br>
213: <cfif variables.qryPage.isDynamic eq 1><br>
<b>214: <cfsavecontent variable="strPageHTML"><cfinclude template="../../#Request.website.domainName#/pages/#variables.qryPage.pageName#.#Application.websiteTemplateExtension#" /></cfsavecontent></b><br>
215: <cfinclude template="../../#Request.website.domainName#/www/header.cfm" /><br>
216: <cfinclude template="../../#Request.website.domainName#/www/nav.cfm" /><br>
|
| | codePrintPlain | | string | 212: </cfsavecontent>
213: <cfif variables.qryPage.isDynamic eq 1>
214: <cfsavecontent variable="strPageHTML"><cfinclude template="../../#Request.website.domainName#/pages/#variables.qryPage.pageName#.#Application.websiteTemplateExtension#" /></cfsavecontent>
215: <cfinclude template="../../#Request.website.domainName#/www/header.cfm" />
216: <cfinclude template="../../#Request.website.domainName#/www/nav.cfm" />
|
| | column | | | id | | | line | | | Raw_Trace | | string | __138.__138._shared.au_ctz._404_cfm$cf$36c.call(../../_shared/au_ctz/404.cfm:214) |
| | template | | string | C:\eprotech\drivingSchoolApp\_websites\_shared\au_ctz\404.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1: <cftry><br>
<b>2: <cfinclude template="../../_shared/au_ctz/404.cfm" /> </b><br>
3: <cfcatch type="Any" ><br>
4: <cfdump var="#cfcatch#"><cfabort><br>
|
| | codePrintPlain | | string | 1: <cftry>
2: <cfinclude template="../../_shared/au_ctz/404.cfm" />
3: <cfcatch type="Any" >
4: <cfdump var="#cfcatch#"><cfabort>
|
| | column | | | id | | | line | | | Raw_Trace | | string | _404_cfm$cf$2uh.call(/404.cfm:2) |
| | template | | string | C:\eprotech\drivingSchoolApp\_websites\australiacitizenshiptest.com.au\www\404.cfm |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 108: <cflocation url="/" addtoken="false" /><br>
109: </cfif><br>
<b>110: <cfinclude template="#ARGUMENTS.TargetPage#" /></b><br>
111: </cffunction><br>
112: <cffunction name="OnRequestEnd" access="public" returntype="void" output="false" hint="Fires after the page processing is complete."><br>
|
| | codePrintPlain | | string | 108: <cflocation url="/" addtoken="false" />
109: </cfif>
110: <cfinclude template="#ARGUMENTS.TargetPage#" />
111: </cffunction>
112: <cffunction name="OnRequestEnd" access="public" returntype="void" output="false" hint="Fires after the page processing is complete.">
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/drivingschoolwebsites/Application.cfc:110) |
| | template | | string | C:\eprotech\drivingSchoolApp\_websites\Application.cfc |
| | type | |
|
|
| type | |
| where | |