hmmm. does mysql not support UNION selects ?
run the sql from your command line. Are you able to issue the query there?
(if you can't I can supply a quick hack/fix)
let me know!
mike
On Wed, Nov 08, 2000 at 10:22:38PM +0100, Bernie Hoeneisen wrote:
> Hi Mike!
>
> I got similar exception than D.R. (see below).
>
> I tried to upgrade my Jyve, not changing the Turbine at all. The Jyve
> version I have been using till now was the one before your changes with
> OUTER JOIN and stuff; before everything used to work fine.
>
> The Exception appears using:
> Linux 2.2.16 (Redhat)
> Apache 1.3.12
> Apache JServ 1.1.2
> MySQL 3.22.32�and driver mm.mysql.jdbc-1.2c
> Turbine from around 10.9.2000 (which worked fine with Jyve before)
> latest Jyve from CVS
> Village 1.3 (using 1.4 does not solve the problem)
>
>
> Any idea, what could be the problem?
>
> T: Bernie
>
> ---
>
> URL:
>http://sipper.ntc.nokia.com/servlet/Turbine/screen/DisplayTopics/action/SetAll/project_id/3/faq_id/4
>
> Exception: java.sql.SQLException: Error during query: Unexpected
> Exception: java.sql.SQLException message given: Syntax error or access
> violation: You have an error in your SQL syntax near 'UNION SELECT
> question.question_id, 0 as count FROM question WHERE NOT EXISTS ( ' at
> line 1
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:807)
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:740)
> at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:159)
> at
> com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:112)
> at
> org.apache.jyve.screens.DisplayTopics.getAnswerCount(DisplayTopics.java:386)
> at
> org.apache.jyve.screens.DisplayTopics.buildTopicTree(DisplayTopics.java:226)
> at
> org.apache.jyve.screens.DisplayTopics.doBuild(DisplayTopics.java:155)
> at org.apache.turbine.modules.Screen.build(Screen.java:100)
> at
> org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.java:126)
> at
> org.apache.jyve.layouts.DefaultLayout.doBuild(DefaultLayout.java:92)
> at org.apache.turbine.modules.Layout.build(Layout.java:93)
> at
> org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:120)
> at
> org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:171)
> at org.apache.turbine.modules.Page.build(Page.java:92)
> at
> org.apache.turbine.modules.PageLoader.exec(PageLoader.java:119)
> at org.apache.turbine.Turbine.doGet(Turbine.java:366)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
> at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
> at
> org.apache.jserv.JServConnection.run(JServConnection.java:188)
> at java.lang.Thread.run(Thread.java:475)
>
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Archives and Other: <http://java.apache.org/main/mail.html>
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
