fpastorocana Posted February 13, 2021 Share Posted February 13, 2021 Buenas noches, actualicé a la versión 1.7.7.1 y me salió error 500, de ahí en adelante solo más y más errores hasta esto: [PrestaShopDatabaseException] Unknown column 'pa.mpn' in 'field list'<br /><br /><pre> SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `mod315_attribute` a LEFT JOIN `mod315_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `mod315_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `mod315_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN mod315_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `mod315_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pa.`id_product` = 5066 AND pac.`id_product_attribute` = 11503 AND agl.`id_lang` = 3</pre> at line 769 in file classes/db/Db.php 764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. } DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 6435 - classes/Product.php] - [1 Arguments] ProductCore::getAttributesParams - [line 5107 - classes/Product.php] - [2 Arguments] ProductCore::getProductProperties - [line 438 - override/classes/Product.php] - [3 Arguments] Product::getProductProperties - [line 5165 - classes/Product.php] - [2 Arguments] ProductCore::getProductsProperties - [line 1067 - classes/Category.php] - [2 Arguments] CategoryCore->getProducts - [line 88 - src/Adapter/Category/CategoryProductSearchProvider.php] - [6 Arguments] PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->getProductsOrCount - [line 105 - src/Adapter/Category/CategoryProductSearchProvider.php] - [3 Arguments] PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->runQuery - [line 659 - modules/iqitelementor/src/widgets/IqitElementorWidget_ProductsList.php] - [2 Arguments] IqitElementorWidget_ProductsList->getProducts - [line 468 - modules/iqitelementor/src/widgets/IqitElementorWidget_ProductsList.php] - [5 Arguments] IqitElementorWidget_ProductsList->parseOptions - [line 511 - modules/iqitelementor/iqitelementor.php] - [2 Arguments] IqitElementor->getIqitElementorWidgetVariables - [line 503 - modules/iqitelementor/iqitelementor.php] - [3 Arguments] IqitElementor->renderIqitElementorWidget - [line 73 - modules/iqitelementor/src/iqitElementorWpHelper.php] - [2 Arguments] IqitElementorWpHelper::renderIqitElementorWidget - [line 93 - modules/iqitelementor/includes/widgets/prestashop.php] - [2 Arguments] Elementor\Widget_Prestashop->render - [line 271 - modules/iqitelementor/includes/widgets/base.php] - [1 Arguments] Elementor\Widget_Base->render_content - [line 76 - modules/iqitelementor/includes/frontend.php] - [1 Arguments] Elementor\Frontend->_print_widget - [line 57 - modules/iqitelementor/includes/frontend.php] - [1 Arguments] Elementor\Frontend->_print_column - [line 40 - modules/iqitelementor/includes/frontend.php] - [1 Arguments] Elementor\Frontend->_print_section - [line 267 - modules/iqitelementor/includes/frontend.php] - [1 Arguments] Elementor\Frontend->apply_builder_in_content - [line 280 - modules/iqitelementor/includes/frontend.php] Elementor\Frontend->__construct - [line 62 - modules/iqitelementor/includes/plugin-elementor.php] - [1 Arguments] Elementor\PluginElementor->get_frontend - [line 566 - modules/iqitelementor/iqitelementor.php] - [1 Arguments] IqitElementor->getWidgetVariables - [line 545 - modules/iqitelementor/iqitelementor.php] - [2 Arguments] IqitElementor->renderWidget - [line 995 - classes/Hook.php] - [2 Arguments] HookCore::coreRenderWidget - [line 947 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 39 - controllers/front/IndexController.php] - [1 Arguments] IndexControllerCore->initContent - [line 306 - classes/controller/Controller.php] ControllerCore->run - [line 518 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] POR FAVOR ayuda que me va el trabajo en ello.... Link to comment Share on other sites More sharing options...
juanrojas Posted February 16, 2021 Share Posted February 16, 2021 hola, desde que version actualizaste? Link to comment Share on other sites More sharing options...
fpastorocana Posted February 16, 2021 Author Share Posted February 16, 2021 Hola! actualicé desde la versión 1.5.2, algo antigua la verdad y con código editado. El caso es que no salió muy allá y tuvimos que tirar de back up. Sabe alguien como hacer la actualización de forma correcta? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now