PHPRC_PDO_MYSQL::REF_EXECUTE_TO_ARRAY
|
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'PARAM_CAT_PRODBRANCH_STATUS' at row 1
|
|
FULL REPORT
|
PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'PARAM_CAT_PRODBRANCH_STATUS' at row 1 in /home/peakpos/public_html/water202207/Modules/Prebuild/PHPLib.php:53
Stack trace:
#0 /home/peakpos/public_html/water202207/Modules/Prebuild/PHPLib.php(53): PDOStatement->execute()
#1 /home/peakpos/public_html/water202207/Modules/Prebuild/StoredProcedures.php(120): PHPRC_PDO_MYSQL::REF_EXECUTE_TO_ARRAY(Object(PDOStatement))
#2 /home/peakpos/public_html/water202207/Modules/Prebuild/StoredProcedures.php(120): PHPCUS_CATEGORY_PRODUCT_BRANCH::CUS_GET('-92233720368547...', '0', '-92233720368547...', '1', -1.0E+16, -1.0E+16, -1.0E+16, -1.0E+16, -1.0E+16, -1.0E+16, 29044268, 'CAT_PRODUCT_DES...', 'ASC', '0', '1000', true, Object(PDO))
#3 /home/peakpos/public_html/water202207/Server/Category/product_branch/get/index.php(130): PHPCUS_CATEGORY_PRODUCT_BRANCH::CUS_GET_MA(Array)
#4 /home/peakpos/public_html/water202207/index.php(74): include('/home/peakpos/p...')
#5 /home/peakpos/public_html/water202207/index.php(194): PHPDIR::LOAD_SERVER('Category/produc...')
#6 /home/peakpos/public_html/water202207/index.php(207): PHPDIR::LOAD_INDEX('Category/produc...')
#7 {main}
|
|
STACK TRACE (1)
|
PHPRC_PDO_MYSQL::REF_EXECUTE_TO_ARRAY (line: 120)
|
|
STACK TRACE (2)
|
PHPCUS_CATEGORY_PRODUCT_BRANCH::CUS_GET (line: 120)
|
|
STACK TRACE (3)
|
PHPCUS_CATEGORY_PRODUCT_BRANCH::CUS_GET_MA (line: 130)
|
|
STACK TRACE (4)
|
include (line: 74)
|
|
STACK TRACE (5)
|
PHPDIR::LOAD_SERVER (line: 194)
|
|
STACK TRACE (6)
|
PHPDIR::LOAD_INDEX (line: 207)
|
|
PDO ERR Details
|
SQLSTATE error code: 22003 || Driver-specific error code: 1264 || Driver-specific error message: Out of range value for column 'PARAM_CAT_PRODBRANCH_STATUS' at row 1
|
|
PDO Statement
|
SQL: [778] CALL `CATEGORY_PRODUCT_BRANCH_GET`(:PARAM_CAT_PRODBRANCH_ID, :PARAM_CAT_PRODBRANCH_ACC_GROUP_ID, :PARAM_CAT_PRODBRANCH_CAT_PRODUCT_ID, :PARAM_CAT_PRODBRANCH_CAT_PRICEMDL_ID, :PARAM_CAT_PRODBRANCH_AMOUNT_PRICE_FROM, :PARAM_CAT_PRODBRANCH_AMOUNT_PRICE_TO, :PARAM_CAT_PRODBRANCH_REORDER_POINT_FROM, :PARAM_CAT_PRODBRANCH_REORDER_POINT_TO, :PARAM_CAT_PRODBRANCH_REORDER_QUANTITY_FROM, :PARAM_CAT_PRODBRANCH_REORDER_QUANTITY_TO, :PARAM_CAT_PRODBRANCH_STATUS, :PARAM_ORDER_FIELD, :PARAM_ORDER_TYPE, :PARAM_SKIP, :PARAM_LIMIT, :PARAM_REQUESTER_USERNAME, :PARAM_REQUESTER_PASSWORD, :PARAM_REQUESTER_PROXY_ID, :PARAM_REQUESTER_PROXY_PASSWORD, :PARAM_REQUESTER_DEVICE_PUBLIC_KEY, :PARAM_REQUESTER_DEVICE_PRIVATE_KEY, :PARAM_REQUESTER_IP, :PARAM_UNIQUE_SESSION_ID, :PARAM_SUPPRESS_RETURN )
Sent SQL: [372] CALL `CATEGORY_PRODUCT_BRANCH_GET`(-9223372036854700032, 0, -9223372036854700032, 1, NULL, NULL, NULL, NULL, NULL, NULL, 29044268, 'CAT_PRODUCT_DESCRIPTION', 'ASC', 0, 1000, NULL, NULL, 0, NULL, 'VKWGX-KUGFI-0TZ7H-ZSGUU-BEUKE-WSYPI-U', 'WCJ7S-HDXMP-YSPD6-KJA5P-MIPVI-TVURE-T', '106.240.230.182', 'User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; 360SE)', 0 )
Params: 24
Key: Name: [24] :PARAM_CAT_PRODBRANCH_ID
paramno=-1
name=[24] ":PARAM_CAT_PRODBRANCH_ID"
is_param=1
param_type=1
Key: Name: [34] :PARAM_CAT_PRODBRANCH_ACC_GROUP_ID
paramno=-1
name=[34] ":PARAM_CAT_PRODBRANCH_ACC_GROUP_ID"
is_param=1
param_type=1
Key: Name: [36] :PARAM_CAT_PRODBRANCH_CAT_PRODUCT_ID
paramno=-1
name=[36] ":PARAM_CAT_PRODBRANCH_CAT_PRODUCT_ID"
is_param=1
param_type=1
Key: Name: [37] :PARAM_CAT_PRODBRANCH_CAT_PRICEMDL_ID
paramno=-1
name=[37] ":PARAM_CAT_PRODBRANCH_CAT_PRICEMDL_ID"
is_param=1
param_type=1
Key: Name: [39] :PARAM_CAT_PRODBRANCH_AMOUNT_PRICE_FROM
paramno=-1
name=[39] ":PARAM_CAT_PRODBRANCH_AMOUNT_PRICE_FROM"
is_param=1
param_type=1
Key: Name: [37] :PARAM_CAT_PRODBRANCH_AMOUNT_PRICE_TO
paramno=-1
name=[37] ":PARAM_CAT_PRODBRANCH_AMOUNT_PRICE_TO"
is_param=1
param_type=1
Key: Name: [40] :PARAM_CAT_PRODBRANCH_REORDER_POINT_FROM
paramno=-1
name=[40] ":PARAM_CAT_PRODBRANCH_REORDER_POINT_FROM"
is_param=1
param_type=1
Key: Name: [38] :PARAM_CAT_PRODBRANCH_REORDER_POINT_TO
paramno=-1
name=[38] ":PARAM_CAT_PRODBRANCH_REORDER_POINT_TO"
is_param=1
param_type=1
Key: Name: [43] :PARAM_CAT_PRODBRANCH_REORDER_QUANTITY_FROM
paramno=-1
name=[43] ":PARAM_CAT_PRODBRANCH_REORDER_QUANTITY_FROM"
is_param=1
param_type=1
Key: Name: [41] :PARAM_CAT_PRODBRANCH_REORDER_QUANTITY_TO
paramno=-1
name=[41] ":PARAM_CAT_PRODBRANCH_REORDER_QUANTITY_TO"
is_param=1
param_type=1
Key: Name: [28] :PARAM_CAT_PRODBRANCH_STATUS
paramno=-1
name=[28] ":PARAM_CAT_PRODBRANCH_STATUS"
is_param=1
param_type=1
Key: Name: [18] :PARAM_ORDER_FIELD
paramno=-1
name=[18] ":PARAM_ORDER_FIELD"
is_param=1
param_type=2
Key: Name: [17] :PARAM_ORDER_TYPE
paramno=-1
name=[17] ":PARAM_ORDER_TYPE"
is_param=1
param_type=2
Key: Name: [11] :PARAM_SKIP
paramno=-1
name=[11] ":PARAM_SKIP"
is_param=1
param_type=1
Key: Name: [12] :PARAM_LIMIT
paramno=-1
name=[12] ":PARAM_LIMIT"
is_param=1
param_type=1
Key: Name: [25] :PARAM_REQUESTER_USERNAME
paramno=-1
name=[25] ":PARAM_REQUESTER_USERNAME"
is_param=1
param_type=1
Key: Name: [25] :PARAM_REQUESTER_PASSWORD
paramno=-1
name=[25] ":PARAM_REQUESTER_PASSWORD"
is_param=1
param_type=1
Key: Name: [25] :PARAM_REQUESTER_PROXY_ID
paramno=-1
name=[25] ":PARAM_REQUESTER_PROXY_ID"
is_param=1
param_type=1
Key: Name: [31] :PARAM_REQUESTER_PROXY_PASSWORD
paramno=-1
name=[31] ":PARAM_REQUESTER_PROXY_PASSWORD"
is_param=1
param_type=1
Key: Name: [34] :PARAM_REQUESTER_DEVICE_PUBLIC_KEY
paramno=-1
name=[34] ":PARAM_REQUESTER_DEVICE_PUBLIC_KEY"
is_param=1
param_type=2
Key: Name: [35] :PARAM_REQUESTER_DEVICE_PRIVATE_KEY
paramno=-1
name=[35] ":PARAM_REQUESTER_DEVICE_PRIVATE_KEY"
is_param=1
param_type=2
Key: Name: [19] :PARAM_REQUESTER_IP
paramno=-1
name=[19] ":PARAM_REQUESTER_IP"
is_param=1
param_type=2
Key: Name: [24] :PARAM_UNIQUE_SESSION_ID
paramno=-1
name=[24] ":PARAM_UNIQUE_SESSION_ID"
is_param=1
param_type=2
Key: Name: [22] :PARAM_SUPPRESS_RETURN
paramno=-1
name=[22] ":PARAM_SUPPRESS_RETURN"
is_param=1
param_type=1
|
|
HTTP_HOST
|
water202207.peakpos.com.ph
|
|
HTTP_REFERER
|
https://water202207.peakpos.com.ph/
|
|
REMOTE_ADDR
|
106.240.230.182
|
|