Products not showing in backoffice, but still online on front page

[jorzech]

Hi.

 

It goes from one problem to another.

I have successfully importet my 6000 products (it was a lot of work and really had a strain on me nerves)

 

Now i have the following Problem:
only 93 products are showing in my BO products catalog.

even if i make a new product in the backoffice, it does not show there but stays online on the front page... 

 

 

Indexing is done.

Debug mode does not give me any readings on Symfony Profiler except: 

"request    Matched route "admin_product_catalog"."

and:

"User Deprecated: The "logger" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead."
 

 

 

 

I hope someone can help.

 

 

 

[jorzech]

also i am a total noob with debug mode, it did not give me any helpful info whenever i used it...

[jorzech]

i have found the issue, but dont know how to resolve it.

The products are only from one Category, because the SQL inquiry says this:

"SELECT SQL_CALC_FOUND_ROWS p.`id_product`  AS `id_product`,
 p.`reference`  AS `reference`,
 p.`price`  AS `price`,
 p.`id_shop_default`  AS `id_shop_default`,
 p.`is_virtual`  AS `is_virtual`,
 pl.`name`  AS `name`,
 pl.`link_rewrite`  AS `link_rewrite`,
 sa.`active`  AS `active`,
 shop.`name`  AS `shopname`,
 image_shop.`id_image`  AS `id_image`,
 cl.`name`  AS `name_category`,
 0 AS `price_final`,
 pd.`nb_downloadable`  AS `nb_downloadable`,
 sav.`quantity`  AS `sav_quantity`,
 IF(sav.`quantity`<=0, 1, 0) AS `badge_danger`,
 cp.`position`  AS `position` 
FROM  `b8f83_product` p 
 LEFT JOIN `b8f83_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.`id_lang` = 2 AND pl.`id_shop` = 1) 
 LEFT JOIN `b8f83_stock_available` sav ON (sav.`id_product` = p.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1  AND sav.id_shop_group = 0 ) 
 JOIN `b8f83_product_shop` sa ON (p.`id_product` = sa.`id_product` AND sa.id_shop = 1) 
 LEFT JOIN `b8f83_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1) 
 LEFT JOIN `b8f83_category` c ON (c.`id_category` = cl.`id_category`) 
 LEFT JOIN `b8f83_shop` shop ON (shop.id_shop = 1) 
 LEFT JOIN `b8f83_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = 1) 
 LEFT JOIN `b8f83_image` i ON (i.`id_image` = image_shop.`id_image`) 
 LEFT JOIN `b8f83_product_download` pd ON (pd.`id_product` = p.`id_product`) 
 INNER JOIN `b8f83_category_product` cp ON (cp.`id_product` = p.`id_product` AND cp.`id_category` = 90210) 
WHERE (1 AND state = 1)
 
ORDER BY  `id_product` asc
 
LIMIT 0, 100
;"

 

 

So only products from the 90210 category get displayed... dont know how to fix, when i remove "AND cp.`id_category` = 90210" i get error messages