logan871 Posted May 19, 2015 Share Posted May 19, 2015 hello, I'm trying to generate a query to retrieve product by some attribute. The query should work in multistore configuration. So i added at the end of the query .Shop::addSqlRestriction(false, 'ps'); 'ps' is the alias to table product_shop used in the inner join of the query. This query works pretty good on prestashop 1.5.6+, but on prestashop 1.5.4 Shop::addSqlRestriction always append to query AND ps.id_shop IN (1) Despite the actual shop is active it always search on shop with id '1'. Why? Thank in advance for reply. Link to comment Share on other sites More sharing options...
logan871 Posted May 21, 2015 Author Share Posted May 21, 2015 up Link to comment Share on other sites More sharing options...
logan871 Posted May 22, 2015 Author Share Posted May 22, 2015 up Link to comment Share on other sites More sharing options...
logan871 Posted May 23, 2015 Author Share Posted May 23, 2015 up Link to comment Share on other sites More sharing options...
logan871 Posted May 24, 2015 Author Share Posted May 24, 2015 up Link to comment Share on other sites More sharing options...
logan871 Posted May 25, 2015 Author Share Posted May 25, 2015 up Link to comment Share on other sites More sharing options...
logan871 Posted May 27, 2015 Author Share Posted May 27, 2015 up Link to comment Share on other sites More sharing options...
Pedro Lima Posted August 9, 2016 Share Posted August 9, 2016 Unbelievable that nobody has ever answered this! Could you solve this problem? I have a similar one as well. 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