id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	blockedby	blocking
2275	Fehler in SQL Query in cart_actions.php	Stefan May <stefan.may@…>	somebody	"Code in /includes/cart_actions.php ab Zeile 385:

{{{
              $check_query = xtc_db_query(""SELECT COUNT(*) AS cnt, 
                                                  SUM(IF(ISNULL(po.products_options_values_id), 0, 1)) AS checksum 
                                             FROM "".TABLE_ORDERS_PRODUCTS_ATTRIBUTES."" opa 
                                        LEFT JOIN "".TABLE_PRODUCTS_OPTIONS_VALUES."" as pov
                                                  ON opa.orders_products_options_values_id = pov.products_options_values_id 
                                                     AND pov.language_id = "".(int)$_SESSION['languages_id']."" 
                                                     AND pov.products_options_values_id > 0 
                                            WHERE opa.orders_products_id = "".(int)$order_data['ORDERS_PRODUCTS_ID']);
}}}

Die angesprochene Tabelle ""po"" in po.products_options_values_id sollte wahrscheinlich ""pov"" (für Tabelle products_options_values) sein.
Korrigiert:

{{{
              $check_query = xtc_db_query(""SELECT COUNT(*) AS cnt, 
                                                  SUM(IF(ISNULL(pov.products_options_values_id), 0, 1)) AS checksum 
                                             FROM "".TABLE_ORDERS_PRODUCTS_ATTRIBUTES."" opa 
                                        LEFT JOIN "".TABLE_PRODUCTS_OPTIONS_VALUES."" as pov
                                                  ON opa.orders_products_options_values_id = pov.products_options_values_id 
                                                     AND pov.language_id = "".(int)$_SESSION['languages_id']."" 
                                                     AND pov.products_options_values_id > 0 
                                            WHERE opa.orders_products_id = "".(int)$order_data['ORDERS_PRODUCTS_ID']);
}}}
"	Bug/Fehler	closed	normal	modified-shop-2.0.8.0	Shop	2.0.7.2	fixed