0004967: Problem while assigning products to categories

ID	Project	Category	View Status	Date Submitted	Last Update

0004967	OXID eShop (all versions)	2.4. Administer products	public	2013-02-27 11:06	2013-03-08 10:25

Reporter	mr_dimson	Assigned To
Priority	normal	Severity	minor	Reproducibility	always
Status	resolved	Resolution	fixed
Product Version	4.6.6 revision 54646
Target Version	4.7.4 / 5.0.4 revision 57063	Fixed in Version	4.7.4 / 5.0.4 revision 57063

Summary	0004967: Problem while assigning products to categories
Description	There's a problem with assigning products to categories - only categories with OXPRICETO=0 are shown in the select list. In application/controllers/admin/article_extend_ajax.php, line 72: $sQAdd .= " where $sO2CView.oxobjectid = " . $oDb->quote( $sSynchOxid ) . " and $sCategoriesTable.oxid is not null ) and $sCategoriesTable.oxpriceto = '0'";
Tags	Category, Products
Attached Files	snapshot14.png (58,285 bytes) snapshot14.png (58,285 bytes)

Theme	Both
Browser	All
PHP Version	any
Database Version	any

leofonic 2013-02-28 14:18 reporter ~0008462	maybe duplicate of 0004486

Linas Kukulskis 2013-03-06 15:26 reporter ~0008480	added additional check on category save: if oxpriceto and oxpricefrom is empty set to 0. .... and $sCategoriesTable.oxpriceto = '0'"; - is used to escape of price categories they should not have any article. please check your db if there are null values on this field update to 0. this part is related with 0004486 fix.