An error has occured in script "/var/www/vhosts/catalystmortgagetraining.com/mtc/modules/resources/state_server.php" on line 1 :
mysqli::query(): (22003/1690): BIGINT UNSIGNED value is out of range in '`catalyst_content`.`n`.`mlo_num` - `catalyst_content`.`n2`.`mlo_num`'
Array
(
[0] => Array
(
[function] => cat_error_handler
[args] => Array
(
[0] => 2
[1] => mysqli::query(): (22003/1690): BIGINT UNSIGNED value is out of range in '`catalyst_content`.`n`.`mlo_num` - `catalyst_content`.`n2`.`mlo_num`'
[2] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/resources/state_server.php
[3] => 1
)
)
[1] => Array
(
[file] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/resources/state_server.php
[line] => 1
[function] => query
[class] => mysqli
[object] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 8.4.21
[client_version] => 80421
[connect_errno] => 0
[connect_error] =>
[errno] => 1690
[error] => BIGINT UNSIGNED value is out of range in '`catalyst_content`.`n`.`mlo_num` - `catalyst_content`.`n2`.`mlo_num`'
[error_list] => Array
(
[0] => Array
(
[errno] => 1690
[sqlstate] => 22003
[error] => BIGINT UNSIGNED value is out of range in '`catalyst_content`.`n`.`mlo_num` - `catalyst_content`.`n2`.`mlo_num`'
)
)
[field_count] => 7
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 11.4.10-MariaDB
[server_version] => 110410
[sqlstate] => 22003
[protocol_version] => 10
[thread_id] => 202558
[warning_count] => 0
)
[type] => ->
[args] => Array
(
[0] => SELECT state_name,n.comp_num,n.branch_num,n.mlo_num,(CAST((n.mlo_num-n2.mlo_num)AS SIGNED)/n2.mlo_num)AS mlo_change,IF(count(c.education_id)>0,"Yes","No")AS ce,IF(count(p.education_id)>0,"Yes","No")AS pe FROM catalyst_content.nmls_lic_rep n INNER JOIN f_lists.states USING(state_id,act)INNER JOIN(SELECT state_id,MAX(yr)AS rep_year,MAX(qtr)AS rep_qtr FROM catalyst_content.nmls_lic_rep GROUP BY state_id)last_rep ON n.yr=last_rep.rep_year AND n.qtr=last_rep.rep_qtr AND n.state_id=last_rep.state_id LEFT JOIN catalyst_content.nmls_lic_rep n2 ON n2.qtr=last_rep.rep_qtr AND n2.yr=(last_rep.rep_year-1) AND n2.act=1 AND n2.state_id=n.state_id LEFT JOIN catalyst_regulation.education_reqs c ON c.state_id=n.state_id AND c.act=1 AND c.type_id=2 AND c.db<=CURDATE() AND(c.de IS NULL OR c.de>=CURDATE())LEFT JOIN catalyst_regulation.education_reqs p ON p.state_id=n.state_id AND p.act=1 AND p.type_id=2 AND p.db<=CURDATE() AND(p.de IS NULL OR p.de>=CURDATE())WHERE n.act=1 GROUP BY n.state_id ORDER BY state_name
)
)
[2] => Array
(
[file] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/layouts/2.php
[line] => 1
[args] => Array
(
[0] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/resources/state_server.php
)
[function] => include
)
[3] => Array
(
[file] => /var/www/vhosts/catalystmortgagetraining.com/mtc/httpdocs/index.php
[line] => 8
[args] => Array
(
[0] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/layouts/2.php
)
[function] => require
)
)
Error Object
(
[message:protected] => Call to a member function free() on false
[string:Error:private] =>
[code:protected] => 0
[file:protected] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/resources/state_server.php
[line:protected] => 1
[trace:Error:private] => Array
(
[0] => Array
(
[file] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/layouts/2.php
[line] => 1
[function] => include
)
[1] => Array
(
[file] => /var/www/vhosts/catalystmortgagetraining.com/mtc/httpdocs/index.php
[line] => 8
[args] => Array
(
[0] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/layouts/2.php
)
[function] => require
)
)
[previous:Error:private] =>
)
Array
(
[0] => Array
(
[function] => cat_exception_handler
[args] => Array
(
[0] => Error Object
(
[message:protected] => Call to a member function free() on false
[string:Error:private] =>
[code:protected] => 0
[file:protected] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/resources/state_server.php
[line:protected] => 1
[trace:Error:private] => Array
(
[0] => Array
(
[file] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/layouts/2.php
[line] => 1
[function] => include
)
[1] => Array
(
[file] => /var/www/vhosts/catalystmortgagetraining.com/mtc/httpdocs/index.php
[line] => 8
[args] => Array
(
[0] => /var/www/vhosts/catalystmortgagetraining.com/mtc/modules/layouts/2.php
)
[function] => require
)
)
[previous:Error:private] =>
)
)
)
)