1. [NA]Remove "DEFINER=`root`@`localhost`" from mysql function
2. [NA]Copy all mysql function and paste at the end of sql file and before "/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;"
3. PHP REQUIREMENT LINK : http://jorani.org/recommended-php-version-benchmark.html and check /vendor/composer/platform_check.php
4. [NA]During manual installation of 1.0.0, while importing SQL script was giving error "DELIMITER $$ CREATE FUNCTION `GetFamilyTree`(`GivenID` INT)........" To rectify that vendor has suggested to import another SQL "GetFamilyTree_mysql5.6.sql" (Confirmed over email)
5. Remove these Lines from /legacy/sql/init/jorani.sql :
CREATE DATABASE IF NOT EXISTS jorani CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE jorani;
and then import sql in created db.
6. Method to install mentioned https://github.com/jorani/jorani?tab=readme-ov-file#manual (just fill in db details in /legacy/application/config/database.php i.e statically ($_db_host = '[[softdbhost]]'; and other values) and $config['base_url'] = '[[softurl]]' in else part, $config['from_mail'] = '[[admin_email]]' and $config['encryption_key'] = '[[encryption_key]]' in /legacy/application/config/config.php.
Don't configure /legacy/application/config/email.php, as method isn't clearly mentioned in docs.
7. Keep $config['debugbar_enabled'] = $env_bool('DEBUGBAR_ENABLED', false); in /legacy/application/config/config.php, as keeping it default $config['debugbar_enabled'] = $env_bool('DEBUGBAR_ENABLED', ENVIRONMENT === 'development') throws 'Class Not found' error.
8. MYSQL 8.0 mentioned as supported requirement https://github.com/jorani/jorani/blob/master/docs/v1.0.4.md
9. Exclude .git, .github while making zip