id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	blockedby	blocking
1938	SQL-Fehler in checkout_process.php	Volker Strähle	somebody	"checkout_process.php:

{{{
298	    $specials_query = xtc_db_query(""SELECT products_id,
299	                                           specials_quantity
300	                                      FROM "".TABLE_SPECIALS.""
301	                                     WHERE products_id = '"".xtc_get_prid($order->products[$i]['id']).""'
302	                                           "".SPECIALS_CONDITIONS);
}}}

Die Konstante SPECIALS_CONDITIONS kann die Spaltenangabe s.status beinhalten. Das führt zu einem Fehler.

Es sollte heißen:

{{{
298	    $specials_query = xtc_db_query(""SELECT s.products_id,
299	                                           s.specials_quantity
300	                                      FROM "".TABLE_SPECIALS."" s
301	                                     WHERE s.products_id = '"".xtc_get_prid($order->products[$i]['id']).""'
302	                                           "".SPECIALS_CONDITIONS);
}}}

Man muss aber noch kontrolleiren ob es auch SPECIAL_CONDITIONS ohne ""s."" gibt."	Bug/Fehler	closed	normal		Shop	trunk	invalid