-
Type:
Bug
-
Resolution: Fixed
-
Priority:
High
-
Affects Version/s: 4.2 - EAP
-
Component/s: Installation
-
Environment:
JAC, Performance.
-
4.02
2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Converting search requests to use the new labels system field is 100% complete.
2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Updating saved filters to use the new labels system field...DONE
2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Updating label gadgets use the new labels system field...
2010-05-04 01:49:24,717 main ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception whi
le executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have a
n error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1)
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE
FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo
ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:188)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:175)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.updateGadgetConfigurations(UpgradeTask_Build552.java:190)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.doUpgrade(UpgradeTask_Build552.java:151)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:562)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:466)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:402)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:353)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:292)
at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:100)
at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpref
erence WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right s
yntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:596)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1076)
at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:919)
at org.ofbiz.core.entity.GenericHelperDAO.findByCondition(GenericHelperDAO.java:162)
at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:960)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:183)
... 25 more