Issue #SCB2508 Unconfirmed

Activity report on

  *Defect SCB2508 - Query partly broken*
 
  Scarab Link: http://www.solitone.org/scarab/issues/id/SCB2508
  Module: Scarab


  Activity generated by  Scarab anonymous ([email protected])  at 02/21/2008 17:21



  ** Issue created **

-------------------------------------------------------------------------------
  *Attribute changes*
  - "Version" set to "trunk"
  - "Stack trace" set to:
    "(...)
Caused by: org.apache.fulcrum.ServiceException: Error rendering Velocity template: screens/IssueTypeList.vm

(...)


Caused by: java.lang.RuntimeException: org.apache.torque.TorqueException: java.sql.SQLException: 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 'SELECT DISTINCT SCARAB_ISSUE.ISSUE_ID FROM SCARAB_ISSUE WHERE S
	at org.tigris.scarab.search.CachedQuery.cacheInitial(CachedQuery.java:97)
	at org.tigris.scarab.search.CachedQuery.getRowCount(CachedQuery.java:64)
	at org.tigris.scarab.util.word.IssueSearch.getIssueCount(IssueSearch.java:1681)
	at org.tigris.scarab.om.MITListItem.getIssueCount(MITListItem.java:93)
	... 143 more
Caused by: org.apache.torque.TorqueException: java.sql.SQLException: 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 'SELECT DISTINCT SCARAB_ISSUE.ISSUE_ID FROM SCARAB_ISSUE WHERE S
	at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:105)
	at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:896)
	at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:840)
	at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:790)
	at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:753)
	at org.tigris.scarab.search.CachedQuery.executeSelect(CachedQuery.java:38)
	at org.tigris.scarab.search.CachedQuery.cacheInitial(CachedQuery.java:90)
	... 146 more
Caused by: java.sql.SQLException: 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 'SELECT DISTINCT SCARAB_ISSUE.ISSUE_ID FROM SCARAB_ISSUE WHERE S
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2949)
	at com.mysql.jdbc.Statement.executeQuery(Statement.java:959)
	at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:113)
	at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:881)
	... 151 more

"
  - "Target milestone" set to "UNDECIDED"
  - "Short description" set to:
    "Private Query, Public Query and extended Search gave a stacktrace before I could enter the queries"
  - "Summary" set to "Query partly broken"
  - "Status" set to "Unconfirmed"
  - "Database" set to "MySQL"
  - "Priority" set to "0-UNDECIDED"

-------------------------------------------------------------------------------