hibernate.exception.SQLGrammarException: could not execute query

Liferay Issues | John O'Neill | 5 years ago
  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 | 5 years ago | John O'Neill
    hibernate.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 | 5 years ago | John O'Neill
    hibernate.exception.SQLGrammarException: could not execute query

    Root Cause Analysis

    1. hibernate.exception.SQLGrammarException

      could not execute query

      at com.liferay.portal.events.StartupAction.run()
    2. Liferay Portal Impl
      MainServlet.init
      1. com.liferay.portal.events.StartupAction.run(StartupAction.java:57)
      2. com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1188)
      3. com.liferay.portal.servlet.MainServlet.init(MainServlet.java:192)
      3 frames
    3. JavaServlet
      GenericServlet.init
      1. javax.servlet.GenericServlet.init(GenericServlet.java:212)
      1 frame
    4. Glassfish Core
      Catalina.start
      1. org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
      2. org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
      3. org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4420)
      4. org.apache.catalina.core.StandardContext.start(StandardContext.java:4733)
      5. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
      6. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
      7. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
      8. org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
      9. org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
      10. org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
      11. org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
      12. org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
      13. org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
      14. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
      15. org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
      16. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      17. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
      18. org.apache.catalina.core.StandardService.start(StandardService.java:525)
      19. org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
      20. org.apache.catalina.startup.Catalina.start(Catalina.java:595)
      20 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:592)
      4 frames
    6. Glassfish Core
      Bootstrap.main
      1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
      2 frames