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]
