org\guzaba\framework\database\exceptions\queryException

SQL query error:
"Cannot add or update a child row: a foreign key constraint fails (`bnap_gdb`.`guzaba_shopping_carts`, CONSTRAINT `shopping_carts_fk1_constraint` FOREIGN KEY (`session_id`) REFERENCES `guzaba_sessions` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE)"

SQL statement execution called from:
/home/bnap/aktivnipotrebiteli.bg/framework/database/classes/pdo.php(104)
org\guzaba\framework\database\classes\pdo::execute()

Exact query:
INSERT
INTO
	guzaba_shopping_carts
(
	coupon_id, session_id, currency_id, courier_rate_id, international_courier_rate_id, sh_cart_courier_price, sh_cart_order_code, sh_cart_payment_method, sh_cart_address_country_id, sh_cart_address_usa_state, sh_cart_address_city, sh_cart_address_street, sh_cart_address_post_code, sh_cart_delivery_address_country_id, sh_cart_delivery_address_usa_state, sh_cart_delivery_address_city, sh_cart_delivery_address_street, sh_cart_delivery_address_post_code, sh_cart_client_first_name, sh_cart_client_last_name, sh_cart_phone, sh_cart_email, sh_cart_send_invoice, sh_cart_invoice_company, sh_cart_invoice_company_address, sh_cart_invoice_recipient, sh_cart_invoice_company_num, sh_cart_invoice_vat_num
)
VALUES
(
	'', 'e3882dc6f2f90119e215c8f88dc98c22', '1', '', '', '0', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', ''_address, '', ''_num, ''
)
			

Query and params data:
SQL: [1474] 
INSERT
INTO
	guzaba_shopping_carts
(
	coupon_id, session_id, currency_id, courier_rate_id, international_courier_rate_id, sh_cart_courier_price, sh_cart_order_code, sh_cart_payment_method, sh_cart_address_country_id, sh_cart_address_usa_state, sh_cart_address_city, sh_cart_address_street, sh_cart_address_post_code, sh_cart_delivery_address_country_id, sh_cart_delivery_address_usa_state, sh_cart_delivery_address_city, sh_cart_delivery_address_street, sh_cart_delivery_address_post_code, sh_cart_client_first_name, sh_cart_client_last_name, sh_cart_phone, sh_cart_email, sh_cart_send_invoice, sh_cart_invoice_company, sh_cart_invoice_company_address, sh_cart_invoice_recipient, sh_cart_invoice_company_num, sh_cart_invoice_vat_num
)
VALUES
(
	:coupon_id, :session_id, :currency_id, :courier_rate_id, :international_courier_rate_id, :sh_cart_courier_price, :sh_cart_order_code, :sh_cart_payment_method, :sh_cart_address_country_id, :sh_cart_address_usa_state, :sh_cart_address_city, :sh_cart_address_street, :sh_cart_address_post_code, :sh_cart_delivery_address_country_id, :sh_cart_delivery_address_usa_state, :sh_cart_delivery_address_city, :sh_cart_delivery_address_street, :sh_cart_delivery_address_post_code, :sh_cart_client_first_name, :sh_cart_client_last_name, :sh_cart_phone, :sh_cart_email, :sh_cart_send_invoice, :sh_cart_invoice_company, :sh_cart_invoice_company_address, :sh_cart_invoice_recipient, :sh_cart_invoice_company_num, :sh_cart_invoice_vat_num
)
			
Sent SQL: [926] 
INSERT
INTO
	guzaba_shopping_carts
(
	coupon_id, session_id, currency_id, courier_rate_id, international_courier_rate_id, sh_cart_courier_price, sh_cart_order_code, sh_cart_payment_method, sh_cart_address_country_id, sh_cart_address_usa_state, sh_cart_address_city, sh_cart_address_street, sh_cart_address_post_code, sh_cart_delivery_address_country_id, sh_cart_delivery_address_usa_state, sh_cart_delivery_address_city, sh_cart_delivery_address_street, sh_cart_delivery_address_post_code, sh_cart_client_first_name, sh_cart_client_last_name, sh_cart_phone, sh_cart_email, sh_cart_send_invoice, sh_cart_invoice_company, sh_cart_invoice_company_address, sh_cart_invoice_recipient, sh_cart_invoice_company_num, sh_cart_invoice_vat_num
)
VALUES
(
	NULL, 'e3882dc6f2f90119e215c8f88dc98c22', 1, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0', NULL, NULL, NULL, '', ''
)
			
Params:  28
Key: Name: [10] :coupon_id
paramno=-1
name=[10] ":coupon_id"
is_param=1
param_type=0
Key: Name: [11] :session_id
paramno=-1
name=[11] ":session_id"
is_param=1
param_type=2
Key: Name: [12] :currency_id
paramno=-1
name=[12] ":currency_id"
is_param=1
param_type=1
Key: Name: [16] :courier_rate_id
paramno=-1
name=[16] ":courier_rate_id"
is_param=1
param_type=0
Key: Name: [30] :international_courier_rate_id
paramno=-1
name=[30] ":international_courier_rate_id"
is_param=1
param_type=0
Key: Name: [22] :sh_cart_courier_price
paramno=-1
name=[22] ":sh_cart_courier_price"
is_param=1
param_type=1
Key: Name: [19] :sh_cart_order_code
paramno=-1
name=[19] ":sh_cart_order_code"
is_param=1
param_type=0
Key: Name: [23] :sh_cart_payment_method
paramno=-1
name=[23] ":sh_cart_payment_method"
is_param=1
param_type=1
Key: Name: [27] :sh_cart_address_country_id
paramno=-1
name=[27] ":sh_cart_address_country_id"
is_param=1
param_type=0
Key: Name: [26] :sh_cart_address_usa_state
paramno=-1
name=[26] ":sh_cart_address_usa_state"
is_param=1
param_type=0
Key: Name: [21] :sh_cart_address_city
paramno=-1
name=[21] ":sh_cart_address_city"
is_param=1
param_type=0
Key: Name: [23] :sh_cart_address_street
paramno=-1
name=[23] ":sh_cart_address_street"
is_param=1
param_type=0
Key: Name: [26] :sh_cart_address_post_code
paramno=-1
name=[26] ":sh_cart_address_post_code"
is_param=1
param_type=0
Key: Name: [36] :sh_cart_delivery_address_country_id
paramno=-1
name=[36] ":sh_cart_delivery_address_country_id"
is_param=1
param_type=0
Key: Name: [35] :sh_cart_delivery_address_usa_state
paramno=-1
name=[35] ":sh_cart_delivery_address_usa_state"
is_param=1
param_type=0
Key: Name: [30] :sh_cart_delivery_address_city
paramno=-1
name=[30] ":sh_cart_delivery_address_city"
is_param=1
param_type=0
Key: Name: [32] :sh_cart_delivery_address_street
paramno=-1
name=[32] ":sh_cart_delivery_address_street"
is_param=1
param_type=0
Key: Name: [35] :sh_cart_delivery_address_post_code
paramno=-1
name=[35] ":sh_cart_delivery_address_post_code"
is_param=1
param_type=0
Key: Name: [26] :sh_cart_client_first_name
paramno=-1
name=[26] ":sh_cart_client_first_name"
is_param=1
param_type=2
Key: Name: [25] :sh_cart_client_last_name
paramno=-1
name=[25] ":sh_cart_client_last_name"
is_param=1
param_type=2
Key: Name: [14] :sh_cart_phone
paramno=-1
name=[14] ":sh_cart_phone"
is_param=1
param_type=2
Key: Name: [14] :sh_cart_email
paramno=-1
name=[14] ":sh_cart_email"
is_param=1
param_type=2
Key: Name: [21] :sh_cart_send_invoice
paramno=-1
name=[21] ":sh_cart_send_invoice"
is_param=1
param_type=2
Key: Name: [24] :sh_cart_invoice_company
paramno=-1
name=[24] ":sh_cart_invoice_company"
is_param=1
param_type=0
Key: Name: [32] :sh_cart_invoice_company_address
paramno=-1
name=[32] ":sh_cart_invoice_company_address"
is_param=1
param_type=0
Key: Name: [26] :sh_cart_invoice_recipient
paramno=-1
name=[26] ":sh_cart_invoice_recipient"
is_param=1
param_type=0
Key: Name: [28] :sh_cart_invoice_company_num
paramno=-1
name=[28] ":sh_cart_invoice_company_num"
is_param=1
param_type=2
Key: Name: [24] :sh_cart_invoice_vat_num
paramno=-1
name=[24] ":sh_cart_invoice_vat_num"
is_param=1
param_type=2



On line 394 in file .framework/database/classes/pdoStatement.php.
#0 /home/bnap/aktivnipotrebiteli.bg/framework/database/classes/pdo.php(104): org\guzaba\framework\database\classes\pdoStatement->execute(Array)
#1 /home/bnap/aktivnipotrebiteli.bg/framework/orm/classes/activeRecord.php(974): org\guzaba\framework\database\classes\pdo->execute('\nINSERT\nINTO\n\tg...', Array)
#2 [internal function]: org\guzaba\framework\orm\classes\activeRecord->save()
#3 /home/bnap/aktivnipotrebiteli.bg/framework/orm/classes/activeRecordSingle.php(130): call_user_func_array('parent::save', Array)
#4 /home/bnap/aktivnipotrebiteli.bg/cms/templates/controllers/template_site.php(673): org\guzaba\framework\orm\classes\activeRecordSingle->save()
#5 [internal function]: org\guzaba\cms\templates\controllers\template_site->main(0, NULL)
#6 /home/bnap/aktivnipotrebiteli.bg/framework/mvc/classes/executor.php(246): call_user_func_array(Array, Array)
#7 /home/bnap/aktivnipotrebiteli.bg/framework/mvc/classes/executor.php(107): org\guzaba\framework\mvc\classes\executor->execute()
#8 /home/bnap/aktivnipotrebiteli.bg/framework/mvc/classes/executor.php(87): org\guzaba\framework\mvc\classes\executor->main_process()
#9 /home/bnap/aktivnipotrebiteli.bg/framework/mvc/classes/executor.php(134): org\guzaba\framework\mvc\classes\executor->__construct(Object(org\guzaba\framework\mvc\classes\environment))
#10 /home/bnap/aktivnipotrebiteli.bg/framework/mvc/classes/executor.php(87): org\guzaba\framework\mvc\classes\executor->main_process()
#11 /home/bnap/aktivnipotrebiteli.bg/framework/runlevels/classes/init_1.php(197): org\guzaba\framework\mvc\classes\executor->__construct(Object(org\guzaba\framework\mvc\classes\environment), true)
#12 /home/bnap/aktivnipotrebiteli.bg/framework/kernel/classes/kernel.php(113): org\guzaba\framework\runlevels\classes\init_1::execute()
#13 /home/bnap/aktivnipotrebiteli.bg/index.php(54): org\guzaba\framework\kernel\classes\kernel->execute()
#14 {main}

Array ( [app] => cms [p] => articles [c] => view_article [a] => main [id] => 650 )
Array ( [app] => cms [p] => articles [c] => view_article [a] => main [id] => 812 )
Array ( [app] => cms [p] => articles [c] => view_article [a] => main [id] => 37 )
Array ( [app] => cms [p] => articles [c] => view_article [a] => main [id] => 626 )
Array ( [app] => cms [p] => categories [c] => view_category [a] => main [id] => 153 )
Array ( [app] => cms [p] => content [c] => view_page [a] => main [id] => 311 )

REQUEST: /%D1%81%D1%82%D0%B0%D1%82%D0%B8%D1%8F/650/%D0%9F%D1%80%D0%B5%D0%B4%D0%BF%D0%B0%D0%B7%D0%B2%D0%B0%D0%BD%D0%B5-%D0%BD%D0%B0-%D0%B2%D0%BE%D0%B4%D0%BE%D0%BF%D1%80%D0%BE%D0%B2%D0%BE%D0%B4%D0%BD%D0%B8%D1%82%D0%B5-%D0%B8%D0%BD%D1%81%D1%82%D0%B0%D0%BB%D0%B0%D1%86%D0%B8%D0%B8-%D0%BE%D1%82-%D0%B7%D0%B0%D0%BC%D1%80%D1%8A%D0%B7%D0%B2%D0%B0%D0%BD%D0%B5

USER-AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)