ibernate.exception.SQLGrammarException: could not execute query

Liferay Issues | John O'Neill | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    After using the manual database creation script, I configured root.xml and portal-ext.properties to point MySQL database (which worked for Liferay 6.0.5). On start-up, the server does not start up completely and fails with the following error. Jul 12, 2011 2:43:32 AM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 Jul 12, 2011 2:43:32 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 1093 ms Jul 12, 2011 2:43:32 AM org.apache.catalina.core.StandardService start INFO: Starting service Catalina Jul 12, 2011 2:43:32 AM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/6.0.32 Jul 12, 2011 2:43:32 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor ROOT.xml Loading jar:file:/C:/liferay/liferay-portal-6.1.0/tomcat-6.0.32/webapps/ROOT/WEB -INF/lib/portal-impl.jar!/system.properties Loading jar:file:/C:/liferay/liferay-portal-6.1.0/tomcat-6.0.32/webapps/ROOT/WEB -INF/lib/portal-impl.jar!/portal.properties Loading file:/C:/liferay/liferay-portal-6.1.0/tomcat-6.0.32/webapps/ROOT/WEB-INF /classes/portal-ext.properties 02:43:45,183 INFO [DialectDetector:80] Determine dialect for MySQL 5 02:43:45,239 INFO [DialectDetector:145] Found dialect org.hibernate.dialect.MyS QLDialect 02:43:55,035 INFO [PortalImpl:298] Global lib directory /C:/liferay/liferay-por tal-6.1.0/tomcat-6.0.32/lib/ext/ 02:43:55,040 INFO [PortalImpl:318] Portal lib directory /C:/liferay/liferay-por tal-6.1.0/tomcat-6.0.32/webapps/ROOT/WEB-INF/lib/ Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / March 2 4, 2011) 02:44:20,182 INFO [BaseDB:404] Database does not support case sensitive queries 02:44:20,557 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify ProcessSuite 02:44:20,560 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Properties 02:44:20,562 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify MySQL 02:44:20,646 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify SQLServer 02:44:20,649 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Counter 02:44:20,755 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify UUID 02:44:20,763 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Permission 02:44:21,198 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Role 02:44:21,397 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Asset 02:44:21,404 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.uti l.UpgradeAssetPublisherManualEntries 02:44:21,424 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Blogs 02:44:21,445 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Bookmarks 02:44:21,466 ERROR [JDBCExceptionReporter:234] Unknown column 'BookmarksEntry.us erName' in 'field list' 02:44:21,473 ERROR [MainServlet:195] com.liferay.portal.kernel.events.ActionExce ption: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.Veri fyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.po rtal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: c ould not execute query com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.Veri fyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kerne l.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org .hibernate.exception.SQLGrammarException: could not execute query at com.liferay.portal.events.StartupAction.run(StartupAction.java:57) at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServl et.java:1188) at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:192) at javax.servlet.GenericServlet.init(GenericServlet.java:212) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper. java:1173) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:99 3) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex t.java:4420) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4 733) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase .java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77 9) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja va:675) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j ava:601) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502 ) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java :324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl eSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463 ) at org.apache.catalina.core.StandardService.start(StandardService.java:5 25) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify. VerifyException: com.liferay.portal.kernel.exception.SystemException: com.lifera y.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarExceptio n: could not execute query at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82) at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProc essUtil.java:101) at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProce ssUtil.java:66) at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.j ava:79) at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelp erUtil.java:44) at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:169) at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:164) at com.liferay.portal.events.StartupAction.run(StartupAction.java:51) ... 29 more Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel. exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.h ibernate.exception.SQLGrammarException: could not execute query at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82) at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:89) at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSu ite.java:37) at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79) ... 36 more Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.port al.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: cou ld not execute query at com.liferay.portlet.bookmarks.service.persistence.BookmarksEntryFinde rImpl.findByNoAssets(BookmarksEntryFinderImpl.java:52) at com.liferay.portlet.bookmarks.service.impl.BookmarksEntryLocalService Impl.getNoAssetEntries(BookmarksEntryLocalServiceImpl.java:289) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Ser viceBeanMethodInvocation.java:119) at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(T ransactionInterceptor.java:86) at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM ethodAdvice.java:60) at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM ethodAdvice.java:60) at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM ethodAdvice.java:60) at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanA opProxy.java:86) at $Proxy165.getNoAssetEntries(Unknown Source) at com.liferay.portlet.bookmarks.service.BookmarksEntryLocalServiceUtil. getNoAssetEntries(BookmarksEntryLocalServiceUtil.java:386) at com.liferay.portal.verify.VerifyBookmarks.doVerify(VerifyBookmarks.ja va:32) at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79) ... 39 more Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.excepti on.SQLGrammarException: could not execute query at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(Ex ceptionTranslator.java:30) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.j ava:104) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.j ava:88) at com.liferay.portlet.bookmarks.service.persistence.BookmarksEntryFinde rImpl.findByNoAssets(BookmarksEntryFinderImpl.java:49) ... 54 more Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2536) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java: 165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.j ava:94) ... 56 more Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column ' BookmarksEntry.userName' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:1313) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 1448) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery( DelegatingPreparedStatement.java:96) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery( DelegatingPreparedStatement.java:96) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: 208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo ader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2533) ... 63 more Stopping the server due to unexpected startup errors

    Liferay Issues | 6 years ago | John O'Neill
    ibernate.exception.SQLGrammarException: could not execute query
  2. 0

    After using the manual database creation script, I configured root.xml and portal-ext.properties to point MySQL database (which worked for Liferay 6.0.5). On start-up, the server does not start up completely and fails with the following error. Jul 12, 2011 2:43:32 AM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 Jul 12, 2011 2:43:32 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 1093 ms Jul 12, 2011 2:43:32 AM org.apache.catalina.core.StandardService start INFO: Starting service Catalina Jul 12, 2011 2:43:32 AM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/6.0.32 Jul 12, 2011 2:43:32 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor ROOT.xml Loading jar:file:/C:/liferay/liferay-portal-6.1.0/tomcat-6.0.32/webapps/ROOT/WEB -INF/lib/portal-impl.jar!/system.properties Loading jar:file:/C:/liferay/liferay-portal-6.1.0/tomcat-6.0.32/webapps/ROOT/WEB -INF/lib/portal-impl.jar!/portal.properties Loading file:/C:/liferay/liferay-portal-6.1.0/tomcat-6.0.32/webapps/ROOT/WEB-INF /classes/portal-ext.properties 02:43:45,183 INFO [DialectDetector:80] Determine dialect for MySQL 5 02:43:45,239 INFO [DialectDetector:145] Found dialect org.hibernate.dialect.MyS QLDialect 02:43:55,035 INFO [PortalImpl:298] Global lib directory /C:/liferay/liferay-por tal-6.1.0/tomcat-6.0.32/lib/ext/ 02:43:55,040 INFO [PortalImpl:318] Portal lib directory /C:/liferay/liferay-por tal-6.1.0/tomcat-6.0.32/webapps/ROOT/WEB-INF/lib/ Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / March 2 4, 2011) 02:44:20,182 INFO [BaseDB:404] Database does not support case sensitive queries 02:44:20,557 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify ProcessSuite 02:44:20,560 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Properties 02:44:20,562 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify MySQL 02:44:20,646 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify SQLServer 02:44:20,649 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Counter 02:44:20,755 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify UUID 02:44:20,763 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Permission 02:44:21,198 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Role 02:44:21,397 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Asset 02:44:21,404 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.uti l.UpgradeAssetPublisherManualEntries 02:44:21,424 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Blogs 02:44:21,445 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify Bookmarks 02:44:21,466 ERROR [JDBCExceptionReporter:234] Unknown column 'BookmarksEntry.us erName' in 'field list' 02:44:21,473 ERROR [MainServlet:195] com.liferay.portal.kernel.events.ActionExce ption: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.Veri fyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.po rtal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: c ould not execute query com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.Veri fyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kerne l.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org .hibernate.exception.SQLGrammarException: could not execute query at com.liferay.portal.events.StartupAction.run(StartupAction.java:57) at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServl et.java:1188) at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:192) at javax.servlet.GenericServlet.init(GenericServlet.java:212) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper. java:1173) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:99 3) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex t.java:4420) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4 733) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase .java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77 9) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja va:675) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j ava:601) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502 ) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java :324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl eSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463 ) at org.apache.catalina.core.StandardService.start(StandardService.java:5 25) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify. VerifyException: com.liferay.portal.kernel.exception.SystemException: com.lifera y.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarExceptio n: could not execute query at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82) at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProc essUtil.java:101) at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProce ssUtil.java:66) at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.j ava:79) at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelp erUtil.java:44) at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:169) at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:164) at com.liferay.portal.events.StartupAction.run(StartupAction.java:51) ... 29 more Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel. exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.h ibernate.exception.SQLGrammarException: could not execute query at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82) at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:89) at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSu ite.java:37) at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79) ... 36 more Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.port al.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: cou ld not execute query at com.liferay.portlet.bookmarks.service.persistence.BookmarksEntryFinde rImpl.findByNoAssets(BookmarksEntryFinderImpl.java:52) at com.liferay.portlet.bookmarks.service.impl.BookmarksEntryLocalService Impl.getNoAssetEntries(BookmarksEntryLocalServiceImpl.java:289) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Ser viceBeanMethodInvocation.java:119) at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(T ransactionInterceptor.java:86) at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM ethodAdvice.java:60) at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM ethodAdvice.java:60) at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM ethodAdvice.java:60) at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanA opProxy.java:86) at $Proxy165.getNoAssetEntries(Unknown Source) at com.liferay.portlet.bookmarks.service.BookmarksEntryLocalServiceUtil. getNoAssetEntries(BookmarksEntryLocalServiceUtil.java:386) at com.liferay.portal.verify.VerifyBookmarks.doVerify(VerifyBookmarks.ja va:32) at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79) ... 39 more Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.excepti on.SQLGrammarException: could not execute query at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(Ex ceptionTranslator.java:30) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.j ava:104) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.j ava:88) at com.liferay.portlet.bookmarks.service.persistence.BookmarksEntryFinde rImpl.findByNoAssets(BookmarksEntryFinderImpl.java:49) ... 54 more Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2536) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java: 165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.j ava:94) ... 56 more Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column ' BookmarksEntry.userName' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:1313) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 1448) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery( DelegatingPreparedStatement.java:96) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery( DelegatingPreparedStatement.java:96) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: 208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo ader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2533) ... 63 more Stopping the server due to unexpected startup errors

    Liferay Issues | 6 years ago | John O'Neill
    ibernate.exception.SQLGrammarException: could not execute query

    Root Cause Analysis

    1. ibernate.exception.SQLGrammarException

      could not execute query

      at com.liferay.portal.verify.VerifyProcess.verify()
    2. Liferay Portal Impl
      VerifyProcess.verify
      1. com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
      2. com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:89)
      3. com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:37)
      4. com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
      4 frames