Show Less...
#0 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1744): RMasterModel->setFrom('site_language')1743: $this->setWhere("AND status = :status", '1', 'string');
1744: $this->setFrom("site_language");
1745: return $this->exec_query();
#1 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1743): RMasterModel->setWhere('AND status = :status', '1', 'string')1742: {
1743: $this->setWhere("AND status = :status", '1', 'string');
1744: $this->setFrom("site_language");
#2 /home/sl/public_html/studio/Services/Classes/StoreConfiguration.php(446): RMasterModel->setSelect(Array)445:
446: $this->db->setSelect(['site_language_id', 'site_language_name', 'shortname', 'studio_font_id']);
447: $siteLanguageData = $this->db->getSiteLanguages();
#3 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(123): RMasterModel->setWhere('AND cms_pages.status = :status', '1', 'int')122: $this->setWhere("AND cms_pages_description.site_language_id = :cms_pages_description_site_language_id", SITE_LANGUAGE_ID, "int");
123: $this->setWhere("AND cms_pages.status = :status", '1', "int");
124: $this->setCache("studio_cms_pages");
#4 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(122): RMasterModel->setWhere('AND cms_pages_description.site_language_id = :cms_pages_description_site_language_id', 1, 'int')121: $this->setJoin("LEFT JOIN cms_pages_description ON cms_pages.page_id = cms_pages_description.page_id");
122: $this->setWhere("AND cms_pages_description.site_language_id = :cms_pages_description_site_language_id", SITE_LANGUAGE_ID, "int");
123: $this->setWhere("AND cms_pages.status = :status", '1', "int");
#5 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(121): RMasterModel->setJoin('LEFT JOIN cms_pages_description ON cms_pages.page_id = cms_pages_description.page_id')120: $this->setWhere("AND page_name IN @page_name", $cmspage, "string");
121: $this->setJoin("LEFT JOIN cms_pages_description ON cms_pages.page_id = cms_pages_description.page_id");
122: $this->setWhere("AND cms_pages_description.site_language_id = :cms_pages_description_site_language_id", SITE_LANGUAGE_ID, "int");
#6 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(120): RMasterModel->setWhere('AND page_name IN @page_name', Array, 'string')119: $this->setFrom("cms_pages");
120: $this->setWhere("AND page_name IN @page_name", $cmspage, "string");
121: $this->setJoin("LEFT JOIN cms_pages_description ON cms_pages.page_id = cms_pages_description.page_id");
#7 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(119): RMasterModel->setFrom('cms_pages')118: if (!empty($cmspage)) {
119: $this->setFrom("cms_pages");
120: $this->setWhere("AND page_name IN @page_name", $cmspage, "string");
#8 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(104): RMasterModel->setJoin(' AND studio_configuration_product_setting.corporate_id = :studio_configuration_product_setting_corporate_id_128454717120250311052629 ', Array, Array)103: $storeAccess = getAccessObj()->getStoreAccess('studio_configuration_product_setting', array('corporate_id' => (int)$storeID));
104: $this->setJoin($storeAccess[0], $storeAccess[1], $storeAccess[2]);
105: }
#9 /home/sl/public_html/studio/Services/Classes/StoreConfiguration.php(370): RMasterModel->setWhere('AND variable_name='custom_default_tab_selected'')369: }
370: $this->db->setWhere("AND variable_name='custom_default_tab_selected'");
371: $defaultTabSetting = $this->db->getStudioConfigSettings($this->params['pid']);
#10 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1366): RMasterModel->setOrderBy('studio_text_clippath.sort_order ASC')1365: ->setWhere("AND status = :status", '1', 'string');
1366: $this->setOrderBy("studio_text_clippath.sort_order ASC");
1367: $this->setCache("studio_text_clippath");
#11 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1365): RMasterModel->setWhere('AND status = :status', '1', 'string')1364: $this->setFrom("studio_text_clippath")
1365: ->setWhere("AND status = :status", '1', 'string');
1366: $this->setOrderBy("studio_text_clippath.sort_order ASC");
#12 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1364): RMasterModel->setFrom('studio_text_clippath')1363: {
1364: $this->setFrom("studio_text_clippath")
1365: ->setWhere("AND status = :status", '1', 'string');
#13 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1284): RMasterModel->setFoundRows()1283: }
1284: $this->setFoundRows();
1285: $this->setCache("studio_design_layouts");
#14 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1282): RMasterModel->setLimit(0, 20)1281: if (isset($offset) && isset($limit)) {
1282: $this->setLimit($offset, $limit);
1283: }
#15 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1280): RMasterModel->setOrderBy('design_layouts.design_layout_id DESC')1279: $this->setOrderBy("design_layouts.sort_order ASC");
1280: $this->setOrderBy("design_layouts.design_layout_id DESC");
1281: if (isset($offset) && isset($limit)) {
#16 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1279): RMasterModel->setOrderBy('design_layouts.sort_order ASC')1278: $this->setFrom('design_layouts');
1279: $this->setOrderBy("design_layouts.sort_order ASC");
1280: $this->setOrderBy("design_layouts.design_layout_id DESC");
#17 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1278): RMasterModel->setFrom('design_layouts')1277: $this->setJoin("LEFT JOIN design_layouts_description ON design_layouts_description.design_layout_id = design_layouts.design_layout_id");
1278: $this->setFrom('design_layouts');
1279: $this->setOrderBy("design_layouts.sort_order ASC");
#18 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1277): RMasterModel->setJoin('LEFT JOIN design_layouts_description ON design_layouts_description.design_layout_id = design_layouts.design_layout_id')1276: $this->setWhere("AND design_layouts_description.site_language_id = :design_layouts_description_site_language_id", SITE_LANGUAGE_ID, 'int');
1277: $this->setJoin("LEFT JOIN design_layouts_description ON design_layouts_description.design_layout_id = design_layouts.design_layout_id");
1278: $this->setFrom('design_layouts');
#19 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1276): RMasterModel->setWhere('AND design_layouts_description.site_language_id = :design_layouts_description_site_language_id', 1, 'int')1275: }
1276: $this->setWhere("AND design_layouts_description.site_language_id = :design_layouts_description_site_language_id", SITE_LANGUAGE_ID, 'int');
1277: $this->setJoin("LEFT JOIN design_layouts_description ON design_layouts_description.design_layout_id = design_layouts.design_layout_id");
#20 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1274): RMasterModel->setWhere('AND design_layouts.status = :status', '1', 'string')1273: if ($status) {
1274: $this->setWhere("AND design_layouts.status = :status", '1', 'string');
1275: }
#21 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(1271): RMasterModel->setWhere('AND ( (design_layouts.products_id = :all_products_id AND design_layouts.products_type_id = :all_type_id) OR (design_layouts.products_id LIKE :products_id) OR ( design_layouts.products_type_id LIKE :products_type_id AND design_layouts.products_id = :all_products_id_zero ) ) ', Array, Array)1270: $productTypeId = getProductsType($productId);
1271: $this->setWhere("AND ( (design_layouts.products_id = :all_products_id AND design_layouts.products_type_id = :all_type_id) OR (design_layouts.products_id LIKE :products_id) OR ( design_layouts.products_type_id LIKE :products_type_id AND design_layouts.products_id = :all_products_id_zero ) ) ", array(":all_products_id" => "0", ":all_type_id" => '0', ":products_id" => "%,$productId,%", ":products_type_id" => "%$productTypeId%", ":all_products_id_zero" => "0"), array(":all_products_id" => "string", ":all_type_id" => "string", ":products_id" => "string", ":products_type_id" => "string", ":all_products_id_zero" => "string"));
1272: }
#22 /home/sl/public_html/studio/Services/Classes/StoreConfiguration.php(158): RMasterModel->setSelect('SUM(case when art_type = 'DL' then 1 else 0 end) AS total, SUM(case when art_type = 'WL' then 1 else 0 end) AS WLtotal')157:
158: $this->db->setSelect("SUM(case when art_type = 'DL' then 1 else 0 end) AS total, SUM(case when art_type = 'WL' then 1 else 0 end) AS WLtotal");
159: $designerLayouts = $this->db->getDesignLayouts(null, $this->params['pid']);
#23 /home/sl/public_html/lib/Classes/Models/RMasterModel.php(645): RMasterModel->setSelect('*')644: if (empty($this->buildQuery['select'])) {
645: $this->setSelect("*");
646: }
#24 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(153): RMasterModel->setOrderBy('SUBSTRING_INDEX( `studio_font_name` , '/', -1 ) ASC')152: if (isset($fontName)) $this->setWhere(" AND replace(LOWER(`studio_font_name`),' ','' ) = :font_name", $fontName, 'string');
153: $this->setOrderBy("SUBSTRING_INDEX( `studio_font_name` , '/', -1 ) ASC");
154: $this->setCache("studio_fonts");
#25 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(150): RMasterModel->setWhere(Array)149: if ($corporateId != '') {
150: $this->setWhere(getAccessObj()->getStoreAccess('site_studio_fonts', array('query_type' => 'C', 'user_type_id' => $userTypeId, 'corporate_id' => $corporateId, 'separator' => ',')));
151: }
#26 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(148): RMasterModel->setWhere(' AND status = :status', '1', 'string')147: $this->setFrom("site_studio_fonts");
148: $this->setWhere(" AND status = :status", "1", 'string');
149: if ($corporateId != '') {
#27 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(147): RMasterModel->setFrom('site_studio_fonts')146: {
147: $this->setFrom("site_studio_fonts");
148: $this->setWhere(" AND status = :status", "1", 'string');
#28 /home/sl/public_html/studio/Services/Classes/BaseClass.php(115): RMasterModel->setWhere('AND studio_font_type != :studio_font_type', '2', 'string')114: $userTypeId = (isset($this->params['user_type_id']) && !$this->isBlank($this->params['user_type_id'])) ? $this->params['user_type_id'] : getAccessObj()->getUserType();
115: $this->db->setWhere("AND studio_font_type != :studio_font_type", '2', "string");
116: $fontListArr = $this->db->getStudioFont(null, (string)$corporateId, $userTypeId);
#29 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(107): RMasterModel->setOrderBy('studio_configuration_product_setting.products_id, studio_configuration_product_setting.products_type_id, studio_configuration_product_setting.corporate_id')106: $this->setWhere(" AND ( IF( studio_configuration_setting.exclude_products_type IS NOT NULL AND studio_configuration_setting.exclude_products_type != '', studio_configuration_setting.exclude_products_type NOT LIKE :exclude_product_type, studio_configuration_setting.products_type IS NULL OR studio_configuration_setting.products_type = '' OR studio_configuration_setting.products_type LIKE :products_type OR studio_configuration_setting.products_type = :products_type_all) )", array(":exclude_product_type" => "%$product_type_id%", ":products_type" => "%$product_type_id%", ":products_type_all" => "-1"), array(":exclude_product_type" => 'string', ":products_type" => 'string', ":products_type_all" => 'string'));
107: $this->setOrderBy("studio_configuration_product_setting.products_id, studio_configuration_product_setting.products_type_id, studio_configuration_product_setting.corporate_id");
108: $this->setCache("studio_configuration_setting");
#30 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(106): RMasterModel->setWhere(' AND ( IF( studio_configuration_setting.exclude_products_type IS NOT NULL AND studio_configuration_setting.exclude_products_type != '', studio_configuration_setting.exclude_products_type NOT LIKE :exclude_product_type, studio_configuration_setting.products_type IS NULL OR studio_configuration_setting.products_type = '' OR studio_configuration_setting.products_type LIKE :products_type OR studio_configuration_setting.products_type = :products_type_all) )', Array, Array)105: }
106: $this->setWhere(" AND ( IF( studio_configuration_setting.exclude_products_type IS NOT NULL AND studio_configuration_setting.exclude_products_type != '', studio_configuration_setting.exclude_products_type NOT LIKE :exclude_product_type, studio_configuration_setting.products_type IS NULL OR studio_configuration_setting.products_type = '' OR studio_configuration_setting.products_type LIKE :products_type OR studio_configuration_setting.products_type = :products_type_all) )", array(":exclude_product_type" => "%$product_type_id%", ":products_type" => "%$product_type_id%", ":products_type_all" => "-1"), array(":exclude_product_type" => 'string', ":products_type" => 'string', ":products_type_all" => 'string'));
107: $this->setOrderBy("studio_configuration_product_setting.products_id, studio_configuration_product_setting.products_type_id, studio_configuration_product_setting.corporate_id");
#31 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(104): RMasterModel->setJoin(' AND studio_configuration_product_setting.corporate_id = :studio_configuration_product_setting_corporate_id_37182056220250311052629 ', Array, Array)103: $storeAccess = getAccessObj()->getStoreAccess('studio_configuration_product_setting', array('corporate_id' => (int)$storeID));
104: $this->setJoin($storeAccess[0], $storeAccess[1], $storeAccess[2]);
105: }
#32 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(102): RMasterModel->setJoin('LEFT JOIN studio_configuration_product_setting ON studio_configuration_setting.configuration_id = studio_configuration_product_setting.configuration_id AND ( IF(studio_configuration_product_setting.products_id != 0, studio_configuration_product_setting.products_id = :products_id, studio_configuration_product_setting.products_type_id =:products_type_id) )', Array, Array)101: } else {
102: $this->setJoin('LEFT JOIN studio_configuration_product_setting ON studio_configuration_setting.configuration_id = studio_configuration_product_setting.configuration_id AND ( IF(studio_configuration_product_setting.products_id != 0, studio_configuration_product_setting.products_id = :products_id, studio_configuration_product_setting.products_type_id =:products_type_id) )', array(':products_id' => $pid, ':products_type_id' => $product_type_id), array(':products_id' => 'int', ':products_type_id' => 'int'));
103: $storeAccess = getAccessObj()->getStoreAccess('studio_configuration_product_setting', array('corporate_id' => (int)$storeID));
#33 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(81): RMasterModel->setFrom('studio_configuration_setting')80: $this->setSelect("*,IF(studio_configuration_product_setting.value != '' ,studio_configuration_product_setting.value,studio_configuration_setting.value) as value");
81: $this->setFrom("studio_configuration_setting");
82: if (!empty($storeID)) {
#34 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(80): RMasterModel->setSelect('*,IF(studio_configuration_product_setting.value != '' ,studio_configuration_product_setting.value,studio_configuration_setting.value) as value')79: $product_type_id = getProductsType($pid); // To get product type id
80: $this->setSelect("*,IF(studio_configuration_product_setting.value != '' ,studio_configuration_product_setting.value,studio_configuration_setting.value) as value");
81: $this->setFrom("studio_configuration_setting");
#35 /home/sl/public_html/lib/Classes/Models/RMasterModel.php(195): RMasterModel->resetVariables()194: }
195: $this->resetVariables();
196: } catch (Exception $e) {
#36 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(66): RMasterModel->setFoundRows()65: $this->setCustomQuery($Query, $this->getCustomParams(), $this->getCustomTypes());
66: $this->setFoundRows();
67: $this->setCache("studio_language_text");
#37 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(65): RMasterModel->setCustomQuery('SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT studio_language_text.constant_name,studio_language_text_description.constant_value,studio_language_text_description.studio_language_text_id , Concat(studio_language_text_description.studio_language_text_id, IF(studio_language_text_description.corporate_id = -1, 2, IF(studio_language_text_description.corporate_id != 0 AND studio_language_text_description.corporate_id = 0, 1, 0))) AS corporateid, studio_language_text_description.corporate_id , Concat(studio_language_text_description.studio_language_text_id, IF(studio_language_text_description.products_type_id = 1, 1, 0)) AS type_id FROM studio_language_text LEFT JOIN studio_language_text_description ON studio_language_text_description.studio_language_text_id = studio_language_text.studio_language_text_id AND studio_language_text_description.site_language_id=:scd_site_language_id WHERE 1 AND studio_language_text_description.corporate_id = :studio_language_text_description_corporate_id_24663662420250311052629 GROUP BY corporateid , type_id ORDER BY corporateid DESC, type_id DESC) AS studio_language_text_description GROUP BY studio_language_text_description.studio_language_text_id ', Array, Array)64: $Query = "SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT " . $fields . " FROM studio_language_text " . $joinCond . " WHERE 1 " . $whereCond . " GROUP BY corporateid " . $group_by . $orderByString . ") AS studio_language_text_description GROUP BY studio_language_text_description.studio_language_text_id " . $limitString;
65: $this->setCustomQuery($Query, $this->getCustomParams(), $this->getCustomTypes());
66: $this->setFoundRows();
#38 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(65): RMasterModel->getCustomTypes()64: $Query = "SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT " . $fields . " FROM studio_language_text " . $joinCond . " WHERE 1 " . $whereCond . " GROUP BY corporateid " . $group_by . $orderByString . ") AS studio_language_text_description GROUP BY studio_language_text_description.studio_language_text_id " . $limitString;
65: $this->setCustomQuery($Query, $this->getCustomParams(), $this->getCustomTypes());
66: $this->setFoundRows();
#39 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(65): RMasterModel->getCustomParams()64: $Query = "SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT " . $fields . " FROM studio_language_text " . $joinCond . " WHERE 1 " . $whereCond . " GROUP BY corporateid " . $group_by . $orderByString . ") AS studio_language_text_description GROUP BY studio_language_text_description.studio_language_text_id " . $limitString;
65: $this->setCustomQuery($Query, $this->getCustomParams(), $this->getCustomTypes());
66: $this->setFoundRows();
#40 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(61): RMasterModel->setCustomParams(Array, Array)60: $joinCond .= " AND studio_language_text_description.site_language_id=:scd_site_language_id";
61: $this->setCustomParams(array(':scd_site_language_id' => SITE_LANGUAGE_ID), array(':scd_site_language_id' => 'int'));
62: }
#41 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(46): RMasterModel->setCustomParams(Array, Array)45: $parentStoreID = getAccessObj()->getParentStoreID();
46: $this->setCustomParams(array('@studio_language_text_descriptioncid0' => array($corporateid, $parentStoreID), ':studio_language_text_description_products_type_id' => $predefinedProductId, ':studio_language_text_description_type_id' => $predefinedProductId), array('@studio_language_text_descriptioncid0' => 'int', ':studio_language_text_description_products_type_id' => 'int', ':studio_language_text_description_type_id' => 'int'));
47:
#42 /home/sl/public_html/studio/Services/Lib/DesignerMaster.php(32): RMasterModel->setCustomParams(Array, Array)31: $whereCond .= $storeAccess[0];
32: $this->setCustomParams($storeAccess[1], $storeAccess[2]);
33: }