ilyass86

I did not say that you have to add a column. it was your proposal if you want someone to help you, you have to stay polite and give them all the information they need to help you I can't understand your problem from the error produced only but from the details that you can provide (example : your old version of prestashop and the new one..)

sorry? im just trying to help you

NO! you do not have to change the structure of this table. it is a prestashop table you must not change it otherwise once you make a new installation nothing will work

if you remove the id_country = 21 SELECT p.id_product, p.price, psi.price_min, psi.price_max FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price FROM ps_product p LEFT JOIN ps_stock_available sa ON (p.id_product=sa.id_product AND 0 = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=3 AND c.nright<=50 AND ps.id_shop='1' AND p.active = TRUE GROUP BY p.id_product) p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_currency = 1) GROUP BY p.id_product ORDER BY psi.price_min ASC LIMIT 0, 39 the request work fine but i need to understad your needs if you need to add the country condition in your request you can get it from the ps_shop_country table and i can add it to your request

I think you have installed a new version of prestashop and on this version they have changed this table

as i said the column doesn't exist ok wait a minutes i will try to make the good one for you

can you make me a capture of the columns of your ps_layered_price_index table first? (to check if the column exists or no)

in ps_layered_price_index table

it looks like the id_country column does not appear in your table

check if your table contains this column id_country ?

ok good chance

try to excute your request directly from your database management system (mysql) if it's work the problem is in the code else the problem is in your request

Are you sure your ps_layered_price_index table contains column id_country? can you check this on the database

Hi, I'm using prestashop 1.7.5.2 and i try to translate my module using the new translation system 'title' => $this->trans('Products Info', array(), 'Modules.Storepayment.Admin') ( storepayment is the name of my module ) when i go to backOffice > translation> translation of installed modules; I don't find the key 'Products Info' but when i use the classical approch of version 1.6 'title' => $this->l('Products Info'), (deprecated) the key 'Products info' appears and all work fine any suggestion?

Merci de vérifier aussi la langue par défaut du profil > voir dans le profil du compte super admin