Hello,
I just switched to using MySQL 5.5.29 from 5.1.x and the following query no
longer works.
The error I get is "The page you were executing caused an internal server
error".
61: <cfquery name="gGetDBInfo" datasource="#session.dbsource#">
62: SHOW VARIABLES LIKE "%version%"
^ Snippet from underlying CFML source
Stack Trace
java.lang.NullPointerException
at
com.naryx.tagfusion.cfm.engine.cfQueryResultSetMetaData$ColumnMetaData.access$800(Unknown
Source)
at
com.naryx.tagfusion.cfm.engine.cfQueryResultSetMetaData.getColumnType(Unknown
Source)
at com.naryx.tagfusion.cfm.engine.cfQueryResultData.setRow(Unknown Source)
at com.naryx.tagfusion.cfm.engine.cfQueryResultData.populate(Unknown Source)
at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.executeAsStatement(Unknown
Source)
at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.execute(Unknown Source)
at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.runQuery(Unknown Source)
at com.naryx.tagfusion.cfm.sql.cfQUERY.executeStatement(Unknown Source)
at com.naryx.tagfusion.cfm.sql.platform.java.cfQueryImplSQL.render(Unknown
Source)
at com.naryx.tagfusion.cfm.sql.cfQUERY.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source)
at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfINCLUDE.renderTemplate(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfINCLUDE.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.renderToString(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfFUNCTION.realRun(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfFUNCTION.run(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfFUNCTION.run(Unknown Source)
at
com.naryx.tagfusion.cfm.parser.script.userDefinedFunction.execute(Unknown
Source)
at com.naryx.tagfusion.cfm.parser.CFFunctionExpression.Eval(Unknown Source)
at com.naryx.tagfusion.cfm.parser.runTime.run(Unknown Source)
at com.naryx.tagfusion.cfm.parser.runTime.runExpression(Unknown Source)
at com.naryx.tagfusion.cfm.parser.runTime.runExpression(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfSET.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfIF.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source)
at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfINCLUDE.renderTemplate(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfINCLUDE.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source)
at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source)
at com.naryx.tagfusion.cfm.engine.cfSession.onRequest(Unknown Source)
at com.naryx.tagfusion.cfm.engine.cfEngine.service(Unknown Source)
at com.naryx.tagfusion.cfm.cfServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1359)
at com.newatlanta.filters.SearchEngineFriendlyURLFilter.doFilter(Unknown
Source)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:520)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:941)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:875)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:345)
at
org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:441)
at
org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:919)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:582)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
at
org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:51)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:586)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:44)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:598)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:533)
at java.lang.Thread.run(Thread.java:680)
I'm using OpenBD 2.0.2
Thanks,
Charlie
<cfquery name="gGetDBInfo" datasource="#session.dbsource#">
SHOW VARIABLES LIKE "%version%"
</cfquery>
--
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
