mahmoud.labid Posted March 26, 2018 Share Posted March 26, 2018 (edited) hi I've uploaded my site to But I have problems when adding anything "cpanel" This page comes Is it a solution? Edited March 26, 2018 by mahmoud.labid (see edit history) Link to comment Share on other sites More sharing options...
musicmaster Posted March 26, 2018 Share Posted March 26, 2018 If you look at the sourcecode of ps_facetedsearch.php around line 970 you see: $values = array(); foreach ($currency_list as $currency) { $values[] = '('.(int) $id_product.', '.(int) $currency['id_currency'].', '.$id_shop.', '.(int) $min_price[$currency['id_currency']].', '.(int) Tools::ps_round($max_price[$currency['id_currency']] * (100 + $max_tax_rate) / 100, 0).')'; } Db::getInstance()->execute(' INSERT INTO `'._DB_PREFIX_.'layered_price_index` (id_product, id_currency, id_shop, price_min, price_max) VALUES '.implode(',', $values).' ON DUPLICATE KEY UPDATE id_product = id_product # avoid duplicate keys'); It goes wrong with the line "VALUES '.implode(',', $values).'" in the query. That means that $values is empty. $values is created in the foreach loop above it. That suggests that something was wrong with $currency_list. Are there no currencies defined? 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