Productos destacados no aparecen.

[Inés]

Hola a todos.

Me ha surgido un problema con la tienda que estoy trabajando (otro) y es que no aparecen los productos destacados.

He asociado dos artículos a la categoría inicio pero no aparecen. El módulo está colocado en dislplayHome y displayHeader. Y dice que no hay productos destacados.

La web es: http://www.krissexshop.com/es/.

Es prestashop 1.5.4.1.

He probado a desistalar el modulo y volver a instalarlo, pero sigue igual.

He probado con la plantilla default y tampoco funciona.

 

He activado los errores y esto es lo que me sale:

 

 

[PrestaShopDatabaseException]
Unknown column 'stock.out_of_stock' in 'field list'

SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
					pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
					il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
					DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
					INTERVAL 20
						DAY)) > 0 AS new, product_shop.price AS orderprice
				FROM `ps_category_product` cp
				LEFT JOIN `ps_product` p
					ON p.`id_product` = cp.`id_product`
				 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_attribute` pa
				ON (p.`id_product` = pa.`id_product`)
				LEFT JOIN `ps_category_lang` cl
					ON (product_shop.`id_category_default` = cl.`id_category`
					AND cl.`id_lang` = 4 AND cl.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` i
					ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=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`
				WHERE product_shop.`id_shop` = 1
					AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC
			LIMIT 0,12

at line 607 in file classes/db/Db.php

601. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
602. 		}
603. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
604. 		{
605. 			if ($sql)
606. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
607. 			throw new PrestaShopDatabaseException($this->getMsgError());
608. 		}
609. 	}
610. 
611. 	/**

DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments]

Argument [0]
SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
					pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
					il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
					DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
					INTERVAL 20
						DAY)) > 0 AS new, product_shop.price AS orderprice
				FROM `ps_category_product` cp
				LEFT JOIN `ps_product` p
					ON p.`id_product` = cp.`id_product`
				 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_attribute` pa
				ON (p.`id_product` = pa.`id_product`)
				LEFT JOIN `ps_category_lang` cl
					ON (product_shop.`id_category_default` = cl.`id_category`
					AND cl.`id_lang` = 4 AND cl.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` i
					ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=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`
				WHERE product_shop.`id_shop` = 1
					AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC
			LIMIT 0,12

DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments]

Argument [0]
SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
					pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
					il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
					DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
					INTERVAL 20
						DAY)) > 0 AS new, product_shop.price AS orderprice
				FROM `ps_category_product` cp
				LEFT JOIN `ps_product` p
					ON p.`id_product` = cp.`id_product`
				 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_attribute` pa
				ON (p.`id_product` = pa.`id_product`)
				LEFT JOIN `ps_category_lang` cl
					ON (product_shop.`id_category_default` = cl.`id_category`
					AND cl.`id_lang` = 4 AND cl.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` i
					ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=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`
				WHERE product_shop.`id_shop` = 1
					AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC
			LIMIT 0,12

DbCore->executeS - [line 649 - classes/Category.php] - [1 Arguments]

Argument [0]
SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
					pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
					il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
					DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
					INTERVAL 20
						DAY)) > 0 AS new, product_shop.price AS orderprice
				FROM `ps_category_product` cp
				LEFT JOIN `ps_product` p
					ON p.`id_product` = cp.`id_product`
				 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_attribute` pa
				ON (p.`id_product` = pa.`id_product`)
				LEFT JOIN `ps_category_lang` cl
					ON (product_shop.`id_category_default` = cl.`id_category`
					AND cl.`id_lang` = 4 AND cl.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` i
					ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=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`
				WHERE product_shop.`id_shop` = 1
					AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC
			LIMIT 0,12

CategoryCore->getProducts - [line 106 - modules/homefeatured/homefeatured.php] - [3 Arguments]

Argument [0]
4
Argument [1]
1
Argument [2]
12

HomeFeatured->hookDisplayHome - [line 421 - classes/Hook.php] - [1 Arguments]

Argument [0]
Array
(
    [cookie] => Cookie Object
        (
            [_content:protected] => Array
                (
                    [date_add] => 2014-05-29 13:20:26
                    [id_lang] => 4
                    [id_currency] => 2
                    [id_guest] => 80850
                    [id_connections] => 73915
                    [last_visited_category] => 321
                    [viewed] => 1435,1432
                    [checksum] => 3023547322
                )

            [_name:protected] => ffdbd13d96d903c026c4876e97eb63a4
            [_expire:protected] => 1403205426
            [_domain:protected] => www.krissexshop.com
            [_path:protected] => /
            [_cipherTool:protected] => Rijndael Object
                (
                    [_key:protected] => hnkFzF8QT8I458Lnbx4ydw2TZcxtH9qm
                    [_iv:protected] => Y %?
                )

            [_key:protected] => i3eca0dwv1tudtoazre5dxhilyu6fggvsaqlinj4sgynnxuwszbefwre
            [_iv:protected] => rulxvrdc
            [_modified:protected] => 
            [_allow_writing:protected] => 1
        )

    [cart] => Cart Object
        (
            [id] => 
            [id_shop_group] => 1
            [id_shop] => 1
            [id_address_delivery] => 0
            [id_address_invoice] => 0
            [id_currency] => 2
            [id_customer] => 
            [id_guest] => 80850
            [id_lang] => 4
            [recyclable] => 0
            [gift] => 0
            [gift_message] => 
            [mobile_theme] => 
            [date_add] => 
            [secure_key] => 
            [id_carrier] => 0
            [date_upd] => 
            [checkedTos] => 
            [pictures] => 
            [textFields] => 
            [delivery_option] => 
            [allow_seperated_package] => 
            [_products:protected] => 
            [_taxCalculationMethod:protected] => 0
            [webserviceParameters:protected] => Array
                (
                    [fields] => Array
                        (
                            [id_address_delivery] => Array
                                (
                                    [xlink_resource] => addresses
                                )

                            [id_address_invoice] => Array
                                (
                                    [xlink_resource] => addresses
                                )

                            [id_currency] => Array
                                (
                                    [xlink_resource] => currencies
                                )

                            [id_customer] => Array
                                (
                                    [xlink_resource] => customers
                                )

                            [id_guest] => Array
                                (
                                    [xlink_resource] => guests
                                )

                            [id_lang] => Array
                                (
                                    [xlink_resource] => languages
                                )

                        )

                    [associations] => Array
                        (
                            [cart_rows] => Array
                                (
                                    [resource] => cart_row
                                    [virtual_entity] => 1
                                    [fields] => Array
                                        (
                                            [id_product] => Array
                                                (
                                                    [required] => 1
                                                    [xlink_resource] => products
                                                )

                                            [id_product_attribute] => Array
                                                (
                                                    [required] => 1
                                                    [xlink_resource] => combinations
                                                )

                                            [quantity] => Array
                                                (
                                                    [required] => 1
                                                )

                                        )

                                )

                        )

                )

            [id_shop_list] => 
            [get_shop_from_context:protected] => 1
            [table:protected] => cart
            [identifier:protected] => id_cart
            [fieldsRequired:protected] => Array
                (
                    [0] => id_currency
                    [1] => id_lang
                )

            [fieldsSize:protected] => Array
                (
                    [secure_key] => 32
                )

            [fieldsValidate:protected] => Array
                (
                    [id_shop_group] => isUnsignedId
                    [id_shop] => isUnsignedId
                    [id_address_delivery] => isUnsignedId
                    [id_address_invoice] => isUnsignedId
                    [id_carrier] => isUnsignedId
                    [id_currency] => isUnsignedId
                    [id_customer] => isUnsignedId
                    [id_guest] => isUnsignedId
                    [id_lang] => isUnsignedId
                    [recyclable] => isBool
                    [gift] => isBool
                    [gift_message] => isMessage
                    [mobile_theme] => isBool
                    [allow_seperated_package] => isBool
                    [date_add] => isDateFormat
                    [date_upd] => isDateFormat
                )

            [fieldsRequiredLang:protected] => Array
                (
                )

            [fieldsSizeLang:protected] => Array
                (
                )

            [fieldsValidateLang:protected] => Array
                (
                )

            [tables:protected] => Array
                (
                )

            [image_dir:protected] => 
            [image_format:protected] => jpg
            [def:protected] => Array
                (
                    [table] => cart
                    [primary] => id_cart
                    [fields] => Array
                        (
                            [id_shop_group] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                )

                            [id_shop] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                )

                            [id_address_delivery] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                )

                            [id_address_invoice] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                )

                            [id_carrier] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                )

                            [id_currency] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                    [required] => 1
                                )

                            [id_customer] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                )

                            [id_guest] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                )

                            [id_lang] => Array
                                (
                                    [type] => 1
                                    [validate] => isUnsignedId
                                    [required] => 1
                                )

                            [recyclable] => Array
                                (
                                    [type] => 2
                                    [validate] => isBool
                                )

                            [gift] => Array
                                (
                                    [type] => 2
                                    [validate] => isBool
                                )

                            [gift_message] => Array
                                (
                                    [type] => 3
                                    [validate] => isMessage
                                )

                            [mobile_theme] => Array
                                (
                                    [type] => 2
                                    [validate] => isBool
                                )

                            [delivery_option] => Array
                                (
                                    [type] => 3
                                )

                            [secure_key] => Array
                                (
                                    [type] => 3
                                    [size] => 32
                                )

                            [allow_seperated_package] => Array
                                (
                                    [type] => 2
                                    [validate] => isBool
                                )

                            [date_add] => Array
                                (
                                    [type] => 5
                                    [validate] => isDateFormat
                                )

                            [date_upd] => Array
                                (
                                    [type] => 5
                                    [validate] => isDateFormat
                                )

                        )

                    [classname] => Cart
                )

            [update_fields:protected] => 
        )

    [altern] => 3
)

HookCore::exec - [line 39 - controllers/front/IndexController.php] - [1 Arguments]

Argument [0]
displayHome

• IndexControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 15 - override/classes/controller/Controller.php] - [0 Argument]
• Controller->run - [line 349 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

A ver si alguien puede ayudarme. 

Un saludo y gracias!!

 

 

Edited May 30, 2014 by Inés (see edit history)

[Inés]

Nadie que me ayude?

[ugatza]

A mí me ocurre prácticamente lo mismo. Está activado el módulo y ubicado en displayHome y displayHeader. He intentado subir nuevos productos -datos e imágenes- y colocarlos en la categoría "inicio", pero no aparece en la página principal. He visto en tu web que pareces haber solucionado el problema. ¿Cómo lo has hecho?

 

Me llamo Natxo, mi web es www.mueblesgarralda.com y mi versión de prestashop es la 1.5.3.1.

 

Gracias de antemano