Post by calebthegeek » Fri Aug 31, 2012 4:54 am

Howdy! I just started working with opencart and I have spent some time digging around and can't get this figured out. When I view certain orders in the backend I get the error below - not all of them (and for whatever reason I can edit all orders). Any thoughts on what could be causing this? Thanks in advance for all your help!

Error: Subquery returns more than 1 row
Error No: 1242
select concat(op.model, '-', IFNULL((select a.attachment_code from attachments a, option_value_description ovd, product_option_value pov, order_option oo where a.attachment_type = ovd.name and ovd.option_value_id = pov.option_value_id and oo.product_option_value_id = pov.product_option_value_id and oo.order_product_id = op.order_product_id and ovd.option_id = 16), 1), '-', (select ca.code from color_acronyms ca, option_value_description ovd, product_option_value pov, order_option oo where ca.`Color Description` = ovd.name and ovd.option_value_id = pov.option_value_id and oo.product_option_value_id = pov.product_option_value_id and oo.order_product_id = op.order_product_id and ovd.option_id = 21)) as SKU from order_product op where op.order_product_id = 268

Newbie

Posts

Joined
Fri Aug 31, 2012 4:52 am

Post by Avvici » Fri Aug 31, 2012 12:09 pm

This error means what it says. There is a table that is returning more than one of the same values at a time. For example if it was your seo_url table you could have category_id = 58 twice and it would return that identical error.

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC
Who is online

Users browsing this forum: No registered users and 92 guests