Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-66221

Unable to start LifeRay 7.0 CE with MySQL

    Details

      Description

      Liferay CE 7 with Widfly bundle + MySQL 5.7.12 is unable to start with the following exception.

      <log4j:message><![CDATA[Unable to execute verify process: com.liferay.portal.verify.VerifyException: 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 '"createDate"' at line 1]]></log4j:message>
      <log4j:throwable><![CDATA[com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: 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 '"createDate"' at line 1
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
      at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
      at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
      at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:252)
      at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:206)
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:77)
      at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1297)
      at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:235)
      at javax.servlet.GenericServlet.init(GenericServlet.java:244)
      at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
      at org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
      at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
      at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)
      at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)
      at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)
      at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
      at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
      at org.jboss.threads.JBossThread.run(JBossThread.java:320)
      Caused by: com.liferay.portal.verify.VerifyException: 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 '"createDate"' at line 1
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
      at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:27)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      ... 25 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 '"createDate"' at line 1
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      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:1053)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2738)
      at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1617)
      at com.liferay.portal.verify.VerifyMySQL.getActualColumnType(VerifyMySQL.java:64)
      at com.liferay.portal.verify.VerifyMySQL.verifyDatetimePrecisionForTable(VerifyMySQL.java:106)
      at com.liferay.portal.verify.VerifyMySQL.verifyDatetimePrecision(VerifyMySQL.java:84)
      at com.liferay.portal.verify.VerifyMySQL.doVerify(VerifyMySQL.java:49)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      ... 28 more
      ]]></log4j:throwable>

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 20 weeks, 3 days ago

                Packages

                Version Package
                7.0.1 CE GA2