Screen Render Error
org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting ProductSearchResult (SQL Exception: (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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting ProductSearchResult (SQL Exception: (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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1)) (Error while inserting ProductSearchResult (SQL Exception: (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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1)))
at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:160)
at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:132)
at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:391)
at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:729)
at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:141)
at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:232)
at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:398)
at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:134)
at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:95)
at org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:105)
at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:849)
at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:562)
at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:228)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting ProductSearchResult (SQL Exception: (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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1))
at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:175)
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:872)
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:738)
at org.ofbiz.entity.GenericValue.create(GenericValue.java:126)
at org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:787)
at org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:238)
at org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:960)
at org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
at KeywordSearch.run(KeywordSearch.groovy:36)
at org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:425)
at org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:125)
at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:225)
... 25 more
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception: (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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1)
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:425)
at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
... 41 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1544)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2351)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:420)
... 42 more