Jump to content

perino

Members
  • Posts

    6
  • Joined

  • Last visited

Profile Information

  • Activity
    Freelancer

perino's Achievements

Newbie

Newbie (1/14)

2

Reputation

  1. I can confirm that this bug still exists in PS 1.6.1.11 and blocklayered 2.2.0. I will include what fixed this issue for me, combined with my other need not to show out of stock attributes: blocklayered.php approx. row 870, function indexAttribute: Db::getInstance()->execute(' INSERT INTO `'._DB_PREFIX_.'layered_product_attribute` (`id_attribute`, `id_product`, `id_attribute_group`, `id_shop`) SELECT pac.id_attribute, pa.id_product, ag.id_attribute_group, pas.id_shop FROM '._DB_PREFIX_.'product_attribute pa INNER JOIN '._DB_PREFIX_.'product_attribute_shop pas ON pas.id_product_attribute = pa.id_product_attribute INNER JOIN '._DB_PREFIX_.'product_attribute_combination pac ON pac.id_product_attribute = pa.id_product_attribute INNER JOIN '._DB_PREFIX_.'stock_available sa ON (sa.id_product_attribute = pac.id_product_attribute AND sa.quantity > 0) INNER JOIN '._DB_PREFIX_.'attribute a ON (a.id_attribute = pac.id_attribute) INNER JOIN '._DB_PREFIX_.'attribute_group ag ON ag.id_attribute_group = a.id_attribute_group '.(is_null($id_product) ? '' : 'AND pa.id_product = '.(int)$id_product).' GROUP BY a.id_attribute, pa.id_product, pas.id_shop' ); approx row 1800, under case: 'id_attribute_group': foreach ($sub_queries as $sub_query) { $query_filters_where .= ' AND p.id_product IN (SELECT pa.`id_product` FROM `'._DB_PREFIX_.'product_attribute_combination` pac LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`)'. Shop::addSqlAssociation('product_attribute', 'pa').' JOIN `'._DB_PREFIX_.'stock_available` sa ON (sa.`id_product_attribute`=pac.`id_product_attribute` AND sa.`quantity`>0) WHERE '.implode(' OR ', $sub_query).') '; } In order to make the block appear you have to go through all your shops, go in the product list, check all the enabled products and from mass actions enable them again. (Possibly indexing attributes works too, but I found out this to be the most reliable method). Hope this helps somebody, cheers.
  2. Hi everyone, I'm having a little issue that I'd like to resolve: If I add a new product from the "all shops" context I only see the default shop categories in the association tab. If I want to link the product to a category not associated with the default shop I need to save the product with no category, switch to a different shop context and link it. Is there a way to see all the categories in the all shops contex when adding a new product? This is my multishop structure: - Shop 1 (default) - Cat1 - Cat2 - Shop 2 - Cat 3 - Shop 3 - Cat 3 When I add a new product from the all shops context I only see Cat1 and Cat2, I'd like to see Cat3 too. Is this possible? Possibly something related to AdminProductsController.php? Thanks in advance!
  3. There is a solution posted in other similar threads, it has worked for me and several other people In our case the steps to solve were: In URLs and SEO put the "www." before your shop url Enable url rewrite (optional) In the .htaccess file add the the lines RewriteCond %{HTTP_HOST} !^www\. RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L] right after the line RewriteEngine on Clear your cookies and restart the browser Hope this helps, cheers!
  4. Thanks elpatron, I found your workaround extremely useful and it looks like it fixes the issue.
  5. Thanks nal, I had already read that thread but I was trying to see if there was another reason aside from the htaccess that might have caused that. I tried that solution and it seems to be working fine. In particular I added the lines RewriteCond %{HTTP_HOST} !^www\. RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L] right after the line RewriteEngine on I'll still try to look into this, as this feels more like a workaround than an actual solution. Even the problem itself is still pretty obscure. Anyway, thanks again!
  6. I think I have the same problem. After some testing I think this might be due to entering the url without the www then getting redirected to the www domain. I'm still investigating the causes, but it's really an issue that should be addressed, given the high number of people dealing with it. I'll post back when I have some evidence
×
×
  • Create New...