เมื่อเช้าตื่นมามีลูกค้าแจ้งมาว่า เว็บมีปัญหาเลยเข้าไปดู ผมได้ตรวจเช็คเว็บอื่นใน host ก็ไม่มีปัญหา เว็บผมหน้าpage มีปัญหาที่หน้า page ส่วนหน้าสินค้ายังเข้าได้ปรกติ ได้ไปเช็ค errer file มันขึ้นแบบนี้ ต้องไปแก้ที่ไหนครับ
SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_int` AS `default`
LEFT JOIN `catalog_product_entity_int` AS `store` ON store.attribute_id=default.attribute_id
AND store.entity_id=default.entity_id
AND store.store_id=1 WHERE (default.entity_type_id=4) AND (default.entity_id in (68, 255, 250, 70, 206, 75, 71, 532, 65, 460, 517, 344, 262, 665, 473, 808, 761, 420, 230, 561, 776, 231, 817, 770, 990)) AND (default.attribute_id in ('80', '109', '120', '89', '119', '116', '70', '78', '111', '114', '115', '112', '85', '91', '113')) AND (default.store_id = 0) UNION SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_decimal` AS `default`
LEFT JOIN `catalog_product_entity_decimal` AS `store` ON store.attribute_id=default.attribute_id
AND store.entity_id=default.entity_id
AND store.store_id=1 WHERE (default.entity_type_id=4) AND (default.entity_id in (68, 255, 250, 70, 206, 75, 71, 532, 65, 460, 517, 344, 262, 665, 473, 808, 761, 420, 230, 561, 776, 231, 817, 770, 990)) AND (default.attribute_id in ('68', '88', '64', '65', '79', '69')) AND (default.store_id = 0) UNION SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_varchar` AS `default`
LEFT JOIN `catalog_product_entity_varchar` AS `store` ON store.attribute_id=default.attribute_id
AND store.entity_id=default.entity_id
AND store.store_id=1 WHERE (default.entity_type_id=4) AND (default.entity_id in (68, 255, 250, 70, 206, 75, 71, 532, 65, 460, 517, 344, 262, 665, 473, 808, 761, 420, 230, 561, 776, 231, 817, 770, 990)) AND (default.attribute_id in ('92', '83', '110', '74', '100', '118', '77', '73', '71', '60', '97', '96', '117', '75', '101', '76', '102', '86', '87')) AND (default.store_id = 0) UNION SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_datetime` AS `default`
LEFT JOIN `catalog_product_entity_datetime` AS `store` ON store.attribute_id=default.attribute_id
AND store.entity_id=default.entity_id
AND store.store_id=1 WHERE (default.entity_type_id=4) AND (default.entity_id in (68, 255, 250, 70, 206, 75, 71, 532, 65, 460, 517, 344, 262, 665, 473, 808, 761, 420, 230, 561, 776, 231, 817, 770, 990)) AND (default.attribute_id in ('93', '94', '81', '82', '66', '67')) AND (default.store_id = 0) UNION SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_text` AS `default`
LEFT JOIN `catalog_product_entity_text` AS `store` ON store.attribute_id=default.attribute_id
AND store.entity_id=default.entity_id
AND store.store_id=1 WHERE (default.entity_type_id=4) AND (default.entity_id in (68, 255, 250, 70, 206, 75, 71, 532, 65, 460, 517, 344, 262, 665, 473, 808, 761, 420, 230, 561, 776, 231, 817, 770, 990)) AND (default.attribute_id in ('95', '61', '72', '90', '62')) AND (default.store_id = 0)
Trace:
#0 /home/breastpu/domains/sandyminishop.com/public_html/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/breastpu/domains/sandyminishop.com/public_html/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /home/breastpu/domains/sandyminishop.com/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `default...', Array)
#3 /home/breastpu/domains/sandyminishop.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `default...', Array)
#4 /home/breastpu/domains/sandyminishop.com/public_html/lib/Zend/Db/Adapter/Abstract.php(706): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `default...', Array)
#5 /home/breastpu/domains/sandyminishop.com/public_html/lib/Varien/Data/Collection/Db.php(724): Zend_Db_Adapter_Abstract->fetchAll('SELECT `default...', Array)
#6 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1007): Varien_Data_Collection_Db->_fetchAll('SELECT `default...')
#7 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Collection.php(314): Mage_Eav_Model_Entity_Collection_Abstract->_loadAttributes(false, false)
#8 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(797): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection->_loadAttributes(false, false)
#9 /home/breastpu/domains/sandyminishop.com/public_html/app/code/local/Luxe/MostViewed/Block/List.php(55): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Catalog/Block/Product/List.php(145): Luxe_MostViewed_Block_List->_getProductCollection()
#11 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(757): Mage_Catalog_Block_Product_List->_beforeToHtml()
#12 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Model/Email/Template/Filter.php(191): Mage_Core_Block_Abstract->toHtml()
#13 /home/breastpu/domains/sandyminishop.com/public_html/lib/Varien/Filter/Template.php(134): Mage_Core_Model_Email_Template_Filter->blockDirective(Array)
#14 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Model/Email/Template/Filter.php(502): Varien_Filter_Template->filter(Array, Array)
#15 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Cms/Block/Widget/Block.php(54): Mage_Core_Model_Email_Template_Filter->filter('<div class="tab...')
#16 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(757): Mage_Cms_Block_Widget_Block->_beforeToHtml('<div class="tab...')
#17 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Widget/Model/Template/Filter.php(76): Mage_Core_Block_Abstract->toHtml()
#18 /home/breastpu/domains/sandyminishop.com/public_html/lib/Varien/Filter/Template.php(134): Mage_Widget_Model_Template_Filter->widgetDirective()
#19 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Model/Email/Template/Filter.php(502): Varien_Filter_Template->filter(Array)
#20 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Cms/Block/Page.php(100): Mage_Core_Model_Email_Template_Filter->filter(Array, Array)
#21 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Cms_Block_Page->_toHtml('<div class="ind...')
#22 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(525): Mage_Core_Block_Abstract->toHtml('<div class="ind...')
#23 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(472): Mage_Core_Block_Abstract->_getChildHtml()
#24 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Page/Block/Html/Wrapper.php(52): Mage_Core_Block_Abstract->getChildHtml()
#25 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Page_Block_Html_Wrapper->_toHtml('cms_page', true)
#26 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml('', true, true)
#27 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Core_Block_Text_List->_toHtml()
#28 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(525): Mage_Core_Block_Abstract->toHtml()
#29 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(476): Mage_Core_Block_Abstract->_getChildHtml()
#30 /home/breastpu/domains/sandyminishop.com/public_html/app/design/frontend/default/sandy/template/page/1column.phtml(48): Mage_Core_Block_Abstract->getChildHtml()
#31 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Template.php(216): include('/home/breastpu/...')
#32 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Template.php(247): Mage_Core_Block_Template->fetchView('content', true)
#33 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Template.php(261): Mage_Core_Block_Template->renderView('content')
#34 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Core_Block_Template->_toHtml('frontend/defaul...')
#35 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Model/Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#36 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(389): Mage_Core_Model_Layout->getOutput()
#37 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Cms/Helper/Page.php(130): Mage_Core_Controller_Varien_Action->renderLayout()
#38 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage()
#39 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage()
#40 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction(Object(Mage_Cms_IndexController), 'mainpage')
#41 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch(Object(Mage_Cms_IndexController), 'mainpage')
#42 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match()
#43 /home/breastpu/domains/sandyminishop.com/public_html/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch('index')
#44 /home/breastpu/domains/sandyminishop.com/public_html/app/Mage.php(596): Mage_Core_Model_App->run(Object(Mage_Core_Controller_Request_Http))
#45 /home/breastpu/domains/sandyminishop.com/public_html/index.php(80): Mage::run()
#46 {main}
พัฒนาเว็บไซต์
