Problème Après Installation De Thème

[david808]

Bonjour!

Nouveau sur ce forum je me présente David 23 ans,

J'ai installé la dernière version de Prestashop en local il y a quelques jours. Je compte prendre mon temps en local et l'héberger ensuite.

J'ai installé un thème gratuit hier et depuis j'ai eu la fameuse page blanche, fait des recherches et activé le mode display errors.

 

Que ce soit sur le shop ou la partie admin, quand je clique sur "Catégorie" ou "Produit", je me trouve devant une liste d'erreur qui a l'air de venir de la partie SQL.

Je n'ai pas de grandes connaissances en MySQL ou php mais je me débrouille avec google etc, le soucis c'est que j'ai pas trouvé de solution sur mes erreurs.

 

Je vais vous coller la liste d'erreur, peut-être pourriez-vous m'aider.

J'espère que la longueur du message ne vous découragera pas lol.

Je vous remercie d'avance.

 

 

[PrestaShopDatabaseException]

Unknown column 'image_shop.id_product' in 'on clause'

SELECT								a.`id_product`, b.`name` AS `name`, `reference`, a.`price` AS `price`, sa.`active` AS `active`			, shop.`name` AS `shopname`, a.`id_shop_default`, image_shop.`id_image` AS `id_image`, cl.`name` AS `name_category`, sa.`price`, 0 AS `price_final`, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` AS `sav_quantity`, sa.`active`, IF(sav.`quantity`<=0, 1, 0) AS `badge_danger`			FROM `ps_product` a 			LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)					LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0		 AND sav.id_shop = 1  AND sav.id_shop_group = 0 )  JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)				LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)				LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default)				LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = a.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)				LEFT JOIN `ps_image` i ON (i.`id_image` = image_shop.`id_image`)				LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`) 			 WHERE 1  			 			 ORDER BY a.`id_product` ASC  LIMIT 0, 50

at line 791 in file classes/db/Db.php

786.         if ($webservice_call && $errno) {787.             $dbg = debug_backtrace();788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {790.             if ($sql) {791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792.             }793. 794.             throw new PrestaShopDatabaseException($this->getMsgError());795.         }796.     }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]

  420.                 $this->result = $this->_query($sql);421.             }422.         }423. 424.         if (_PS_DEBUG_SQL_) {425.             $this->displayError($sql);426.         }427. 428.         return $this->result;429.     }430. 

• DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]

  Argument [0]SELECT								a.`id_product`, b.`name` AS `name`, `reference`, a.`price` AS `price`, sa.`active` AS `active`			, shop.`name` AS `shopname`, a.`id_shop_default`, image_shop.`id_image` AS `id_image`, cl.`name` AS `name_category`, sa.`price`, 0 AS `price_final`, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` AS `sav_quantity`, sa.`active`, IF(sav.`quantity`

• DbCore->executeS - [line 3207 - classes/controller/AdminController.php] - [3 Arguments]

  3202. 								'.($this->_tmpTableFilter ? ' * FROM (SELECT ' : '').$this->_listsql.$sql_from.$sql_join.' WHERE 1 '.$sql_where.3203.                                 $sql_order_by.$sql_limit;3204.                 $list_count = 'SELECT COUNT(*) AS `'._DB_PREFIX_.$this->table.'` '.$sql_from.$sql_join.' WHERE 1 '.$sql_where;3205.             }3206. 3207.             $this->_list = Db::getInstance()->executeS($this->_listsql, true, false);3208. 3209.             if ($this->_list === true) {3210.                 $this->_list_error = Db::getInstance()->getMsgError();3211.                 break;3212.             }

• AdminControllerCore->getList - [line 409 - controllers/admin/AdminProductsController.php] - [6 Arguments]

  Argument [0]1Argument [1]Argument [2]Argument [3]0Argument [4]Argument [5]1

• AdminProductsControllerCore->getList - [line 2326 - classes/controller/AdminController.php] - [1 Arguments]

  2321.     public function renderList()2322.     {2323.         if (!($this->fields_list && is_array($this->fields_list))) {2324.             return false;2325.         }2326.         $this->getList($this->context->language->id);2327. 2328.         // If list has 'active' field, we automatically create bulk action2329.         if (isset($this->fields_list) && is_array($this->fields_list) && array_key_exists('active', $this->fields_list)2330.             && !empty($this->fields_list['active'])) {2331.             if (!is_array($this->bulk_actions)) {

• AdminControllerCore->renderList - [line 2596 - controllers/admin/AdminProductsController.php]

  2591.     {2592.         $this->addRowAction('edit');2593.         $this->addRowAction('preview');2594.         $this->addRowAction('duplicate');2595.         $this->addRowAction('delete');2596.         return parent::renderList();2597.     }2598. 2599.     public function ajaxProcessProductManufacturers()2600.     {2601.         $manufacturers = Manufacturer::getManufacturers(false, 0, true, false, false, false, true);

• AdminProductsControllerCore->renderList - [line 2027 - classes/controller/AdminController.php]

  2022.         } elseif ($this->display == 'details') {2023.             $this->content .= $this->renderDetails();2024.         } elseif (!$this->ajax) {2025.             $this->content .= $this->renderModulesList();2026.             $this->content .= $this->renderKpis();2027.             $this->content .= $this->renderList();2028.             $this->content .= $this->renderOptions();2029. 2030.             // if we have to display the required fields form2031.             if ($this->required_database) {2032.                 $this->content .= $this->displayRequiredFields();

• AdminControllerCore->initContent - [line 2514 - controllers/admin/AdminProductsController.php]

  2509.             $this->tpl_list_vars['base_url'] = preg_replace('#&id_category=[0-9]*#', '', self::$currentIndex).'&token='.$this->token;2510.         }2511.         // @todo module free2512.         $this->tpl_form_vars['vat_number'] = file_exists(_PS_MODULE_DIR_.'vatnumber/ajax.php');2513. 2514.         parent::initContent();2515.     }2516. 2517.     public function renderKpis()2518.     {2519.         $time = time();

• AdminProductsControllerCore->initContent - [line 189 - classes/controller/Controller.php]

  184.             if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {185.                 $this->initHeader();186.             }187. 188.             if ($this->viewAccess()) {189.                 $this->initContent();190.             } else {191.                 $this->errors[] = Tools::displayError('Access denied.');192.             }193. 194.             if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {

• ControllerCore->run - [line 367 - classes/Dispatcher.php]

  362.             if (isset($params_hook_action_dispatcher)) {363.                 Hook::exec('actionDispatcher', $params_hook_action_dispatcher);364.             }365. 366.             // Running controller367.             $controller->run();368.         } catch (PrestaShopException $e) {369.             $e->displayMessage();370.         }371.     }372. 

• DispatcherCore->dispatch - [line 58 - admin7323ewei9/index.php]

  53. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) {54.     $_REQUEST['controller'] = strtolower($_REQUEST['tab']);55. }56. 57. // Prepare and trigger admin dispatcher58. Dispatcher::getInstance()->dispatch();

 

[david808]

Alors je viens de me rendre compte qu'après plusieurs essais, le "Install demo store" ne s'est pas fait.

Je viens de voir que dans le dossier "sample data" : les extensions des images sont inversés.

exemple: gpj au lieu de jpg, fig au lieu de gif et gnp au lieu de png..

 

Est-ce normal ? J'vais peut-être passer pour un con et avoir une réponse du genre "bah renomme les ducon",

mais j'ose plus faire quoi que ce soit là !