No se ven los artículos en mi backoffice (si existen) [SOLUCIONADO]

[Ballet15]

Buenos días, 

Tengo la versión 1.7.6.1 de prestashop con la plantilla Movic Fashion Store 

El problema es el siguiente: En el backoffice > catálogo > productos, me dice que no tengo artículos, pero en la web si que aparecen.  

Si voy por ejemplo desde un pedido y busco el artículo también puedo acceder a el.

Si alguien me puede ayudar estaría muy agradecida...

Inspeccionando desde la consola he encontrado esto:

"Failed to load resource: the server responded with a status of 503 (Service Unavailable) ----> /modules/leofeature/psajax.php?rand=1579198933682"

Y en el modo depuración me aparece lo siguiente ( y un fantasma que en otra situación en haría gracia )

Unknown column 'state' in 'where clause'<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 `e_product` p
LEFT JOIN `e_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1)
LEFT JOIN `e_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 `e_product_shop` sa ON (p.`id_product` = sa.`id_product` AND sa.id_shop = 1)
LEFT JOIN `e_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1)
LEFT JOIN `e_category` c ON (c.`id_category` = cl.`id_category`)
LEFT JOIN `e_shop` shop ON (shop.id_shop = 1)
LEFT JOIN `e_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 `e_image` i ON (i.`id_image` = image_shop.`id_image`)
LEFT JOIN `e_product_download` pd ON (pd.`id_product` = p.`id_product`)
WHERE (1 AND state = 1)

ORDER BY `id_product` ASC

LIMIT 0, 300
;</pre>

  LOGS:

INFO12:08:16phpUser Deprecated: Implementing "Symfony\Component\HttpKernel\DataCollector\DataCollectorInterface" without the "reset()" method is deprecated since Symfony 3.4 and will be unsupported in 4.0 for class "Csa\Bundle\GuzzleBundle\DataCollector\GuzzleCollector".

CRITICAL12:08:16phpUncaught Exception: Unknown column 'state' in 'where clause'<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 `e_product` p LEFT JOIN `e_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1) LEFT JOIN `e_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 `e_product_shop` sa ON (p.`id_product` = sa.`id_product` AND sa.id_shop = 1) LEFT JOIN `e_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1) LEFT JOIN `e_category` c ON (c.`id_category` = cl.`id_category`) LEFT JOIN `e_shop` shop ON (shop.id_shop = 1) LEFT JOIN `e_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 `e_image` i ON (i.`id_image` = image_shop.`id_image`) LEFT JOIN `e_product_download` pd ON (pd.`id_product` = p.`id_product`) WHERE (1 AND state = 1) ORDER BY `id_product` ASC LIMIT 0, 300 ;</pre>

CRITICAL12:08:16requestUncaught PHP Exception PrestaShopDatabaseException: "Unknown column 'state' in 'where clause'<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 `e_product` p LEFT JOIN `e_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1) LEFT JOIN `e_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 `e_product_shop` sa ON (p.`id_product` = sa.`id_product` AND sa.id_shop = 1) LEFT JOIN `e_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1) LEFT JOIN `e_category` c ON (c.`id_category` = cl.`id_category`) LEFT JOIN `e_shop` shop ON (shop.id_shop = 1) LEFT JOIN `e_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 `e_image` i ON (i.`id_image` = image_shop.`id_image`) LEFT JOIN `e_product_download` pd ON (pd.`id_product` = p.`id_product`) WHERE (1 AND state = 1) ORDER BY `id_product` ASC LIMIT 0, 300 ;</pre>" at /var/www/vhosts/balletandyou.com/pruebas.balletandyou.com/classes/db/Db.php line 769

[Ballet15]

Por si da más pistas, he pegado la consulta en base de datos > consulta SQL y quitando WHERE (1 AND state = 1) da resultados. 

Lo que no sé es dónde incluyo el STATE.

 

[gusman126]

Pregunta tonta, tienes filtro por categoría? si le das a deseleccionar salen? no es la primera vez que busco un producto y tengo activa una categoria o no veo el filtro

Quita el filtro tambien

 

[Ballet15]

La pregunta es normal, es lo primero que pensé... pero si están quitados los filtros.

[gusman126]

Leyendo los errores, has actualizado la versión desde una anterior ? cual tenias antes?

He tenido el problema parecido, la unica manera ha sido ir a PHPMyAdmin y añadir las columnas que indica, para saber el tipo que es , baja la versión 1.7.6.2 de descargas de prestashop y comprueba el fichero db_structure.sql, te lo he adjuntado aqui

db_structure.sql

[Ballet15]

Si, viene de una actualización. La anterior era la 1.6.1

Mil gracias, efectivamente me faltaban columnas y una clave. Con unas consultas de "alter" solucionado.

Muchas gracias!