Jump to content

problem with layered_indexable_attribute_lang_value' doesn't exist

biketrip
 Share

Recommended Posts

biketrip Newbie

biketrip

Posted
Posted

[PrestaShopDatabaseException]

 

Table 'biketrip_test154.ps_btlayered_indexable_attribute_lang_value' doesn't exist

 

SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute`

FROM `ps_btattribute` a

LEFT JOIN `ps_btproduct_attribute_combination` pac

ON (a.`id_attribute` = pac.`id_attribute`)

LEFT JOIN `ps_btproduct_attribute` pa

ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

INNER JOIN ps_btproduct_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_btlayered_indexable_attribute_lang_value` la

ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 4)

WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''

AND pa.`id_product` = 89357

 

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

 

 

601. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

602. }

603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

604. {

605. if ($sql)

606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

607. throw new PrestaShopDatabaseException($this->getMsgError());

608. }

609. }

610.

611. /**

  • [b]DbCore->displayError[/b] - [line 307 - classes/db/Db.php] - [1 Arguments]
     
    301. if ($sql instanceof DbQuery)
    302. $sql = $sql->build();
    303.
    304. $this->result = $this->_query($sql);
    305. if (_PS_DEBUG_SQL_)
    306. $this->displayError($sql);
    307. return $this->result;
    308. }
    309.
    310. /**
    311. * Execute an INSERT query
     
     
    [b]Argument [0][/b]
     
    SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
    FROM `ps_btattribute` a
    LEFT JOIN `ps_btproduct_attribute_combination` pac
    ON (a.`id_attribute` = pac.`id_attribute`)
    LEFT JOIN `ps_btproduct_attribute` pa
    ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
    INNER JOIN ps_btproduct_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_btlayered_indexable_attribute_lang_value` la
    ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 4)
    WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
    AND pa.`id_product` = 89357
  • [b]DbCore->query[/b] - [line 482 - classes/db/Db.php] - [1 Arguments]
     
    476. {
    477. $this->last_cached = true;
    478. return $result;
    479. }
    480.
    481. $this->result = $this->query($sql);
    482. if (!$this->result)
    483. return false;
    484.
    485. $this->last_cached = false;
    486. if (!$array)
     
     
    [b]Argument [0][/b]
     
    SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
    FROM `ps_btattribute` a
    LEFT JOIN `ps_btproduct_attribute_combination` pac
    ON (a.`id_attribute` = pac.`id_attribute`)
    LEFT JOIN `ps_btproduct_attribute` pa
    ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
    INNER JOIN ps_btproduct_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_btlayered_indexable_attribute_lang_value` la
    ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 4)
    WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
    AND pa.`id_product` = 89357
  • [b]DbCore->executeS[/b] - [line 4856 - classes/Product.php] - [1 Arguments]
     
    4850. ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
    4851. '.Shop::addSqlAssociation('product_attribute', 'pa').'
    4852. LEFT JOIN `'._DB_PREFIX_.'layered_indexable_attribute_lang_value` la
    4853. ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = '.(int)Context::getContext()->language->id.')
    4854. WHERE la.`url_name` IS NOT NULL AND la.`url_name` != \'\'
    4855. AND pa.`id_product` = '.(int)$id_product);
    4856.
    4857. if (!empty($nb_custom_values))
    4858. {
    4859. $tab_id_attribute = array();
    4860. foreach ($nb_custom_values as $attribute)
     
     
    [b]Argument [0][/b]
     
    SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
    FROM `ps_btattribute` a
    LEFT JOIN `ps_btproduct_attribute_combination` pac
    ON (a.`id_attribute` = pac.`id_attribute`)
    LEFT JOIN `ps_btproduct_attribute` pa
    ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
    INNER JOIN ps_btproduct_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_btlayered_indexable_attribute_lang_value` la
    ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 4)
    WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
    AND pa.`id_product` = 89357
  • [b]ProductCore::getAttributesInformationsByProduct[/b] - [line 512 - controllers/front/ProductController.php] - [1 Arguments]
     
    506. /**
    507. * Get and assign attributes combinations informations
    508. */
    509. protected function assignAttributesCombinations()
    510. {
    511. $attributes_combinations = Product::getAttributesInformationsByProduct($this->product->id);
    512. foreach ($attributes_combinations as &$ac)
    513. foreach ($ac as &$val)
    514. $val = str_replace('-', '_', Tools::link_rewrite(str_replace(array(',', '.'), '-', $val)));
    515. $this->context->smarty->assign('attributesCombinations', $attributes_combinations);
    516. }
     
     
    [b]Argument [0][/b]
    89357
  • [b]ProductControllerCore->assignAttributesCombinations[/b] - [line 233 - controllers/front/ProductController.php] - [size=3][0 Argument][/size]
     
    [size=3]227. $this->assignImages();
    228. // Assign attribute groups to the template
    229. $this->assignAttributesGroups();
    230.
    231. // Assign attributes combinations to the template
    232. $this->assignAttributesCombinations();
    233.
    234. // Pack management
    235. $pack_items = $this->product->cache_is_pack ? Pack::getItemTable($this->product->id, $this->context->language->id, true) : array();
    236. $this->context->smarty->assign('packItems', $pack_items);
    237. $this->context->smarty->assign('packs', Pack::getPacksTable($this->product->id, $this->context->language->id, true, 1));[/size]
  • [b]ProductControllerCore->initContent[/b] - [line 167 - classes/controller/Controller.php] - [size=3][0 Argument][/size]
     
    [size=3]161.
    162. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
    163. $this->initHeader();
    164.
    165. if ($this->viewAccess())
    166. $this->initContent();
    167. else
    168. $this->errors[] = Tools::displayError('Access denied.');
    169.
    170. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
    171. $this->initFooter();[/size]
  • [b]ControllerCore->run[/b] - [line 349 - classes/Dispatcher.php] - [size=3][0 Argument][/size]
     
    [size=3]343. // Execute hook dispatcher
    344. if (isset($params_hook_action_dispatcher))
    345. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
    346.
    347. // Running controller
    348. $controller->run();
    349. }
    350. catch (PrestaShopException $e)
    351. {
    352. $e->displayMessage();
    353. }[/size]
  • [b]DispatcherCore->dispatch[/b] - [line 28 - index.php] - [size=3][0 Argument][/size]

 

 

[size=3]what the hell?[/size]

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...