Try the Demo

Magento

Magento Forum

   
products not showing to NOT LOGGED IN !! once logged in no problems. 
 
Marcin85
Member
 
Avatar
Total Posts:  48
Joined:  2009-10-23
Worcester
 

I have problem like in topic:
all products are not showing to NOT LOGGED IN !! once logged in no problems - everythink is in right place.

Please help.

 Signature 

sukienki wieczorowe
Sklep z sukienkami wieczorowymi i pięknymi sukniami ślubnymi.

 
 
Posted: March 27 2010
   |  top
 
Magento Community Magento Community
Magento Community
Magento Community
 
Marcin85
Member
 
Avatar
Total Posts:  48
Joined:  2009-10-23
Worcester
 

Fixed by editing database in “customer_group” table, “customer_group_id” value should be “0” for “NOT LOGGED IN” customer group

 Signature 

sukienki wieczorowe
Sklep z sukienkami wieczorowymi i pięknymi sukniami ślubnymi.

 
 
Posted: April 1 2010
   |  top  |  # 1 
 
Magento Community Magento Community
Magento Community
Magento Community
 
jekab
Jr. Member
 
Total Posts:  14
Joined:  2007-09-10
 

Related issue is with 3 other tables:

Next four records MUST HAVE id = 0 (zero) in primary key field:

WHERE:

core_store.code=\’admin\’

core_website.code=\’admin\’

core_store_group.name=\’Default\’

customer_group.customer_group_code=\’NOT LOGGED IN\’

 
 
Posted: April 16 2010
   |  top  |  # 2 
 
Magento Community Magento Community
Magento Community
Magento Community
 
zemang
Jr. Member
 
Total Posts:  5
Joined:  2010-12-21
 

sorry to interup. this solves my problem and what really happened is i removed the qaaaa group in the manage customer group.before editing the database table, name a new group in the customer manager then go to the database in the customer_group table, renaming it to NOT LOGGED IN and setting the value to 0.it worked just fine.

Just to remind everyone, never delete the qaaaa customer group seems that will cause the bug.

Hope this will help.
zemang

 
 
Posted: December 28 2010
   |  top  |  # 3 
 
Magento Community Magento Community
Magento Community
Magento Community
 
_ADS_
Jr. Member
 
Total Posts:  15
Joined:  2008-12-02
 
jekab - 16 April 2010 05:17 AM

Related issue is with 3 other tables:

Next four records MUST HAVE id = 0 (zero) in primary key field:

WHERE:

core_store.code=\’admin\’

core_website.code=\’admin\’

core_store_group.name=\’Default\’

customer_group.customer_group_code=\’NOT LOGGED IN\’

This worked for me, 10x

 
 
Posted: August 30 2011
   |  top  |  # 4 
 
Magento Community Magento Community
Magento Community
Magento Community
 
HighKickX
Jr. Member
 
Total Posts:  1
Joined:  2011-02-28
 

I have a similar problem : I can see a product page when customer logged out but not when he is logged in. Otherwise everything seems to be ok.

Tables :

core_store :

store_id    cod    website_id    group_id    name    sort_order    is_active
0    admin    0    0    Admin    0    1
1    default    1    1    Default Store View    0    1




core_store_group :

group_id    website_id    name    root_category_id    default_store_id
0    0    Default    0    0
1    1    Main Website Store    2    1


core_website :

website_id    code    name    sort_order    default_group_id    is_default
0    admin    Admin    0    0    0
1    base    Main Website    0    1    1


customer_group :

customer_group_id    customer_group_code    tax_class_id
0    NOT LOGGED IN    3
1    General    3
2    Wholesale    3
3    Retailer    3

Error log :

a:5:{i:0;s:77:"SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row";i:1;s:6638:"#0 lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(DI...', Array)
#4 lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(DI...', Array)
#5 lib/Zend/Db/Adapter/Abstract.php(825): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 lib/Varien/Data/Collection/Db.php(217): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()
#8 lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()
#9 app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(996): Varien_Data_Collection->getCurPage()
#10 app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(831): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#11 app/code/core/Mage/Catalog/Block/Product/List/Upsell.php(74): Mage_Eav_Model_Entity_Collection_Abstract->load()
#12 app/code/core/Mage/Catalog/Block/Product/List/Upsell.php(94): Mage_Catalog_Block_Product_List_Upsell->_prepareData()
#13 app/code/core/Mage/Core/Block/Abstract.php(862): Mage_Catalog_Block_Product_List_Upsell->_beforeToHtml()
#14 app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#15 app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml('upsell_products', true)
#16 app/design/frontend/base/default/template/catalog/product/view.phtml(155): Mage_Core_Block_Abstract->getChildHtml('upsell_products')
#17 app/code/core/Mage/Core/Block/Template.php(241): include('/var/www/vhosts...')
#18 app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/base/d...')
#19 app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#20 app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#21 app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#22 app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#23 app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#24 app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#25 app/design/frontend/base/default/template/page/2columns-right.phtml(48): Mage_Core_Block_Abstract->getChildHtml('content')
#26 app/code/core/Mage/Core/Block/Template.php(241): include('/var/www/vhosts...')
#27 app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/base/d...')
#28 app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#29 app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#30 app/code/core/Mage/Core/Model/Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#31 app/code/core/Mage/Core/Controller/Varien/Action.php(391): Mage_Core_Model_Layout->getOutput()
#32 app/code/core/Mage/Cms/Helper/Page.php(132): Mage_Core_Controller_Varien_Action->renderLayout()
#33 app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'no-route')
#34 app/code/core/Mage/Cms/controllers/IndexController.php(75): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'no-route')
#35 app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Cms_IndexController->noRouteAction()
#36 app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('noRoute')
#37 app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#38 app/code/core/Mage/Core/Model/App.php(347): Mage_Core_Controller_Varien_Front->dispatch()
#39 app/Mage.php(640): Mage_Core_Model_App->run(Array)
#40 index.php(80): Mage::run('', 'store')
#41 {main}";s:3:"url";s:25:"/basics-blenders-textures";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

 
 
Posted: November 20 2011
   |  top  |  # 5 
 
Magento Community Magento Community
Magento Community
Magento Community
 
Paulmobba
Jr. Member
 
Total Posts:  20
Joined:  2010-03-10
 

Hi did you ever solve this, I am having the same problem, customers who are logged in can’t view products but they show up fine for non logged in customers.

Thanks
Paul

 Signature 

Instagram Printing

 
 
Posted: July 16 2012
   |  top  |  # 6 
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
Missing attribute fields from Manage Products
pager-top pager-bottom css formatting on site map page