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

Problems with more than one Product in Cart
 
DMSD24
Jr. Member
 
Avatar
Total Posts:  3
Joined:  2011-10-17
 

Hi,

i got some trouble with the shop i\’m currently developing.
If i add more then one Product into cart, no product-page will be displayed anymore, everything else keep working.
If i remove the Products from cart except one or even all, Product-Pages work well again.

In the exception-log i find the following:

2012-01-19T17:40:25+00:00 ERR (3): 
exception \'PDOException\' with message \'SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row\' in /srv/www/vhosts/testsolardirekt24.de/httpdocs/lib/Zend/Db/Statement/Pdo.php:228

Next exception \
'Zend_Db_Statement_Exception\' with message \'SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row\' in /srv/www/vhosts/testsolardirekt24.de/httpdocs/lib/Zend/Db/Statement/Pdo.php:234
Stack trace
:

Version is the current stable 1.6.2.0

Has anyone a solution for this?
Thank u

 
Magento Community Magento Community
Magento Community
Magento Community
 
luciddreams
Jr. Member
 
Avatar
Total Posts:  23
Joined:  2011-08-25
 

Can You paste whole call stack?

 
Magento Community Magento Community
Magento Community
Magento Community
 
DMSD24
Jr. Member
 
Avatar
Total Posts:  3
Joined:  2011-10-17
 

Thank u for your replay!

attached is the whole Stack.

File Attachments
exception.txt  (File Size: 13KB - Downloads: 114)
 
Magento Community Magento Community
Magento Community
Magento Community
 
DMSD24
Jr. Member
 
Avatar
Total Posts:  3
Joined:  2011-10-17
 

somebody can help?

 
Magento Community Magento Community
Magento Community
Magento Community
 
guillemweb
Jr. Member
 
Total Posts:  8
Joined:  2011-09-05
 

I have the same problem

exception ‘PDOException’ with message ‘SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row’ in /********/lib/Zend/Db/Statement/Pdo.php:228

In my case, I have grouped products and crashed when I add three different products.

Thanks!!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
bjgray
Jr. Member
 
Total Posts:  3
Joined:  2011-12-20
 

Same problem. Desperately searching for a solution to this.

 
Magento Community Magento Community
Magento Community
Magento Community
 
guillemweb
Jr. Member
 
Total Posts:  8
Joined:  2011-09-05
 

I only solved this problem updating my VPS or with other hostings. Try to upload your magento in other hosting, probably you solved this problem.

Good luck!

 
Magento Community Magento Community
Magento Community
Magento Community
 
techgolazo
Jr. Member
 
Total Posts:  5
Joined:  2012-11-13
 

has this issue ever been solved ?

I’m running in exactly the same.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Narly
Jr. Member
 
Total Posts:  11
Joined:  2009-01-10
 

bump, Any solution to this?

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