Hi,
i currently face the followin issue: Testing the following sql statement which is also used in SOLR (DIH) leads to a wrong categorization in solr: select p.title as title, p.id, p.category_id, p.pic_thumb, c.name as category, c.id as category_id from product p, category c WHERE p.category_id = c.id AND p.id = 3091328 This returns in my sql client: Apple MacBook Pro MD313D/A 33,8 cm (13,3 Zoll) Notebook (Intel Core i5-2435M, 2,4GHz, 4GB RAM, 500GB HDD, Intel HD 3000, Mac OS), 3091328, 1003, http://m-d.ww.cdn.com/images/I/41teWbp-uAL._SL75_.jpg, Computer, 1003 As you see, the categoryid 1003 points to "Computer" Via the solr searchadmin i get the following result when searchgin for id:3091328 <str name="category">Sport</str> <int name="category_id">1003</int> Which is wrong. ID 1003 points to the correct category name "Computer" in my sql client Does anyone knows what's going wrong here? I'm using solr 3.5 on a tomcat 6 Thanks, Ramo
