Error
[17-11-2025 18:12:30 UTC] [17-11-2025 18:12:30 UTC] [ERROR] : [PDOException, 42000] SQLSTATE[42000]: Syntax error or access violation: 1305 PROCEDURE promo_coFxeBzhHl_ops.USPGetTemplateDetails does not exist @line 123 in file /home/promo/public_html/lib/Classes/Data/RDataConnection.php
GET promo.fourprintshop.com /business-stationary/square-magnets/s21/animal-pets/designs
Debug Backtrace
#1 RDataConnection.php:123 -- PDOStatement->execute()
#2 RMasterModel.php:182 -- RDataConnection->Execute()
#3 CorporateProductsTrait.php:344 -- RMasterModel->exec_query()
#4 TemplateMaster.php:610 -- TemplateMaster->exec_query()
#5 twig_functions.php:1802 -- TemplateMaster->get_template_details_filter()
#6 product_designs.php:121 -- getTemplateRecords()
Last Query :
CALL USPGetTemplateDetails('{\"temp_fields\":\"count(DISTINCT site_master_template.template_id) as site_total, 0 as \'master_total\',site_master_template.template_language_ids,GROUP_CONCAT(site_master_template.color,\'\') as color,GROUP_CONCAT(DISTINCT site_master_template.orientation,\'\') as orientation\",\"master_temp_fields\":\"\'0\', count(DISTINCT master_template.template_id) as master_total,master_template.template_language_ids,GROUP_CONCAT(master_template.color,\'\') as color,GROUP_CONCAT(DISTINCT master_template.orientation,\'\') as orientation\"}', '{\"status\":\"1\",\"product_id\":68,\"store_access\":\" AND ((site_master_template.user_type_id IN (\'0\',\'1\') AND (site_master_template.user_ids = \'\')))\",\"template_type\":true,\"size_data\":\"0,95\",\"lang_id\":1,\"include_desc_lang\":true}', '{\"temp_category_enabled\":true,\"designer_enabled\":true,\"order_by\":null,\"group_by\":{\"site_template\":\"\",\"master_template\":\"\"},\"fetch_data\":\"B\",\"lang_where\":true,\"psize_pid_join\":1,\"corporate_id\":0}') Prepared Statement :
CALL USPGetTemplateDetails(:fields, :conditions, :extra) Params: Array
(
[:fields] => {"temp_fields":"count(DISTINCT site_master_template.template_id) as site_total, 0 as 'master_total',site_master_template.template_language_ids,GROUP_CONCAT(site_master_template.color,'') as color,GROUP_CONCAT(DISTINCT site_master_template.orientation,'') as orientation","master_temp_fields":"'0', count(DISTINCT master_template.template_id) as master_total,master_template.template_language_ids,GROUP_CONCAT(master_template.color,'') as color,GROUP_CONCAT(DISTINCT master_template.orientation,'') as orientation"}
[:conditions] => {"status":"1","product_id":68,"store_access":" AND ((site_master_template.user_type_id IN ('0','1') AND (site_master_template.user_ids = '')))","template_type":true,"size_data":"0,95","lang_id":1,"include_desc_lang":true}
[:extra] => {"temp_category_enabled":true,"designer_enabled":true,"order_by":null,"group_by":{"site_template":"","master_template":""},"fetch_data":"B","lang_where":true,"psize_pid_join":1,"corporate_id":0}
)
Show Less...
#0 /home/promo/public_html/model/TemplateMaster.php(609): RMasterModel->setProcedure('CALL USPGetTemplateDetails(:fields, :conditions, :extra)', Array, Array)608: $Query = 'CALL USPGetTemplateDetails(:fields, :conditions, :extra)';
609: $this->setProcedure($Query, array(':fields' => opsJsonEncode(array('temp_fields' => $fields, 'master_temp_fields' => $mfields)), ':conditions' => opsJsonEncode($whereConds), ':extra' => opsJsonEncode($extra)), array(':fields' => 'string', ':conditions' => 'string', ':extra' => 'string'));
610: $result = $this->exec_query();
#1 /home/promo/public_html/lib/Classes/Models/RMasterModel.php(288): RMasterModel->resetVariables()287: {
288: $this->resetVariables($var);
289: }