ruloshop Posted February 1, 2019 Share Posted February 1, 2019 Actualice mi tienda de 1.7.4 a 1.7.5 pero al poner en modo Debug me da este error al querer ver un producto [PrestaShopDatabaseException] Unknown column 'location' in 'field list' SELECT location FROM `pse0_stock_available` WHERE (id_product = 24) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 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 663 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 697 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 782 - classes/stock/StockAvailable.php] - [1 Arguments] StockAvailableCore::getLocation - [line 6522 - classes/Product.php] - [1 Arguments] ProductCore->loadStockData - [line 576 - classes/Product.php] ProductCore->__construct - [line 93 - controllers/front/ProductController.php] - [4 Arguments] ProductControllerCore->init - [line 262 - classes/controller/Controller.php] ControllerCore->run - [line 509 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Gracias por su ayuda Link to comment Share on other sites More sharing options...
ruloshop Posted February 6, 2019 Author Share Posted February 6, 2019 alguien que me ayude Link to comment Share on other sites More sharing options...
tecnicomalaga Posted May 22, 2019 Share Posted May 22, 2019 Hola, me ha pasado ahora lo mismo. ¿Has podido arreglarlo? Gracias Link to comment Share on other sites More sharing options...
tecnicomalaga Posted May 22, 2019 Share Posted May 22, 2019 12 minutes ago, tecnicomalaga said: Hola, me ha pasado ahora lo mismo. ¿Has podido arreglarlo? Gracias En realidad mi error era: Unknown column 'id_shop' in 'where clause' SELECT * FROM `all_info_lang` WHERE `id_lang` = 1 AND `id_shop` = 1 LIMIT 1 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 663 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 290 - modules/ps_customtext/ps_customtext.php] - [1 Arguments] Ps_Customtext->getWidgetVariables - [line 279 - modules/ps_customtext/ps_customtext.php] - [2 Arguments] Ps_Customtext->renderWidget - [line 971 - classes/Hook.php] - [2 Arguments] HookCore::coreRenderWidget - [line 923 - classes/Hook.php] - [3 Arguments] Y lo he solucionado renombrando la carpeta: modules/ps_customtext 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