I did not get what to do please explain something more broadly
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `a`.`sort_order`, (CASE WHEN (a.sort_order = 1) THEN Yes ELSE No END) AS `sel_vendor` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '5' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `eav_attribute_option` AS `a` ON e.manufacturer = a.option_id ORDER BY `cat_index`.`position` asc, sel_vendor DESC
Get your e-commerce health checkup at http://ecommerce.fitness
My local.xml is not in this address :-(
Most of the time it is cause by broken database connection especially at local server, when one forget to start XAMPP or WAMPP server,
[enter image description here][1]
**solution -1** :- Rename pub/local.xml.sample into local.xml or pub/local.xml into local.xml.sample if this no work then try solution 2
solution 2 :- [go to php.ini file and increase max_execution time and fresh install magento confirm issue resolved][2]
[1]: https://i.stack.imgur.com/UmgJ8.png
[2]: https://www.youtube.com/watch?v=jqJOohTRCgE&t=1s
i have some problem,, can u explain step by step how to change ?
thx
@Sinisa wrote:SQLSTATE[28000] [1045] Access denied for user 'notascratch'@'localhost' (using password: YES)Your database credentials are not good. Update database host, username, password and database name in app/etc/local.xml .
i just got same issue, can u explain step by step how to update database ?
Error in HTTP request
#0 /home1/website_name/public_html/lib/Zend/Oauth/Http/RequestToken.php(51): Zend_Oauth_Http->startRequestCycle(Array) |
#1 /home1/website_name/public_html/lib/Zend/Oauth/Consumer.php(115): Zend_Oauth_Http_RequestToken->execute() |
#2 /home1/website_name/public_html/app/code/local/Magestore/Sociallogin/controllers/TwloginController.php(167): Zend_Oauth_Consumer->getRequestToken() |
#3 /home1/website_name/public_html/app/code/local/Magestore/Sociallogin/controllers/TwloginController.php(35): Magestore_Sociallogin_TwloginController->getAuthorization() |
#4 /home1/website_name/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Magestore_Sociallogin_TwloginController->loginAction() |
#5 /home1/website_name/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('login') |
#6 /home1/website_name/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) |
#7 /home1/website_name/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() |
#8 /home1/website_name/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) |
#9 /home1/website_name/public_html/index.php(83): Mage::run('', 'store') |
what does this message saying it is too complicated to understand
SELECT `e`.*, `relation`.`product_id`, `relation`.`store_id` AS `item_store_id`, `t`.`tag_id`, `t`.`status` AS `tag_status`, `t`.`name` AS `tag_name`, IF(t.first_store_id = 0, relation.store_id, t.first_store_id) AS `store_id` FROM `catalog_product_entity` AS `e`
INNER JOIN `tag_relation` AS `relation` ON relation.product_id = e.entity_id
INNER JOIN `tag` AS `t` ON t.tag_id = relation.tag_id WHERE (relation.store_id IN ('1')) AND (relation.customer_id IN('11067')) AND (relation.active = 1) GROUP BY `e`.`entity_id` ORDER BY `e`.`relation`.`tag_relation_id` DESC LIMIT 5
Am also facing this same issue. I just remove the cache folder and run again. It working fine for me...