| additional | | SQL | | string |
SELECT c.nome,
c.slug_pt as fName,
c.slug_pt as jornal_slug,
c.url,
c.pais,
c.estado,
c.cidade,
c.codigo,
c.cod_jornal,
folderName,
c.formato,
c.cod_capa,
c.edicao_dia,
c.periodicidade,
c.data_importacao,
FROM_UNIXTIME(c.data_importacao,'%m-%Y') mes_ano,
c.acessos
FROM vw_capa_por_data c
WHERE 0 = 0
AND c.slug_pt = 'a-bola'
AND c.data_importacao = '10-09-2017'
ORDER BY pais,nome
| |
| | | DatabaseName | | | | DatabaseVersion | | | | DriverName | | string | MySQL-AB JDBC Driver | |
| | | DriverVersion | | string | mysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw ) | |
| | | Datasource | | |
| |
| DataSource | | |
| Detail | | string | Table 'netpaper_netpapers.vw_capa_por_data' doesn't exist | |
| |
| ErrorCode | | |
| Extended_Info | | |
| ExtendedInfo | | |
| Message | | |
| NativeErrorCode | | |
| queryError | | string |
SELECT c.nome,
c.slug_pt as fName,
c.slug_pt as jornal_slug,
c.url,
c.pais,
c.estado,
c.cidade,
c.codigo,
c.cod_jornal,
folderName,
c.formato,
c.cod_capa,
c.edicao_dia,
c.periodicidade,
c.data_importacao,
FROM_UNIXTIME(c.data_importacao,'%m-%Y') mes_ano,
c.acessos
FROM vw_capa_por_data c
WHERE 0 = 0
AND c.slug_pt = 'a-bola'
AND c.data_importacao = '10-09-2017'
ORDER BY pais,nome
| |
| |
| Sql | | string |
SELECT c.nome,
c.slug_pt as fName,
c.slug_pt as jornal_slug,
c.url,
c.pais,
c.estado,
c.cidade,
c.codigo,
c.cod_jornal,
folderName,
c.formato,
c.cod_capa,
c.edicao_dia,
c.periodicidade,
c.data_importacao,
FROM_UNIXTIME(c.data_importacao,'%m-%Y') mes_ano,
c.acessos
FROM vw_capa_por_data c
WHERE 0 = 0
AND c.slug_pt = 'a-bola'
AND c.data_importacao = '10-09-2017'
ORDER BY pais,nome
| |
| |
| SQLState | | |
| StackTrace | | string |
at sun.reflect.GeneratedConstructorAccessor82.newInstance(Unknown Source):-1
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45):45
at java.lang.reflect.Constructor.newInstance(Constructor.java:423):423
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411):411
at com.mysql.jdbc.Util.getInstance(Util.java:386):386
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052):1052
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096):4096
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028):4028
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490):2490
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651):2651
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683):2683
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144):2144
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379):1379
at lucee.runtime.db.driver.state.StateUtil.execute(StateUtil.java:145):145
at lucee.runtime.db.driver.state.StatePreparedStatement.execute(StatePreparedStatement.java:135):135
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:240):240
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:252):252
at lucee.runtime.tag.Query.executeDatasoure(Query.java:802):802
at lucee.runtime.tag.Query.doEndTag(Query.java:604):604
at com.netpapers_cfc$cf.udfCall4(/home/netpaper/public_html/com/Netpapers.cfc:1037):1037
at com.netpapers_cfc$cf.udfCall(/home/netpaper/public_html/com/Netpapers.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1603):1603
at capa_do_jornal_cfm585$cf.call(/home/netpaper/public_html/capa-do-jornal.cfm:22):22
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:954):954
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:906):906
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:225):225
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2265):2265
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2228):2228
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729):729
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at com.seefusion.Filter.doFilter(Filter.java:49):49
at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500):1500
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217):217
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518):518
at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844):844
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673):673
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500):1500
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456):1456
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
at java.lang.Thread.run(Thread.java:745):745
| |
| |
| TagContext | | 1 | | codePrintHTML | | string | 1035: </cfif><br>
1036: ORDER BY #ARGUMENTS.orderby#<br>
<b>1037: </cfquery></b><br>
1038: <br>
1039: <cfreturn qListaCapas/><br>
| |
| | | codePrintPlain | | string | 1035: </cfif>
1036: ORDER BY #ARGUMENTS.orderby#
1037: </cfquery>
1038:
1039: <cfreturn qListaCapas/>
| |
| | | column | | | | id | | | | line | | | | Raw_Trace | | string | com.netpapers_cfc$cf.udfCall4(/home/netpaper/public_html/com/Netpapers.cfc:1037) | |
| | | template | | string | /home/netpaper/public_html/com/Netpapers.cfc | |
| | | type | | |
| | | 2 | | codePrintHTML | | string | 20: REQUEST.qryCapas = REQUEST.Netpapers.getListaCapas(jornal_slug=URL.jornal);<br>
21: } else {<br>
<b>22: REQUEST.qryCapas = REQUEST.Netpapers.getListaCapasByData(jornal_slug=URL.jornal,data_capa=URL.data_capa);</b><br>
23: }<br>
24: <br>
| |
| | | codePrintPlain | | string | 20: REQUEST.qryCapas = REQUEST.Netpapers.getListaCapas(jornal_slug=URL.jornal);
21: } else {
22: REQUEST.qryCapas = REQUEST.Netpapers.getListaCapasByData(jornal_slug=URL.jornal,data_capa=URL.data_capa);
23: }
24:
| |
| | | column | | | | id | | | | line | | | | Raw_Trace | | string | capa_do_jornal_cfm585$cf.call(/home/netpaper/public_html/capa-do-jornal.cfm:22) | |
| | | template | | string | /home/netpaper/public_html/capa-do-jornal.cfm | |
| | | type | | |
| |
| |
| type | | |
| where | | |