Jump to content

Unknown column 'a.active' in 'where clause' PROBLEMA CON SQL, REGLAS DE IMPUESTOS


Recommended Posts

Buenas tardes a todos los valientes soldados y guerreros de prestashop! cada día me sorprende más esta herramienta, en algunos casos, de buena manera, y otra como estas, me asustan, en fin.

el problema es el siguiente, cuando voy a "localización"-"regla de impuestos", y quiero agregar o modificar alguno me aparece el siguiente error:

[PrestaShopDatabaseException]

Unknown column 'a.active' in 'where clause'


		SELECT SQL_CALC_FOUND_ROWS
		 a.*
		, 
			c.`name` AS country_name,
			s.`name` AS state_name,
			CONCAT_WS(" - ", a.`zipcode_from`, a.`zipcode_to`) AS zipcode,
			t.rate
		FROM `ps_tax_rule` a
		
		
			LEFT JOIN `ps_country_lang` c
				ON (a.`id_country` = c.`id_country` AND id_lang = 3)
			LEFT JOIN `ps_state` s
				ON (a.`id_state` = s.`id_state`)
			LEFT JOIN `ps_tax` t
				ON (a.`id_tax` = t.`id_tax`) 
		
		WHERE 1 AND `id_tax_rules_group` = 53  AND a.`active` = 1 
		
		
		ORDER BY `id_tax_rules_group` ASC LIMIT 0,50

at line 623 in file classes/db/Db.php
617. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
618. 		}
619. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
620. 		{
621. 			if ($sql)
622. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
623. 			throw new PrestaShopDatabaseException($this->getMsgError());
624. 		}
625. 	}
626. 
627. 	/**
DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 489 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 2728 - classes/controller/AdminController.php] - [3 Arguments]
AdminControllerCore->getList - [line 1923 - classes/controller/AdminController.php] - [1 Arguments]
AdminControllerCore->renderList - [line 152 - controllers/admin/AdminTaxRulesGroupController.php]
AdminTaxRulesGroupControllerCore->initRulesList - [line 225 - controllers/admin/AdminTaxRulesGroupController.php] - [1 Arguments]
AdminTaxRulesGroupControllerCore->renderForm - [line 1738 - classes/controller/AdminController.php]
AdminControllerCore->initContent - [line 180 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 54 - admin/index.php]

estan adjuntos las capturas de pantalla

 

utilizo la version 1.6 de PS

post-796871-0-39623400-1405602616_thumb.jpg

post-796871-0-40177800-1405602617_thumb.jpg

  • Like 1

Share this post


Link to post
Share on other sites
  • nadie locked this topic
Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More