Last Query :

SELECT site_language_id, site_language_name, shortname, studio_font_id FROM site_language WHERE status = '1'

Prepared Statement :

SELECT site_language_id, site_language_name, shortname, studio_font_id FROM site_language WHERE status = :status

Params: Array
(
    [:status] => 1
)

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:         }

 
[11-03-2025 05:26:29 UTC] [11-03-2025 05:26:29 UTC] [ERROR] : [PDOException, 42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'studio_font_id' in 'SELECT' @line 113 in file /home/sl/public_html/lib/Classes/Data/RDataConnection.php
/product_design_customize.php?pid=9 
 

#1 RDataConnection.php:113 -- PDO->prepare()
#2 RMasterModel.php:182 -- RDataConnection->Execute()
#3 CorporateProductsTrait.php:344 -- RMasterModel->exec_query()
#4 DesignerMaster.php:1745 -- DesignerMaster->exec_query()
#5 StoreConfiguration.php:447 -- DesignerMaster->getSiteLanguages()
#6 StoreConfiguration.php:78 -- StoreConfiguration->siteLanguages()
#7 Configuration.php:40 -- StoreConfiguration->index()
#8 direct.php:20 -- Configuration->index()
#9 product_design_customize.php:47 -- directCall()