Error

 
[Exception, 0] 
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'site_master_template.products_id' in 'where clause' in /home/xumbaprinting/public_html/lib/Classes/Models/RMasterModel.php:89
Stack trace:
#0 /home/xumbaprinting/public_html/model/TemplateMaster.php(650): RMasterModel->exec_query()
#1 /home/xumbaprinting/public_html/templates/include/twig_functions.php(1702): TemplateMaster->get_template_details_filter()
#2 /home/xumbaprinting/public_html/product_designs.php(114): getTemplateRecords()
#3 {main} 
@line 702 in file /home/xumbaprinting/public_html/lib/Classes/Models/RMasterModel.php

Debug Backtrace

#1 RMasterModel.php:91 -- RMasterModel->displayException()
#2 TemplateMaster.php:650 -- RMasterModel->exec_query()
#3 twig_functions.php:1702 -- TemplateMaster->get_template_details_filter()
#4 product_designs.php:114 -- getTemplateRecords()

Last Query :

SELECT SQL_CALC_FOUND_ROWS 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 FROM site_master_template LEFT JOIN site_master_template_description ON site_master_template_description.template_id = site_master_template.template_id AND ( site_master_template_description.site_language_id =1 OR site_master_template_description.site_language_id IS NULL) RIGHT JOIN products ON products.products_id=site_master_template.products_id LEFT JOIN product_category ON product_category.category_id=products.category_id WHERE site_master_template.status = '1' AND (site_master_template.products_id = 137 OR site_master_template.duplicate_product_id LIKE '%,137-%') AND ((site_master_template.user_type_id IN ('0', '1') AND (site_master_template.user_ids = ''))) AND ( site_master_template.studiodata !='') AND (site_master_template.size_id IN ('391', '392', '393', '394', '390', '395', '396', '397', '399', '400', '401', '402', '403', '404', '405', '406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '416', '417') OR site_master_template.duplicate_product_id LIKE '%-391,%' OR site_master_template.duplicate_product_id LIKE '%-392,%' OR site_master_template.duplicate_product_id LIKE '%-393,%' OR site_master_template.duplicate_product_id LIKE '%-394,%' OR site_master_template.duplicate_product_id LIKE '%-390,%' OR site_master_template.duplicate_product_id LIKE '%-395,%' OR site_master_template.duplicate_product_id LIKE '%-396,%' OR site_master_template.duplicate_product_id LIKE '%-397,%' OR site_master_template.duplicate_product_id LIKE '%-399,%' OR site_master_template.duplicate_product_id LIKE '%-400,%' OR site_master_template.duplicate_product_id LIKE '%-401,%' OR site_master_template.duplicate_product_id LIKE '%-402,%' OR site_master_template.duplicate_product_id LIKE '%-403,%' OR site_master_template.duplicate_product_id LIKE '%-404,%' OR site_master_template.duplicate_product_id LIKE '%-405,%' OR site_master_template.duplicate_product_id LIKE '%-406,%' OR site_master_template.duplicate_product_id LIKE '%-407,%' OR site_master_template.duplicate_product_id LIKE '%-408,%' OR site_master_template.duplicate_product_id LIKE '%-409,%' OR site_master_template.duplicate_product_id LIKE '%-410,%' OR site_master_template.duplicate_product_id LIKE '%-411,%' OR site_master_template.duplicate_product_id LIKE '%-412,%' OR site_master_template.duplicate_product_id LIKE '%-413,%' OR site_master_template.duplicate_product_id LIKE '%-414,%' OR site_master_template.duplicate_product_id LIKE '%-415,%' OR site_master_template.duplicate_product_id LIKE '%-416,%' OR site_master_template.duplicate_product_id LIKE '%-417,%') AND (site_master_template.template_language_ids = '0' OR FIND_IN_SET('1',site_master_template.template_language_ids))

Prepared Statement :

SELECT SQL_CALC_FOUND_ROWS 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 FROM site_master_template LEFT JOIN site_master_template_description ON site_master_template_description.template_id = site_master_template.template_id AND ( site_master_template_description.site_language_id =:smtd_site_language_id OR site_master_template_description.site_language_id IS NULL) RIGHT JOIN products ON products.products_id=site_master_template.products_id LEFT JOIN product_category ON product_category.category_id=products.category_id WHERE site_master_template.status = :site_master_template_status AND (site_master_template.products_id = :smt_products_id OR site_master_template.duplicate_product_id LIKE :smt_dup_product_id) AND ((site_master_template.user_type_id IN (:input_34, :input_35) AND (site_master_template.user_ids = :user_ids_75763922920240919133629))) AND ( site_master_template.studiodata !='') AND (site_master_template.size_id IN (:input_36, :input_37, :input_38, :input_39, :input_40, :input_41, :input_42, :input_43, :input_44, :input_45, :input_46, :input_47, :input_48, :input_49, :input_50, :input_51, :input_52, :input_53, :input_54, :input_55, :input_56, :input_57, :input_58, :input_59, :input_60, :input_61, :input_62) OR site_master_template.duplicate_product_id LIKE :smt_product_id1 OR site_master_template.duplicate_product_id LIKE :smt_product_id2 OR site_master_template.duplicate_product_id LIKE :smt_product_id3 OR site_master_template.duplicate_product_id LIKE :smt_product_id4 OR site_master_template.duplicate_product_id LIKE :smt_product_id5 OR site_master_template.duplicate_product_id LIKE :smt_product_id6 OR site_master_template.duplicate_product_id LIKE :smt_product_id7 OR site_master_template.duplicate_product_id LIKE :smt_product_id8 OR site_master_template.duplicate_product_id LIKE :smt_product_id9 OR site_master_template.duplicate_product_id LIKE :smt_product_id10 OR site_master_template.duplicate_product_id LIKE :smt_product_id11 OR site_master_template.duplicate_product_id LIKE :smt_product_id12 OR site_master_template.duplicate_product_id LIKE :smt_product_id13 OR site_master_template.duplicate_product_id LIKE :smt_product_id14 OR site_master_template.duplicate_product_id LIKE :smt_product_id15 OR site_master_template.duplicate_product_id LIKE :smt_product_id16 OR site_master_template.duplicate_product_id LIKE :smt_product_id17 OR site_master_template.duplicate_product_id LIKE :smt_product_id18 OR site_master_template.duplicate_product_id LIKE :smt_product_id19 OR site_master_template.duplicate_product_id LIKE :smt_product_id20 OR site_master_template.duplicate_product_id LIKE :smt_product_id21 OR site_master_template.duplicate_product_id LIKE :smt_product_id22 OR site_master_template.duplicate_product_id LIKE :smt_product_id23 OR site_master_template.duplicate_product_id LIKE :smt_product_id24 OR site_master_template.duplicate_product_id LIKE :smt_product_id25 OR site_master_template.duplicate_product_id LIKE :smt_product_id26 OR site_master_template.duplicate_product_id LIKE :smt_product_id27) AND (site_master_template.template_language_ids = '0' OR FIND_IN_SET(:site_master_template_template_language_ids,site_master_template.template_language_ids)) 
Params: Array
(
    [:smtd_site_language_id] => 1
    [:site_master_template_status] => 1
    [:smt_products_id] => 137
    [:smt_dup_product_id] => %,137-%
    [:user_ids_75763922920240919133629] => 
    [:smt_product_id1] => %-391,%
    [:smt_product_id2] => %-392,%
    [:smt_product_id3] => %-393,%
    [:smt_product_id4] => %-394,%
    [:smt_product_id5] => %-390,%
    [:smt_product_id6] => %-395,%
    [:smt_product_id7] => %-396,%
    [:smt_product_id8] => %-397,%
    [:smt_product_id9] => %-399,%
    [:smt_product_id10] => %-400,%
    [:smt_product_id11] => %-401,%
    [:smt_product_id12] => %-402,%
    [:smt_product_id13] => %-403,%
    [:smt_product_id14] => %-404,%
    [:smt_product_id15] => %-405,%
    [:smt_product_id16] => %-406,%
    [:smt_product_id17] => %-407,%
    [:smt_product_id18] => %-408,%
    [:smt_product_id19] => %-409,%
    [:smt_product_id20] => %-410,%
    [:smt_product_id21] => %-411,%
    [:smt_product_id22] => %-412,%
    [:smt_product_id23] => %-413,%
    [:smt_product_id24] => %-414,%
    [:smt_product_id25] => %-415,%
    [:smt_product_id26] => %-416,%
    [:smt_product_id27] => %-417,%
    [:site_master_template_template_language_ids] => 1
    [:input_34] => 0
    [:input_35] => 1
    [:input_36] => 391
    [:input_37] => 392
    [:input_38] => 393
    [:input_39] => 394
    [:input_40] => 390
    [:input_41] => 395
    [:input_42] => 396
    [:input_43] => 397
    [:input_44] => 399
    [:input_45] => 400
    [:input_46] => 401
    [:input_47] => 402
    [:input_48] => 403
    [:input_49] => 404
    [:input_50] => 405
    [:input_51] => 406
    [:input_52] => 407
    [:input_53] => 408
    [:input_54] => 409
    [:input_55] => 410
    [:input_56] => 411
    [:input_57] => 412
    [:input_58] => 413
    [:input_59] => 414
    [:input_60] => 415
    [:input_61] => 416
    [:input_62] => 417
)
Show More...