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

Unknown column 'calendarim0_.timeZoneId' in 'field list' when deploying custom Calendar portlet

Details

    • Bug
    • Status: Closed
    • Resolution: Fixed
    • 6.2.X EE
    • 6.2.X EE
    • Calendar > Upgrade
    • None

    Description

      Description:
      Unknown column 'calendarim0_.timeZoneId' in 'field list' when upgrading previous calendar portlet provided on USTRANSCOM-58 to new calendar portlet provided on USTRANSCOM-100.

      Steps to Reproduce:

      1. Start up a new instance of Liferay 6.2 EE SP-6.
      2. Once it has built it's database and finished stating up, log on as Test and go to Tests' dashboard.
      3. Add the calendar portlet.
      4. Add a new event. Put in a Title and a description. Under "Reminders" check the first Email and set it for 5 minutes, check the second email and set it for 15 minutes. Save the event.
      5. Shutdown Liferay 6.2 EE sp-6.
      6. Setup a new instance of Liferay 6.2 EE sp-18
      7. Remove the calendar-portlet from the webapps directory.
      8. Copy the Calendar portlet war from USTRANSCOM-58 to the deploy directory of the sp-18 instance.
      9. Copy the data from the sp-6 instance to the sp-18 instance.
      10. Start the Liferay 6.2 EE sp-18 instance.
      11. Once it has finished starting up and all portlets are deployed, shut it down.
      12. Remove the calendar-portlet from the webapps directory.
      13. Copy the Calendar portlet war from USTRANSCOM-100 to the deploy directory of the sp-18 instance (extract it from the .zip).
      14. Start the Liferay 6.2 EE sp-18 instance.
      15. Wait for it to finish starting up and all portlets deploy.

      Result: Calendar portlet finishes deploying but then hits MySQLSyntaxException

      21:39:55,533 ERROR [http-bio-8080-exec-6][JDBCExceptionReporter:82] Unknown column 'calendarim0_.timeZoneId' in 'field list'

      On browser, "Calendar is temporarily unavailable." error message

      Results of Testing:
      Expected Results: Able to deploy new calendar portlet from USTRANSCOM-100.
      Actual Results: Unable to deploy new calendar portlet from USTRANSCOM-100 due to MySQLSyntaxException.

      Error Log:

      21:39:29,876 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][AutoDeployDir:204] Processing calendar-portlet-6.2.10.13-SUPPORT-SNAPSHOT-20170428093307633.war
      21:39:29,888 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][PortletAutoDeployListener:79] Copying portlets for C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\deploy\calendar-portlet-6.2.10.13-SUPPORT-SNAPSHOT-20170428093307633.war
      21:39:29,974 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][BaseDeployer:884] Deploying calendar-portlet-6.2.10.13-SUPPORT-SNAPSHOT-20170428093307633.war
        Expanding: C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\deploy\calendar-portlet-6.2.10.13-SUPPORT-SNAPSHOT-20170428093307633.war into C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\temp\20170602213929977
        Copying 1 file to C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\temp\20170602213929977\WEB-INF
        Copying 1 file to C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\temp\20170602213929977\WEB-INF\classes
        Copying 1 file to C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\temp\20170602213929977\WEB-INF\classes
        Copying 1 file to C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\temp\20170602213929977\WEB-INF\jsp
      21:39:33,785 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][BaseDeployer:2438] Modifying Servlet 2.4 C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\temp\20170602213929977\WEB-INF\web.xml
        Copying 303 files to C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\webapps\calendar-portlet
        Copying 1 file to C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\webapps\calendar-portlet
        Deleting directory C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\temp\20170602213929977
      21:39:35,797 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][PortletAutoDeployListener:91] Portlets for C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\deploy\calendar-portlet-6.2.10.13-SUPPORT-SNAPSHOT-20170428093307633.war copied successfully. Deployment will start in a few seconds.
      Jun 02, 2017 9:39:42 PM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deploying web application directory C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\webapps\calendar-portlet
      Jun 02, 2017 9:39:44 PM org.apache.catalina.startup.TldConfig execute
      INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
      21:39:44,902 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin calendar-portlet requires marketplace-portlet
      21:39:44,903 INFO  [localhost-startStop-2][HotDeployImpl:217] Deploying calendar-portlet from queue
      21:39:44,903 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for calendar-portlet
      Loading file:/C:/Users/liferay/Downloads/liferay-portal-6.2-ee-sp18/tomcat-7.0.62/temp/11-calendar-portlet/WEB-INF/classes/portlet.properties
      Loading file:/C:/Users/liferay/Downloads/liferay-portal-6.2-ee-sp18/tomcat-7.0.62/temp/11-calendar-portlet/WEB-INF/classes/service.properties
      Loading file:/C:/Users/liferay/Downloads/liferay-portal-6.2-ee-sp18/tomcat-7.0.62/temp/11-calendar-portlet/WEB-INF/classes/portlet.properties
      Jun 02, 2017 9:39:45 PM org.apache.catalina.core.ApplicationContext log
      INFO: Initializing Spring root WebApplicationContext
      Loading file:/C:/Users/liferay/Downloads/liferay-portal-6.2-ee-sp18/tomcat-7.0.62/temp/11-calendar-portlet/WEB-INF/classes/service.properties
      Loading file:/C:/Users/liferay/Downloads/liferay-portal-6.2-ee-sp18/tomcat-7.0.62/temp/11-calendar-portlet/WEB-INF/classes/service.properties
      21:39:45,971 INFO  [localhost-startStop-2][HookHotDeployListener:715] Registering hook for calendar-portlet
      Loading file:/C:/Users/liferay/Downloads/liferay-portal-6.2-ee-sp18/tomcat-7.0.62/temp/11-calendar-portlet/WEB-INF/classes/portal.properties
      21:39:46,055 INFO  [localhost-startStop-2][HookHotDeployListener:857] Hook for calendar-portlet is available for use
      21:39:46,075 INFO  [localhost-startStop-2][PortletHotDeployListener:344] Registering portlets for calendar-portlet
      Loading file:/C:/Users/liferay/Downloads/liferay-portal-6.2-ee-sp18/tomcat-7.0.62/temp/11-calendar-portlet/WEB-INF/classes/portlet.properties
      21:39:46,263 INFO  [localhost-startStop-2][PortletHotDeployListener:492] 1 portlet for calendar-portlet is available for use
      21:39:46,265 INFO  [localhost-startStop-2][SocialHotDeployListener:94] Registering social for calendar-portlet
      21:39:46,268 INFO  [localhost-startStop-2][SocialHotDeployListener:103] Social for calendar-portlet is available for use
      Jun 02, 2017 9:39:46 PM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deployment of web application directory C:\Users\liferay\Downloads\liferay-portal-6.2-ee-sp18\tomcat-7.0.62\webapps\calendar-portlet has finished in 4,011 ms
      21:39:55,533 ERROR [http-bio-8080-exec-6][JDBCExceptionReporter:82] Unknown column 'calendarim0_.timeZoneId' in 'field list'
      Jun 02, 2017 9:39:55 PM org.apache.catalina.core.ApplicationDispatcher invoke
      SEVERE: Servlet.service() for servlet jsp threw exception
      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'calendarim0_.timeZoneId' in 'field list'
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
              at com.mysql.jdbc.Util.getInstance(Util.java:387)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
              at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
              at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
              ...
      

      Reproduced in?
      Branch? Yes, reproduced in 6.2.x
      Git ID: b0719d165ef3306729ae5468c073d671b72bf6bf
      Plugins: 2410edcd8ec675568cf029904ad038157e74c5da
      (Repeated all same steps, but instead of sp-18, used 6.2.x, and in Step 13, deployed newly built calendar-portlet-6.2.10.14.war from plugins 6.2.x)
      Master? Unable to test in master because cannot deploy 6.2 portlets

      Attachments

        Issue Links

          Activity

            People

              felix.zhang Felix Zhang
              joshua.stclair Joshua St. Clair (Inactive)
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                5 years, 24 weeks ago

                Packages

                  Version Package
                  6.2.X EE