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

• 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
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 1.5
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-plugins-ee/pull/21826

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