Errors (0)

Suppressed (0)

Javascript Errors (0)

Benchmark (2)

Name	Time	Start	Total	Memory
application start	0.0000	2026-10-15	0.0000	2.1 Mb
application end	0.0304	10/15/2026 7:11:56 pm	0.0304	2.1 Mb

Sql (12)

Sql

SELECT
	sm_session_data
FROM b4j_production.sm_sessions AS a
WHERE sm_session_id = '8d3ojega7mhuevvsla9vae0qp6'
	AND sm_session_expires >= '2026-10-15 19:11:56.348866'
LIMIT 1

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

blob	1	196605

0.0010321140289307

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  sm_session_data FROM b4j_production.sm_sessions AS a WHERE sm_session_id = '8d3ojega7mhuevvsla9vae0qp6'  AND sm_session_expires >= '2026-10-15 19:11:56.348866' LIMIT 1, NULL, ['cache'=>false]...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  sm_session_data FROM b4j_production.sm_sessions AS a WHERE sm_session_id = '8d3ojega7mhuevvsla9vae0qp6'  AND sm_session_expires >= '2026-10-15 19:11:56.348866' LIMIT 1, NULL, []...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Session/Db/Base.php(53): Numbers\Backend\Db\Common\Query\Builder->query();
#4 Unknown: Numbers\Backend\Session\Db\Base->read(8d3ojega7mhuevvsla9vae0qp6);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Session.php(76): session_start();
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Bootstrap.php(95): Session::start(['ip_link'=>'default','gc_maxlifetime'=>'7200']...);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(156): Bootstrap::init([]...);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

UPDATE b4j_production.sm_sessions AS a
SET sm_session_expires = '2026-10-15 19:10:16.350326'
WHERE sm_session_id = '8d3ojega7mhuevvsla9vae0qp6'

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

0.00025105476379395

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(UPDATE b4j_production.sm_sessions AS a SET sm_session_expires = '2026-10-15 19:10:16.350326' WHERE sm_session_id = '8d3ojega7mhuevvsla9vae0qp6', NULL, ['cache'=>false]...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(UPDATE b4j_production.sm_sessions AS a SET sm_session_expires = '2026-10-15 19:10:16.350326' WHERE sm_session_id = '8d3ojega7mhuevvsla9vae0qp6', NULL, []...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Session/Db/Base.php(126): Numbers\Backend\Db\Common\Query\Builder->query();
#4 Unknown: Numbers\Backend\Session\Db\Base->destroy(8d3ojega7mhuevvsla9vae0qp6);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Session.php(79): session_regenerate_id(true);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Bootstrap.php(95): Session::start(['ip_link'=>'default','gc_maxlifetime'=>'7200']...);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(156): Bootstrap::init([]...);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	sm_session_data
FROM b4j_production.sm_sessions AS a
WHERE sm_session_id = 'bq8hvb9oblljrmo0vqi5ihi88q'
	AND sm_session_expires >= '2026-10-15 19:11:56.350899'
LIMIT 1

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

blob	1	196605

0.0005040168762207

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  sm_session_data FROM b4j_production.sm_sessions AS a WHERE sm_session_id = 'bq8hvb9oblljrmo0vqi5ihi88q'  AND sm_session_expires >= '2026-10-15 19:11:56.350899' LIMIT 1, NULL, ['cache'=>false]...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  sm_session_data FROM b4j_production.sm_sessions AS a WHERE sm_session_id = 'bq8hvb9oblljrmo0vqi5ihi88q'  AND sm_session_expires >= '2026-10-15 19:11:56.350899' LIMIT 1, NULL, []...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Session/Db/Base.php(53): Numbers\Backend\Db\Common\Query\Builder->query();
#4 Unknown: Numbers\Backend\Session\Db\Base->read(bq8hvb9oblljrmo0vqi5ihi88q);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Session.php(79): session_regenerate_id(true);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Bootstrap.php(95): Session::start(['ip_link'=>'default','gc_maxlifetime'=>'7200']...);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(156): Bootstrap::init([]...);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	*
FROM b4j_production.sm_ips_version4 AS a
WHERE sm_ipver4_start >= 3628718260
	AND sm_ipver4_end <= 3628718260
LIMIT 1

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

sm_ipver4_start
sm_ipver4_end

longlong		20
longlong		20
string	1	6
var_string	1	360
var_string	1	360
newdecimal	1	12
newdecimal	1	12

0.00031304359436035

Cache Tags

b4j_production.sm_ips_version4

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  * FROM b4j_production.sm_ips_version4 AS a WHERE sm_ipver4_start >= 3628718260  AND sm_ipver4_end <= 3628718260 LIMIT 1, [0=>'sm_ipver4_start',1=>'sm_ipver4_end']..., ['cache_tags'=>[0=>'b4j_production.sm_ips_version4'],'cache'=>false]...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  * FROM b4j_production.sm_ips_version4 AS a WHERE sm_ipver4_start >= 3628718260  AND sm_ipver4_end <= 3628718260 LIMIT 1, [0=>'sm_ipver4_start',1=>'sm_ipver4_end']..., ['cache_tags'=>[0=>'b4j_production.sm_ips_version4']]...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Table/Trait2.php(157): Numbers\Backend\Db\Common\Query\Builder->query([0=>'sm_ipver4_start',1=>'sm_ipver4_end']..., ['cache_tags'=>[0=>'b4j_production.sm_ips_version4']]...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/IP/Simple/Base.php(28): Object\Table->get(['where'=>['sm_ipver4_start;>='=>3628718260,'sm_ipver4_end;<='=>3628718260],'single_row'=>1]...);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Miscellaneous/IP.php(42): Numbers\Backend\IP\Simple\Base->get(216.73.216.180);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Session.php(93): Object\Miscellaneous\IP->get(216.73.216.180);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Bootstrap.php(95): Session::start(['ip_link'=>'default','gc_maxlifetime'=>'7200']...);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(156): Bootstrap::init([]...);
#9 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	a.in_group_id AS `group_id`,
	a.in_group_name AS `group_name`,
	a.in_group_language_code AS `language_code`,
	a.in_group_locale_code AS `locale_code`,
	a.in_group_timezone_code AS `timezone_code`,
	a.in_group_organization_id AS `organization_id`,
	a.in_group_format_date AS `format_date`,
	a.in_group_format_time AS `format_time`,
	a.in_group_format_datetime AS `format_datetime`,
	a.in_group_format_timestamp AS `format_timestamp`,
	a.in_group_format_amount_frm AS `format_amount_frm`,
	a.in_group_format_amount_fs AS `format_amount_fs`,
	a.in_group_format_uom AS `format_uom`,
	b.in_language_rtl AS `rtl`
FROM b4j_production.in_groups AS a
INNER JOIN b4j_production.in_language_codes b ON b.in_language_tenant_id = 2
	AND a.in_group_language_code = b.in_language_code
WHERE a.in_group_tenant_id = 2
	AND a.in_group_inactive = 0

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

group_id

long		11
var_string		360
string		9
var_string		90
var_string		90
long	1	11
var_string		765
var_string		765
var_string		765
var_string		765
short		6
short		6
var_string		90
char		4

0.0005040168762207

Cache Tags

b4j_production.in_groups
+numbers_tenant_2
b4j_production.in_language_codes

group_id	group_name	language_code	locale_code	timezone_code	organization_id	format_date	format_time	format_datetime	format_timestamp	format_amount_frm	format_amount_fs	format_uom	rtl
1	English	eng	en_CA.UTF-8	America/Toronto		m/d/Y	g:i:s a	m/d/Y g:i:s a	m/d/Y g:i:s.u a	10	30	METRIC	0
2	Ukrainian	ukr	uk_UA.UTF-8	America/Toronto		m/d/Y	g:i:s a	m/d/Y g:i:s a	m/d/Y g:i:s.u a	10	30	METRIC	0

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  a.in_group_id AS `group_id`,  a.in_group_name AS `group_name`,  a.in_group_language_code AS `language_code`,  a.in_group_locale_code AS `locale_code`,  a.in_group_timezone_code AS `timezone_code`,  a.in_group_organization_id AS `organization_id`,  a.in_group_format_date AS `format_date`,  a.in_group_format_time AS `format_time`,  a.in_group_format_datetime AS `format_datetime`,  a.in_group_format_timestamp AS `format_timestamp`,  a.in_group_format_amount_frm AS `format_amount_frm`,  a.in_group_format_amount_fs AS `format_amount_fs`,  a.in_group_format_uom AS `format_uom`,  b.in_language_rtl AS `rtl` FROM b4j_production.in_groups AS a INNER JOIN b4j_production.in_language_codes b ON b.in_language_tenant_id = 2  AND a.in_group_language_code = b.in_language_code WHERE a.in_group_tenant_id = 2  AND a.in_group_inactive = 0, [0=>'group_id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.in_groups',1=>'+numbers_tenant_2',4=>'b4j_producti...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  a.in_group_id AS `group_id`,  a.in_group_name AS `group_name`,  a.in_group_language_code AS `language_code`,  a.in_group_locale_code AS `locale_code`,  a.in_group_timezone_code AS `timezone_code`,  a.in_group_organization_id AS `organization_id`,  a.in_group_format_date AS `format_date`,  a.in_group_format_time AS `format_time`,  a.in_group_format_datetime AS `format_datetime`,  a.in_group_format_timestamp AS `format_timestamp`,  a.in_group_format_amount_frm AS `format_amount_frm`,  a.in_group_format_amount_fs AS `format_amount_fs`,  a.in_group_format_uom AS `format_uom`,  b.in_language_rtl AS `rtl` FROM b4j_production.in_groups AS a INNER JOIN b4j_production.in_language_codes b ON b.in_language_tenant_id = 2  AND a.in_group_language_code = b.in_language_code WHERE a.in_group_tenant_id = 2  AND a.in_group_inactive = 0, [0=>'group_id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.in_groups',1=>'+numbers_tenant_2',4=>'b4j_producti...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(276): Numbers\Backend\Db\Common\Query\Builder->query([0=>'group_id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.in_groups',1=>'+numbers_tenant_2',4=>'b4j_producti...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(340): Object\DataSource->get([]...);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Internalization/Internalization/Base.php(34): Object\DataSource::getStatic();
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/I18n.php(42): Numbers\Internalization\Internalization\Base->init(['submodule'=>'\\Numbers\\Internalization\\Internalization\\Base','group_id'=>'1','language_code'=>'...);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Bootstrap.php(114): I18n::init();
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(156): Bootstrap::init([]...);
#9 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	a.sm_resource_id AS `id`,
	a.sm_resource_code AS `code`,
	a.sm_resource_name AS `name`,
	a.sm_resource_description AS `description`,
	a.sm_resource_classification AS `classification`,
	a.sm_resource_icon AS `icon`,
	a.sm_resource_module_code AS `module_code`,
	concat_ws('::', b.sm_module_name, a.sm_resource_group1_name, a.sm_resource_group2_name, sm_resource_group3_name, sm_resource_group4_name, sm_resource_group5_name, sm_resource_group6_name, sm_resource_group7_name, sm_resource_group8_name, sm_resource_group9_name) AS `breadcrumbs`,
	c.actions AS `actions`,
	a.sm_resource_acl_public AS `acl_public`,
	a.sm_resource_acl_authorized AS `acl_authorized`,
	a.sm_resource_acl_permission AS `acl_permission`,
	COALESCE(d.missing_features, 0) AS `missing_features`
FROM b4j_production.sm_resources AS a
LEFT JOIN b4j_production.sm_modules b ON a.sm_resource_module_code = b.sm_module_code
LEFT JOIN (
	SELECT
		inner_a.sm_rsrcmp_resource_id,
		GROUP_CONCAT(concat_ws('::', inner_a.sm_rsrcmp_method_code, inner_a.sm_rsrcmp_action_id, inner_b.sm_action_code) SEPARATOR ';;') AS `actions`
	FROM b4j_production.sm_resource_map AS inner_a
	INNER JOIN b4j_production.sm_resource_actions inner_b ON inner_a.sm_rsrcmp_action_id = inner_b.sm_action_id
	WHERE inner_a.sm_rsrcmp_inactive = 0
		AND inner_b.sm_action_inactive = 0
	GROUP BY sm_rsrcmp_resource_id
) c ON a.sm_resource_id = c.sm_rsrcmp_resource_id
LEFT JOIN (
	SELECT
		inner_a.sm_rsrcftr_resource_id AS `resource_id`,
		SUM(CASE WHEN inner_b.tm_feature_feature_code IS NULL THEN 1 ELSE 0 END) AS `missing_features`
	FROM b4j_production.sm_resource_features AS inner_a
	LEFT JOIN b4j_production.tm_module_features inner_b ON inner_b.tm_feature_tenant_id = 2
		AND inner_b.tm_feature_feature_code = inner_a.sm_rsrcftr_feature_code
	GROUP BY resource_id
) d ON a.sm_resource_id = d.resource_id
WHERE a.sm_resource_type = 100
	AND a.sm_resource_inactive = 0
	AND ( a.sm_resource_module_code IN('SM', 'TM')
		OR  EXISTS (SELECT
				exists_a.tm_module_module_code
			FROM b4j_production.tm_modules AS exists_a
			WHERE exists_a.tm_module_tenant_id = 2
				AND exists_a.tm_module_module_code = a.sm_resource_module_code)
	)

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

code

long		11
var_string		765
var_string		360
var_string	1	6000
var_string	1	360
var_string	1	150
string		6
var_string	1	3654
blob	1	9216
char		4
char		4
char		4
newdecimal		24

0.0043120384216309

Cache Tags

b4j_production.sm_resources
b4j_production.sm_modules
b4j_production.sm_resource_map
b4j_production.sm_resource_actions
b4j_production.sm_resource_features
b4j_production.tm_module_features
+numbers_tenant_2
b4j_production.tm_modules

id	code	name	classification	icon	module_code	breadcrumbs	actions	acl_public	acl_authorized	acl_permission	missing_features
3	\Numbers\Backend\Db\Common\Controller\Report\DataClassification	S/M Data Classification	Reports	fas fa-database	SM	S/M System::Operations::System Management::Miscellaneous::Reports	Index::4000::Report_View	0	1	1	0
5	\Controller\B4J\Periods	B/J Periods	Settings	far fa-calendar	B4	B/J Break For Jesus::Operations::Registrations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
6	\Controller\B4J\Registrations	B/J Camp Registrations	Transactions	fas fa-registered	B4	B/J Break For Jesus::Operations::Registrations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
7	\Controller\B4J\Counselors	B/J Counselor Registrations	Transactions	fab fa-delicious	B4	B/J Break For Jesus::Operations::Registrations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
8	\Controller\B4J\Register	Register for Camp	Miscellaneous	far fa-registered	B4	B/J Break For Jesus::Account		1	1	0	0
9	\Controller\B4J\CounselorsRegister	Register for Counselor	Miscellaneous	fab fa-delicious	B4	B/J Break For Jesus::Account		1	1	0	0
22	\Numbers\Backend\Session\Db\Controller\Report\SessionLog	S/M Session Log	Reports	fas fa-sign-in-alt	SM	S/M System::Operations::System Management::Miscellaneous::Reports	Index::4000::Report_View	0	1	1	0
24	\Numbers\Tenants\Tenants\Controller\Activation\Modules	T/M General Modules	Global	fas fa-cubes	TM	T/M Tenants::Operations::System Management::Data Activation	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New	0	1	1	0
25	\Numbers\Tenants\Tenants\Controller\Activation\Features	T/M General Features	Global	fas fa-cube	TM	T/M Tenants::Operations::System Management::Data Activation	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New	0	1	1	0
26	\Numbers\Tenants\Tenants\Controller\Activation\ResetModule	T/M Reset Modules	Global	fas fa-unlink	TM	T/M Tenants::Operations::System Management::Data Activation	AllActions::-1::All_Actions;;Edit::2000::Record_View;;Edit::2010::Record_New	0	1	1	0
27	\Numbers\Tenants\Tenants\Controller\Activation\ResetFeature	T/M Reset Feature	Global	far fa-times-circle	TM	T/M Tenants::Operations::System Management::Data Activation	AllActions::-1::All_Actions;;Edit::2000::Record_View;;Edit::2010::Record_New	0	1	1	0
28	\Numbers\Tenants\Tenants\Controller\Assignments	T/M Assignments	Settings	fas fa-assistive-listening-systems	TM	T/M Tenants::Operations::System Management::Miscellaneous	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
29	\Numbers\Tenants\Tenants\Controller\Registries	T/M Registries	Settings	far fa-gem	TM	T/M Tenants::Operations::System Management::Miscellaneous	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
30	\Numbers\Tenants\Tenants\Controller\Policy\Folders	T/M Policy Folders	Settings	far fa-folder	TM	T/M Tenants::Operations::System Management::Policy Management	AllActions::-1::All_Actions;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete	0	1	1	1
42	\Numbers\Countries\Countries\Controller\Countries	C/M Countries	Global	far fa-flag	CM	C/M Country Management::Operations::System Management::Country Management	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
43	\Numbers\Countries\Countries\Controller\PostalCodes	C/M Postal Codes	Global	far fa-compass	CM	C/M Country Management::Operations::System Management::Country Management	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
44	\Numbers\Countries\Countries\Controller\Provinces	C/M Provinces	Global	far fa-circle	CM	C/M Country Management::Operations::System Management::Country Management	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
45	\Numbers\Countries\Countries\Controller\Regions	C/M Regions	Global	far fa-object-group	CM	C/M Country Management::Operations::System Management::Country Management	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
46	\Numbers\Countries\Countries\Controller\Address\Types	C/M Address Types	Settings	fas fa-circle	CM	C/M Country Management::Operations::System Management::Country Management	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
53	\Numbers\Users\Organizations\Controller\Organizations	O/N Organizations	Global	far fa-building	ON	O/N Organization Management::Operations::Organization Management	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
54	\Numbers\Users\Organizations\Controller\Locations	O/N Locations	Global	fas fa-coffee	ON	O/N Organization Management::Operations::Organization Management	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	1
55	\Numbers\Users\Organizations\Controller\Location\Zones	O/N Location Zones / Slots	Settings	fas fa-clone	ON	O/N Organization Management::Operations::Organization Management::Locations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	1
56	\Numbers\Users\Organizations\Controller\Location\Territories	O/N Territories	Global	far fa-square	ON	O/N Organization Management::Operations::Organization Management::Locations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	2
57	\Numbers\Users\Organizations\Controller\Organization\Types	O/N Organization Types	Settings	far fa-clone	ON	O/N Organization Management::Operations::Organization Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
58	\Numbers\Users\Organizations\Controller\Jurisdictions	O/N Jurisdictions	Settings	fas fa-flag	ON	O/N Organization Management::Operations::Organization Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
59	\Numbers\Users\Organizations\Controller\LegalAuthorities	O/N Legal Authorities	Settings	far fa-money-bill-alt	ON	O/N Organization Management::Operations::Organization Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
60	\Numbers\Users\Organizations\Controller\StrategicBusinessUnits	O/N Strategic Business Units	Settings	fas fa-hospital	ON	O/N Organization Management::Operations::Organization Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
61	\Numbers\Users\Organizations\Controller\Departments	O/N Departments	Settings	fas fa-address-book	ON	O/N Organization Management::Operations::Organization Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
62	\Numbers\Users\Organizations\Controller\Trademarks	O/N Trademarks	Settings	fas fa-trademark	ON	O/N Organization Management::Operations::Organization Management::Locations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	1
63	\Numbers\Users\Organizations\Controller\Brands	O/N Brands	Settings	fas fa-thumbs-up	ON	O/N Organization Management::Operations::Organization Management::Locations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	1
64	\Numbers\Users\Organizations\Controller\Districts	O/N Districts	Settings	far fa-sticky-note	ON	O/N Organization Management::Operations::Organization Management::Locations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	1
65	\Numbers\Users\Organizations\Controller\Markets	O/N Markets	Settings	fas fa-sticky-note	ON	O/N Organization Management::Operations::Organization Management::Locations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	1
66	\Numbers\Users\Organizations\Controller\Regions	O/N Regions	Settings	fas fa-tag	ON	O/N Organization Management::Operations::Organization Management::Locations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	1
67	\Numbers\Users\Organizations\Controller\ItemMasters	O/N Item Masters	Settings	fas fa-cubes	ON	O/N Organization Management::Operations::Organization Management::Locations	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	1
68	\Numbers\Users\Organizations\Controller\CostCenters	O/N Cost Centers	Settings	fas fa-rupee-sign	ON	O/N Organization Management::Operations::Organization Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
69	\Numbers\Users\Organizations\Controller\Divisions	O/N Divisions	Settings	fas fa-star-half	ON	O/N Organization Management::Operations::Organization Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
70	\Numbers\Users\Organizations\Controller\Queue\Types	O/N Queue Types	Settings	fab fa-gg	ON	O/N Organization Management::Operations::Organization Management::Settings::Queues	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
71	\Numbers\Users\Organizations\Controller\Queue\OwnerTypes	O/N Owner Types	Settings	far fa-user	ON	O/N Organization Management::Operations::Organization Management::Settings::Queues	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
95	\Numbers\Users\Users\Controller\Login	Sign In	Miscellaneous	fas fa-sign-in-alt	UM	U/M User Management::Account::Authorization		1	0	0	0
96	\Numbers\Users\Users\Controller\Logout	Sign Out	Miscellaneous	fas fa-sign-out-alt	UM	U/M User Management::Account::Authorization		0	1	0	0
97	\Numbers\Users\Users\Controller\Helper\Dashboard	Welcome	Miscellaneous	fab fa-wpexplorer	UM	U/M User Management::Account::Authorization		0	1	0	0
98	\Numbers\Users\Users\Controller\Account\Profile	Profile	Miscellaneous	far fa-user	UM	U/M User Management::Account		0	1	0	0
99	\Numbers\Users\Users\Controller\Account\Messages	Messages	Miscellaneous	far fa-envelope	UM	U/M User Management::Account		0	1	0	0
100	\Numbers\Users\Users\Controller\Password\Reset	Password Reset	Miscellaneous	fas fa-key	UM	U/M User Management::Account::Authorization		1	1	0	0
101	\Numbers\Users\Users\Controller\Users	U/M Users	Global	fas fa-users	UM	U/M User Management::Operations::User Management	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
102	\Numbers\Users\Users\Controller\Groups	U/M Groups	Settings	far fa-object-group	UM	U/M User Management::Operations::User Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
103	\Numbers\Users\Users\Controller\Teams	U/M Teams	Settings	fas fa-sitemap	UM	U/M User Management::Operations::User Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
104	\Numbers\Users\Users\Controller\Titles	U/M Titles	Settings	fas fa-blind	UM	U/M User Management::Operations::User Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
105	\Numbers\Users\Users\Controller\Roles	U/M User Roles	Settings	far fa-user-circle	UM	U/M User Management::Operations::User Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
106	\Numbers\Users\Users\Controller\TeamRoles	U/M Team Roles	Settings	fas fa-male	UM	U/M User Management::Operations::User Management::Settings	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
107	\Numbers\Users\Users\Controller\Form\Overrides	U/M Form Overrides	Settings	fas fa-cogs	UM	U/M User Management::Operations::System Management::Miscellaneous	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
108	\Numbers\Users\Users\Controller\System\Senders	U/M Notification Senders	Settings	far fa-envelope	UM	U/M User Management::Operations::System Management::Miscellaneous	AllActions::-1::All_Actions;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit	0	1	1	0
109	\Numbers\Users\Users\Controller\Report\Security\OrganizationAccessReport	U/M Organization Access Report	Reports	far fa-building	UM	U/M User Management::Operations::User Management::Reports	Index::4000::Report_View	0	1	1	0
110	\Numbers\Users\Users\Controller\Report\Security\ResourceSetupReport	U/M Resource Setup Report	Reports	fas fa-tasks	UM	U/M User Management::Operations::User Management::Reports	Index::4000::Report_View	0	1	1	0
111	\Numbers\Users\Users\Controller\Report\Security\RoleSetupReport	U/M Role Setup Report	Reports	far fa-user-circle	UM	U/M User Management::Operations::User Management::Reports	Index::4000::Report_View	0	1	1	0
112	\Numbers\Users\Users\Controller\Report\Security\RoleAssignmentReport	U/M Role Assignment Report	Reports	far fa-user-circle	UM	U/M User Management::Operations::User Management::Reports	Index::4000::Report_View	0	1	1	0
136	\Numbers\Internalization\Internalization\Controller\Language\Codes	I/N Language Codes	Global	far fa-flag	IN	I/N Internalization::Operations::System Management::Internalization	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
137	\Numbers\Internalization\Internalization\Controller\Locales	I/N Locales	Global	far fa-compass	IN	I/N Internalization::Operations::System Management::Internalization	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
138	\Numbers\Internalization\Internalization\Controller\Timezones	I/N Timezones	Global	far fa-calendar	IN	I/N Internalization::Operations::System Management::Internalization	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
139	\Numbers\Internalization\Internalization\Controller\Groups	I/N Groups	Global	far fa-object-group	IN	I/N Internalization::Operations::System Management::Internalization	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
140	\Numbers\Internalization\Internalization\Controller\Translations	I/N Translations	Global	fas fa-font	IN	I/N Internalization::Operations::System Management::Internalization	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete;;Import::3000::Import_Records	0	1	1	0
141	\Numbers\Internalization\Internalization\Controller\Missing	I/N Missing Translations	Global	fas fa-strikethrough	IN	I/N Internalization::Operations::System Management::Internalization	AllActions::-1::All_Actions;;Index::1000::List_View;;Index::1010::List_Export;;Edit::2000::Record_View;;Edit::2010::Record_New;;Edit::2020::Record_Edit;;Edit::2030::Record_Inactivate;;Edit::2040::Record_Delete	0	1	1	0
149	\Controller\B4J\ResendEmails	B/J Resend Camp Registration Emails	Transactions	far fa-comment	B4	B/J Break For Jesus::Operations::Registrations	Edit::2000::Record_View	0	1	1	0

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  a.sm_resource_id AS `id`,  a.sm_resource_code AS `code`,  a.sm_resource_name AS `name`,  a.sm_resource_description AS `description`,  a.sm_resource_classification AS `classification`,  a.sm_resource_icon AS `icon`,  a.sm_resource_module_code AS `module_code`,  concat_ws('::', b.sm_module_name, a.sm_resource_group1_name, a.sm_resource_group2_name, sm_resource_group3_name, sm_resource_group4_name, sm_resource_group5_name, sm_resource_group6_name, sm_resource_group7_name, sm_resource_group8_name, sm_resource_group9_name) AS `breadcrumbs`,  c.actions AS `actions`,  a.sm_resource_acl_public AS `acl_public`,  a.sm_resource_acl_authorized AS `acl_authorized`,  a.sm_resource_acl_permission AS `acl_permission`,  COALESCE(d.missing_features, 0) AS `missing_features` FROM b4j_production.sm_resources AS a LEFT JOIN b4j_production.sm_modules b ON a.sm_resource_module_code = b.sm_module_code LEFT JOIN (  SELECT   inner_a.sm_rsrcmp_resource_id,   GROUP_CONCAT(concat_ws('::', inner_a.sm_rsrcmp_method_code, inner_a.sm_rsrcmp_action_id, inner_b.sm_action_code) SEPARATOR ';;') AS `actions`  FROM b4j_production.sm_resource_map AS inner_a  INNER JOIN b4j_production.sm_resource_actions inner_b ON inner_a.sm_rsrcmp_action_id = inner_b.sm_action_id  WHERE inner_a.sm_rsrcmp_inactive = 0   AND inner_b.sm_action_inactive = 0  GROUP BY sm_rsrcmp_resource_id ) c ON a.sm_resource_id = c.sm_rsrcmp_resource_id LEFT JOIN (  SELECT   inner_a.sm_rsrcftr_resource_id AS `resource_id`,   SUM(CASE WHEN inner_b.tm_feature_feature_code IS NULL THEN 1 ELSE 0 END) AS `missing_features`  FROM b4j_production.sm_resource_features AS inner_a  LEFT JOIN b4j_production.tm_module_features inner_b ON inner_b.tm_feature_tenant_id = 2   AND inner_b.tm_feature_feature_code = inner_a.sm_rsrcftr_feature_code  GROUP BY resource_id ) d ON a.sm_resource_id = d.resource_id WHERE a.sm_resource_type = 100  AND a.sm_resource_inactive = 0  AND ( a.sm_resource_module_code IN('SM', 'TM')   OR  EXISTS (SELECT     exists_a.tm_module_module_code    FROM b4j_production.tm_modules AS exists_a    WHERE exists_a.tm_module_tenant_id = 2     AND exists_a.tm_module_module_code = a.sm_resource_module_code)  ), [0=>'code']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.sm_resources',2=>'b4j_production.sm_modules',3=>'b...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  a.sm_resource_id AS `id`,  a.sm_resource_code AS `code`,  a.sm_resource_name AS `name`,  a.sm_resource_description AS `description`,  a.sm_resource_classification AS `classification`,  a.sm_resource_icon AS `icon`,  a.sm_resource_module_code AS `module_code`,  concat_ws('::', b.sm_module_name, a.sm_resource_group1_name, a.sm_resource_group2_name, sm_resource_group3_name, sm_resource_group4_name, sm_resource_group5_name, sm_resource_group6_name, sm_resource_group7_name, sm_resource_group8_name, sm_resource_group9_name) AS `breadcrumbs`,  c.actions AS `actions`,  a.sm_resource_acl_public AS `acl_public`,  a.sm_resource_acl_authorized AS `acl_authorized`,  a.sm_resource_acl_permission AS `acl_permission`,  COALESCE(d.missing_features, 0) AS `missing_features` FROM b4j_production.sm_resources AS a LEFT JOIN b4j_production.sm_modules b ON a.sm_resource_module_code = b.sm_module_code LEFT JOIN (  SELECT   inner_a.sm_rsrcmp_resource_id,   GROUP_CONCAT(concat_ws('::', inner_a.sm_rsrcmp_method_code, inner_a.sm_rsrcmp_action_id, inner_b.sm_action_code) SEPARATOR ';;') AS `actions`  FROM b4j_production.sm_resource_map AS inner_a  INNER JOIN b4j_production.sm_resource_actions inner_b ON inner_a.sm_rsrcmp_action_id = inner_b.sm_action_id  WHERE inner_a.sm_rsrcmp_inactive = 0   AND inner_b.sm_action_inactive = 0  GROUP BY sm_rsrcmp_resource_id ) c ON a.sm_resource_id = c.sm_rsrcmp_resource_id LEFT JOIN (  SELECT   inner_a.sm_rsrcftr_resource_id AS `resource_id`,   SUM(CASE WHEN inner_b.tm_feature_feature_code IS NULL THEN 1 ELSE 0 END) AS `missing_features`  FROM b4j_production.sm_resource_features AS inner_a  LEFT JOIN b4j_production.tm_module_features inner_b ON inner_b.tm_feature_tenant_id = 2   AND inner_b.tm_feature_feature_code = inner_a.sm_rsrcftr_feature_code  GROUP BY resource_id ) d ON a.sm_resource_id = d.resource_id WHERE a.sm_resource_type = 100  AND a.sm_resource_inactive = 0  AND ( a.sm_resource_module_code IN('SM', 'TM')   OR  EXISTS (SELECT     exists_a.tm_module_module_code    FROM b4j_production.tm_modules AS exists_a    WHERE exists_a.tm_module_tenant_id = 2     AND exists_a.tm_module_module_code = a.sm_resource_module_code)  ), [0=>'code']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.sm_resources',2=>'b4j_production.sm_modules',3=>'b...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(276): Numbers\Backend\Db\Common\Query\Builder->query([0=>'code']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.sm_resources',2=>'b4j_production.sm_modules',3=>'b...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(52): Object\DataSource->get(['skip_acl'=>true]...);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(65): Object\ACL\Resources->get(controllers, primary, NULL);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(147): Object\ACL\Resources::getStatic(controllers, primary);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(174): Object\Controller->__construct();
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	a.tm_module_id AS `id`,
	a.tm_module_name AS `name`,
	a.tm_module_module_code AS `module_code`,
	b.sm_module_multiple AS `module_multiple`,
	c.features AS `features`
FROM b4j_production.tm_modules AS a
INNER JOIN b4j_production.sm_modules b ON b.sm_module_code = a.tm_module_module_code
LEFT JOIN (
	SELECT
		inner_a.tm_feature_module_id,
		GROUP_CONCAT(inner_a.tm_feature_feature_code SEPARATOR ';;') AS `features`
	FROM b4j_production.tm_module_features AS inner_a
	INNER JOIN b4j_production.sm_module_features inner_c ON inner_a.tm_feature_feature_code = inner_c.sm_feature_code
	WHERE inner_a.tm_feature_tenant_id = 2
		AND inner_a.tm_feature_inactive = 0
		AND inner_c.sm_feature_inactive = 0
	GROUP BY inner_a.tm_feature_module_id
) c ON a.tm_module_id = c.tm_feature_module_id
WHERE a.tm_module_tenant_id = 2
	AND a.tm_module_inactive = 0
	AND b.sm_module_inactive = 0

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

long		11
var_string		360
string		6
char		4
blob	1	9216

0.00098013877868652

Cache Tags

b4j_production.tm_modules
+numbers_tenant_2
b4j_production.sm_modules
b4j_production.tm_module_features
b4j_production.sm_module_features

id	name	module_code	features
2	A/N Application	AN
8	B/J Break For Jesus	B4	B4::B4J;;B4::EMAIL_NEED_MEDICAL;;B4::EMAIL_ON_WAITING_LIST;;B4::EMAIL_REG_ACCEPTED;;B4::EMAIL_REG_CONFIRMATION
5	C/M Country Management	CM	CM::COUNTRIES;;CM::DATA_ALL_COUNTRIES
6	I/N Internalization	IN	IN::INTERNALIZATION
4	O/N Organization Management	ON	ON::ORGANIZATIONS
1	S/M System	SM	SM::EMAIL_COMMON_RECORD_CHANGE
3	T/M Tenants	TM	TM::TENANTS
7	U/M User Management	UM	UM::EMAIL_PASSWORD_CHANGED;;UM::EMAIL_RESET_PASSWORD;;UM::EMAIL_SEND_MESSAGE;;UM::EMAIL_TENANT_CONFIRMATION;;UM::EMAIL_USERS_CHANGED;;UM::RBAC;;UM::USERS

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  a.tm_module_id AS `id`,  a.tm_module_name AS `name`,  a.tm_module_module_code AS `module_code`,  b.sm_module_multiple AS `module_multiple`,  c.features AS `features` FROM b4j_production.tm_modules AS a INNER JOIN b4j_production.sm_modules b ON b.sm_module_code = a.tm_module_module_code LEFT JOIN (  SELECT   inner_a.tm_feature_module_id,   GROUP_CONCAT(inner_a.tm_feature_feature_code SEPARATOR ';;') AS `features`  FROM b4j_production.tm_module_features AS inner_a  INNER JOIN b4j_production.sm_module_features inner_c ON inner_a.tm_feature_feature_code = inner_c.sm_feature_code  WHERE inner_a.tm_feature_tenant_id = 2   AND inner_a.tm_feature_inactive = 0   AND inner_c.sm_feature_inactive = 0  GROUP BY inner_a.tm_feature_module_id ) c ON a.tm_module_id = c.tm_feature_module_id WHERE a.tm_module_tenant_id = 2  AND a.tm_module_inactive = 0  AND b.sm_module_inactive = 0, [0=>'id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.tm_modules',1=>'+numbers_tenant_2',4=>'b4j_product...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  a.tm_module_id AS `id`,  a.tm_module_name AS `name`,  a.tm_module_module_code AS `module_code`,  b.sm_module_multiple AS `module_multiple`,  c.features AS `features` FROM b4j_production.tm_modules AS a INNER JOIN b4j_production.sm_modules b ON b.sm_module_code = a.tm_module_module_code LEFT JOIN (  SELECT   inner_a.tm_feature_module_id,   GROUP_CONCAT(inner_a.tm_feature_feature_code SEPARATOR ';;') AS `features`  FROM b4j_production.tm_module_features AS inner_a  INNER JOIN b4j_production.sm_module_features inner_c ON inner_a.tm_feature_feature_code = inner_c.sm_feature_code  WHERE inner_a.tm_feature_tenant_id = 2   AND inner_a.tm_feature_inactive = 0   AND inner_c.sm_feature_inactive = 0  GROUP BY inner_a.tm_feature_module_id ) c ON a.tm_module_id = c.tm_feature_module_id WHERE a.tm_module_tenant_id = 2  AND a.tm_module_inactive = 0  AND b.sm_module_inactive = 0, [0=>'id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.tm_modules',1=>'+numbers_tenant_2',4=>'b4j_product...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(276): Numbers\Backend\Db\Common\Query\Builder->query([0=>'id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.tm_modules',1=>'+numbers_tenant_2',4=>'b4j_product...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(52): Object\DataSource->get(['skip_acl'=>true]...);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(65): Object\ACL\Resources->get(modules, primary, NULL);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(151): Object\ACL\Resources::getStatic(modules, primary);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(174): Object\Controller->__construct();
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	a.tm_registry_code AS `code`,
	a.tm_registry_value AS `value`,
	a.tm_registry_inactive AS `inactive`
FROM b4j_production.tm_registries AS a
WHERE a.tm_registry_tenant_id = 2
	AND a.tm_registry_inactive = 0

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

code

var_string		765
blob		196605
char		4

0.00054192543029785

Cache Tags

b4j_production.tm_registries
+numbers_tenant_2

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  a.tm_registry_code AS `code`,  a.tm_registry_value AS `value`,  a.tm_registry_inactive AS `inactive` FROM b4j_production.tm_registries AS a WHERE a.tm_registry_tenant_id = 2  AND a.tm_registry_inactive = 0, [0=>'code']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.tm_registries',1=>'+numbers_tenant_2']]...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  a.tm_registry_code AS `code`,  a.tm_registry_value AS `value`,  a.tm_registry_inactive AS `inactive` FROM b4j_production.tm_registries AS a WHERE a.tm_registry_tenant_id = 2  AND a.tm_registry_inactive = 0, [0=>'code']..., ['cache'=>true,'cache_tags'=>[0=>'b4j_production.tm_registries',1=>'+numbers_tenant_2']]...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(276): Numbers\Backend\Db\Common\Query\Builder->query([0=>'code']..., ['cache'=>true,'cache_tags'=>[0=>'b4j_production.tm_registries',1=>'+numbers_tenant_2']]...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(52): Object\DataSource->get(['skip_acl'=>true]...);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(65): Object\ACL\Resources->get(registries, primary, NULL);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Registry.php(45): Object\ACL\Resources::getStatic(registries, primary);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Functions.php(930): Registry::get(b4j.contact.email);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html(43): registry(b4j.contact.email);
#9 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/View.php(30): require(/home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html);
#10 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(320): View->__construct((object) Numbers\Frontend\HTML\FontAwesome\Controller\Icons, /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html, html);
#11 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(204): Application::process();
#12 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	a.sm_resource_id AS `id`,
	a.sm_resource_type AS `type`,
	a.sm_resource_name AS `name`,
	a.sm_resource_description AS `description`,
	a.sm_resource_icon AS `icon`,
	a.sm_resource_menu_url AS `url`,
	a.sm_resource_module_code AS `module_code`,
	a.sm_resource_group1_name AS `group1`,
	a.sm_resource_group2_name AS `group2`,
	a.sm_resource_group3_name AS `group3`,
	a.sm_resource_group4_name AS `group4`,
	a.sm_resource_group5_name AS `group5`,
	a.sm_resource_group6_name AS `group6`,
	a.sm_resource_group7_name AS `group7`,
	a.sm_resource_group8_name AS `group8`,
	a.sm_resource_group9_name AS `group9`,
	a.sm_resource_acl_public AS `acl_public`,
	a.sm_resource_acl_authorized AS `acl_authorized`,
	a.sm_resource_acl_permission AS `acl_permission`,
	a.sm_resource_menu_acl_resource_id AS `acl_resource_id`,
	a.sm_resource_menu_acl_method_code AS `acl_method_code`,
	a.sm_resource_menu_acl_action_id AS `acl_action_id`,
	a.sm_resource_menu_child_ordered AS `child_ordered`,
	a.sm_resource_menu_order AS `order`,
	a.sm_resource_menu_separator AS `separator`,
	a.sm_resource_menu_name_generator AS `name_generator`,
	a.sm_resource_menu_class AS `class`
FROM b4j_production.sm_resources AS a
WHERE a.sm_resource_type >= 200
	AND a.sm_resource_type < 300
	AND a.sm_resource_inactive = 0
ORDER BY a.sm_resource_type DESC

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

long		11
short		6
var_string		360
var_string	1	6000
var_string	1	150
blob	1	196605
string		6
var_string	1	360
var_string	1	360
var_string	1	360
var_string	1	360
var_string	1	360
var_string	1	360
var_string	1	360
var_string	1	360
var_string	1	360
char		4
char		4
char		4
long	1	11
var_string	1	765
short	1	6
char		4
long		11
char		4
blob	1	196605
blob	1	196605

0.002601146697998

Cache Tags

b4j_production.sm_resources

id	type	name	description	icon	url	module_code	group1	group2	group3	group4	acl_public	acl_authorized	acl_permission	acl_resource_id	acl_method_code	acl_action_id	child_ordered	order	separator	name_generator	class
2	299	Reports		fas fa-table		SM	Operations	System Management	Miscellaneous		0	0	0				0	0	0
88	299	Locations		fas fa-coffee		ON	Operations	Organization Management			0	0	0				0	0	0
113	299	Account		fas fa-address-card		UM					1	0	0				1	0	0	/Numbers/Users/Users/Controller/Account/Account/_JsonMenuName
114	299	Reports		fas fa-table		UM	Account				1	0	0				0	32000	0
115	299	Miscellaneous		fas fa-cubes		UM	Account	Reports			1	0	0				0	0	0
120	299	User Management		far fa-user		UM	Operations				0	0	0				0	0	0
124	299	Settings		fas fa-cogs		UM	Operations	User Management			0	0	0				0	0	0
75	299	Queues		fab fa-gg-circle		ON	Operations	Organization Management	Settings		0	0	0				0	0	0
74	299	Settings		fas fa-cogs		ON	Operations	Organization Management			0	0	0				0	0	0
72	299	Organization Management		fas fa-building		ON	Operations				0	0	0				0	0	0
127	299	Reports		fas fa-table		UM	Operations	User Management			0	0	0				0	0	0
128	299	Security		fas fa-shield-alt		UM	Operations	User Management	Reports		0	0	0				0	0	0
47	299	Country Management		fas fa-globe		CM	Operations	System Management			0	0	0				0	0	0
40	299	Policy Management		far fa-futbol		TM	Operations	System Management			0	0	0				0	0	0
142	299	Internalization		fas fa-adjust		UM	Operations	System Management			0	0	0				0	0	0
33	299	Data Activation		fas fa-cogs		TM	Operations	System Management			0	0	0				0	0	0
31	299	System Management		fas fa-wrench		TM	Operations				0	0	0				0	0	0
1	299	Miscellaneous		fas fa-cubes		SM	Operations	System Management			0	0	0				0	0	0
151	299	Media				B4	Media				1	0	0				1	0	0	/Numbers/Users/Users/Controller/Account/Account/_JsonMenuName
16	299	Registrations		far fa-user-circle		B4	Operations				0	0	0				0	0	0
32	299	Operations		far fa-clone		TM					0	0	0				0	0	0
119	210	Messages		far fa-envelope	/Numbers/Users/Users/Controller/Account/Messages	UM	Account				0	1	0				0	10100	0	/Numbers/Users/Users/Controller/Account/Messages/_JsonMenuName
20	210	Register for Counselor		fab fa-delicious	/B4J/CounselorsRegister	B4	Account				1	1	0	9	Index		0	10200	0
118	210	Profile		far fa-user	/Numbers/Users/Users/Controller/Account/Profile	UM	Account				0	1	0				0	10000	0
117	210	Sign Out		fas fa-sign-out-alt	/Numbers/Users/Users/Controller/Logout	UM	Account				0	1	0				0	999999	1
116	210	Sign In		fas fa-sign-in-alt	/Numbers/Users/Users/Controller/Login	UM	Account				1	0	0				0	-32000	0
18	210	Register for Camp		far fa-registered	/B4J/Register	B4	Account				1	1	0	8	Index		0	10100	0
152	200	2018			/Media/_2018	AN	Media				1	1	0				0	-31900	0
122	200	Groups		far fa-object-group	/Numbers/Users/Users/Controller/Groups	UM	Operations	User Management	Settings		0	0	1	102	Index	1000	0	0	0
121	200	Users		fas fa-users	/Numbers/Users/Users/Controller/Users	UM	Operations	User Management			0	0	1	101	Index	1000	0	0	0
143	200	Languages		far fa-flag	/Numbers/Internalization/Internalization/Controller/Language/Codes	IN	Operations	System Management	Internalization		0	0	1	136	Index	1000	0	0	0
150	200	Resend Camp Emails		far fa-comment	/B4J/ResendEmails/_Edit	B4	Operations	Registrations			0	0	1	149	Edit	2000	0	0	0
153	200	2019			/Media/_2019	AN	Media				1	1	0				0	-31900	0
154	200	2023			/Media/_2023	AN	Media				1	1	0				0	-31900	0
94	200	Owner Types		far fa-user	/Numbers/Users/Organizations/Controller/Queue/OwnerTypes	ON	Operations	Organization Management	Settings	Queues	0	0	1	71	Index	1000	0	0	0
93	200	Queue Types		fab fa-gg	/Numbers/Users/Organizations/Controller/Queue/Types	ON	Operations	Organization Management	Settings	Queues	0	0	1	70	Index	1000	0	0	0
92	200	Territories		far fa-square	/Numbers/Users/Organizations/Controller/Location/Territories	ON	Operations	Organization Management	Locations		0	0	1	56	Index	1000	0	0	0
123	200	Titles		fas fa-blind	/Numbers/Users/Users/Controller/Titles	UM	Operations	User Management	Settings		0	0	1	104	Index	1000	0	0	0
135	200	Team Roles		fas fa-male	/Numbers/Users/Users/Controller/TeamRoles	UM	Operations	User Management	Settings		0	0	1	106	Index	1000	0	0	0
148	200	Missing Translations		fas fa-strikethrough	/Numbers/Internalization/Internalization/Controller/Missing	IN	Operations	System Management	Internalization		0	0	1	141	Index	1000	0	0	0
144	200	Locales		far fa-compass	/Numbers/Internalization/Internalization/Controller/Locales	IN	Operations	System Management	Internalization		0	0	1	137	Index	1000	0	0	0
125	200	User Roles		far fa-user-circle	/Numbers/Users/Users/Controller/Roles	UM	Operations	User Management	Settings		0	0	1	105	Index	1000	0	0	0
147	200	Translations		fas fa-font	/Numbers/Internalization/Internalization/Controller/Translations	IN	Operations	System Management	Internalization		0	0	1	140	Index	1000	0	0	0
126	200	Notification Senders		far fa-envelope	/Numbers/Users/Users/Controller/System/Senders/_Edit	UM	Operations	System Management	Miscellaneous		0	0	1	108	Index	1000	0	0	0
146	200	Groups		far fa-object-group	/Numbers/Internalization/Internalization/Controller/Groups	IN	Operations	System Management	Internalization		0	0	1	139	Index	1000	0	0	0
129	200	Organization Access Report		far fa-building	/Numbers/Users/Users/Controller/Report/Security/OrganizationAccessReport	UM	Operations	User Management	Reports	Security	0	0	1	109	Index	4000	0	0	0
130	200	Resource Setup Report		fas fa-tasks	/Numbers/Users/Users/Controller/Report/Security/ResourceSetupReport	UM	Operations	User Management	Reports	Security	0	0	1	110	Index	4000	0	0	0
131	200	Role Setup Report		far fa-user-circle	/Numbers/Users/Users/Controller/Report/Security/RoleSetupReport	UM	Operations	User Management	Reports	Security	0	0	1	111	Index	4000	0	0	0
145	200	Timezones		far fa-calendar	/Numbers/Internalization/Internalization/Controller/Timezones	IN	Operations	System Management	Internalization		0	0	1	138	Index	1000	0	0	0
132	200	Role Assignment Report		far fa-user-circle	/Numbers/Users/Users/Controller/Report/Security/RoleAssignmentReport	UM	Operations	User Management	Reports	Security	0	0	1	112	Index	4000	0	0	0
133	200	Form Overrides		fas fa-cogs	/Numbers/Users/Users/Controller/Form/Overrides	UM	Operations	System Management	Miscellaneous		0	0	1	107	Index	1000	0	0	0
134	200	Teams		fas fa-sitemap	/Numbers/Users/Users/Controller/Teams	UM	Operations	User Management	Settings		0	0	1	103	Index	1000	0	0	0
21	200	Counselor Registrations		fab fa-delicious	/B4J/Counselors	B4	Operations	Registrations			0	0	1	7	Index	1000	0	0	0
48	200	Countries		far fa-flag	/Numbers/Countries/Countries/Controller/Countries	CM	Operations	System Management	Country Management		0	0	1	42	Index	1000	0	0	0
41	200	Folders		far fa-folder	/Numbers/Tenants/Tenants/Controller/Policy/Folders/_Edit	TM	Operations	System Management	Policy Management		0	0	1	30	index	2000	0	0	0
39	200	Registries		far fa-gem	/Numbers/Tenants/Tenants/Controller/Registries	TM	Operations	System Management	Miscellaneous		0	0	1	29	index	1000	0	0	0
38	200	Assignments		fas fa-assistive-listening-systems	/Numbers/Tenants/Tenants/Controller/Assignments	TM	Operations	System Management	Miscellaneous		0	0	1	28	index	1000	0	0	0
37	200	Reset Feature	T/M Reset Feature	far fa-times-circle	/Numbers/Tenants/Tenants/Controller/Activation/ResetFeature	TM	Operations	System Management	Data Activation		0	0	1	27	index	1000	0	0	0
36	200	Reset Modules	T/M Reset Modules	fas fa-unlink	/Numbers/Tenants/Tenants/Controller/Activation/ResetModule	TM	Operations	System Management	Data Activation		0	0	1	26	index	1000	0	0	0
35	200	General Features	T/M General Features	fas fa-cube	/Numbers/Tenants/Tenants/Controller/Activation/Features	TM	Operations	System Management	Data Activation		0	0	1	25	index	1000	0	0	0
34	200	General Modules	T/M General Modules	fas fa-cubes	/Numbers/Tenants/Tenants/Controller/Activation/Modules	TM	Operations	System Management	Data Activation		0	0	1	24	index	1000	0	0	0
23	200	Session Log		fas fa-sign-in-alt	/Numbers/Backend/Session/Db/Controller/Report/SessionLog	SM	Operations	System Management	Miscellaneous	Reports	0	0	1	22	index	4000	0	0	0
49	200	Postal Codes		far fa-compass	/Numbers/Countries/Countries/Controller/PostalCodes	CM	Operations	System Management	Country Management		0	0	1	43	Index	1000	0	0	0
19	200	Camp Registrations		fas fa-registered	/B4J/Registrations	B4	Operations	Registrations			0	0	1	6	Index	1000	0	0	0
17	200	Periods		far fa-calendar	/B4J/Periods	B4	Operations	Registrations			0	0	1	5	Index	1000	0	0	0
15	200	Contact			/Contact	AN					1	1	0				0	-31600	0
14	200	Counselors			/Counselors	AN					1	1	0				0	-31700	0		b4j_important_menu
13	200	Donors			/Donors	AN					1	1	0				0	-31800	0
11	200	Registration			/Registration	AN					1	1	0				0	-32050	0		b4j_important_menu
10	200	Home			/	AN					1	1	0				0	-32100	0
4	200	Data Classification		fas fa-database	/Numbers/Backend/Db/Common/Controller/Report/DataClassification	SM	Operations	System Management	Miscellaneous	Reports	0	0	1	3	index	4000	0	0	0
80	200	Departments		fas fa-address-book	/Numbers/Users/Organizations/Controller/Departments	ON	Operations	Organization Management	Settings		0	0	1	61	Index	1000	0	0	0
90	200	Item Masters		fas fa-cubes	/Numbers/Users/Organizations/Controller/ItemMasters	ON	Operations	Organization Management	Locations		0	0	1	67	Index	1000	0	0	0
89	200	Locations		fas fa-coffee	/Numbers/Users/Organizations/Controller/Locations	ON	Operations	Organization Management			0	0	1	54	Index	1000	0	0	0
87	200	Markets		fas fa-sticky-note	/Numbers/Users/Organizations/Controller/Markets	ON	Operations	Organization Management	Locations		0	0	1	65	Index	1000	0	0	0
86	200	Districts		far fa-sticky-note	/Numbers/Users/Organizations/Controller/Districts	ON	Operations	Organization Management	Locations		0	0	1	64	Index	1000	0	0	0
85	200	Regions		fas fa-tag	/Numbers/Users/Organizations/Controller/Regions	ON	Operations	Organization Management	Locations		0	0	1	66	Index	1000	0	0	0
84	200	Divisions		fas fa-star-half	/Numbers/Users/Organizations/Controller/Divisions	ON	Operations	Organization Management	Settings		0	0	1	69	Index	1000	0	0	0
83	200	Cost Centers		fas fa-rupee-sign	/Numbers/Users/Organizations/Controller/CostCenters	ON	Operations	Organization Management	Settings		0	0	1	68	Index	1000	0	0	0
82	200	Brands		fas fa-thumbs-up	/Numbers/Users/Organizations/Controller/Brands	ON	Operations	Organization Management	Locations		0	0	1	63	Index	1000	0	0	0
81	200	Trademarks		fas fa-trademark	/Numbers/Users/Organizations/Controller/Trademarks	ON	Operations	Organization Management	Locations		0	0	1	62	Index	1000	0	0	0
91	200	Zones / Slots		fas fa-clone	/Numbers/Users/Organizations/Controller/Location/Zones	ON	Operations	Organization Management	Locations		0	0	1	55	Index	1000	0	0	0
79	200	Strategic Business Units		fas fa-hospital	/Numbers/Users/Organizations/Controller/StrategicBusinessUnits	ON	Operations	Organization Management	Settings		0	0	1	60	Index	1000	0	0	0
78	200	Legal Authorities		far fa-money-bill-alt	/Numbers/Users/Organizations/Controller/LegalAuthorities	ON	Operations	Organization Management	Settings		0	0	1	59	Index	1000	0	0	0
77	200	Jurisdictions		fas fa-flag	/Numbers/Users/Organizations/Controller/Jurisdictions	ON	Operations	Organization Management	Settings		0	0	1	58	Index	1000	0	0	0
76	200	Organization Types		far fa-clone	/Numbers/Users/Organizations/Controller/Organization/Types	ON	Operations	Organization Management	Settings		0	0	1	57	Index	1000	0	0	0
73	200	Organizations		far fa-building	/Numbers/Users/Organizations/Controller/Organizations	ON	Operations	Organization Management			0	0	1	53	Index	1000	0	0	0
52	200	Address Types		fas fa-circle	/Numbers/Countries/Countries/Controller/Address/Types	CM	Operations	System Management	Country Management		0	0	1	46	Index	1000	0	0	0
51	200	Regions		far fa-object-group	/Numbers/Countries/Countries/Controller/Regions	CM	Operations	System Management	Country Management		0	0	1	45	Index	1000	0	0	0
50	200	Provinces		far fa-circle	/Numbers/Countries/Countries/Controller/Provinces	CM	Operations	System Management	Country Management		0	0	1	44	Index	1000	0	0	0

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  a.sm_resource_id AS `id`,  a.sm_resource_type AS `type`,  a.sm_resource_name AS `name`,  a.sm_resource_description AS `description`,  a.sm_resource_icon AS `icon`,  a.sm_resource_menu_url AS `url`,  a.sm_resource_module_code AS `module_code`,  a.sm_resource_group1_name AS `group1`,  a.sm_resource_group2_name AS `group2`,  a.sm_resource_group3_name AS `group3`,  a.sm_resource_group4_name AS `group4`,  a.sm_resource_group5_name AS `group5`,  a.sm_resource_group6_name AS `group6`,  a.sm_resource_group7_name AS `group7`,  a.sm_resource_group8_name AS `group8`,  a.sm_resource_group9_name AS `group9`,  a.sm_resource_acl_public AS `acl_public`,  a.sm_resource_acl_authorized AS `acl_authorized`,  a.sm_resource_acl_permission AS `acl_permission`,  a.sm_resource_menu_acl_resource_id AS `acl_resource_id`,  a.sm_resource_menu_acl_method_code AS `acl_method_code`,  a.sm_resource_menu_acl_action_id AS `acl_action_id`,  a.sm_resource_menu_child_ordered AS `child_ordered`,  a.sm_resource_menu_order AS `order`,  a.sm_resource_menu_separator AS `separator`,  a.sm_resource_menu_name_generator AS `name_generator`,  a.sm_resource_menu_class AS `class` FROM b4j_production.sm_resources AS a WHERE a.sm_resource_type >= 200  AND a.sm_resource_type < 300  AND a.sm_resource_inactive = 0 ORDER BY a.sm_resource_type DESC, [0=>'id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.sm_resources']]...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  a.sm_resource_id AS `id`,  a.sm_resource_type AS `type`,  a.sm_resource_name AS `name`,  a.sm_resource_description AS `description`,  a.sm_resource_icon AS `icon`,  a.sm_resource_menu_url AS `url`,  a.sm_resource_module_code AS `module_code`,  a.sm_resource_group1_name AS `group1`,  a.sm_resource_group2_name AS `group2`,  a.sm_resource_group3_name AS `group3`,  a.sm_resource_group4_name AS `group4`,  a.sm_resource_group5_name AS `group5`,  a.sm_resource_group6_name AS `group6`,  a.sm_resource_group7_name AS `group7`,  a.sm_resource_group8_name AS `group8`,  a.sm_resource_group9_name AS `group9`,  a.sm_resource_acl_public AS `acl_public`,  a.sm_resource_acl_authorized AS `acl_authorized`,  a.sm_resource_acl_permission AS `acl_permission`,  a.sm_resource_menu_acl_resource_id AS `acl_resource_id`,  a.sm_resource_menu_acl_method_code AS `acl_method_code`,  a.sm_resource_menu_acl_action_id AS `acl_action_id`,  a.sm_resource_menu_child_ordered AS `child_ordered`,  a.sm_resource_menu_order AS `order`,  a.sm_resource_menu_separator AS `separator`,  a.sm_resource_menu_name_generator AS `name_generator`,  a.sm_resource_menu_class AS `class` FROM b4j_production.sm_resources AS a WHERE a.sm_resource_type >= 200  AND a.sm_resource_type < 300  AND a.sm_resource_inactive = 0 ORDER BY a.sm_resource_type DESC, [0=>'id']..., ['cache'=>true,'cache_tags'=>[0=>'b4j_production.sm_resources']]...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(276): Numbers\Backend\Db\Common\Query\Builder->query([0=>'id']..., ['cache'=>true,'cache_tags'=>[0=>'b4j_production.sm_resources']]...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Users/Users/DataSource/ACL/Menu/Permissions.php(14): Object\DataSource->get();
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(52): Numbers\Users\Users\DataSource\ACL\Menu\Permissions->get(['skip_acl'=>true]...);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(65): Object\ACL\Resources->get(menu, primary, NULL);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(462): Object\ACL\Resources::getStatic(menu, primary);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html(56): Object\Controller::renderMenu(['class'=>'nav-bg','brand_logo'=>'/assets/img/b4j_logo.png']...);
#9 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/View.php(30): require(/home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html);
#10 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(320): View->__construct((object) Numbers\Frontend\HTML\FontAwesome\Controller\Icons, /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html, html);
#11 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(204): Application::process();
#12 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	a.sm_action_id AS `id`,
	a.sm_action_code AS `code`,
	a.sm_action_name AS `name`,
	a.sm_action_parent_action_id AS `parent_action_id`,
	a.sm_action_inactive AS `inactive`
FROM b4j_production.sm_resource_actions AS a
WHERE a.sm_action_inactive = 0

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

code

short		6
var_string		765
var_string		360
short	1	6
char		4

0.00045108795166016

Cache Tags

b4j_production.sm_resource_actions

id	code	name	parent_action_id
-1	All_Actions	All Actions
1000	List_View	View List
1010	List_Export	Export/Print List	1000
2000	Record_View	View Record
2010	Record_New	New Record	2000
2020	Record_Edit	Edit Record	2000
2030	Record_Inactivate	Inactivate Record	2020
2040	Record_Delete	Delete Record	2020
2050	Record_Post	Post Record	2020
2100	Record_View_Comment	View Comments	2020
2101	Record_Make_Comment	Make a Comment	2100
2110	Record_Audit	View Audit	2020
2120	Record_View_Document	View Documents	2020
2121	Record_Add_Document	Add Documents	2120
2200	Record_View_Workflow	View Workflow	2020
2210	Record_Execute_Workflow	Execute Workflow	2200
2300	Record_View_Service_Script	View Service Script	2020
2310	Record_Execute_Service_Script	Execute Service Script	2300
2400	Record_View_Owners	View Owners	2020
2410	Record_Execute_Owners	Execute Owners	2400
2900	Record_TreeView	Tree View
3000	Import_Records	Import Records
4000	Report_View	View Report

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  a.sm_action_id AS `id`,  a.sm_action_code AS `code`,  a.sm_action_name AS `name`,  a.sm_action_parent_action_id AS `parent_action_id`,  a.sm_action_inactive AS `inactive` FROM b4j_production.sm_resource_actions AS a WHERE a.sm_action_inactive = 0, [0=>'code']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.sm_resource_actions']]...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  a.sm_action_id AS `id`,  a.sm_action_code AS `code`,  a.sm_action_name AS `name`,  a.sm_action_parent_action_id AS `parent_action_id`,  a.sm_action_inactive AS `inactive` FROM b4j_production.sm_resource_actions AS a WHERE a.sm_action_inactive = 0, [0=>'code']..., ['cache'=>true,'cache_tags'=>[0=>'b4j_production.sm_resource_actions']]...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(276): Numbers\Backend\Db\Common\Query\Builder->query([0=>'code']..., ['cache'=>true,'cache_tags'=>[0=>'b4j_production.sm_resource_actions']]...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(52): Object\DataSource->get(['skip_acl'=>true]...);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(65): Object\ACL\Resources->get(actions, primary, NULL);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(337): Object\ACL\Resources::getStatic(actions, primary);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Users/Users/DataSource/ACL/Menu/Permissions.php(25): Object\Controller->canExtended(102, Index, 1000);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(52): Numbers\Users\Users\DataSource\ACL\Menu\Permissions->get(['skip_acl'=>true]...);
#9 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(65): Object\ACL\Resources->get(menu, primary, NULL);
#10 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(462): Object\ACL\Resources::getStatic(menu, primary);
#11 /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html(56): Object\Controller::renderMenu(['class'=>'nav-bg','brand_logo'=>'/assets/img/b4j_logo.png']...);
#12 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/View.php(30): require(/home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html);
#13 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(320): View->__construct((object) Numbers\Frontend\HTML\FontAwesome\Controller\Icons, /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html, html);
#14 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(204): Application::process();
#15 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	a.um_role_id AS `id`,
	a.um_role_code AS `code`,
	a.um_role_type_id AS `type_id`,
	a.um_role_name AS `name`,
	a.um_role_super_admin AS `super_admin`,
	a.um_role_inactive AS `inactive`,
	b.parents,
	c.permissions
FROM b4j_production.um_roles AS a
LEFT JOIN (
	SELECT
		inner_a.um_rolrol_child_role_id,
		GROUP_CONCAT(concat_ws('::', inner_b.um_role_code, inner_a.um_rolrol_inactive) SEPARATOR ';;') AS `parents`
	FROM b4j_production.um_role_children AS inner_a
	INNER JOIN b4j_production.um_roles inner_b ON inner_b.um_role_tenant_id = 2
		AND inner_a.um_rolrol_parent_role_id = inner_b.um_role_id
	WHERE inner_a.um_rolrol_tenant_id = 2
		AND inner_b.um_role_inactive = 0
	GROUP BY inner_a.um_rolrol_child_role_id
) b ON a.um_role_id = b.um_rolrol_child_role_id
LEFT JOIN (
	SELECT
		inner_a.um_rolperm_role_id,
		GROUP_CONCAT(concat_ws('::', inner_a.um_rolperm_resource_id, inner_a.um_rolperm_method_code, inner_a.um_rolperm_action_id, inner_a.um_rolperm_inactive, inner_a.um_rolperm_module_id) SEPARATOR ';;') AS `permissions`
	FROM b4j_production.um_role_permissions AS inner_a
	WHERE inner_a.um_rolperm_tenant_id = 2
	GROUP BY inner_a.um_rolperm_role_id
) c ON a.um_role_id = c.um_rolperm_role_id
WHERE a.um_role_tenant_id = 2
	AND a.um_role_inactive = 0

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

code

long		11
var_string		90
short		6
var_string		360
char		4
char		4
blob	1	9216
blob	1	9216

0.00066900253295898

Cache Tags

b4j_production.um_roles
+numbers_tenant_2
b4j_production.um_role_children
b4j_production.um_role_permissions

id	code	type_id	name	super_admin	permissions
1	SA	20	Super Administrator	1
2	CUSTOMER	20	Customer	0
3	VENDOR	20	Vendor	0
4	B4J	10	B4J	0	5::AllActions::-1::0::8;;6::AllActions::-1::0::8;;7::AllActions::-1::0::8

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  a.um_role_id AS `id`,  a.um_role_code AS `code`,  a.um_role_type_id AS `type_id`,  a.um_role_name AS `name`,  a.um_role_super_admin AS `super_admin`,  a.um_role_inactive AS `inactive`,  b.parents,  c.permissions FROM b4j_production.um_roles AS a LEFT JOIN (  SELECT   inner_a.um_rolrol_child_role_id,   GROUP_CONCAT(concat_ws('::', inner_b.um_role_code, inner_a.um_rolrol_inactive) SEPARATOR ';;') AS `parents`  FROM b4j_production.um_role_children AS inner_a  INNER JOIN b4j_production.um_roles inner_b ON inner_b.um_role_tenant_id = 2   AND inner_a.um_rolrol_parent_role_id = inner_b.um_role_id  WHERE inner_a.um_rolrol_tenant_id = 2   AND inner_b.um_role_inactive = 0  GROUP BY inner_a.um_rolrol_child_role_id ) b ON a.um_role_id = b.um_rolrol_child_role_id LEFT JOIN (  SELECT   inner_a.um_rolperm_role_id,   GROUP_CONCAT(concat_ws('::', inner_a.um_rolperm_resource_id, inner_a.um_rolperm_method_code, inner_a.um_rolperm_action_id, inner_a.um_rolperm_inactive, inner_a.um_rolperm_module_id) SEPARATOR ';;') AS `permissions`  FROM b4j_production.um_role_permissions AS inner_a  WHERE inner_a.um_rolperm_tenant_id = 2  GROUP BY inner_a.um_rolperm_role_id ) c ON a.um_role_id = c.um_rolperm_role_id WHERE a.um_role_tenant_id = 2  AND a.um_role_inactive = 0, [0=>'code']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.um_roles',1=>'+numbers_tenant_2',4=>'b4j_productio...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  a.um_role_id AS `id`,  a.um_role_code AS `code`,  a.um_role_type_id AS `type_id`,  a.um_role_name AS `name`,  a.um_role_super_admin AS `super_admin`,  a.um_role_inactive AS `inactive`,  b.parents,  c.permissions FROM b4j_production.um_roles AS a LEFT JOIN (  SELECT   inner_a.um_rolrol_child_role_id,   GROUP_CONCAT(concat_ws('::', inner_b.um_role_code, inner_a.um_rolrol_inactive) SEPARATOR ';;') AS `parents`  FROM b4j_production.um_role_children AS inner_a  INNER JOIN b4j_production.um_roles inner_b ON inner_b.um_role_tenant_id = 2   AND inner_a.um_rolrol_parent_role_id = inner_b.um_role_id  WHERE inner_a.um_rolrol_tenant_id = 2   AND inner_b.um_role_inactive = 0  GROUP BY inner_a.um_rolrol_child_role_id ) b ON a.um_role_id = b.um_rolrol_child_role_id LEFT JOIN (  SELECT   inner_a.um_rolperm_role_id,   GROUP_CONCAT(concat_ws('::', inner_a.um_rolperm_resource_id, inner_a.um_rolperm_method_code, inner_a.um_rolperm_action_id, inner_a.um_rolperm_inactive, inner_a.um_rolperm_module_id) SEPARATOR ';;') AS `permissions`  FROM b4j_production.um_role_permissions AS inner_a  WHERE inner_a.um_rolperm_tenant_id = 2  GROUP BY inner_a.um_rolperm_role_id ) c ON a.um_role_id = c.um_rolperm_role_id WHERE a.um_role_tenant_id = 2  AND a.um_role_inactive = 0, [0=>'code']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.um_roles',1=>'+numbers_tenant_2',4=>'b4j_productio...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(276): Numbers\Backend\Db\Common\Query\Builder->query([0=>'code']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.um_roles',1=>'+numbers_tenant_2',4=>'b4j_productio...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(52): Object\DataSource->get(['skip_acl'=>true]...);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(65): Object\ACL\Resources->get(roles, primary, NULL);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(392): Object\ACL\Resources::getStatic(roles, primary);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(374): Object\Controller->processRole(SYSTEM_ANONYMOUS, 102, Index, 1000, NULL);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Users/Users/DataSource/ACL/Menu/Permissions.php(25): Object\Controller->canExtended(102, Index, 1000);
#9 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(52): Numbers\Users\Users\DataSource\ACL\Menu\Permissions->get(['skip_acl'=>true]...);
#10 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/ACL/Resources.php(65): Object\ACL\Resources->get(menu, primary, NULL);
#11 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(462): Object\ACL\Resources::getStatic(menu, primary);
#12 /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html(56): Object\Controller::renderMenu(['class'=>'nav-bg','brand_logo'=>'/assets/img/b4j_logo.png']...);
#13 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/View.php(30): require(/home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html);
#14 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(320): View->__construct((object) Numbers\Frontend\HTML\FontAwesome\Controller\Icons, /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html, html);
#15 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(204): Application::process();
#16 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Sql

SELECT
	a.in_translation_id AS `id`,
	a.in_translation_i18n_id AS `i18n_id`,
	a.in_translation_from_text AS `from_text`,
	a.in_translation_to_text AS `to_text`
FROM b4j_production.in_translations AS a
WHERE a.in_translation_tenant_id = 2
	AND a.in_translation_inactive = 0
	AND a.in_translation_from_language_code = 'sm0'
	AND a.in_translation_to_language_code = 'eng'
	AND NOT  EXISTS (SELECT
			1
		FROM b4j_production.in_translation_organizations AS inner_a
		WHERE inner_a.in_translorg_tenant_id = 2
			AND inner_a.in_translorg_translation_id = a.in_translation_id)

Error

Errno

Num Rows

Affected Rows

Key

Structure

Cache

Time

longlong		20
long	1	11
var_string		7500
var_string		7500

0.00043106079101562

Cache Tags

b4j_production.in_translations
+numbers_tenant_2
b4j_production.in_translation_organizations

#1 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Db.php(125): Numbers\Backend\Db\MySQLi\Base->query(SELECT  a.in_translation_id AS `id`,  a.in_translation_i18n_id AS `i18n_id`,  a.in_translation_from_text AS `from_text`,  a.in_translation_to_text AS `to_text` FROM b4j_production.in_translations AS a WHERE a.in_translation_tenant_id = 2  AND a.in_translation_inactive = 0  AND a.in_translation_from_language_code = 'sm0'  AND a.in_translation_to_language_code = 'eng'  AND NOT  EXISTS (SELECT    1   FROM b4j_production.in_translation_organizations AS inner_a   WHERE inner_a.in_translorg_tenant_id = 2    AND inner_a.in_translorg_translation_id = a.in_translation_id), [0=>'id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.in_translations',1=>'+numbers_tenant_2',4=>'b4j_pr...);
#2 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Backend/Db/Common/Query/Builder.php(713): Db->query(SELECT  a.in_translation_id AS `id`,  a.in_translation_i18n_id AS `i18n_id`,  a.in_translation_from_text AS `from_text`,  a.in_translation_to_text AS `to_text` FROM b4j_production.in_translations AS a WHERE a.in_translation_tenant_id = 2  AND a.in_translation_inactive = 0  AND a.in_translation_from_language_code = 'sm0'  AND a.in_translation_to_language_code = 'eng'  AND NOT  EXISTS (SELECT    1   FROM b4j_production.in_translation_organizations AS inner_a   WHERE inner_a.in_translorg_tenant_id = 2    AND inner_a.in_translorg_translation_id = a.in_translation_id), [0=>'id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.in_translations',1=>'+numbers_tenant_2',4=>'b4j_pr...);
#3 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/DataSource.php(276): Numbers\Backend\Db\Common\Query\Builder->query([0=>'id']..., ['cache'=>false,'cache_tags'=>[0=>'b4j_production.in_translations',1=>'+numbers_tenant_2',4=>'b4j_pr...);
#4 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Internalization/Internalization/Base.php(134): Object\DataSource->get([]...);
#5 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Internalization/Internalization/Base.php(67): Numbers\Internalization\Internalization\Base->loadTranslations(sm0, eng, 0, 0);
#6 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/I18n.php(91): Numbers\Internalization\Internalization\Base->get(NULL, Home, []...);
#7 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/I18n.php(75): I18n::getOne(NULL, Home, []...);
#8 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Functions.php(905): I18n::get(NULL, Home, []...);
#9 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Frontend/HTML/Renderers/Bootstrap/Base.php(419): i18n(NULL, Home);
#10 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Factory.php(71): Numbers\Frontend\HTML\Renderers\Bootstrap\Base::menu(['brand_name'=>'B4J','brand_logo'=>'/assets/img/b4j_logo.png','brand_url'=>'/Numbers/Users/Users/Con...);
#11 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/HTML.php(441): Factory::delegate(flag.numbers.framework.html, menu, [0=>['brand_name'=>'B4J','brand_logo'=>'/assets/img/b4j_logo.png','brand_url'=>'/Numbers/Users/Users...);
#12 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Object/Controller.php(476): HTML::menu(['brand_name'=>'B4J','brand_logo'=>'/assets/img/b4j_logo.png','brand_url'=>'/Numbers/Users/Users/Con...);
#13 /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html(56): Object\Controller::renderMenu(['class'=>'nav-bg','brand_logo'=>'/assets/img/b4j_logo.png']...);
#14 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/View.php(30): require(/home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html);
#15 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(320): View->__construct((object) Numbers\Frontend\HTML\FontAwesome\Controller\Icons, /home/domains/ca.b4j.new/deployments/build.1792016661.289/application/Layout/reveal.html, html);
#16 /home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework/Application.php(204): Application::process();
#17 /home/domains/ca.b4j.new/deployments/build.1792016661.289/public_html/index.php(12): Application::run();

Cache (0)

Type	Link	Cache #	Has Data

Dump (0)

Name	Dump

Input (1)

Input
Array ( )

Session (1)

Session
Array ( [numbers] => Array ( [flag_generated_by_system] => 1 [ip] => Array ( [ip] => 216.73.216.180 ) [user] => Array ( [roles] => Array ( [0] => SYSTEM_ANONYMOUS ) ) ) )

Loaded Classes (45)

Class Name

File

Media

Object\Magic\Variables

Object/Magic/Variables.php

Object\Data

Object/Data.php

Object\Table\Options

Object/Table/Options.php

Object\Override\Data

Object/Override/Data.php

Object\Data\Common

Object/Data/Common.php

Object\Data\Domains

Object/Data/Domains.php

Object\Data\Types

Object/Data/Types.php

Request

Request.php

Debug

Debug.php

Bootstrap

Bootstrap.php

Object\Error\Base

Object/Error/Base.php

Format

Format.php

I18n

I18n.php

Crypt

Crypt.php

Factory

Factory.php

Layout

Layout.php

View

View.php

Overrides\Factory

Overrides/Factory.php

Object\Structure\Base

Object/Structure/Base.php

Object\Validator\Domain\Part

Object/Validator/Domain/Part.php

Object\Validator\Base

Object/Validator/Base.php

Db.php

Cache

Cache.php

Session

Session.php

Object\Table

Object/Table.php

Object\Table\Trait2

Object/Table/Trait2.php

Tenant

Tenant.php

Object\ACL\Resources

Object/ACL/Resources.php

Object\Override\Blank

Object/Override/Blank.php

Object\Table\Widgets

Object/Table/Widgets.php

Object\Query\Builder

Object/Query/Builder.php

Object\ACL\Registered

Object/ACL/Registered.php

Object\Miscellaneous\IP

Object/Miscellaneous/IP.php

User

User.php

Object\DataSource

Object/DataSource.php

Object\Controller\Front

Object/Controller/Front.php

Object\Controller

Object/Controller.php

Object\Controller\Model\UsageCodes

Object/Controller/Model/UsageCodes.php

Helper\Dispatch

Helper/Dispatch.php

Helper\Ob

Helper/Ob.php

Can

Can.php

HTML

HTML.php

Object\Table\Columns

Object/Table/Columns.php

Library

Library.php

Object\Form\Workflow\Base

Object/Form/Workflow/Base.php

Application (15)

PHPInfo

PHP Version 7.4.33

System	Linux ubuntu-tor-1 5.15.0-86-generic #96-Ubuntu SMP Wed Sep 20 08:23:49 UTC 2023 x86_64
Build Date	Sep 2 2023 08:03:46
Server API	Apache 2.0 Handler
Virtual Directory Support	disabled
Configuration File (php.ini) Path	/etc/php/7.4/apache2
Loaded Configuration File	/etc/php/7.4/apache2/php.ini
Scan this dir for additional .ini files	/etc/php/7.4/apache2/conf.d
Additional .ini files parsed	/etc/php/7.4/apache2/conf.d/10-mysqlnd.ini, /etc/php/7.4/apache2/conf.d/10-opcache.ini, /etc/php/7.4/apache2/conf.d/10-pdo.ini, /etc/php/7.4/apache2/conf.d/20-bcmath.ini, /etc/php/7.4/apache2/conf.d/20-calendar.ini, /etc/php/7.4/apache2/conf.d/20-ctype.ini, /etc/php/7.4/apache2/conf.d/20-exif.ini, /etc/php/7.4/apache2/conf.d/20-ffi.ini, /etc/php/7.4/apache2/conf.d/20-fileinfo.ini, /etc/php/7.4/apache2/conf.d/20-ftp.ini, /etc/php/7.4/apache2/conf.d/20-gd.ini, /etc/php/7.4/apache2/conf.d/20-gettext.ini, /etc/php/7.4/apache2/conf.d/20-iconv.ini, /etc/php/7.4/apache2/conf.d/20-json.ini, /etc/php/7.4/apache2/conf.d/20-mbstring.ini, /etc/php/7.4/apache2/conf.d/20-mysqli.ini, /etc/php/7.4/apache2/conf.d/20-pdo_mysql.ini, /etc/php/7.4/apache2/conf.d/20-phar.ini, /etc/php/7.4/apache2/conf.d/20-posix.ini, /etc/php/7.4/apache2/conf.d/20-readline.ini, /etc/php/7.4/apache2/conf.d/20-shmop.ini, /etc/php/7.4/apache2/conf.d/20-sockets.ini, /etc/php/7.4/apache2/conf.d/20-sysvmsg.ini, /etc/php/7.4/apache2/conf.d/20-sysvsem.ini, /etc/php/7.4/apache2/conf.d/20-sysvshm.ini, /etc/php/7.4/apache2/conf.d/20-tokenizer.ini
PHP API	20190902
PHP Extension	20190902
Zend Extension	320190902
Zend Extension Build	API320190902,NTS
PHP Extension Build	API20190902,NTS
Debug Build	no
Thread Safety	disabled
Zend Signal Handling	enabled
Zend Memory Manager	enabled
Zend Multibyte Support	provided by mbstring
IPv6 Support	enabled
DTrace Support	available, disabled
Registered PHP Streams	https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar
Registered Stream Socket Transports	tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
Registered Stream Filters	zlib., string.rot13, string.toupper, string.tolower, string.strip_tags, convert., consumed, dechunk, convert.iconv.*

This program makes use of the Zend Scripting Language Engine:
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.33, Copyright (c), by Zend Technologies

Configuration

apache2handler

Apache Version	Apache/2.4.52 (Ubuntu)
Apache API Version	20120211
Server Administrator	webmaster@localhost
Hostname:Port	b4j.ca:0
User/Group	www-data(33)/33
Max Requests	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts	Connection: 300 - Keep-Alive: 5
Virtual Server	Yes
Server Root	/etc/apache2
Loaded Modules	core mod_so mod_watchdog http_core mod_log_config mod_logio mod_version mod_unixd mod_access_compat mod_alias mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_host mod_authz_user mod_autoindex mod_deflate mod_dir mod_env mod_filter mod_mime prefork mod_negotiation mod_php7 mod_reqtimeout mod_rewrite mod_setenvif mod_socache_shmcb mod_ssl mod_status

Directive	Local Value	Master Value
engine	1	1
last_modified	0	0
xbithack	0	0

Apache Environment

Variable	Value
REDIRECT_HTTPS	on
REDIRECT_SSL_TLS_SNI	www.b4j.ca
REDIRECT_STATUS	200
HTTPS	on
SSL_TLS_SNI	www.b4j.ca
HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_HOST	www.b4j.ca
PATH	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
SERVER_SIGNATURE	<address>Apache/2.4.52 (Ubuntu) Server at www.b4j.ca Port 443</address>
SERVER_SOFTWARE	Apache/2.4.52 (Ubuntu)
SERVER_NAME	www.b4j.ca
SERVER_ADDR	143.110.213.75
SERVER_PORT	443
REMOTE_ADDR	216.73.216.180
DOCUMENT_ROOT	/home/domains/ca.b4j.new/deployed/public_html
REQUEST_SCHEME	https
CONTEXT_PREFIX	no value
CONTEXT_DOCUMENT_ROOT	/home/domains/ca.b4j.new/deployed/public_html
SERVER_ADMIN	webmaster@localhost
SCRIPT_FILENAME	/home/domains/ca.b4j.new/deployed/public_html/index.php
REMOTE_PORT	35027
REDIRECT_URL	/Numbers/Frontend/HTML/FontAwesome/Controller/Icons
GATEWAY_INTERFACE	CGI/1.1
SERVER_PROTOCOL	HTTP/1.1
REQUEST_METHOD	GET
QUERY_STRING	no value
REQUEST_URI	/Numbers/Frontend/HTML/FontAwesome/Controller/Icons
SCRIPT_NAME	/index.php

HTTP Headers Information

HTTP Request Headers
HTTP Request	GET /Numbers/Frontend/HTML/FontAwesome/Controller/Icons HTTP/1.1
accept	/
user-agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept-encoding	gzip, br, zstd, deflate
host	www.b4j.ca
HTTP Response Headers
Set-Cookie	PHPSESSID=8d3ojega7mhuevvsla9vae0qp6; path=/
Expires	Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control	no-cache
Pragma	no-cache
Set-Cookie	PHPSESSID=bq8hvb9oblljrmo0vqi5ihi88q; path=/

bcmath

BCMath support

enabled

Directive	Local Value	Master Value
bcmath.scale	0	0

calendar

Calendar support

enabled

Core

PHP Version

7.4.33

Directive	Local Value	Master Value
allow_url_fopen	On	On
allow_url_include	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
auto_append_file	no value	no value
auto_globals_jit	On	On
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	UTF-8	UTF-8
default_mimetype	text/html	text/html
disable_classes	no value	no value
disable_functions	pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,	pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
display_errors	Off	Off
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	Off	Off
enable_post_data_reading	On	On
error_append_string	no value	no value
error_log	no value	no value
error_prepend_string	no value	no value
error_reporting	24565	22527
expose_php	Off	Off
extension_dir	/usr/lib/php/20190902	/usr/lib/php/20190902
file_uploads	On	On
hard_timeout	2	2
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	/home/domains/ca.b4j.new/deployments/build.1792016661.289/application:/home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor/Numbers/Framework:/home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/private:/home/domains/ca.b4j.new/deployments/build.1792016661.289/libraries/vendor	.:/usr/share/php
input_encoding	no value	no value
internal_encoding	no value	no value
log_errors	On	On
log_errors_max_len	1024	1024
mail.add_x_header	Off	Off
mail.force_extra_parameters	no value	no value
mail.log	no value	no value
max_execution_time	30	30
max_file_uploads	20	20
max_input_nesting_level	64	64
max_input_time	60	60
max_input_vars	1000	1000
max_multipart_body_parts	-1	-1
memory_limit	1024M	128M
open_basedir	no value	no value
output_buffering	4096	4096
output_encoding	no value	no value
output_handler	no value	no value
post_max_size	64M	8M
precision	14	14
realpath_cache_size	4096K	4096K
realpath_cache_ttl	120	120
register_argc_argv	Off	Off
report_memleaks	On	On
report_zend_debug	On	On
request_order	GP	GP
sendmail_from	no value	no value
sendmail_path	/usr/sbin/sendmail -t -i	/usr/sbin/sendmail -t -i
serialize_precision	-1	-1
short_open_tag	Off	Off
SMTP	localhost	localhost
smtp_port	25	25
sys_temp_dir	no value	no value
syslog.facility	LOG_USER	LOG_USER
syslog.filter	no-ctrl	no-ctrl
syslog.ident	php	php
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	64M	2M
upload_tmp_dir	no value	no value
user_dir	no value	no value
user_ini.cache_ttl	300	300
user_ini.filename	.user.ini	.user.ini
variables_order	GPCS	GPCS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
zend.assertions	-1	-1
zend.detect_unicode	On	On
zend.enable_gc	On	On
zend.exception_ignore_args	On	On
zend.multibyte	Off	Off
zend.script_encoding	no value	no value
zend.signal_check	Off	Off

ctype

ctype functions

enabled

date

date/time support	enabled
timelib version	2018.04
"Olson" Timezone Database Version	0.system
Timezone Database	internal
Default timezone	America/Toronto

Directive	Local Value	Master Value
date.default_latitude	31.7667	31.7667
date.default_longitude	35.2333	35.2333
date.sunrise_zenith	90.583333	90.583333
date.sunset_zenith	90.583333	90.583333
date.timezone	America/Toronto	no value

exif

EXIF Support	enabled
Supported EXIF Version	0220
Supported filetypes	JPEG, TIFF
Multibyte decoding support using mbstring	enabled
Extended EXIF tag formats	Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson

Directive	Local Value	Master Value
exif.decode_jis_intel	JIS	JIS
exif.decode_jis_motorola	JIS	JIS
exif.decode_unicode_intel	UCS-2LE	UCS-2LE
exif.decode_unicode_motorola	UCS-2BE	UCS-2BE
exif.encode_jis	no value	no value
exif.encode_unicode	ISO-8859-15	ISO-8859-15

FFI

FFI support	enabled

Directive	Local Value	Master Value
ffi.enable	preload	preload
ffi.preload	no value	no value

fileinfo

fileinfo support	enabled
libmagic	537

filter

Input Validation and Filtering

enabled

Directive	Local Value	Master Value
filter.default	unsafe_raw	unsafe_raw
filter.default_flags	no value	no value

ftp

FTP support	enabled
FTPS support	enabled

gd

GD Support	enabled
GD headers Version	2.3.3
GD library Version	2.3.3
FreeType Support	enabled
FreeType Linkage	with freetype
GIF Read Support	enabled
GIF Create Support	enabled
JPEG Support	enabled
PNG Support	enabled
WBMP Support	enabled
XPM Support	enabled
XBM Support	enabled
WebP Support	enabled
BMP Support	enabled
TGA Read Support	enabled

Directive	Local Value	Master Value
gd.jpeg_ignore_warning	1	1

gettext

GetText Support

enabled

hash

hash support

enabled

Hashing Engines

md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b crc32c fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

MHASH support	Enabled
MHASH API Version	Emulated Support

iconv

iconv support	enabled
iconv implementation	glibc
iconv library version	2.35

Directive	Local Value	Master Value
iconv.input_encoding	no value	no value
iconv.internal_encoding	no value	no value
iconv.output_encoding	no value	no value

json

json support

enabled

libxml

libXML support	active
libXML Compiled Version	2.9.14
libXML Loaded Version	20914
libXML streams	enabled

mbstring

Multibyte Support	enabled
Multibyte string engine	libmbfl
HTTP input encoding translation	disabled
libmbfl version	1.3.2

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Multibyte (japanese) regex support	enabled
Multibyte regex (oniguruma) version	6.9.7

Directive	Local Value	Master Value
mbstring.detect_order	no value	no value
mbstring.encoding_translation	Off	Off
mbstring.func_overload	0	0
mbstring.http_input	no value	no value
mbstring.http_output	no value	no value
mbstring.http_output_conv_mimetypes	^(text/\|application/xhtml\+xml)	^(text/\|application/xhtml\+xml)
mbstring.internal_encoding	no value	no value
mbstring.language	neutral	neutral
mbstring.regex_retry_limit	1000000	1000000
mbstring.regex_stack_limit	100000	100000
mbstring.strict_detection	Off	Off
mbstring.substitute_character	no value	no value

mysqli

MysqlI Support	enabled
Client API library version	mysqlnd 7.4.33
Active Persistent Links	0
Inactive Persistent Links	0
Active Links	1

Directive	Local Value	Master Value
mysqli.allow_local_infile	Off	Off
mysqli.allow_persistent	On	On
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	no value	no value
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.max_persistent	Unlimited	Unlimited
mysqli.reconnect	Off	Off
mysqli.rollback_on_cached_plink	Off	Off

mysqlnd

mysqlnd	enabled
Version	mysqlnd 7.4.33
Compression	supported
core SSL	supported
extended SSL	supported
Command buffer size	4096
Read buffer size	32768
Read timeout	86400
Collecting statistics	Yes
Collecting memory statistics	No
Tracing	n/a
Loaded plugins	mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions	mysqli,pdo_mysql

openssl

OpenSSL support	enabled
OpenSSL Library Version	OpenSSL 3.0.2 15 Mar 2022
OpenSSL Header Version	OpenSSL 3.0.2 15 Mar 2022
Openssl default config	/usr/lib/ssl/openssl.cnf

Directive	Local Value	Master Value
openssl.cafile	no value	no value
openssl.capath	no value	no value

pcre

PCRE (Perl Compatible Regular Expressions) Support	enabled
PCRE Library Version	10.40 2022-04-14
PCRE Unicode Version	14.0.0
PCRE JIT Support	enabled
PCRE JIT Target	x86 64bit (little endian + unaligned)

Directive	Local Value	Master Value
pcre.backtrack_limit	1000000	1000000
pcre.jit	1	1
pcre.recursion_limit	100000	100000

PDO

PDO support	enabled
PDO drivers	mysql

pdo_mysql

PDO Driver for MySQL	enabled
Client API version	mysqlnd 7.4.33

Directive	Local Value	Master Value
pdo_mysql.default_socket	/var/run/mysqld/mysqld.sock	/var/run/mysqld/mysqld.sock

Phar

Phar: PHP Archive support	enabled
Phar API version	1.1.1
Phar-based phar archives	enabled
Tar-based phar archives	enabled
ZIP-based phar archives	enabled
gzip compression	enabled
bzip2 compression	disabled (install ext/bz2)
Native OpenSSL support	enabled

Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.

Directive	Local Value	Master Value
phar.cache_list	no value	no value
phar.readonly	On	On
phar.require_hash	On	On

posix

POSIX support

enabled

readline

Readline Support	enabled
Readline library	EditLine wrapper

Directive	Local Value	Master Value
cli.pager	no value	no value
cli.prompt	\b \>	\b \>

Reflection

enabled

session

Session Support	enabled
Registered save handlers	files user
Registered serializer handlers	php_serialize php php_binary

Directive	Local Value	Master Value
session.auto_start	Off	Off
session.cache_expire	180	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_httponly	no value	no value
session.cookie_lifetime	0	0
session.cookie_path	/	/
session.cookie_samesite	no value	no value
session.cookie_secure	0	0
session.gc_divisor	100	1000
session.gc_maxlifetime	7200	1440
session.gc_probability	1	0
session.lazy_write	On	On
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	user	files
session.save_path	/var/lib/php/sessions	/var/lib/php/sessions
session.serialize_handler	php	php
session.sid_bits_per_character	5	5
session.sid_length	26	26
session.upload_progress.cleanup	On	On
session.upload_progress.enabled	On	On
session.upload_progress.freq	1%	1%
session.upload_progress.min_freq	1	1
session.upload_progress.name	PHP_SESSION_UPLOAD_PROGRESS	PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix	upload_progress_	upload_progress_
session.use_cookies	1	1
session.use_only_cookies	off	1
session.use_strict_mode	0	0
session.use_trans_sid	0	0

shmop

shmop support

enabled

sockets

Sockets Support

enabled

sodium

sodium support	enabled
libsodium headers version	1.0.18
libsodium library version	1.0.18

SPL

SPL support

enabled

Interfaces

OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject

Classes

AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

standard

Dynamic Library Support	enabled
Path to sendmail	/usr/sbin/sendmail -t -i

Directive	Local Value	Master Value
assert.active	1	1
assert.bail	0	0
assert.callback	no value	no value
assert.exception	0	0
assert.quiet_eval	0	0
assert.warning	1	1
auto_detect_line_endings	0	0
default_socket_timeout	60	60
from	no value	no value
session.trans_sid_hosts	no value	no value
session.trans_sid_tags	a=href,area=href,frame=src,form=	a=href,area=href,frame=src,form=
unserialize_max_depth	4096	4096
url_rewriter.hosts	no value	no value
url_rewriter.tags	form=	form=
user_agent	no value	no value

sysvmsg

sysvmsg support

enabled

sysvsem

sysvsem support

enabled

sysvshm

sysvshm support

enabled

tokenizer

Tokenizer Support

enabled

Zend OPcache

Opcode Caching	Up and Running
Optimization	Enabled
SHM Cache	Enabled
File Cache	Disabled
Startup	OK
Shared memory model	mmap
Cache hits	29885508
Cache misses	196
Used memory	12938240
Free memory	121279488
Wasted memory	0
Interned Strings Used memory	781000
Interned Strings Free memory	5510008
Cached scripts	195
Cached keys	379
Max keys	16229
OOM restarts	0
Hash keys restarts	0
Manual restarts	0

Directive	Local Value	Master Value
opcache.blacklist_filename	no value	no value
opcache.consistency_checks	0	0
opcache.dups_fix	Off	Off
opcache.enable	On	On
opcache.enable_cli	Off	Off
opcache.enable_file_override	Off	Off
opcache.error_log	no value	no value
opcache.file_cache	no value	no value
opcache.file_cache_consistency_checks	On	On
opcache.file_cache_only	Off	Off
opcache.file_update_protection	2	2
opcache.force_restart_timeout	180	180
opcache.huge_code_pages	Off	Off
opcache.interned_strings_buffer	8	8
opcache.lockfile_path	/tmp	/tmp
opcache.log_verbosity_level	1	1
opcache.max_accelerated_files	10000	10000
opcache.max_file_size	0	0
opcache.max_wasted_percentage	5	5
opcache.memory_consumption	128	128
opcache.opt_debug_level	0	0
opcache.optimization_level	0x7FFEBFFF	0x7FFEBFFF
opcache.preferred_memory_model	no value	no value
opcache.preload	no value	no value
opcache.preload_user	no value	no value
opcache.protect_memory	Off	Off
opcache.restrict_api	no value	no value
opcache.revalidate_freq	2	2
opcache.revalidate_path	Off	Off
opcache.save_comments	On	On
opcache.use_cwd	On	On
opcache.validate_permission	Off	Off
opcache.validate_root	Off	Off
opcache.validate_timestamps	On	On

zlib

ZLib Support	enabled
Stream Wrapper	compress.zlib://
Stream Filter	zlib.inflate, zlib.deflate
Compiled Version	1.2.11
Linked Version	1.2.11

Directive	Local Value	Master Value
zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value

Additional Modules

Module Name

Environment

Variable	Value
APACHE_RUN_DIR	/var/run/apache2
SYSTEMD_EXEC_PID	841777
APACHE_PID_FILE	/var/run/apache2/apache2.pid
JOURNAL_STREAM	8:343741801
PATH	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
INVOCATION_ID	d7604413ffcf4228ba236474e1145c8e
APACHE_LOCK_DIR	/var/lock/apache2
LANG	C
APACHE_RUN_USER	www-data
APACHE_RUN_GROUP	www-data
APACHE_LOG_DIR	/var/log/apache2
PWD	/

PHP Variables

Variable	Value
$_SERVER['REDIRECT_HTTPS']	on
$_SERVER['REDIRECT_SSL_TLS_SNI']	www.b4j.ca
$_SERVER['REDIRECT_STATUS']	200
$_SERVER['HTTPS']	on
$_SERVER['SSL_TLS_SNI']	www.b4j.ca
$_SERVER['HTTP_ACCEPT']	/
$_SERVER['HTTP_USER_AGENT']	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
$_SERVER['HTTP_ACCEPT_ENCODING']	gzip, br, zstd, deflate
$_SERVER['HTTP_HOST']	www.b4j.ca
$_SERVER['PATH']	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
$_SERVER['SERVER_SIGNATURE']	<address>Apache/2.4.52 (Ubuntu) Server at www.b4j.ca Port 443</address>
$_SERVER['SERVER_SOFTWARE']	Apache/2.4.52 (Ubuntu)
$_SERVER['SERVER_NAME']	www.b4j.ca
$_SERVER['SERVER_ADDR']	143.110.213.75
$_SERVER['SERVER_PORT']	443
$_SERVER['REMOTE_ADDR']	216.73.216.180
$_SERVER['DOCUMENT_ROOT']	/home/domains/ca.b4j.new/deployed/public_html
$_SERVER['REQUEST_SCHEME']	https
$_SERVER['CONTEXT_PREFIX']	no value
$_SERVER['CONTEXT_DOCUMENT_ROOT']	/home/domains/ca.b4j.new/deployed/public_html
$_SERVER['SERVER_ADMIN']	webmaster@localhost
$_SERVER['SCRIPT_FILENAME']	/home/domains/ca.b4j.new/deployed/public_html/index.php
$_SERVER['REMOTE_PORT']	35027
$_SERVER['REDIRECT_URL']	/Numbers/Frontend/HTML/FontAwesome/Controller/Icons
$_SERVER['GATEWAY_INTERFACE']	CGI/1.1
$_SERVER['SERVER_PROTOCOL']	HTTP/1.1
$_SERVER['REQUEST_METHOD']	GET
$_SERVER['QUERY_STRING']	no value
$_SERVER['REQUEST_URI']	/Numbers/Frontend/HTML/FontAwesome/Controller/Icons
$_SERVER['SCRIPT_NAME']	/index.php
$_SERVER['PHP_SELF']	/index.php
$_SERVER['REQUEST_TIME_FLOAT']	1792105916.3455
$_SERVER['REQUEST_TIME']	1792105916

PHP Credits

PHP Group
Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski

Language Design & Concept
Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger

PHP Authors
Contribution	Authors
Zend Scripting Language Engine	Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov
Extension Module API	Andi Gutmans, Zeev Suraski, Andrei Zmievski
UNIX Build and Modularization	Stig Bakken, Sascha Schumann, Jani Taskinen, Peter Kokot
Windows Support	Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski, Kalle Sommer Nielsen
Server API (SAPI) Abstraction Layer	Andi Gutmans, Shane Caraveo, Zeev Suraski
Streams Abstraction Layer	Wez Furlong, Sara Golemon
PHP Data Objects Layer	Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
Output Handler	Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner
Consistent 64 bit support	Anthony Ferrara, Anatol Belski

SAPI Modules
Contribution	Authors
Apache 2.0 Handler	Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code)
CGI / FastCGI	Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov
CLI	Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui
Embed	Edin Kadribasic
FastCGI Process Manager	Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet
litespeed	George Wang
phpdbg	Felipe Pena, Joe Watkins, Bob Weinand

Module Authors
Module	Authors
BC Math	Andi Gutmans
Bzip2	Sterling Hughes
Calendar	Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong
COM and .Net	Wez Furlong
ctype	Hartmut Holzgraefe
cURL	Sterling Hughes
Date/Time Support	Derick Rethans
DB-LIB (MS SQL, Sybase)	Wez Furlong, Frank M. Kromann, Adam Baratz
DBA	Sascha Schumann, Marcus Boerger
DOM	Christian Stocker, Rob Richards, Marcus Boerger
enchant	Pierre-Alain Joye, Ilia Alshanetsky
EXIF	Rasmus Lerdorf, Marcus Boerger
FFI	Dmitry Stogov
fileinfo	Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans, Anatol Belski
Firebird driver for PDO	Ard Biesheuvel
FTP	Stefan Esser, Andrew Skalski
GD imaging	Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger
GetText	Alex Plotnick
GNU GMP support	Stanislav Malyshev
Iconv	Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi
IMAP	Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky
Input Filter	Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky
Internationalization	Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar
JSON	Jakub Zelenka, Omar Kilani, Scott MacVicar
LDAP	Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas
LIBXML	Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo
Multibyte String Functions	Tsukada Takuya, Rui Hirokawa
MySQL driver for PDO	George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter
MySQLi	Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel
MySQLnd	Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter
OCI8	Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation
ODBC driver for PDO	Wez Furlong
ODBC	Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky
Opcache	Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Dmitry Stogov, Xinchen Hui
OpenSSL	Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar
Oracle (OCI) driver for PDO	Wez Furlong
pcntl	Jason Greene, Arnaud Le Blanc
Perl Compatible Regexps	Andrei Zmievski
PHP Archive	Gregory Beaver, Marcus Boerger
PHP Data Objects	Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
PHP hash	Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar
Posix	Kristian Koehntopp
PostgreSQL driver for PDO	Edin Kadribasic, Ilia Alshanetsky
PostgreSQL	Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne
Pspell	Vlad Krupin
Readline	Thies C. Arntzen
Reflection	Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter
Sessions	Sascha Schumann, Andrei Zmievski
Shared Memory Operations	Slava Poliakov, Ilia Alshanetsky
SimpleXML	Sterling Hughes, Marcus Boerger, Rob Richards
SNMP	Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin
SOAP	Brad Lafountain, Shane Caraveo, Dmitry Stogov
Sockets	Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene
Sodium	Frank Denis
SPL	Marcus Boerger, Etienne Kneuss
SQLite 3.x driver for PDO	Wez Furlong
SQLite3	Scott MacVicar, Ilia Alshanetsky, Brad Dewar
System V Message based IPC	Wez Furlong
System V Semaphores	Tom May
System V Shared Memory	Christian Cartus
tidy	John Coggeshall, Ilia Alshanetsky
tokenizer	Andrei Zmievski, Johannes Schlueter
XML	Stig Bakken, Thies C. Arntzen, Sterling Hughes
XMLReader	Rob Richards
xmlrpc	Dan Libby
XMLWriter	Rob Richards, Pierre-Alain Joye
XSL	Christian Stocker, Rob Richards
Zip	Pierre-Alain Joye, Remi Collet
Zlib	Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner

PHP Documentation
Authors	Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Philip Olson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey
Editor	Peter Cowburn
User Note Maintainers	Daniel P. Brown, Thiago Henrique Pojda
Other Contributors	Previously active authors, editors and other contributors are listed in the manual.

PHP Quality Assurance Team
Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs

Websites and Infrastructure team
PHP Websites Team	Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison
Event Maintainers	Damien Seguy, Daniel P. Brown
Network Infrastructure	Daniel P. Brown
Windows Infrastructure	Alex Schoenmaker

Debian Packaging
DEB.SURY.ORG, an Ondřej Surý project

PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.

Acls (0)

[Acls]

Array
(
)