muzima
Page tree
Skip to end of metadata
Go to start of metadata
  1. From where should I download the mUzima app?
    1. Check here.
  2.  Is mUzima app available on mac?
    1. No, its not available at present.
  3. I have problem with the configuration of the app. What to do?
    1. For configuration related issues, check here.
  4. What if I want to test the mUzima app?

    1. Use the following settings to connect to our Demo server:

  5. I want to contribute to the the project. How can I do so?
    1. Help us by solving an issue or two. Check here. You can create new issues too.
  6. I want to resolve the following Error on Uploading the mUzima Module 

    

Change Set liquibase.xml::muzimaform-2014-10-31::SahajSoft failed.  Error: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Cannot add foreign key constraint
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Cannot add foreign key constraint
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
        at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
        at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
        at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:191)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
        at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:220)
        at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:986)
        at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:726)
        at org.openmrs.api.context.Daemon$1.run(Daemon.java:80)
Caused by: java.sql.SQLException: Cannot add foreign key constraint
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
        at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
        at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
        ... 11 more
INFO 11/20/20 10:10 AM:liquibase: Successfully released change log lock
WARN - ModuleFactory.startModuleInternal(786) |2020-11-20 10:10:39,241| Error while trying to start module: muzimacore
org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Muzima Core Module
        at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:993)
        at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:726)
        at org.openmrs.api.context.Daemon$1.run(Daemon.java:80)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::muzimaform-2014-10-31::SahajSoft:
     Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Cannot add foreign key constraint:
          Caused By: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Cannot add foreign key constraint:
          Caused By: Cannot add foreign key constraint
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
        at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:191)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
        at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:220)
        at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:986)
        ... 2 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Cannot add foreign key constraint
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
        at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
        at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
        ... 7 more
Caused by: java.sql.SQLException: Cannot add foreign key constraint
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
        at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
        at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
        ... 11 more
INFO - LoggingAdvice.invoke(116) |2020-11-20 10:10:39,805| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
INFO - LoggingAdvice.invoke(156) |2020-11-20 10:10:39,856| Exiting method saveAlert

a. You can resolve the above error by checking for the collation of the muzima_form and form tables. That is, you should check for the collation of columns uuid (form table) and form (muzima_form). Ideally, the tables and the columns should have the same collation type in order for the foreign key constraints to be added. The difference in collation is usually brought up by the creation of the Database by a user without declaring the collation.


  • No labels