Error
[13-10-2025 20:14:01 America/New_York] [14-10-2025 00:14:01 UTC] [ERROR] : [PDOException, 42000] SQLSTATE[42000]: Syntax error or access violation: 1305 PROCEDURE xumbaprinting.USPGetProductsDetail does not exist @line 123 in file /home/xumbaprinting/public_html/lib/Classes/Data/RDataConnection.php
GET xumbaprinting.dev.radixweb.net /en/letterheads/products
Debug Backtrace
#1 RDataConnection.php:123 -- PDOStatement->execute()
#2 RMasterModel.php:182 -- RDataConnection->Execute()
#3 CorporateProductsTrait.php:344 -- RMasterModel->exec_query()
#4 ProductsMaster.php:929 -- ProductsMaster->exec_query()
#5 ProductFiltersMaster.php:376 -- ProductsMaster->getProductsDetail()
#6 twig.php:167 -- ProductFiltersMaster->getProductFilters()
#7 common.php:543 -- require_once (/home/xumbaprinting/public_html/lib/twig.php, )
#8 productlist_category_wise.php:14 -- require_once (/home/xumbaprinting/public_html/lib/common.php, )
Last Query :
CALL USPGetProductsDetail('products.products_id, products.kit_type_id', '{\"visible\":1,\"found_rows\":\"true\",\"include_kit\":\"false\",\"site_language_id\":1,\"store_access\":\" AND ((products.user_type_id IN (\'0\',\'1\')))\",\"category_id\":24,\"is_admin\":0,\"modules\":\"0,1\",\"product_service_type\":\"2,1,3,4,5\"}', '{\"groupby\":\"products.products_id\"}') Prepared Statement :
CALL USPGetProductsDetail(:fields, :conditions, :extra) Params: Array
(
[:fields] => products.products_id, products.kit_type_id
[:conditions] => {"visible":1,"found_rows":"true","include_kit":"false","site_language_id":1,"store_access":" AND ((products.user_type_id IN ('0','1')))","category_id":24,"is_admin":0,"modules":"0,1","product_service_type":"2,1,3,4,5"}
[:extra] => {"groupby":"products.products_id"}
)
Show Less...
#0 /home/xumbaprinting/public_html/model/ProductsMaster.php(926): RMasterModel->setProcedure('CALL USPGetProductsDetail(:fields, :conditions, :extra)', Array, Array)925: $Query = 'CALL USPGetProductsDetail(:fields, :conditions, :extra)';
926: $this->setProcedure($Query, array(':fields' => $fields, ':conditions' => opsJsonEncode($conditions), ':extra' => opsJsonEncode($extraParams)), array(':fields' => 'string', ':conditions' => 'string', ':extra' => 'string'));
927: if ($cache) $this->setCache('product');
#1 /home/xumbaprinting/public_html/lib/Classes/Models/RMasterModel.php(288): RMasterModel->resetVariables()287: {
288: $this->resetVariables($var);
289: }