Jump to content

Broken Images after upgrade + cannot delete broken images!


Recommended Posts

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 by pppggg (see edit history)
Link to comment
Share on other sites

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...