Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

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.

 
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

 
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

 
Magento Community Magento Community
Magento Community
Magento Community
 
_ADS_
Jr. Member
 
Total Posts:  15
Joined:  2008-12-02
 
jekab - 16 April 2010 04: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

 
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";}
 
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

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top