>This error looks to me like it's coming from the mysql driver directly.
Ok. >Did you say this code worked somewhere? Presently, I have three databases in use: ssp, tmw and infobase. Of the three, only ssp is responding properly. The other two (tmw and infobase) are generating OBD Internal Server Errors with the Stack Trace listed below. All were created the same way (using Navicat) and populated the same way (imports from Excel workbooks). Using Navicat, I just assigned full privileges to the users for both tmw and infobase. Error persists. >Are the databases the same version? Are the drivers the same version? There's only one MySQL instance. Why would there be multiple drivers? Here's the response to ./mysqladmin version: ./mysqladmin Ver 8.41 Distrib 5.0.67, for apple-darwin8.11.0 on powerpc Copyright (C) 2000-2006 MySQL AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.0.67 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 4 days 3 hours 51 min 25 sec Threads: 3 Questions: 1077 Slow queries: 0 Opens: 52 Flush tables: 1 Open tables: 25 Queries per second avg: 0.003 * * * * Thank you, * JB * Jordan Michaels wrote: > > Warm regards, > Jordan Michaels > Vivio Technologies > http://www.viviotech.net/ > Open BlueDragon Steering Committee > Adobe Solution Provider > > > J.B. Mentzer wrote: > >> Andy Wu wrote: >> >>> Hi JB, >>> >>> Can you show us the stacktrace that comes with the Internal Server Error? >>> >>> Thanks >>> Andy >>> >>> >> In the error screen, "18: SELECT * FROM parts" is in red type. >> >> Thank you! >> >> * JB * >> >> Type Internal >> Tag Context CFINCLUDE: Line=20; Column=1 >> | >> +-- cf_tag_gm_current_parts: Line=106; Column=23 >> | >> +-- CFQUERY: Line=18; Column=1 >> >> Source >> 15: --> >> 16: >> 17: <cfquery datasource="#SESSION.dsn#" name="CALLER.gm_parts"> >> 18: SELECT * FROM parts >> 19: >> >> ^ Snippet from underlying CFML source >> >> >> Stack Trace >> >> java.lang.NullPointerException >> at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1103) >> at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5531) >> at com.mysql.jdbc.Field.getCollation(Field.java:469) >> at >> com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:558) >> at com.naryx.tagfusion.cfm.engine.cfQueryResultSetMetaData.(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.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.cfMODULE.renderCustomTagStart(Unknown >> Source) >> at com.naryx.tagfusion.cfm.tag.cfMODULE.realCustomRender(Unknown Source) >> at com.naryx.tagfusion.cfm.tag.cfMODULE.customRender(Unknown Source) >> at com.naryx.tagfusion.cfm.tag.cfCustomTag.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.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) >> at >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363) >> at >> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) >> at >> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) >> at >> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:757) >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:416) >> at >> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) >> at >> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) >> at org.mortbay.jetty.Server.handle(Server.java:324) >> at >> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502) >> at >> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:826) >> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:523) >> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:377) >> at >> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) >> at >> org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:497) >> >> >> >>> J.B. Mentzer wrote: >>> >>> >>>> Hi all, >>>> >>>> Trying to get one of my websites to work on my Mac running BlueDragon >>>> ... and have run into an error I can't resolve. Here's the query in >>>> question: >>>> >>>> <cfquery datasource="#SESSION.dsn#" name="CALLER.gm_parts"> >>>> SELECT >>>> parts_ID, >>>> reference_pn, >>>> category, >>>> img_med, >>>> img_lg, >>>> part_name, >>>> part_desc, >>>> price_each, >>>> price_100 >>>> >>>> FROM >>>> parts >>>> >>>> WHERE >>>> product_line = '#SESSION.product_line#' >>>> >>>> ORDER BY '#ATTRIBUTES.order_by#'; >>>> </cfquery> >>>> >>>> >>>> As written, the page generates an "Open BD Internal Server Error" >>>> complete with Stack Trace and a verbose dump of variables. >>>> >>>> When I include an equals sign in the Order By Clause, this error is >>>> generated: >>>> >>>> Query Error You have an error in your SQL syntax; check the manual >>>> that corresponds to your MySQL server version for the right syntax to >>>> use near '= 'reference_pn'' at line 18. >>>> >>>> What do I need to do to resolve this? >>>> >>>> Thank you, >>>> >>>> * JB * >>>> > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
