Catch
Entries: 15
additional
Struct
SQL
string SELECT ContarDeCodigo, idioma, idioma_slug FROM (SELECT SUM(ContarDeCodigo) ContarDeCodigo, idioma, idioma_slug FROM( SELECT count(j.codigo) ContarDeCodigo, trim(j.idioma) idioma, trim(j.idioma_slug) idioma_slug FROM jornais j WHERE instr(j.Idioma,',') = 0 GROUP BY j.Idioma UNION SELECT count(j.Codigo) ContarDeCodigo, trim(substr(j.Idioma,1,instr(j.Idioma,',')-1)) idioma, trim(substr(j.Idioma_slug,1,instr(j.Idioma_slug,'-')-1)) idioma_slug FROM Jornais j WHERE instr(j.Idioma,',') <> 0 GROUP BY j.Idioma UNION SELECT count(ContarDeCodigo) ContarDeCodigo, if(instr(idioma,',')=0,idioma,trim(substr(Idioma,1,instr(Idioma,',')-1))) idioma, if(instr(idioma_slug,'-')=0,idioma_slug,trim(substr(idioma_slug,1,instr(idioma_slug,'-')-1))) idioma_slug FROM (SELECT j.Codigo AS ContarDeCodigo, trim(substr(j.Idioma,instr(j.Idioma,',')+1)) idioma, trim(substr(j.Idioma_slug,instr(j.Idioma_slug,'-')+1)) idioma_slug FROM Jornais j WHERE instr(j.Idioma,',') <> 0 ) j GROUP BY j.idioma ) B GROUP BY b.idioma ORDER BY ContarDeCodigo DESC, idioma) t
DatabaseName
stringMySQL
DatabaseVersion
string5.5.54-cll
DriverName
stringMySQL-AB JDBC Driver
DriverVersion
stringmysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw )
Datasource
stringnetpapers
DataSource
stringnetpapers
Detail
stringTable 'netpaper_netpapers.Jornais' doesn't exist
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number1146
queryError
string SELECT ContarDeCodigo, idioma, idioma_slug FROM (SELECT SUM(ContarDeCodigo) ContarDeCodigo, idioma, idioma_slug FROM( SELECT count(j.codigo) ContarDeCodigo, trim(j.idioma) idioma, trim(j.idioma_slug) idioma_slug FROM jornais j WHERE instr(j.Idioma,',') = 0 GROUP BY j.Idioma UNION SELECT count(j.Codigo) ContarDeCodigo, trim(substr(j.Idioma,1,instr(j.Idioma,',')-1)) idioma, trim(substr(j.Idioma_slug,1,instr(j.Idioma_slug,'-')-1)) idioma_slug FROM Jornais j WHERE instr(j.Idioma,',') <> 0 GROUP BY j.Idioma UNION SELECT count(ContarDeCodigo) ContarDeCodigo, if(instr(idioma,',')=0,idioma,trim(substr(Idioma,1,instr(Idioma,',')-1))) idioma, if(instr(idioma_slug,'-')=0,idioma_slug,trim(substr(idioma_slug,1,instr(idioma_slug,'-')-1))) idioma_slug FROM (SELECT j.Codigo AS ContarDeCodigo, trim(substr(j.Idioma,instr(j.Idioma,',')+1)) idioma, trim(substr(j.Idioma_slug,instr(j.Idioma_slug,'-')+1)) idioma_slug FROM Jornais j WHERE instr(j.Idioma,',') <> 0 ) j GROUP BY j.idioma ) B GROUP BY b.idioma ORDER BY ContarDeCodigo DESC, idioma) t
Sql
string SELECT ContarDeCodigo, idioma, idioma_slug FROM (SELECT SUM(ContarDeCodigo) ContarDeCodigo, idioma, idioma_slug FROM( SELECT count(j.codigo) ContarDeCodigo, trim(j.idioma) idioma, trim(j.idioma_slug) idioma_slug FROM jornais j WHERE instr(j.Idioma,',') = 0 GROUP BY j.Idioma UNION SELECT count(j.Codigo) ContarDeCodigo, trim(substr(j.Idioma,1,instr(j.Idioma,',')-1)) idioma, trim(substr(j.Idioma_slug,1,instr(j.Idioma_slug,'-')-1)) idioma_slug FROM Jornais j WHERE instr(j.Idioma,',') <> 0 GROUP BY j.Idioma UNION SELECT count(ContarDeCodigo) ContarDeCodigo, if(instr(idioma,',')=0,idioma,trim(substr(Idioma,1,instr(Idioma,',')-1))) idioma, if(instr(idioma_slug,'-')=0,idioma_slug,trim(substr(idioma_slug,1,instr(idioma_slug,'-')-1))) idioma_slug FROM (SELECT j.Codigo AS ContarDeCodigo, trim(substr(j.Idioma,instr(j.Idioma,',')+1)) idioma, trim(substr(j.Idioma_slug,instr(j.Idioma_slug,'-')+1)) idioma_slug FROM Jornais j WHERE instr(j.Idioma,',') <> 0 ) j GROUP BY j.idioma ) B GROUP BY b.idioma ORDER BY ContarDeCodigo DESC, idioma) t
SQLState
string42S02
StackTrace
string at sun.reflect.GeneratedConstructorAccessor45.newInstance(Unknown Source):-1 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45):45 at java.lang.reflect.Constructor.newInstance(Constructor.java:422):422 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:2677):2677 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627):2627 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:841):841 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681):681 at lucee.runtime.db.driver.state.StateUtil.execute(StateUtil.java:37):37 at lucee.runtime.db.driver.state.StateStatement.execute(StateStatement.java:43):43 at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:232):232 at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:243):243 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.udfCall3(/home/netpaper/public_html/com/Netpapers.cfc:921):921 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.call(UDFImpl.java:229):229 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761 at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743 at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593 at jornais_por_idioma_cfm900$cf.call(/home/netpaper/public_html/jornais-por-idioma.cfm:2):2 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
Array
1
Struct
codePrintHTML
string919: WHERE t.idioma_slug = &lt;cfqueryparam value=&quot;#lcase(ARGUMENTS.idioma_slug)#&quot; cfsqltype=&quot;cf_sql_varchar&quot;/&gt;<br> 920: &lt;/cfif&gt; <br> <b>921: &lt;/cfquery&gt;</b><br> 922: <br> 923: &lt;cfreturn qListaIdiomas/&gt;<br>
codePrintPlain
string919: WHERE t.idioma_slug = <cfqueryparam value="#lcase(ARGUMENTS.idioma_slug)#" cfsqltype="cf_sql_varchar"/> 920: </cfif> 921: </cfquery> 922: 923: <cfreturn qListaIdiomas/>
column
number0
id
string??
line
number921
Raw_Trace
stringcom.netpapers_cfc$cf.udfCall3(/home/netpaper/public_html/com/Netpapers.cfc:921)
template
string/home/netpaper/public_html/com/Netpapers.cfc
type
stringcfml
2
Struct
codePrintHTML
string1: &lt;cfscript&gt;<br> <b>2: REQUEST.qListaIdiomas = REQUEST.Netpapers.getListaIdiomas();</b><br> 3: <br> 4: REQUEST.limitAcessos = 15;<br>
codePrintPlain
string1: <cfscript> 2: REQUEST.qListaIdiomas = REQUEST.Netpapers.getListaIdiomas(); 3: 4: REQUEST.limitAcessos = 15;
column
number0
id
string??
line
number2
Raw_Trace
stringjornais_por_idioma_cfm900$cf.call(/home/netpaper/public_html/jornais-por-idioma.cfm:2)
template
string/home/netpaper/public_html/jornais-por-idioma.cfm
type
stringcfml
type
stringdatabase
where
string