- From where should I download the mUzima app?
- Check here.
- Is mUzima app available on mac?
- No, its not available at present.
- I have problem with the configuration of the app. What to do?
- For configuration related issues, check here.
- What if I want to test the mUzima app?
Use the following settings to connect to our Demo server:
- URL: http://demo2.muzima.org
- username: admin
- password: test
- I want to contribute to the the project. How can I do so?
- Help us by solving an issue or two. Check here. You can create new issues too.
- 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.