y.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarExceptio n: 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
    y.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarExceptio n: 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
    y.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarExceptio n: could not execute query

    Root Cause Analysis

    1. y.portal.kernel.dao.orm.ORMException

      org.hibernate.exception.SQLGrammarExceptio n: could not execute query

      at com.liferay.portal.verify.VerifyProcess.verify()
    2. Liferay Portal Impl
      StartupAction.run
      1. com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
      2. com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:101)
      3. com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:66)
      4. com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:79)
      5. com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:44)
      6. com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:169)
      7. com.liferay.portal.events.StartupAction.doRun(StartupAction.java:164)
      8. com.liferay.portal.events.StartupAction.run(StartupAction.java:51)
      8 frames