pppggg Posted February 3, 2014 Share Posted February 3, 2014 (edited) hi i upgraded and none of my images are showing, they are all broken. i put it in debug and this error shows when i click to view a products page: [PrestaShopDatabaseException] Table 'puregraf_shop.ps_layered_indexable_attribute_lang_value' doesn't exist SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_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 `ps_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 186 at line 613 in file classes/db/Db.php 607. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 608. } 609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 610. { 611. if ($sql) 612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 613. throw new PrestaShopDatabaseException($this->getMsgError()); 614. } 615. } 616. 617. /** DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 5005 - classes/Product.php] - [1 Arguments] ProductCore::getAttributesInformationsByProduct - [line 520 - controllers/front/ProductController.php] - [1 Arguments] ProductControllerCore->assignAttributesCombinations - [line 241 - controllers/front/ProductController.php] - [0 Argument] ProductControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument] ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument] Edited February 3, 2014 by pppggg (see edit history) Link to comment Share on other sites More sharing options...
pppggg Posted February 3, 2014 Author Share Posted February 3, 2014 (edited) when i upgraded i had a few errors <action result="fail" error="34"> Edited February 3, 2014 by pppggg (see edit history) Link to comment Share on other sites More sharing options...
pppggg Posted February 3, 2014 Author Share Posted February 3, 2014 OK so i checked inside the folders where the images are linked to, and all the images are gone. I did not delete them, just did the upgrade. I tried to delete the broken images by going to each product > images and clicked the delete to delete the broken image, but nothing happens! the image is not deleted, and i cannot get rid of it someone please help, i will settle with having to re-upload all new images to every product, but my problem is i cannot delete the broken images? Link to comment Share on other sites More sharing options...
pppggg Posted February 3, 2014 Author Share Posted February 3, 2014 ok its very weird but, if i save changes, and go back to the images i tried to delete, they have indeed been deleted 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