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

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.2.X EE
    • Fix Version/s: 6.2.X EE
    • Component/s: Calendar > Upgrade
    • Labels:
      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

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

                Dates

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

                  Packages

                  Version Package
                  6.2.X EE