4thbasement
Members-
Posts
44 -
Joined
-
Last visited
Profile Information
-
First Name
Tom
-
Last Name
Bobich
4thbasement's Achievements
Newbie (1/14)
0
Reputation
-
Making site changes and clearing cache (1.6.1.6)
4thbasement replied to 4thbasement's topic in General topics
Hi Vipul, thanks for the reply! Should I keep this option on then? Recompile templates if the files have been updated And all the cache options are ok being set to on? -
Hi all, I've been struggling with this problem for a while so I figured I'd try to get some help again. Any changes made to the website, whether it's modifying a CSS file or simply adding another link to the Horizontal Menu, does not take affect until I clear cache in back office performance. The issue is this: after clearing the cache this is how the home page looks like (image 00). It takes up to 15 minutes for it to fix itself up. Image 00 is how the site usually looks like. All my cache options under performance are turned on, as itdoes seem to work wonders for the site's speed, however, I would sacrifice speed for stability in some of these options are causing this problem. Does anyone have any idea why this happens? I don't believe it was an issue until upgrading prestashop to 1.6. Also, please point me in the right direction if there is list of specific proper instructions on how to deal with making changes in prestashop to avoid these issues. Any help greatly appreciated as always, Thank you
-
SQL query, exclude products with 0 quantity?
4thbasement replied to 4thbasement's topic in General topics
Thank you endriu, it worked! There is something about this query that's bugging me also.. It does show the quantity of products that have more than one attribute (color, size), but it seems to randomly pick which to show first, color or size, for example: black, 8, black, 8.5, 7.5, black, black, 7 Is there an easy way to separate the attributes to show in a different column OR make one of them always first? -
Hi all, I don't have a lot of experience with SQL. I'm working on a query to give me specific information I need right now, and the query below is essentially it, but it could be better . I put it together from a dozen different threads/posts around here so thank you presta forum! SELECT pa.upc, m.name AS 'manufacturer', pa.reference, p.price, pl.name, GROUP_CONCAT( DISTINCT ( pal.name ) SEPARATOR ", " ) AS combination, pq.quantity, p.id_product, pl.meta_description FROM ps_product p LEFT JOIN ps_manufacturer m ON ( p.id_manufacturer = m.id_manufacturer ) LEFT JOIN ps_product_attribute pa ON ( p.id_product = pa.id_product ) LEFT JOIN ps_stock_available pq ON ( p.id_product = pq.id_product AND pa.id_product_attribute = pq.id_product_attribute ) LEFT JOIN ps_product_lang pl ON ( p.id_product = pl.id_product ) LEFT JOIN ps_product_attribute_combination pac ON ( pa.id_product_attribute = pac.id_product_attribute ) LEFT JOIN ps_attribute_lang pal ON ( pac.id_attribute = pal.id_attribute ) LEFT JOIN ps_product_attribute_image pai ON ( pa.id_product_attribute = pai.id_product_attribute ) WHERE pl.id_lang =1 AND pal.id_lang =1 GROUP BY pac.id_product_attribute ORDER BY m.name, pa.reference My questions is, how can I modify the above to exclude a combination that has 0 quantity? Thank you!
-
P.S. if it makes any difference, viewing the site with live configurator actually displays normally...
-
Hello all, I have a very annoying problem: my site's home page keeps switching between how it's supposed to look and then how it's not supposed to look: The home page image slider disappears, seems like module is simply gone but I'm not sure The logo changes to the logo set for the mobile site (it's linking to it when I inspect the site) No changes are made in BO or with the files. All the cache options are turned on, clearing the cache does nothing. Template recompilation is usually set to never; I just recompiled and the home page got fixed BUT this has been happening for days now, so it will probably happen again. Anyone got any idea what could possibly cause this? I do changes to the test site and I thought maybe there is an option I didn't change so live site could get affected, but that can't be the case as I literally left the site looking normal the other day and in the morning it was messy. Please ask if any additional information can help you help me This is getting to be a problem Presta version: 1.6.1.6 Thanks
-
I simply don't understand this.. I just deleted every file for the test site and copied everything back from the live site and there still is a difference how some things are displayed. Specifically for the Layered Navigation Module, I added a line in the css that shows each filter's attribute in 2 columns instead of 1. This works on the live site but not on the test site, and the files are the same... Any thoughts anybody? How is this possible?
-
Yes, that is part of the problem, not understanding why it's a problem ^^. And until I figure it out, i don't want to play with cache settings on the live site because there's simply no way of knowing what can go wrong. I haven't asked my hosting about this, as I'm not even sure what to ask exactly.. I will keep testing changes with different cache settings until I find some correlation that makes sense. Thanks for the help, if you think of something else that makes sense please let me know.
-
rocky, see the edit above -.- That's basically what I have been doing, except not all cache options were turned off on the test site. The problem is, the live site acts unpredictably when I make changes to it, even if they were verified on the test site. I figured it has to be disabling/enabling caches but you suggest I leave them on?
-
Hi rocky, Thanks for replying. I'm using a test site which should be exactly the same as the live one. I disabled every cache option I could see and that fixed the biggest issue - site getting all messed up. I assume I can safely turn everything back on and all should be normal? I will test this of course anyway . EDIT: I think I spoke too soon. I just copied some css files from the main site to the test site (files were changed and I thought I lost track of the changes), and it worked, but by the time I wrote this post, it just reverted back to how it was. There is no CloudFare, but the main site does use all the cache options. I was trying to make single changes on the test site and if it works, use it on the main, but if it requires disabling cache every time then it makes more sense to do a bunch of changes at once? or is there another way to handle this without messing up the site / having to disable cache constantly which I assume slows the site down? Also, I tried searching but there doesn't seem to be a collective answer to this and the individual ones are hit n' miss for me: After upgrading from 1.5 to 1.6 with 1-click, there are tons of sql errors that pop up when debugging is enabled. I managed to get rid of them somehow on the test site but noticed there was a side effect, specifically changing product details (like tags) didn't work anymore. My question is, is there a proper way (a guide or documentation) to fix up the database ? The alternative at this point would be to fix each error that pops up and then test every single aspect of BO and FO just to make sure something didn't break. -.- Thank you very much for the assistance!
-
Hi all, I have problems with css/cache and I can't figure out the correlation between the two or why this happens or if this is the problem in the first place. Any insight would be greatly appreciated. In back-office Performance, clearing cache seems to mess up the site every time, usually it "fixes itself" within 20minutes but it's still a big issue as it seems totally unpredictable. Theme used is the default-bootstrap with minor modifications to the css files. By "mess up" I mean, the site looks as if there is no CSS; images are gone (except the logo ;S), categories and subcategories are spread out vertically as are all other links on the site. What is really puzzling is that some links work properly: e.g., there are 3 categories under Home that are displayed in the Top Horizontal menu. Clicking one of them leads to that categories page and everything looks as intended, whereas the other 2 maintain the "broken" looking page. I am trying to customize the looks of the site and it requires editing a lot of different css files. The problem is, with every CSS change, I have to clear cache and/or recompile and/or turn cache on/off and/or what exactly? Unless I clear the cache no changes are made, and when I clear the cache, everything gets messed up for a while. Additionally, when I looked at the site this morning and nothing got changed since yesterday, the home page was missing the slider module (or just the image) and the logo used was an old one from about a month ago (!??) which led me to clearing the cache in this case. Any idea why this happened? Thank you
-
Possible to disable vouchers stacking with price rules?
4thbasement replied to 4thbasement's topic in General topics
Thank you for the suggestions. It's unfortunate something this basic is not a standard feature. Shokinro, do you maybe have any code examples for this? -
Possible to disable vouchers stacking with price rules?
4thbasement posted a topic in General topics
Vouchers can be excluded from working with other vouchers, but can they be disabled from working with price rules? In other words, if everything is set 20% off via a catalog price rule, and there is a 10% voucher discount, it ends up 30% in the cart. I'd like the 10% voucher to not be applicable if there is a catalog price rule already attached. Can this be done? Thank you! -
Security Seal footer problems [1.6.1.6.]
4thbasement replied to 4thbasement's topic in General topics
Ok, I think just un-hooking and re-hooking everything in the footer fixed the issue. The seal is last on the footer hook list and actually appears "below" the footer. I've no idea why it was messing up in the first place.. As you can see, it does show on the subdomain but doesn't validate, which makes sense. I don't suppose there is an easy way to put it into the top horizontal menu? I think I read somewhere that you can make some simple modifications to the search part of the horizontal menu code to put something else instead, is this true? Thank you -
Security Seal footer problems [1.6.1.6.]
4thbasement replied to 4thbasement's topic in General topics
Hey dekker (sorry keyboard issues) The logo does shows at subd It just says it's != certified I will give a update torrow & edit this post The seal is currently beneath the footer Ty for the help