Looks like that is 1.1.020 in the sqldiff: http://svn.openmrs.org/openmrs-modules/ncd/trunk/metadata/sqldiff.xml
You could try just dropping that column if there is nothing in it and restarting the module. Then that changeset in the sqldiff should be able to run. Alternatively you could run the sql in that changeset in the link manually so as to not lose anything. Make sure you reset the global property ncd.database_version to 1.1.020 after runinng that sql so that it can start up correctly. Ben On Thu, Dec 1, 2011 at 3:24 AM, Marcos Núñez <[email protected]> wrote: > Hi! I'm trying to setup the Notifiable Condition Module (NCD) in my OpenMRS > 1.8.2. I successfully installed and configured both Messaging and MRNGen > Modules, but the NCD Module cannot start because: > > > > Error while trying to start module > Error while running sql: ALTER TABLE ncdtblloinccode ADD (codename TEXT NULL) > . Message: Duplicate column name 'codename' > ** org.openmrs.util.DatabaseUtil.executeSQL(DatabaseUtil.java:107) > ** > org.openmrs.api.db.hibernate.HibernateAdministrationDAO.executeSQL(HibernateAdministrationDAO.java:315) > ** > org.openmrs.api.impl.AdministrationServiceImpl.executeSQL(AdministrationServiceImpl.java:796) > sun.reflect.GeneratedMethodAccessor1313.invoke(Unknown Source) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > java.lang.reflect.Method.invoke(Method.java:616) > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) > $Proxy731.executeSQL(Unknown Source) > sun.reflect.GeneratedMethodAccessor1313.invoke(Unknown Source) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > java.lang.reflect.Method.invoke(Method.java:616) > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > ** org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:114) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) > $Proxy732.executeSQL(Unknown Source) > sun.reflect.GeneratedMethodAccessor1313.invoke(Unknown Source) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > java.lang.reflect.Method.invoke(Method.java:616) > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) > $Proxy732.executeSQL(Unknown Source) > ** org.openmrs.module.ModuleFactory.runDiff(ModuleFactory.java:666) > ** > org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:511) > ** org.openmrs.api.context.Daemon$1.run(Daemon.java:56) > > > I'm using the MVP Concept Dictionary, there are thousands of LOINC codes in > that "ncdtblloinccode" table. Has anyone experienced this error before? > > > > Thanks in advance > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
