- changed status to open
A full-text search query like "user:<username> searchterm" results in an exception
[2015-02-23 19:16:16,275] [ERROR] [org.bibsonomy.webapp.util.spring.controller.MinimalisticControllerSpringWrapper] - Could not complete controller (general exception) for request /search?null
with referer http://www.biblicious.org/
java.lang.RuntimeException: Couldn't execute query 'getGroupMembersByGroupName'
at org.bibsonomy.util.ExceptionUtils.logErrorAndThrowRuntimeException(ExceptionUtils.java:59)
at org.bibsonomy.database.common.impl.DBSessionImpl.logException(DBSessionImpl.java:368)
at org.bibsonomy.database.common.impl.DBSessionImpl.handleException(DBSessionImpl.java:358)
at org.bibsonomy.database.common.impl.DBSessionImpl.handleException(DBSessionImpl.java:293)
at org.bibsonomy.database.common.impl.DBSessionImpl.queryForList(DBSessionImpl.java:245)
at org.bibsonomy.database.common.AbstractDatabaseManager.queryForList(AbstractDatabaseManager.java:63)
at org.bibsonomy.lucene.database.LuceneInfoDBLogic.getGroupMembersByGroupName(LuceneInfoDBLogic.java:94)
at org.bibsonomy.lucene.search.LuceneResourceSearch.buildGroupSearchQuery(LuceneResourceSearch.java:371)
at org.bibsonomy.lucene.search.LuceneResourceSearch.buildQuery(LuceneResourceSearch.java:534)
at org.bibsonomy.lucene.search.LuceneResourceSearch.getPosts(LuceneResourceSearch.java:138)
at org.bibsonomy.lucene.search.LuceneResourceSearch.getPosts(LuceneResourceSearch.java:800)
at org.bibsonomy.database.managers.PostDatabaseManager.getPostsByResourceSearch(PostDatabaseManager.java:632)
at org.bibsonomy.database.managers.chain.resource.get.GetResourcesByResourceSearch.handle(GetResourcesByResourceSearch.java:86)
at org.bibsonomy.database.managers.chain.resource.get.GetResourcesByResourceSearch.handle(GetResourcesByResourceSearch.java:50)
at org.bibsonomy.database.managers.chain.Chain.perform(Chain.java:54)
at org.bibsonomy.database.managers.PostDatabaseManager.getPosts(PostDatabaseManager.java:1179)
at org.bibsonomy.database.DBLogic.getPosts(DBLogic.java:762)
at org.bibsonomy.webapp.controller.ResourceListController.setList(ResourceListController.java:301)
at org.bibsonomy.webapp.controller.SearchPageController.workOn(SearchPageController.java:133)
at org.bibsonomy.webapp.controller.SearchPageController.workOn(SearchPageController.java:52)
at org.bibsonomy.webapp.util.spring.controller.MinimalisticControllerSpringWrapper.handleRequestInternal(MinimalisticControllerSpringWrapper.java:230)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
...
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in Queries-lucene.xml.
--- The error occurred while applying a parameter map.
--- Check the getGroupMembersByGroupName-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bibsonomy.groups' doesn't exist
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.bibsonomy.database.common.impl.DBSessionImpl.queryForList(DBSessionImpl.java:243)
... 119 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bibsonomy.groups' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
...
Comments (3)
-
Account Deleted -
- changed status to resolved
fixing
#2432please check→ <<cset aa53947bdb60>>
-
works like a charm.
- Log in to comment