[
https://wso2.org/jira/browse/MASHUP-785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16490#action_16490
]
Yumani Ranaweera commented on MASHUP-785:
-----------------------------------------
The same error appears when you search for "everyone's comments" while keeping
comments text box empty.
> Error when searching for a comment from a user
> ----------------------------------------------
>
> Key: MASHUP-785
> URL: https://wso2.org/jira/browse/MASHUP-785
> Project: WSO2 Mashup Server
> Issue Type: Bug
> Components: Admin UI
> Affects Versions: Nightly
> Environment: WinXp, JDK1.5, FF
> Reporter: Yumani Ranaweera
> Assignee: Tyrell Perera
> Priority: Blocker
> Fix For: 1.1
>
>
> Steps:
> -------
> Do a the following search without log in
> comments by = user3
> comment = sample
> Issue:
> -------
> The following error appears;
> ERROR [2008-05-05 16:38:30,109] Failed to execute query
> /querystore/mycomments. All database operations will be rolled back. Column
> 'C.CM_ID' is eith
> er not in any table in the FROM list or appears within a join specification
> and is outside the scope of the join specification or appears in a HAVING
> clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE
> statement then 'C.CM_ID' is not a column in the target table.
> org.wso2.registry.RegistryException: Column 'C.CM_ID' is either not in any
> table in the FROM list or appears within a join specification and is outsid
> e the scope of the join specification or appears in a HAVING clause and is
> not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement the
> n 'C.CM_ID' is not a column in the target table.
> at
> org.wso2.registry.jdbc.queries.SQLQueryProcessor.executeQuery(SQLQueryProcessor.java:114)
> at
> org.wso2.registry.jdbc.queries.QueryProcessorManager.executeQuery(QueryProcessorManager.java:95)
> at
> org.wso2.registry.jdbc.TransactionalJDBCRegistry.executeQuery(TransactionalJDBCRegistry.java:804)
> at
> org.wso2.registry.jdbc.NonTransactionalJDBCRegistry.executeQuery(NonTransactionalJDBCRegistry.java:1169)
> at
> org.wso2.registry.jdbc.JDBCRegistry.executeQuery(JDBCRegistry.java:591)
> at
> org.wso2.registry.session.UserRegistry.executeQuery(UserRegistry.java:434)
> at
> org.wso2.mashup.webapp.utils.RegistryUtils.doQuery(RegistryUtils.java:457)
> at
> org.apache.jsp.search_jsp._jspService(org.apache.jsp.search_jsp:416)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> org.wso2.mashup.transport.ServiceUIFilter.doFilter(ServiceUIFilter.java:210)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Mashup-dev mailing list
[email protected]
http://www.wso2.org/cgi-bin/mailman/listinfo/mashup-dev
