[solved ]Products don't show up in Backend

[nikoz]

Hi everyone, I am using Prestashop 1.7.8.11.
PHP version 7.4 (Tried also 7.3, 7.2)

None of my products are visible in the backend under Catalog → Products, but they appear correctly on the frontend, and orders can be placed without issues.

However, I can see the products in the backend under Catalog → Stock.

I have cleared the cache and rebuilt the index.

When I add a new product, it is created successfully but still does not appear in the catalog.

So, I enabled debug mode, and this is the output I get when accessing the Catalog -> products.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND state = 1 AND p.id_product NOT IN ())

ORDER BY `id_product` asc

LI...' at line 26<br /><br /><pre>SELECT SQL_CALC_FOUND_ROWS p.`id_product` AS `id_product`,
p.`reference` AS `reference`,
sa.`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`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1)
LEFT JOIN `ps_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 `ps_product_shop` sa ON (p.`id_product` = sa.`id_product` AND sa.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1)
LEFT JOIN `ps_category` c ON (c.`id_category` = cl.`id_category`)
LEFT JOIN `ps_shop` shop ON (shop.id_shop = 1)
LEFT JOIN `ps_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 `ps_image` i ON (i.`id_image` = image_shop.`id_image`)
LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = p.`id_product`)
WHERE (1 AND p.id_product NOT IN () AND state = 1 AND p.id_product NOT IN ())

ORDER BY `id_product` asc

LIMIT 0, 300
;</pre>

I have read some other similar topics but didn't resolve the issue. Any idea what I could further do ?

Thanks in advance

Nikos

p.s Attached a png of the logs.

 

Edited February 10 by nikoz (see edit history)

[ComGrafPL]

You dont have any filter enabled on products list?

[nikoz]

No, I don’t have any filters enabled. Even if I were to select a category filter, it should still display some products, right? But right now, it’s not showing any products at all.

 

[Prestashop Addict]

Can you show the stack trace to see where the error occurred?

[nikoz]

After a lot of attempts, research, testing the sql,  I disabled one module (Gift Card by FMM Modules )and suddenly all products are back again. It seems that there was a conflict with this module and that was creating this problem

Thank you uthough for your responses