Gecko [ www.arkitchencabinet.com ]

Name	Size	Permission	Date
images	[ DIR ]	drwxr-xr-x	2026-04-08 22:26
php53	[ DIR ]	drwxr-xr-x	2026-04-08 22:26
php56	[ DIR ]	drwxr-xr-x	2026-04-08 22:26
php71	[ DIR ]	drwxr-xr-x	2026-04-08 22:26
php81	[ DIR ]	drwxr-xr-x	2026-04-08 22:26
php82	[ DIR ]	drwxr-xr-x	2026-04-08 22:26
_clone.php	4.04 KB	-rw-r--r--	2026-04-07 07:20
config.php	24.46 KB	-rw-r--r--	2026-04-07 07:20
database.php	4.68 KB	-rw-r--r--	2026-04-07 07:20
edit.php	4.19 KB	-rw-r--r--	2026-04-07 10:07
edit.xml	433 B	-rw-r--r--	2021-12-23 11:54
fileindex.php	193 B	-rw-r--r--	2026-04-07 07:20
import.php	4.3 KB	-rw-r--r--	2026-04-07 10:07
info.xml	3.12 KB	-rw-r--r--	2026-04-07 07:20
install.js	924 B	-rw-r--r--	2021-12-23 11:54
install.php	5.96 KB	-rw-r--r--	2026-04-07 10:07
install.xml	786 B	-rw-r--r--	2021-12-23 11:54
jorani.sql	19.98 KB	-rw-r--r--	2026-04-07 07:20
jorani.zip	16.91 MB	-rw-r--r--	2026-04-07 07:20
md5	3.6 KB	-rw-r--r--	2026-04-07 10:07
notes.txt	1.68 KB	-rw-r--r--	2026-04-07 07:20

Rename

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