Error

 
[17-11-2025 18:10:22 UTC] [17-11-2025 18:10:22 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 /marketing-materials/yard-sign-banners/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\":66,\"store_access\":\" AND ((site_master_template.user_type_id IN (\'0\',\'1\') AND (site_master_template.user_ids = \'\')))\",\"template_type\":true,\"size_data\":\"0,92,93\",\"lang_id\":1,\"include_desc_lang\":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":66,"store_access":" AND ((site_master_template.user_type_id IN ('0','1') AND (site_master_template.user_ids = '')))","template_type":true,"size_data":"0,92,93","lang_id":1,"include_desc_lang":true}
    [:extra] => {"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 More...