Jump to content

PrestaShopDatabaseException: No se muestran los productos


Recommended Posts

Hola,

 

He mirado por todos lados, he probado de todo, pero no salen los productos que he dado de alta. No se en en el FrontOffice. Pero si uso el buscador sí que aparecen.

El error que me da:

Unknown column 'product_attribute_shop.id_product' in 'on clause'
 

SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
			pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
			product_shop.`date_add` > "2017-07-28" as new,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
FROM `ps_product` p
 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_lang` `pl` ON 
			p.`id_product` = pl.`id_product`
			AND pl.`id_lang` = 4 AND pl.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_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 4
LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1
 LEFT JOIN ps_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2017-07-28") AND (EXISTS(SELECT 1 FROM `ps_category_product` cp
				JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
				WHERE cp.`id_product` = p.`id_product`))
ORDER BY product_shop.`date_add` DESC
LIMIT 8

¿alguna idea de dónde encontrar el error y como podría solucionarse?

Versión Prestashop: 1.6.1.13

 

Muchas gracias de antemano.

Link to comment
Share on other sites

Esto te ha pasado desde el primer producto que subiste no?

De ser así, prueba a eliminarlos todos e importas este .zip que te adjunto con la tabla que te falta.. a ver si se soluciona.

Desde phpmyadmin --> Importar --> Selecionar archivo --> ps_product_attribute_shop.sql --> Continuar

De ahí prueba a subir productos a ver si esta todo correcto.

ps_product_attribute_shop.sql.zip

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...