Something Error:
Severity: Warning
pg_query(): Query failed: ERROR: invalid input syntax for type bigint: ""
LINE 3: WHERE a.bpr='' AND finan...
^
Filename: postgre/postgre_driver.php
Line Number: 242
Backtrace:
File: /var/www/html/sip/application/modules/home/models/Mbprfinanceasset.php
Line: 41
Function: query
File: /var/www/html/sip/application/modules/home/views/bpr_profile.php
Line: 279
Function: getBPRFinanceAssetByAssetType
File: /var/www/html/sip/application/core/MY_Loader.php
Line: 100
Function: include
File: /var/www/html/sip/application/third_party/MX/Loader.php
Line: 302
Function: _ci_load
File: /var/www/html/sip/application/views/layout/main-new.php
Line: 256
Function: view
File: /var/www/html/sip/application/core/MY_Loader.php
Line: 100
Function: include
File: /var/www/html/sip/application/third_party/MX/Loader.php
Line: 302
Function: _ci_load
File: /var/www/html/sip/application/modules/home/controllers/Bpr.php
Line: 469
Function: view
File: /var/www/html/sip/index.php
Line: 302
Function: require_once
Error Number:
ERROR: invalid input syntax for type bigint: ""
LINE 3: WHERE a.bpr='' AND finan...
^
SELECT a.*, b.name FROM bpr_finance_assets a
LEFT JOIN bpr_finance_asset_types b ON b.id = a.finance_asset_type
WHERE a.bpr='' AND finance_asset_type='4' AND a.year='2022'
Filename: modules/home/models/Mbprfinanceasset.php
Line Number: 41