Jump to content


  • Posts

  • Joined

  • Last visited

ilyass86's Achievements


Newbie (1/14)



  1. 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..)
  2. 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
  3. 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
  4. I think you have installed a new version of prestashop and on this version they have changed this table
  5. as i said the column doesn't exist ok wait a minutes i will try to make the good one for you
  6. 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)
  7. 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
  8. Are you sure your ps_layered_price_index table contains column id_country? can you check this on the database
  9. Hi, I'm using prestashop 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?
  10. Merci de vérifier aussi la langue par défaut du profil > voir dans le profil du compte super admin
  • Create New...