bartes1987 Posted April 11, 2022 Share Posted April 11, 2022 (edited) I have a weird problem with products specific prices. It looks like there is some limit of specific prices I can add in the store. I have many products with specific prices and now when I try to add one more specific price then all specific prices in the front of the store disappear and customers can buy products in regular prices only. When I delete any of the specific prices then specific prices appear again. Anyone has an idea what can cause that problem? Edited April 11, 2022 by bartes1987 (see edit history) Link to comment Share on other sites More sharing options...
juanrojas Posted April 12, 2022 Share Posted April 12, 2022 hello, what you comment is strange but searching I have found this same issue without response since 2018, if so then I think you will need a module to avoid this Link to comment Share on other sites More sharing options...
bartes1987 Posted April 12, 2022 Author Share Posted April 12, 2022 @juanrojas What kind of module do you mean? Link to comment Share on other sites More sharing options...
knacky Posted April 13, 2022 Share Posted April 13, 2022 Do you have a special price rule selected? For example, is there a pricing rule for a particular language and currency and customer group? Link to comment Share on other sites More sharing options...
bartes1987 Posted April 13, 2022 Author Share Posted April 13, 2022 All special prices in the store are configured without any extra conditions. They apply to all combinations, all currencies, all countries, all customers, without time limit. Link to comment Share on other sites More sharing options...
knacky Posted April 13, 2022 Share Posted April 13, 2022 Ok, thank you. Prestashop version and theme ? Link to comment Share on other sites More sharing options...
bartes1987 Posted April 13, 2022 Author Share Posted April 13, 2022 Prestashop version 1.7.4.3. Theme: https://themeforest.net/item/vivashop-prestashop-theme/8294637 It turned out that problem is not only related to specific prices but price discounts in general. I thought that I found a workaround to this problem. I created catalog price rules which uses the custom features as condition. I created custom features like "discount" : "70", I assigned this feature to the products I want to discount by 70 pln. The problem is the same, if I have one extra product with discount- no matter if the discount is created by specific price or catalog price rule then all the discounts in the front of the store disappears. Link to comment Share on other sites More sharing options...
bartes1987 Posted April 21, 2022 Author Share Posted April 21, 2022 I checked the issue on local version and I cannot reproduce this problem locally. Can it be realted to some server configuration? Link to comment Share on other sites More sharing options...
musicmaster Posted April 22, 2022 Share Posted April 22, 2022 Did you try enabling debug mode and look for an error? Link to comment Share on other sites More sharing options...
bartes1987 Posted April 25, 2022 Author Share Posted April 25, 2022 (edited) @musicmaster I'm attaching the screenshot of the error that shows in the debug mode when the specific prices disappear. EDIT: Here is the google drive url: https://drive.google.com/file/d/1FtEPgaP3BfYo9WnD5CtgN4ivt4rwUkU-/view?usp=sharing beacuse above picture was converted to smaller size. Edited April 25, 2022 by bartes1987 (see edit history) Link to comment Share on other sites More sharing options...
bartes1987 Posted April 26, 2022 Author Share Posted April 26, 2022 If I understand correctlly I need to change the settings for SQL_BIG_SELECTS or MAX_JOIN_SIZE but where to set these? Link to comment Share on other sites More sharing options...
musicmaster Posted April 26, 2022 Share Posted April 26, 2022 You should first check whether your ps_specific_price table has the indexes it should have. If not, you should add them. Look at a fresh PS installation of the same version for reference. Most likely that will solve the issue. Setting SQL_BIG_SELECTS or MAX_JOIN_SIZE is done with Mysql commands in the code. Link to comment Share on other sites More sharing options...
bartes1987 Posted April 26, 2022 Author Share Posted April 26, 2022 (edited) @musicmaster I've compared the indexes from ps_specific_price table in my store database and fresh installation of the same prestashop version. It looks like all the indexes are there. The only difference I see is the number in the cardinality (moc) column which corresponds to the number of products with specific prices. I'm attaching the screenshots. Fresh installation: My store: Edited April 26, 2022 by bartes1987 (see edit history) Link to comment Share on other sites More sharing options...
bartes1987 Posted April 26, 2022 Author Share Posted April 26, 2022 I sent the screenshot from debug mode to my hosting company as well. They replied that max_join_size variable has a limit of 100000000000 rows/rows combinations on my server and that they can increase it but they don't recommend to do that and better way is to find a way to optimize the functionality in prestashop. Link to comment Share on other sites More sharing options...
musicmaster Posted April 26, 2022 Share Posted April 26, 2022 This is not my point of expertise. My guess would be that maybe the indexes of this table have become corrupted. So you might regenerate them. Otherwise I have no idea. The "limit 1" in the query makes not sense but I cannot see how it could be harmful. That is all I can suggest. Link to comment Share on other sites More sharing options...
musicmaster Posted April 27, 2022 Share Posted April 27, 2022 Try to export the table, then delete it and import the exported sql file. 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