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.6.23
DriverName
stringMySQL Connector Java
DriverVersion
stringmysql-connector-java-5.1.33 ( Revision: alexander.soklakov@oracle.com-20140908134200-8ukofe1izi0r2b63 )
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.GeneratedConstructorAccessor325.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:377):377 at com.mysql.jdbc.Util.getInstance(Util.java:360):360 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978):978 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887):3887 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823):3823 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435):2435 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582):2582 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526):2526 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484):2484 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848):848 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742):742 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:787):787 at lucee.runtime.tag.Query.doEndTag(Query.java:597):597 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:742):742 at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1590):1590 at jornais_por_idioma_cfm900$cf.call(/home/netpaper/public_html/jornais-por-idioma.cfm:2):2 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:951):951 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:903):903 at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:35):35 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2262):2262 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2225):2225 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:722):722 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 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:243):243 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225):225 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169):169 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472):472 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168):168 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98):98 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565):565 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307):307 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617 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