cancel
Showing results for 
Search instead for 
Did you mean: 

Cardinality violation at some products

Cardinality violation at some products

Hello,

i am new here, and at first i would like to say hello to everybody in this great forum. It was often helping me out. I hope i can explain in correct words what is my problem. English is not my native language. So, please excuse some faults.

 

Now to my problem:

I have on a new shop with some products a strange problem. My error is:

 

SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s), query was: SELECT `lomag_catalog_category_flat_store_1`.* FROM `lomag_catalog_category_flat_store_1` WHERE (`lomag_catalog_category_flat_store_1`.`entity_id`='449', '982')

I have checked google hours over hours. Have reimported the product. Tried to reindex everything. Clear Cache. Nothing helps, i can´t find a solution. I just appears on some products. At all others everything is fine. 

 

I have Magento 1.9.1 installed and buyshop theme and Scp. All products was integrated by a script.

 

But all looks fine. I cant find duplicated attributes or anything else at this product. 

 

Hope somebody has a helping idear for me.

 

Here is the trace of the error:

 

Trace:
#0 /var/www/vhosts/testserver.de/mag.testserver.de/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/testserver.de/mag.testserver.de/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/testserver.de/mag.testserver.de/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `lomag_c...', Array)
#4 /var/www/vhosts/testserver.de/mag.testserver.de/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `lomag_c...', Array)
#5 /var/www/vhosts/testserver.de/mag.testserver.de/lib/Zend/Db/Adapter/Abstract.php(756): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(380): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#7 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Model/Abstract.php(225): Mage_Core_Model_Resource_Db_Abstract->load(Object(Mage_Catalog_Model_Category), Array, NULL)
#8 /var/www/vhosts/testserver.de/mag.testserver.de/app/design/frontend/lampenonline/default/template/catalog/product/list/upsell.phtml(89): Mage_Core_Model_Abstract->load(Array)
#9 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(241): include('/var/www/vhosts...')
#10 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/lampen...')
#11 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#12 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#13 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#14 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('upsell_products', true)
#15 /var/www/vhosts/testserver.de/mag.testserver.de/app/design/frontend/lampenonline/default/template/catalog/product/view.phtml(539): Mage_Core_Block_Abstract->getChildHtml('upsell_products')
#16 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(241): include('/var/www/vhosts...')
#17 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/lampen...')
#18 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#19 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#20 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#21 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
#22 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#23 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#24 /var/www/vhosts/testserver.de/mag.testserver.de/app/design/frontend/buyshop/default/template/page/1column.phtml(51): Mage_Core_Block_Abstract->getChildHtml('content')
#25 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(241): include('/var/www/vhosts...')
#26 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/buysho...')
#27 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#28 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#29 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#30 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#31 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Cms/controllers/IndexController.php(91): Mage_Core_Controller_Varien_Action->renderLayout()
#32 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->defaultNoRouteAction()
#33 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('defaultNoRoute')
#34 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#35 /var/www/vhosts/testserver.de/mag.testserver.de/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#36 /var/www/vhosts/testserver.de/mag.testserver.de/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#37 /var/www/vhosts/testserver.de/mag.testserver.de/index.php(88): Mage::run('', 'store')

1 REPLY

Re: Cardinality violation at some products

Hi @Shopynativ

 

Please take backup of your website first and try to run the compilation. It will most likely to fix the issue.

 

Let me know if it doesn't



Problem solved? Click Accept as Solution!