A full-text search query like "user:<username> searchterm" results in an exception

Issue #2432 resolved
Former user created an issue

[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)

  1. Log in to comment