Problema con los atributos de los articulos

ivas · March 30, 2015

Buenas,

Estoy montando una web, estoy subiendo modulos y modificación cosas resulta que me doy cuenta ahora que por alguna modificación que he realizado se ha quedado asi la pagina adjunto foto

Bueno haber si me podeis echar una mano y decir donde esta el fallo.

Gracias

Creo que el problema ha sido despues de instalar este modulo

http://prestaportal.com/thread-725.html

attributeposition.zip

Edited March 30, 2015 by ivas (see edit history)

ivas · March 30, 2015

Cuando creo un atributo no me deja me sale esto

Se ha producido un error mientras se creaba el objeto attribute_group (Unknown column 'position' in 'field list')

ventura · March 30, 2015

Prueba a restaurar los archivos originales

themes/tu_plantilla/js/product.js
themes/tu_plantilla/product.tpl

Edited March 30, 2015 by ventura (see edit history)

ivas · March 30, 2015

Gracias ventura, como los restauro? de otra instalacion limpia?

Un saludo

ventura · March 30, 2015

Gracias ventura, como los restauro? de otra instalacion limpia?

Un saludo

Si, sería lo mejor

ivas · March 30, 2015

He editado el archivo completo y no va.

ventura · March 30, 2015

Lo mas probable es que como comentas el modulo que has instalado sea el culpable del mal funcionamiento, prueba a desinstalarlo, es muy probable que no sea compatible con la version de prestashop que tienes instalada

ivas · March 30, 2015

Gracias por la repida respuesta, esta desistalado ya,

cuando lo desistalo me sale el producto y precio, pero no me salen los atributos ni me deja crearlos.

Ve alguna solucion? me toca rehacer la web de nuevo?

Gracias

ventura · March 30, 2015

Activa el modo de visualizacion de errores para ver si te muestra algun error o conflicto

http://victor-rodenas.com/2013/05/11/guia-habilitar-el-reporte-de-errores-en-prestashop-1-5-y-prestashop-1-4/

ivas · March 30, 2015

Te pego lo que me sale, gracias

[PrestaShopDatabaseException]

Unknown column 'ag.position' in 'order clause'
SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, pa.`id_product_attribute`, pa.`quantity`, pa.`price`, pa.`ecotax`, pa.`weight`, pa.`default_on`, pa.`reference`, pa.`unit_price_impact`, pa.`minimal_quantity` FROM `pss_product_attribute` pa LEFT JOIN `pss_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `pss_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pss_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pss_attribute_lang` al ON a.`id_attribute` = al.`id_attribute` LEFT JOIN `pss_attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group` WHERE pa.`id_product` = 1 AND al.`id_lang` = 1 AND agl.`id_lang` = 1 ORDER BY ag.position,a.position,agl.`public_name`, al.`name`

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

629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. 		}631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. 		{633. 			if ($sql)634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. 			throw new PrestaShopDatabaseException($this->getMsgError());636. 		}637. 	}638. 639. 	/**

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

319. 		if ($sql instanceof DbQuery)320. 			$sql = $sql->build();321. 322. 		$this->result = $this->_query($sql);323. 		if (_PS_DEBUG_SQL_)324. 			$this->displayError($sql);325. 		return $this->result;326. 	}327. 328. 	/**329. 	 * Execute an INSERT query

Argument [0]		SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name,		a.`color` AS attribute_color, pa.`id_product_attribute`, pa.`quantity`, pa.`price`, pa.`ecotax`, pa.`weight`, pa.`default_on`, pa.`reference`, pa.`unit_price_impact`, pa.`minimal_quantity`		FROM `pss_product_attribute` pa		LEFT JOIN `pss_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`		LEFT JOIN `pss_attribute` a ON a.`id_attribute` = pac.`id_attribute`		LEFT JOIN `pss_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`		LEFT JOIN `pss_attribute_lang` al ON a.`id_attribute` = al.`id_attribute`		LEFT JOIN `pss_attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group`		WHERE pa.`id_product` = 1		AND al.`id_lang` = 1		AND agl.`id_lang` = 1		ORDER BY ag.position,a.position,agl.`public_name`, al.`name`

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

495. 		{496. 			$this->last_cached = true;497. 			return $result;498. 		}499. 500. 		$this->result = $this->query($sql);501. 502. 		if (!$this->result)503. 			$result = false;504. 		else505. 		{

Argument [0]		SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name,		a.`color` AS attribute_color, pa.`id_product_attribute`, pa.`quantity`, pa.`price`, pa.`ecotax`, pa.`weight`, pa.`default_on`, pa.`reference`, pa.`unit_price_impact`, pa.`minimal_quantity`		FROM `pss_product_attribute` pa		LEFT JOIN `pss_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`		LEFT JOIN `pss_attribute` a ON a.`id_attribute` = pac.`id_attribute`		LEFT JOIN `pss_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`		LEFT JOIN `pss_attribute_lang` al ON a.`id_attribute` = al.`id_attribute`		LEFT JOIN `pss_attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group`		WHERE pa.`id_product` = 1		AND al.`id_lang` = 1		AND agl.`id_lang` = 1		ORDER BY ag.position,a.position,agl.`public_name`, al.`name`

DbCore->executeS - [line 27 - override/classes/Product.php] - [1 Arguments]

21. 		LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON a.`id_attribute` = al.`id_attribute`22. 		LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group`23. 		WHERE pa.`id_product` = '.(int)($this->id).'24. 		AND al.`id_lang` = '.(int)($id_lang).'25. 		AND agl.`id_lang` = '.(int)($id_lang).'26. 		ORDER BY ag.position,a.position,agl.`public_name`, al.`name`');27. 	}28.         29. }30. 31. ?>

Argument [0]		SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name,		a.`color` AS attribute_color, pa.`id_product_attribute`, pa.`quantity`, pa.`price`, pa.`ecotax`, pa.`weight`, pa.`default_on`, pa.`reference`, pa.`unit_price_impact`, pa.`minimal_quantity`		FROM `pss_product_attribute` pa		LEFT JOIN `pss_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`		LEFT JOIN `pss_attribute` a ON a.`id_attribute` = pac.`id_attribute`		LEFT JOIN `pss_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`		LEFT JOIN `pss_attribute_lang` al ON a.`id_attribute` = al.`id_attribute`		LEFT JOIN `pss_attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group`		WHERE pa.`id_product` = 1		AND al.`id_lang` = 1		AND agl.`id_lang` = 1		ORDER BY ag.position,a.position,agl.`public_name`, al.`name`

Product->getAttributesGroups - [line 19 - override/controllers/ProductController.php] - [1 Arguments]

13. 	{14. 		parent::process();15. 16. 				/* Attributes / Groups & colors */17. 				$colors = array();18. 				$attributesGroups = $this->product->getAttributesGroups((int)(self::$cookie->id_lang));19. 				if (is_array($attributesGroups) AND sizeof($attributesGroups))20. 				{21. 					$combinationImages = $this->product->getCombinationImages((int)(self::$cookie->id_lang));22. 					foreach ($attributesGroups AS $k => $row)23. 					{

Argument [0]1

ProductController->process - [line 439 - classes/controller/FrontController.php]

433. 	{434. 	}435. 436. 	public function initContent()437. 	{438. 		$this->process();439. 		if (!isset($this->context->cart))440. 			$this->context->cart = new Cart();441. 		if (!$this->useMobileTheme())442. 		{443. 			// These hooks aren't used for the mobile theme.

FrontControllerCore->initContent - [line 176 - controllers/front/ProductController.php]

170. 	 * Assign template vars related to page content171. 	 * @see FrontController::initContent()172. 	 */173. 	public function initContent()174. 	{175. 		parent::initContent();176. 177. 		if (!$this->errors)178. 		{179. 			if (Pack::isPack((int)$this->product->id) && !Pack::isInStock((int)$this->product->id))180. 				$this->product->quantity = 0;

ProductControllerCore->initContent - [line 180 - classes/controller/Controller.php]

174. 175. 			if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))176. 				$this->initHeader();177. 178. 			if ($this->viewAccess())179. 				$this->initContent();180. 			else181. 				$this->errors[] = Tools::displayError('Access denied.');182. 183. 			if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))184. 				$this->initFooter();

ControllerCore->run - [line 373 - classes/Dispatcher.php]

367. 			// Execute hook dispatcher368. 			if (isset($params_hook_action_dispatcher))369. 				Hook::exec('actionDispatcher', $params_hook_action_dispatcher);370. 371. 			// Running controller372. 			$controller->run();373. 		}374. 		catch (PrestaShopException $e)375. 		{376. 			$e->displayMessage();377. 		}

DispatcherCore->dispatch - [line 28 - index.php]

ventura · March 31, 2015

Tienes estos overrides

override/controllers/ProductController.php
 override/classes/Product.php

Posiblemente te los haya creado el modulo, renombralos o eliminalos y prueba a ver

ivas · March 31, 2015

Hola Ventura,

Las eliminado sigue igual no salen en los articulos los tributos ni deja crearlos.

Se ha producido un error mientras se creaba el objeto attribute (Unknown column 'position' in 'field list')

ventura · March 31, 2015

Tienes algun backup de la base de datos ¿?

ivas · March 31, 2015

No,

ventura · March 31, 2015

borra este archivo del cache por si te sigue aplicando los overrides

\cache\class_index.php

Con el modulo desinstalado, sin archivos que sobreescriiban a los originales del core de Prestashop ya solo podria ser un tema de base de datos dañada o corrompida

ivas · March 31, 2015

Nada Ventura,

Bueno voy a a instalar en local la tienda y empezar hacer las modificaciones.

Gracias por todo.

Un saludo

Problema con los atributos de los articulos

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites